DatamineHub Docs

Appearance

Import File To Sheet ​

Here is an explanation of what a chart is and what it is used for. How to create and manage them.

INFO

If this is your first time knowing DatamineHub, you may wonder what DatamineHub does and whether it can meet your needs. You can quickly browse our brief introduction and main concepts

INFO

If you don’t have an account yet, you can give it a try. DatamineHub offers a permanent free tier, and no credit card is required for registration.

DatamineHub Web App

You can also start with mobile app and scan your barcode with mobile app for free.

download from apple store, start to track your inventory and others with great barcode scan
download from google play store, start to track your inventory and others with great barcode scan

WARNING

Import file feature is only available on DatamineHub Web App.

INFO

You can also watch the corresponding video (double click to full screen)

What's File Import? ​

We can add items one by one on the working sheet page, or scan the code to add items on the mobile app. These are very convenient. However, if you already have a batch of data files on hand. You want to manage and maintain your data in DatamineHub, and analyze your data through our analytics platform. If you still need to add items one by one, it will be very inefficient. With import file, you can import a large amount of data at one time.

How to import a file? ​

On the sheets page, you can start uploading files by clicking the import file button. Or you can also do that on the working sheet page.

[Double click the image to enlarge] click the import file button on sheets page to start the import file workflow.

Click import file and the Import data to sheet window will pop up. The whole import process is divided into three steps.

[Double click the image to enlarge] the import file workflow consists of three steps. upload file, field mapping and preview.

Step 1. Upload file. Select a file from your computer. Currently, the file cannot exceed 10 MB. Only comma-separated CSV format files are supported. The first line is the header, which is the name of each column. This is an example of a CSV file. The first line is the name of each column, AmazonOrderId, SKU, ListPrice and so on. From the second line onwards is the actual data. They are all separated by commas. If the file you have is not in csv format, such as the common excel format or other formats. Basically all these formats can be converted into csv format.

There are two options to import the file to. One is a new sheet. The other is an existing sheet. If it is a new sheet, the system will automatically create field names based on the sheet. If it is an existing sheet, no matter whether the sheet is based on template or non-template, no fields will be created, and you need to match the fields in the next step.

Now let's choose new sheet and give the sheet a name.

[Double click the image to enlarge] in the first upload file step, upload a CSV file that doesn't exceed 10 MB,set to new sheet with name Amazon order.

Step 2. Now we come to the second step. Field Mapping. On the left is the name of each column extracted from the first row of csv. Because we just selected new sheet. So there is no need to do mapping operation. But if you want to change the column name obtained from csv, you can modify it in the middle part of the correspondence. Then after the name is the data type. The default is text. Unlike the fields we create templates or sheets, it can support complex types such as options, money, and formula. Only ordinary text, number, decimal, and date time types are supported in the imported file. You can select the appropriate type based on the actual situation of the data. The checkbox in the last part indicates whether the data is required, and the default is yes. If it is required, but the data is not provided in the csv, then the error will be displayed in the next step of verification.

[Double click the image to enlarge] in the second field mapping step, map the fields from uploaded CSV file to sheet, choose the proper data type, is required.

Step 3. Validation. If there is any error, the error message will be displayed. We can go back to the previous step to fix the error and verify again. Such as below error example, we just intentionally changed the type of the quantity field to date time, which is obviously wrong. So these errors are displayed during verification. These error messages show which specific line has an error and what the error is. This information can help us locate the source of the error and fix it.

[Double click the image to enlarge] set the Quantity data type to datetime purposely to produce error in the next validation.

[Double click the image to enlarge] the valiation check every single row and each field to make sure the data type is correct, otherwise, show the errors.

If everything is good, it shows validation passed. Click the 'Finish' button to save the file to the sheet.

[Double click the image to enlarge] if the data type is set correctly for all fields, the validation passed info would tell this.

Now, we can see the saved sheet and its items.

[Double click the image to enlarge] the file is imported into the new sheet successfully, the sheets page show the new created sheet amazon orders.