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.
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.
Glenn Adams Tiber Creek C> Hi, i have large list of items, how could i import them into RMS? any tools? > -Cheng >
Hi,
If you are interested we can write a custom import solution for you.
Regards, Manick snipped-for-privacy@hotmail.com
"mchenga" wrote:
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
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
"Terrible Tom" wrote:
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
You can contact me and I will give you an FTP address to download the evaluation version of our RR Import Utility tool.
Yes it works with 2.0 Store and HQ
I am looking for import thousands of items from Excel to RMS. Any suggestions are welcomed. If excel works, please provide more detail instructions.
CSV for the import utility,
We have an Import Utility for RMS Store and HQ. This also allows for import of catalogues from different vendors.
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
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.