Table Data Which Automatically Updates?

[JamesD]

Is it possible to have prices in a table which automatically update?

To explain my current method:

I have to base all my prices on a 'product file' which is an excel table with product codes and their associated retail prices.

I then use a formula in my excel file to link to the product file and so the 'up to date' retail price is produced in the csv.

I then import the csv regularly eg once a day to keep up to date with the product file.

---------------------------------------------------------------

My problem is I currently have multiple price lists shown on the website but this is basically a jpeg fragment.
(I have basically print screened the tables in excel to make jpg fragments and then uploaded to actinic.)

I would like these price lists to be kept constantly up to date without having to do more print screens and then upload every time a price changes.

What would be the best way of doing this?

Any help greatly appreciated.

[Mike Hughes]

It sounds as if this should do it

http://vbadud.blogspot.com/2010/06/h...age-using.html

Mike

[NormanRouxel]

The PHP built-in to Actinic can read Excel spreadsheets saved in XML format.

I've used this to extract price and size ranges from customer spreadsheets. Customer maintains their spreadsheet, saves it in XML format and Actinic automatically picks up their changes.

I use this in a rather complex add-on Made to Measure from XML Sizeranges. This is often used where the product price comes from a table of e.g. widths and heights (think garage doors, Venetian blinds, etc) and the price has to come from the item in the table that gets cut down to provide the customers sizes.