|
You can Import data from CSV and upload that imported data to Amazon SimpleDB. SDB Explorer helps you to auto generate Item Names while bulk uploading.
Follow the steps below to Upload CSV file data with auto generated item name:
-
Run
SDB Explorer
as Usual.
-
After successful login, 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 the main window.
-
Select
Import data from CSV
from drop down window, it will open a new panel.
-
Browse the valid CSV file from your local native file system.
-
Keep that default setting as it is only if you have comma separated values, commented line starts with #, qualifier is " ", and you want to specify 1st row as an Attribute name. If not so, then update parse settings.
-
Specify separator by which you want separate multi-values for an attribute.
-
Uncheck the check box for Column Number.
-
Provide starting Number i.e. from where you want to start generating numbers.
-
Provide zero pad digits for e.g if you have, between 1 to 99 rows, to be uploaded then you have to provide 2 or more than two. If you have between 100 - 1000 rows, to be uploaded then you have to provide 4 or more than four.
-
Providing prefix is optional.
-
Example 1:
-
* Starting Number - 0
-
* Zero Pad Digits - 1
-
* Result : 0, 1, 2, 3.. N (Number of Rows)
-
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 be opened, now without any change click on
Ok
button.
-
After some time a queue will be opened and the uploading process will start.
-
The database row will be uploaded in batch. A single batch will process 25 rows.
-
If batch gets succeeded then success count must be updated, if batch gets failed then fail count must be updated.
-
After queue processing gets over, double click on domain in which you have uploaded.
-
The number of rows that have been uploaded successfully, will be shown in GRID.
|
Related Topics
|
|
