Online Order Tracking

[sexy2wear]

Been lurking on this site for quite a while and have used most of the ideas (especially Normans!) on my websites.

Anyhow there are several posts on this forum about writing an Online Order Tracking System but no simple solutions.

If your'e interested this is how I did it in a couple of hours.

Create a New Access database with linked Order and Person tables to the live ActinicCatalog.mdb

Created a query that pulls the info I want from these linked tables. For the Order Comments I use the User Defined Field under "Customer" Invoice Contact as its easy to enter text into when processing orders.

Created an Autoexec Macro that

Runs the Query
Exports the data to an .xls file
Opens DBManager Pro
Closes Access Database

Created a Data Wizard in DBManager Pro that uploads the .xls to a mysql database

DBManager Pro is FREE and very easy to use.

Wrote the data access and database result page

Sexy 2 Wear Online Tracking System is the result. Order No DW04EE10002989 will return some data.

It may sound complicated and it could be automated further, but to update I simply

Run my Access Database to extract the data
Run the DBManager Query to upload to mysql and voila !
Takes a couple of minutes.

Hope this of use !

Dom Watts
sales@sexy2wear.co.uk
Sexy 2 Wear Lingerie

[Mike Hughes]

Hi Dom,

Nice job. Using DBmanager Pro to create the mySQL database sounds like a very useful way to do it.

Looking at DBmanager Pro, you could probably cut out the first step that uses Access. Can't DBmanager Pro do the database access itself?

Mike

[Aby]

Well Done Dom, looks brilliant! Any chance of posting the necessary files for a few of us computing dummies

[sexy2wear]

Mike

Sorry for the delay but I've been out of the country on business.

In theory you could update mysql using DBmanager Pro directly from the Actinic Database but sadly it doesn't work because the Order Table is linked to other tables and the upload fails. Even if it did work you would be uploading a lot of information that is unnecessary (and would increase the upload time significantly). The Access query only pulls the information that I need thus making the system efficient.

Aby - The setup is custom and requires some Computer Knowledge- PM me and I'll see if I can help you out !

Dom Watts
sales@sexy2wear.co.uk
Sexy 2 Wear Lingerie

[mbishop]

Version of access?

What version of Access does Actinic use for their databases?

[TraceyG]

What version of Access does Actinic use for their databases?

Access 2000