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
Reply to
DonS
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
Reply to
Joie
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
Reply to
DonS
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
Reply to
Afshin
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:
formatting link
Doug Morton Mountain POS
Reply to
Doug - Mountain
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
Reply to
Joie
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
Reply to
DonS
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
Reply to
DonS
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
Reply to
Afshin
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
Reply to
DonS
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
Reply to
Doug - Mountain
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
Reply to
Afshin

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
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
Previous Posts In This Thread:
On Monday, January 12, 2009 11:45 AM
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
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
On Monday, January 12, 2009 1:18 PM
Thanks, Joie. Where do you go to perform the import? 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
On Tuesday, January 13, 2009 1:50 AM
Hi Don,You can evaluate the Retail Realm RR Import Utility if you wish. 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
On Tuesday, January 13, 2009 9:02 AM
The freeware tool "QSC Import" is an import tool from the early version of 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:
formatting link
Doug Morton Mountain POS
On Tuesday, January 13, 2009 10:41 AM
Perhaps if your items already in MS Access format you can export them to tab 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
"DonS"
On Tuesday, January 13, 2009 10:46 PM
RE: Import Items Into RMS 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
On Tuesday, January 13, 2009 11:13 PM
Re: Import Items Into RMS 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
On Wednesday, January 14, 2009 3:57 AM
Please note QSC Import does not import all data. 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 = = = = = = = = "DonS"
On Wednesday, January 14, 2009 9:01 AM
Re: Import Items Into RMS 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
On Wednesday, January 14, 2009 9:32 AM
For a free tool, it works just fine for my needs. 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
On Wednesday, January 14, 2009 1:09 PM
Hi Don,Drop me an email and I will sen dyou the link and instructions to get 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 = = = = = = = Submitted via EggHeadCafe - Software Developer Portal of Choice WPF Customized Find Control for FlowDocuments
formatting link
Reply to
Trish Yovanovich

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.