Documentation

File Import

Updated on

Feb 18, 2025

‍

  1. 1Click on the File Import tile. You can find it using the search or checking the Flat Data category.
Click to open in full screen πŸ‘€
  1. 2File Importing flow will be opened after accessing the corresponding datasource.
  1. 1Click to select a file from your computer, or simply drag and drop your file to this area.
Click to open in full screen πŸ‘€

Note

  • Supported file formats: CSV, TSV, XLS, XLSX, AVRO, ZIP, GZIP
  • Maximum size: 10 GB
  • A file must begin with column headers starting in column A. If additional information is provided before β€” it is necessary, use the Header rows to skip field to skip a certain number of rows to import data correctly.

  1. 2After picking the file a processing bar will show the upload progress. You can click on the β€œtrash bin” icon to cancel the file upload.
  2. 3After your file has been successfully uploaded and checked for security let’s move to the settings.
  3. 4Click on the Continue button.
  1. 1Set the Table name which will be used for loading data to your destination.
Click to open in full screen πŸ‘€
  1. 2Select the fields you need to import. By default, all fields are selected.
  2. 3Check the type. Each field in a data table can be assigned a text, number, or date type.
    1. The date field is a unique date-key in the database and should be singular. Also, you have the flexibility to choose from a wide range of date formats for this field.
    1. If you have fields with numeric values that you don't want to include in your calculations, change the type from Number to Text.

Note
You can learn more about how to work with dates in Flat Data here.

  1. 4The skip rule allows you to exclude empty rows and rows with specific values in selected fields
    1. Default to 'Do Not Skip': Ensures all data is initially included.
    1. Multi-Select Options: Combine 'Skip: empty' and 'Skip: value' for targeted exclusions. Selecting 'Do Not Skip' disables other skip options.
    1. Custom Rule addition: Add one custom rule; the form is disabled afterward to maintain focus
    1. Custom Rule deletion:  Hover over and click on the red-highlighted basket icon next to the rule to exclude it.‍

‍Usage Note: the component is designed for straightforward value-based selections and does not support complex expressions like '<10'.

Click to open in full screen πŸ‘€

Note
System default account ID, account name, and date_yyyymmdd fields are automatically added by default. The 'id', 'metrics', 'account_id' reserved for internal usage. Please do not import fields with the same titles to avoid data issues.

  1. 5Click on the Import N fields button to continue.
  1. 1Check the structure of data that will be extracted.
Click to open in full screen πŸ‘€
  1. 2Once you've reviewed the fields, click the Continue button to confirm settings and proceed with data extraction.
  1. 1Find the File Import on the Connections page.
  2. 2Choose one of the Imported Files. Each element in the list corresponds to a Data Tabe with a structure set during the first setup.
  3. 3Click to select a file from your computer, or simply drag&drop an additional file to this area.
  4. 4A list of uploaded files below will be enriched with a new file.
Click to open in full screen πŸ‘€
No items found.
Check out troubleshooting guides for
File Import
here:
No items found.
Related articles
No items found.
No items found.

Questions?

Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.