download free 30 days trial version buy simpledb explorer
Documentation   Download   Purchase   Support   FAQs   Forum   ScreenShots & Demos       

How to Upload CSV File Data by Specifying Column as an Item Name Using Amazon SimpleDB?

Upload  CSV File  Data using Amazon SimpleDB. You can upload CSV File data by specifying column name as item name using Amazon SimpleDB.
 

Follow the steps below to Upload CSV data in your domain :

  1. Run SDB Explorer as usual.
  2. After successful authentication, select any domain of any region end point from the tree on left hand side corner.
  3. Click on Import Data button situated over tool bar of main window.
  4. Select Import data from CSV from drop down window.
  5. A new upload panel will open.
  6. Browse the CSV file from your local native file system whose content you would like to upload.
  7. Keep that default setting as-is only if you have comma separated values, commented line starts with #, qualifier is " " and you would like to specify 1st row as an Attribute name. If not so then update settings.
  8. Specify separator by which you want separate multi-values for an attribute.
  9. Provide the Column number from the Column Number box that you would like to specify as an Item Name. This column must have unique values. 
  10. You can set desired number of rows in combo box for preview.
  11. Click on  Preview . It will show the exact structure according to your specified setting in combo box . 
  12. Then click on 'OK' button.
  13. A new ADD/REPLACE panel will open, and without any change hit on Ok button.
  14. You will see a progress bar running while opening queue panel.
  15. After some time a queue panel will open and the upload process will start.
  16. You can see uploaded data after queue process gets over, by double clicking on domain in which you have uploaded.
  17. You will see that the column number that you have mentioned , will be item name for the uploaded data.

Related Topics