I'm working on a catalogue that will have approximately 12000 products. Is there any way to automate the addition of CUSTOM VARs for each product directly? For example, is there a proven method to directly import data into the relevant table in the underlying Access database?
Announcement
Collapse
No announcement yet.
Automatically updating CUSTOM VARs
Collapse
X
-
Automatically updating CUSTOM VARs
Pat Nelson
vcommunity - the business to business network
email: pnelson@vcommunity.org.uk
www.vcommunity.org.uk
Experts in database integration for Actinic Stores
For web hosting, visit: www.vhost.org.uk
Advertise your company for £1 for a year on www.1000adpages.comTags: None
-
TechnoWeb,
Thanks for the reply. I've looked at that method already but it's not ideal. I have a supplier datafeed imported into an Access database and am using that to create the necessary export files to Actinic. I was hoping to use some of the data to populate the relevant table in the Actinic mdb but really need to know the format/purpose of the fields.Pat Nelson
vcommunity - the business to business network
email: pnelson@vcommunity.org.uk
www.vcommunity.org.uk
Experts in database integration for Actinic Stores
For web hosting, visit: www.vhost.org.uk
Advertise your company for £1 for a year on www.1000adpages.com
Comment
-
From a few minutes poking around in ActinicCatalog.mdb it seems that Custom Properties are defined in the HTMLVariables table. Where nVariableID is matched against the ProductPropeties table field nValue1 (where nType of 3 means a Custom Property). What the other fields do I don't know.
NormanNorman - www.drillpine.biz
Edinburgh, U K / Bitez, Turkey
Comment
Comment