[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
[mv] Please HELP in Data Bases!!!
****** message to minivend-users from Eduardo Marquez <emarquez@wmega.es> ******
Hi all , i only need a piece of a simple catalog.cfg file using
Databases , that show me how to tell Minivend to get the products
database from a PostgresSql Database named test_minivend , with fields
"code" , "description" and "price".
My PostgresSql is running , and the database is created and running
fine.
This is my catalog.cfg , but it doesn't works.
I can't find a good documentation on it , and i don't know what to do.
Please , help !!!
Thanks in advance
Variable PGSQL 1
#ifdef PGSQL
Variable SQLDSN dbi:Pg:test_minivend:xxxx.xxxxx.xxx:11111
Message <<EOF
Using PostgreSQL for databases, DSN=__SQLDSN__.
EOF
# Uncomment if needed
Variable SQLPASS xxxx
Variable SQLUSER xxxx
# The tables are in separate files in the mysql directory
#include pgsql/*
#endif
## Whether to encrypt passwords in UserDB
UserDB default crypt 0
## Change a field to something that doesn't conflict in MySQL
UserDB default time_field mod_time
ScratchDefault mv_add_dot_html 1
ScratchDefault mv_no_session_id 1
ScratchDefault mv_no_count 1
ValuesDefault mv_shipmode upsg
# Sets Minivend to not parse <BODY MV="body 1"> and other tags within
# HTML tags, use [pragma no_html_parse 0] to enable on a page
Pragma no_html_parse
Database country country.txt TAB
#Database inventory inventory.txt TAB
Database orderline orderline.txt TAB
Database products
dbi:Pg:dbname=test_minivend:host=xxx.xxxx.xxx:port=1111 SQL
Database transactions transactions.txt TAB
Database userdb userdb.txt TAB
# Needed for UPS lookup
Database 2ndDayAir 2ndDayAir.csv CSV
Database Ground Ground.csv CSV
Database NextDayAir NextDayAir.csv CSV
Variable MINIMATE_META mv_metadata
Variable MINIMATE_TABLE minimate
Database minimate minimate.asc TAB
Database mv_metadata mv_metadata.asc TAB
AlwaysSecure checkout
AsciiTrack etc/tracking.asc
PriceField price
EncryptProgram __ENCRYPTOR__
--
Eduardo Márquez Martínez
Director Técnico
Equipo Consultor Informatico W-Mega S.A
http://www.wmega.es
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
