Import Items Into RMS

Friends:
I need to import items into RMS database. Does RMS have an import routines to intitially charge up the items table?
I've been trying to run an append query thru Access 2007 ODBC connection.
Do I append to DBO_Item. That table does NOT allow new records to be added. Do I use one of the PUBLIC tables?
I'm lost. Please help me. I have to get this database up and running this week.
Thanks, D
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Hi D
I dont think RMS out of the box has the import feature What i am doing is create a spreadsheet in XLS and generate the SQL statements to insert from there using XLS text/string functions
There are alot of 3rd party add on that allow u to import data into the RMS for example from RetailRealm. I have never tried any of this import addons
If you decide to use own SQL statements here what i can suggest : - Do not populate the quantity column with your initial inventory count, the default is 0 - Instead you should only load the Itemlookupcode, description, prices, cost for start - Create a transfer In with all your item - the default value will be 1 - Edit the item quantities in that Transfer in with actual quantity - Select "Receive all" for that transfer in
If you just need to play with RMS for testing, you can use the sample database.Instructions are in the manual
About the error, does the user used in your ODBC connection has the proper right to the target database? If you can get 'sa' account, may be the error will go away
Hope that helps rgds, joie

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Thanks, Joie. Where do you go to perform the import? How do you connect your spreadsheet data into the actual SQL database?
Are you bringing your XLS items i nto the SQL data tables? Are you bringing them in as ITEMS ... or in as TRANSFER INs?
I am using sa to connect to the database. It lets me edit Items table, but not add new items. That connection does let me add new records to other tables, just NOT the ITEMS table.
Can you explain more please?
Thanks, D
"Joie" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Perhaps if your items already in MS Access format you can export them to tab delimited file and then use the utilities that either Doug or Afshin suggested. This way is less technical.
So if you still prefer the hard way like me, here's the steps that i have taken in the past (no idea about the fail to insert in the Item table when u use sa account)
1. You have to make a series of SQL insert statements manually The easiest is to use XLS string concatenation functions the result should be something similar to this INSERT Item(ItemLookupCode, Description, Price.Cost) Values('100100100', 'ItemName01', 5, 3)
2. Copy that SQL statements 3. Open store operations Administrator, connect to the target database 4. Click Query ->New 5. Paste your sql statements 6. Click the "Run" button (green triangle) 7. Open store operations Manager 8. Click Inventory -> Transfer In 9. Click New -> Choose Generate all items in the selected group 10. Below it, choose all items and hit OK 11. Now Edit the newly created Transfer in 12. Openon theOn the tab "header" fill whatever you think is necessary 13. On the tab "content", you will see whatever items that you have imported in step 6 is listed there with Qty Ord = 1 14. You can edit that column with the actual quantity that you have or you can edit the item quantity later. Hit OK 15. Highlight that new Transfer In and click "receive" 16. Click "Receive All" and OK. you are done
Someone in this forum taught me why it is necessary to go through step 7-16 because you want your item quantity history to be correct on the reports.This is because if you fill in the quantity column in SQL statements, it WILL NOT be audited and therefore your item movement history report will always be off by this amount. I follow the steps above because all my items information are initially written using pen and paper.
Its pretty strange that the account 'sa' cant add record to that 'specific' Item table because by default the 'sa' comes with server role 'sysadmin' which can do anything in the SQL Server database.
May be if you still have problem adding new record into Item table, you can try to backup your current RMS database and create a new database?
Hope that helps, Joie

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Joie:
Thank you. I have test your single insert command and it worked. I also understand what you are saying about the historical postings of transactions.
You've been a great help.
Don
"Joie" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Hi Don,
You can evaluate the Retail Realm RR Import Utility if you wish. The modue is widely used and it works with Store and HQ database. Additionally it has capabilities to import historical sales information. One other major function in RR Import is the Catalogue feature. You can saveteh import format of your various suppliers and then use the catalogue to update price, cost or add new items to your databse. This is colour coded and sorted in a tree structure to ease the viewing of the data in the Catalogue. Contact me for more information.
Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk Retail Realm = = = = = = = =

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
The freeware tool "QSC Import" is an import tool from the early version of what RMS is built upon - Quick Sell. It works just fine. I had all my data in a spreadsheet and then exported it (or saved it) as a tab delimited text file. Then this tool scans it, you then map the fields, and then it imports it into the RMS database. If you use Outlook Express as your reader for this newsgroup, you will find it as an attachment in many threads (you can't download it via a browser reader). However, I couldn't locate it this morning so I placed it on my website: http://www.mountainpos.com/downloads/Store_Operations_Import_Utility.zip
Doug Morton Mountain POS
"DonS" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Doug:
Thank you for the good information. I had run into that utility before and thought that I had struck out.
WHERE do you tell it to direct the output to RMS SQL data tables? It just looks to me as if it is headed for the qsc data tables.
Thanks, Don
"Doug - Mountain POS" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
For a free tool, it works just fine for my needs. As Afshin is stating his product has more features, but I don't have a need for more at this time. As to pointing the import data to a database, the tool asks for the database instance that you are wanting to populate in the wizard. While it says QuickSellImport Database, that is just a title - when you hit Connect, it asks for the database properties that you wish to connect and then the next step is what tables you want to populate (inventory, customers, etc...). It does the rest. The one thing I don't like about it is the error control (or lack of). If something is formatted wrong, it does not prompt you to fix it - it just tells you it is complete. Doug Morton Mountain POS
"DonS" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Hey, been trying to track you down. Hope this works. e-mail me at snipped-for-privacy@consigningdesign.com. I need some Zebra labels and advice. Hope I hear from you soon.
Trish
DougMountainPO wrote:
For a free tool, it works just fine for my needs. 14-Jan-09
For a free tool, it works just fine for my needs. As Afshin is stating his product has more features, but I don't have a need for more at this time. As to pointing the import data to a database, the tool asks for the database instance that you are wanting to populate in the wizard. While it says QuickSellImport Database, that is just a title - when you hit Connect, it asks for the database properties that you wish to connect and then the next step is what tables you want to populate (inventory, customers, etc...). It does the rest. The one thing I don't like about it is the error control (or lack of). If something is formatted wrong, it does not prompt you to fix it - it just tells you it is complete. Doug Morton Mountain POS
"DonS" wrote:
Previous Posts In This Thread:
On Monday, January 12, 2009 11:45 AM Don wrote:
Import Items Into RMS Friends:
I need to import items into RMS database. Does RMS have an import routines to intitially charge up the items table?
I've been trying to run an append query thru Access 2007 ODBC connection.
Do I append to DBO_Item. That table does NOT allow new records to be added. Do I use one of the PUBLIC tables?
I'm lost. Please help me. I have to get this database up and running this week.
Thanks, D
On Monday, January 12, 2009 12:55 PM Joie wrote:
Hi DI dont think RMS out of the box has the import featureWhat i am doing is Hi D
I dont think RMS out of the box has the import feature What i am doing is create a spreadsheet in XLS and generate the SQL statements to insert from there using XLS text/string functions
There are alot of 3rd party add on that allow u to import data into the RMS for example from RetailRealm. I have never tried any of this import addons
If you decide to use own SQL statements here what i can suggest : - Do not populate the quantity column with your initial inventory count, the default is 0 - Instead you should only load the Itemlookupcode, description, prices, cost for start - Create a transfer In with all your item - the default value will be 1 - Edit the item quantities in that Transfer in with actual quantity - Select "Receive all" for that transfer in
If you just need to play with RMS for testing, you can use the sample database.Instructions are in the manual
About the error, does the user used in your ODBC connection has the proper right to the target database? If you can get 'sa' account, may be the error will go away
Hope that helps rgds, joie
Retail Realm = = = = = = = =
Submitted via EggHeadCafe - Software Developer Portal of Choice WPF Customized Find Control for FlowDocuments http://www.eggheadcafe.com/tutorials/aspnet/233d3397-0388-473c-8473-721a40cf910c/wpf-customized-find-contr.aspx
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Please note QSC Import does not import all data. Limited to only flat fle import and cannot do Data Base ot Database import. No Catalogue and compare facility either if you plan to reuse the import periodically to update your supplier item catalogue and cost and price. It does not import past transaction from another syste, or past created PO and ransfers from another system. RR Import Utility does all above.
Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk Retail Realm

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Afshin:
THank you for that information. Do you have a link where I can read more about the product, demos and pricing for US?
Thanks, Don
"Afshin" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Hi Don,
Drop me an email and I will sen dyou the link and instructions to get an evaluation copy.
Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk Retail Realm

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.