Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 08-31-2012 10:49:35

Registered: 08-17-2009
Posts: 41

Batch Import multiple ecom_prod.csv files

Using Europacart 7 and have a very large product file (>10,000 items). Trying to import all at once causes a time out.
I can use the standard interface which allows me to import the products in batches of around 2500 items, however since we will be updating the file regularly I would be keen to streamline the operation and take away the need for a lot of manual intervention.
I have set up a routine using MS Access to automatically create the multiple csv files and would be keen to add some sort of automatic upload to the Europacart7 database table ecom_prod. I,m sure it can be done reasonably simply from Access VB but wondered if anyone had set up a batch proceedure within the system database administration section of the management interface tool.
Is there a "standard" way to set up a batch of csv files for import?

Any suggestions.





Board footer