QSC Import

Nov 25, 2008 3 Replies

I have found the tool and installed it. I have Excel 2007 (and beginning to think this is the problem). I have attempted to use the QSCimport tool for inventory only and I connect to the DB and map the fields. I tried to map just the fields I had data in and it didn't work. I then mapped all 52 fields in Inventory. That still didn't work. QSC attached to the DB and the import kicks off and completes but it does not enter any records. I have thought that maybe it didn't have a reference to some fields like suppliers or item type and made them all Zero. That didn't help. The activity log says nothing of errors, it just lists a comma delimited bunch of items with a sequential number in the front of each line item in { }. I think it should work, but it doesn't. Any help here?



Doug


Doug

First save your excel 2007 item file as excel 97 or 2003. Open that up then save the item file as a TAB delimited file.

Run your import again - set destination table = inventory, delimiter = TAB

Map your fields, and finish the import.

Typically, if you can see your items in the preview screen (where you can indicate that the first row is a column header) it means it reads and understands the file.

Give this a shot -

"Doug - Mounta> I have found the tool and installed it. I have Excel 2007 (and beginning to

That was the problem - works like a charm. Save as 97/2003 first and then as a Tab text file.

First true install went fairly well. I'm glad I have two years of alt POS software under my belt. There was a lot to think about for a store to truly work well with this product. I like the Alias tab. It helped with Suppliers that ship product with a different UPC code on a shipping document than what is on the product itself.

Thanks, Doug

"c> Doug

If you want to try our Import Utility that does Item import, Catalogue import, transactional and historfical import, as well as link with store and hq and also upgrade MS POS to RMS contact me. I will send you a link to download and evaluate the product.

Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk Retail Realm = = = = = = = = = "Doug - Mountain POS" wrote in message news: snipped-for-privacy@microsoft.com...

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required