Import/Export Data

From Wiki

sitaceldr

Contents 1 Adding new items using the Store Operations Manager Program 2 Importing Items from a specific supplier using a CSV file 2.1 Find out the supplier ID for the items that are going to be imported. 2.2 Import Items to the database.

Adding new items using the Store Operations Manager Program

• Click on Database>>Items>>New
• Add new item information and save to enter new item.

Importing Items from a specific supplier using a CSV file

Find out the supplier ID for the items that are going to be imported.

• First Make sure the supplier exist in the database.
  • If the supplier doesn't exist in the POS database then add him before importing any data.
  • Learn how to add a new supplier in the RMS database.
• Find out what is the Supplier ID for the supplier that the items that are going to be imported, belong too. Find out how

Import Items to the database.

• The file you are going to be importing needs to be in a CSV format. If the file is not in a CSV form, it needs to be saved as one before import
• You will want to give a heading for each colum that is going to be imported to make it easier to understand what you are importing to where.
• You will also need to add another column named Supplier ID and fill all the columns with the Supplier ID that was found by the previous section above.
• Open the EMS MS SQL Import program by going to Start>>Programs>>EMS>>MS SQL Import. If you don't find the Import program in that path, you probablly don't have the program installed and you will need to istall it before using the import utility.
• Login to the Database using the username and password used for the database administration login.
• Open the CSV file and Pick the Database you will connecting too and the dbo.item database table you will be importing the items too and then click ok.
• Click on the Map Tab and specify which column represents which data type field by:
  • Click on the drop down field to select the name of the first column and then click on the Column Heading to select all fields below that column
  • Repeat the above step until all columns that are beeing imported are selected. You may skeep columns if you like.
• Click on the Options Tab and then the Import Mode Tab to select the type of import and choose, Update or Insert.
• Click on the Options Tab and then the Key Columns Tab to enter the key columns in the same order as the map
• Click next
• Save the Template if you will be reusing this import template in the future. Note that every data import can be different and may require it's own uniqe script if the CSV file is not the same. Save it by clicking on Tools>>Save Template