Exporting Actinic Prices

[Rich-MLandS]

I've created a system for our website allowing customers to assemble a certain product. However; it would be useful if I could export some of the prices from Actinic.. I want to use the simplest way possible for my successor to understand it.

Cheers.

[Bruce]

Richard,

Can you expand on this a bit please, is it the prices for the products in the application you wish to export?

Kind regards,

[Rich-MLandS]

Yes, got a selection of products in the same section which the prices need to be exported.

[Rich-MLandS]

Hello World?

Any help.. please?

[Jan]

You can only do this by exporting the whole catalog (file / export) and extracting the bits you need.

Regards,

[Rich-MLandS]

meh. - word of the day!

that means every time we update a set of product with new prices the database exported then extract just the prices and then put back into a MySQL database to allow a system to work. FUN!

Why can Actinic just be easy sometimes!

[Jan]

Actinic uses an access database, you could try using SQL to extract the data from access into the form you need it in MsSQL or into an intermediate form.

Regards,

[Rich-MLandS]

Next question.. the prices are located in which table in the actinic database.

[Marci]

"Products" table >> "Price" field. It's in pence - divide by 100 to translate into ££.pp

[Jan]

Those are the prices for the main products - you have also prices for components and customer based pricing in the productproperties table.

Regards,