Hi,
Can anybody give me advise on importing bulk data from a spreadsheet? I have 1000's of new products and want to add them without having to do it one by one, is this something that i should attempt myself - if so what is the best utility to import it into my HQ database before sending it to stores?
Thanks in advance for any guidance :o)
You can save the worksheet as a comma-delimited .CSV file and import it with the free QSCImport utility (from CustomerSource) or with a third party import utility like EMS' MS SQL Data Import. Most third party tools will have the same shortcomins as using a query...
Using a query or set of queries is challenging if you want to add Supplier info like reorder number, MPQ, etc. These fields are not part of the Item table but part of the Supplier table.
It'd be easy to create a series of query statements in a column of your spreadsheet with a formula like this one: ="INSERT INTO Item (Field1, Field2...) VALUES ("Value1", "Value2"...)" where 'ValueX' refers to the appropriate cell.
Best of luck, Tom
Philip,
HQ is a different animal than SO. Do not use the QSC Import tool on it.
Try Retail Realm
Hi Phillip,
RMSynergy have written a range of bespoke Add-ons that enhance the capabilities of RMS. In particular one of the Add-ons we have written is Data Management. We wrote it with the view that you may want to import data according to a department or by supplier likewise we have also written a profile that enables you to manipulate data on mass, again by department or supplier. Data Management can be used at either store or HQ.
If you feel that this add-on would bring benefits to your organisation or would like more information on our complete range please do not hesitate to contact me and I will pass your details on to your local RMSynergy reseller.
Kind Regards
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.