Using the Advanced Upload feature, you can upload a table to 1010data with a finer
grain of control.
The Advanced Upload feature provides many options for fine-grained control over the
data you are uploading. In addition, the Advanced Upload feature is recommended when
uploading a file in the user interface that is larger than 20 MB in size.
When you perform an Advanced Upload, you have the option of choosing either a local
file or a file in your 1010data FTP account. To choose a file from your FTP account,
you must first use a third-party FTP client to transfer the file to 1010data. For
instructions, see Transfer a file to your FTP account.
To upload a table using the Advanced Upload:
In the Folders and Tables browser, select the folder where
you want to upload your table.
You can only upload tables to folders you own (
) or have permission to modify (
On the Folders and Tables toolbar, click the
Upload () icon.
1010data displays fields related to the table beneath the toolbar.
In the Title field, enter the title of the table.
The title is used to help describe the contents of a table (e.g.,
Sales Detail by Customer). The title may contain
any combination of uppercase and lowercase letters, numbers, spaces, and
special characters. If you leave this field blank, a system-generated title
will be used (e.g., Uploaded 2014-01-02
In the Full Path field, enter the table name.
The table name must begin with a letter and can only contain numbers, letters,
and underscores. It cannot contain any spaces or other special characters. If
you leave this field blank, a system-generated name will be used (e.g.,
). The path to the
parent folder will be automatically prepended to the Full
Note: If you are uploading to the My
Data folder, the path uploads will be
automatically prepended to the Full Path, and a
system-generated table name will be used (e.g.,
uploads.t662528755_yourusername). You will
not be able to enter anything into the Full Path text
The Advanced Uploader tab opens. By default, the
FTP option is selected and any files transferred
to your 1010data FTP account are listed.
The Advanced Uploader tab is used to select the
file you want to upload and to configure how that table should be formatted
Depending where the file you want to upload is located, do one of the
|1010data FTP account
||In the field below the Source options, click
the file containing the table you want to upload.
||Click Local File, then click the
Choose Files button and select the file
containing the table you want to upload.
Do one of the following:
- Click Auto Detect File Specs.
Click this button
to have 1010data automatically configure the settings for the table
based on the data in the file. If the file is formatted and delineated
properly, 1010data will identify the number of columns in your table,
create a section for each column to provide the necessary information,
and complete as much information as possible from the data in the file.
While you may need to make some adjustments afterward, this option can
save you a lot of time and effort compared to manually configuring the
Note: The Auto Detect File
Specs button cannot be used on a compressed file. If
a saved specification file does not exist for the compressed file,
you can either manually configure the upload file or you can create
a new specification file. To create a new specification file for a
compressed file, first prepare a small sample of the table that
contains all of the columns in the table. Next, upload the sample
file into 1010data using the Advanced Upload feature. Once the
uncompressed sample is uploaded, click Auto Detect
File Specs. After 1010data identifies each column in
the table and completes the appropriate Column
Information fields, you can either select the
compressed file in the field below the Source
options and continue with the compressed file upload or save the
specification file for later use.
- Select a previously saved specification file from the drop-down list and then
click the Load Spec () icon.
Select this option to use a
previously saved specification to configure the settings for the table.
This option is best used if you regularly use the Advanced Upload
feature to add tables to 1010data with the same data format. For
example, if you upload weekly sales data, the specification file can
automatically complete all of the configuration settings of the table
1010data identifies each column in the table and completes the appropriate
Column Information fields.
Complete or edit the File Information, Table
Information, and Column Information
fields and options.
As necessary, you can add, clone, move, or delete a column before uploading the
For details, see Table 2.
After configuring the fields and options in your file, you can create a
specification file so the settings can be used again. This is helpful if you
regularly upload files with the same data format. To save the settings,
click the Save Spec () icon
, name the file, and click
. The specification file is added to the drop-down list.
At the top right side of the Advanced
Uploader tab, click Start Load.
1010data uploads the file and creates a new table. Once the process is
complete, the Folders and Tables browser hides and
the table opens in a new tab.
After the file has been successfully uploaded to 1010data, you can share the table
with other 1010data users.