|
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 :
-
Run
SDB Explorer
as usual.
-
After successful authentication, select any domain of any region end point from the tree on left hand side corner.
-
Click on
Import Data
button situated over tool bar of main window.
-
Select
Import data from CSV
from drop down window.
-
A new upload panel will open.
-
Browse
the CSV file from your local native file system whose content you would like to upload.
-
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.
-
Specify separator by which you want separate multi-values for an attribute.
-
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.
-
You can set desired number of rows in combo box for preview.
-
Click on
Preview
. It will show the exact structure according to your specified setting in combo box .
-
Then click on
'OK'
button.
-
A new
ADD/REPLACE
panel will open, and without any change hit on
Ok
button.
-
You will see a progress bar running while opening queue panel.
-
After some time a queue panel will open and the upload process will start.
-
You can see uploaded data after queue process gets over, by double clicking on domain in which you have uploaded.
-
You will see that the
column number
that you have mentioned
,
will be item name for the uploaded data.
|
Related Topics
|
|