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.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?midI285b9f-5601-48f0-a664-6928de770384&dg=microsoft.public.pos
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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. http://www.retailrealm.co.uk
Glenn Adams Tiber Creek Consulting http://www.tibercreek.com 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.
mchenga wrote:

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?midI285b9f-5601-48f0-a664-6928de770384&dg=microsoft.public.pos
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Hi,
If you are interested we can write a custom import solution for you.
Regards, Manick snipped-for-privacy@hotmail.com
"mchenga" wrote:

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?midI285b9f-5601-48f0-a664-6928de770384&dg=microsoft.public.pos
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Afshin, Does your import utility work with v2.0?
"Afshin Alikhani" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Yes it works with 2.0 Store and HQ
Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ] CEO - Retail Realm = = = = = = = = = =

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
I am looking for import thousands of items from Excel to RMS. Any suggestions are welcomed. If excel works, please provide more detail instructions.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
CSV for the import utility,
=============<ming y> wrote in message

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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 = = = = = = = = = = = = = = = = = = = "ming y" wrote in message

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.