how to import item list into rms pos?

Hi, i have large list of items, how could i import them into RMS? any tools? -Cheng
---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.
formatting link
.mspx?mid=49285b9f-5601-48f0-a664-6928de770384&dg=microsoft.public.pos
Reply to
mchenga
There is an unsupported tool called QSImport that is available from MS Tech Support. Personally I don't think that tool is worth the effort of learning - it's easier for me to just use the tools built into SQL Management Studio. If you want to use a tool specific to RMS, get the Import Tool from Retail Realm - it is far more powerful than QSImport.
formatting link

Glenn Adams Tiber Creek Consulting
formatting link
snipped-for-privacy@tibercreek.com ---------------------------------------------- Please DO NOT respond to me directly but post all responses here in the newsgroup so that all can share the information.
formatting link
.mspx?mid=49285b9f-5601-48f0-a664-6928de770384&dg=microsoft.public.pos
Reply to
Glenn Adams [MVP - Retail Mgmt
Hi,
If you are interested we can write a custom import solution for you.
Regards, Manick snipped-for-privacy@hotmail.com
formatting link
.mspx?mid=49285b9f-5601-48f0-a664-6928de770384&dg=microsoft.public.pos
Reply to
=?Utf-8?B?bWFuaWNr?=
QSCimport works OK.
For items, it's almost easier to use Excel to generate a series of query statements.
Unless you are absolutely helpless, don't pay for data import into RMS.
Tom
--
Stop fishing for e-mail


"mchenga" wrote:
 Click to see the full signature
Reply to
=?Utf-8?B?VGVycmlibGUgVG9t?=
Hi Tom,
I am obviously helpless as I don't know how you can import an excel file into RMS. Can you give me any hints as this would save a considerable amount of time.
Thanks
Andy
formatting link
.mspx?mid=49285b9f-5601-48f0-a664-6928de770384&dg=microsoft.public.pos
Reply to
=?Utf-8?B?QW5keSBXaWxsaXM=?=
Contact me by e-mail and I will give you some direction.
Basically, use the text functions in Excel to build a series of INSERT INTO statements, copy the statements into SO Admin and run them.
For every row, add this in the rightmost column: ="INSERT INTO Item (ItemLookupCode, Description, etc...) VALUES ("&ILC&", "&DESC&", "&ETC...&")"
Where the values referenced are cell references. The quotes are required.
The Excel VLOOKUP function can help you associate the items with the necessary SupplierIDs from the Supplier table. You'll want to export the supplier table and copy it into Excel - preferably to a separate worksheet within a single workbook.
If you need to import suppliers, do that first. Items second. If you want to import customers with account balances, use QSCimport. Importing customers (no account balances) would be OK.
Tom
--
Stop fishing for e-mail


"Andy Willis" wrote:
 Click to see the full signature
Reply to
=?Utf-8?B?VGVycmlibGUgVG9t?=
You can contact me and I will give you an FTP address to download the evaluation version of our RR Import Utility tool.
Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ] CEO - Retail Realm = = = = = = = = = =
formatting link
.mspx?mid=49285b9f-5601-48f0-a664-6928de770384&dg=microsoft.public.pos
Reply to
Afshin Alikhani
Yes it works with 2.0 Store and HQ
Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ] CEO - Retail Realm = = = = = = = = = = =
formatting link
.mspx?mid=49285b9f-5601-48f0-a664-6928de770384&dg=microsoft.public.pos
Reply to
Afshin Alikhani

I am looking for import thousands of items from Excel to RMS. Any suggestions are welcomed. If excel works, please provide more detail instructions.
Reply to
ming y

We have an Import Utility for RMS Store and HQ. This also allows for import of catalogues from different vendors.
Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk Retail Realm = = = = = = = = = = = = = = = = = = = =
Reply to
Afshin

There is a utility for importing from QuickSell - QSCImp. If you can find that somewhere then you can import from a text file that is saved in Excel.
Koit Lahesoo
Reply to
Koit Lahesoo

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.