Import from db into Quick.Cart?

stevie

2006-04-09 20:12

I like that Quick.Cart doesn't require use of a database on the web host. But, I already keep my internal product information in a database. I'd like to export fields from my already existing database (MS Access) into files suitable for Quick.Cart.

I can backwards engineer what fields are in what files, but it would be great if someone already has a short description of the fields used?

Any advice?

stevie

2006-04-10 04:10

I made a quick run through the files in the db directory for QuickCart 1.2, and this is what I came up with. Can anyone help me with the question marks, or correct any mistakes I made?

Again, if this info is already available elsewhere, where? Thanks!

=================================

Each file in quick.cart/db starts with the line:
<?php exit; ?>

Each file has several fields, each ending with the "$" character

Categories.php
F1=Category ID?
F2=Category Name
F3=?
F4=?
F5=?
F6=?


categories_ext.php
F1=Category ID?
F2=Short Description
F3=Full Description


Categories_files.php
???


Couriers.php
F1=Courier ID?
F2=Courier Name
F3=Courier price


Orders.php
F1=Order ID?
F2=Date/Time?
F3=Order status?


Orders_ext.php
F1=Order ID?
F2=Date/Time?
F3=Courier name?
F4=Courier price?
F5=First name
F6=Last name
F7=Company name
F8=Address
F9=Postal code
F10=city
F11=phone
F12=email address
F13=IP address
F14=note


Orders_products.php
F1
F2
F3
F4
F5=price
F6=product name


Products.php
F1=product ID?
F2=product5 name
F3=price
F4=short description
F5=?
F6=?


Products_categories.php
F1=?
F2=?


Products_ext.php
F1=Product ID?
F2=Full Description


Products_files.php
F1=Product ID?
F2=Filename
F3=Description
F4=?

treewood (OpenSolution)

2006-04-10 06:28

stevie - go to download and check file v1.x_db.png ... there is schema of database.

stevie

2006-04-10 13:25

Perfect! Thanks so much, that's exactly what I wanted.

http://opensolution.org/download/v1.x_db.png

Thanks. -Steve