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.Note: 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 15:14:05).
- 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., t662528755_yourusername). The path to the parent folder will be automatically prepended to the Full Path.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 box.
- Click Advanced.
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 in 1010data.
- Depending where the file you want to upload is located, do one of the following:
Option Description 1010data FTP account In the field below the Source options, click the file containing the table you want to upload.Note: You must have already transferred the file to your 1010data FTP account. For instructions, see Transfer a file to your FTP account. Local file 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 file yourself.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 for you.
- Click Auto Detect File Specs.
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 file.
For details, see table 2 in our User Guide page for Table UploadingNote: 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 Save. 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.