Skip to main content

​
Intro

The File Upload Connector enables you to bring your important spreadsheet files into Domo and helps to make quick decisions. Irrespective of the file type that you choose (CSV, XLS, or XLSX), there are a wide range of configuration options to meet your custom file needs. This connector uploads files larger than 250 MB. You can connect to your File Upload Legacy account in the Data Center. This topic discusses the fields and menus that are specific to the File Upload Legacy connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Data Connector.

​
Prerequisites

No prerequisites are required to create a Dataset.

​
Details Pane

The following fields are available in the Details pane:

Menu

Description

Select File

Select a file. The maximum file size is 256MB.

File Type

Enter file type that you want to import.

File Password

If your file is password protected, enter the file password.

Sheet Name

Enter the sheet name you want to retrieve from the specified spreadsheet. Ensure to verify the sheet name for accidental spaces. First sheet of the workbook will be used if the field is blank.

Update method

When Domo retrieves your data from the source, you can determine how new the data is imported into the current DataSet. You can select Append or Replace from the drop-down list.

  • Append - This method takes your new data and adds it to your current DataSet. Using this may create duplicate data entries.
  • Replace - This method takes your current DataSet and replaces it with new data. Using this may result in some data loss.

​
Advanced

The following fields are available in the Advanced pane:
Field Description
Layout Select the Layout.
Mode

Select parsing options from the drop-down list.

  • Auto - detects cell range.
  • Manual - Enter the cell range.
Column Header Range

Enter the range of cells which will be used as headers (for example, A2:F8). This field appears if you select the Mode as Manual .

Data Range

Enter the range of cells which will be used as data (for example, A3:F20). This field appears if you select the Mode as Manual .

Include Phonetic Data

If you want to append Phonetic data, then select True , or select False . By default False is selected.

Row Header Range

Enter the range of cells which will be used as headers (for example, A2:A8). This field appears, if you select the Layout as Row As Header and the Mode as Manual .

Delimiter Select the character used by your character-separated values (CSV) text to separate your columns. If your delimiter is not listed select ‘Other’.
Specify Your Delimiter Enter the character used to delimit your character-separated values (CSV) text. This field appears when you select Other from the Delimiter drop-down list.
Quote Character Select the desired quote character for parsing CSV files. (Double quote is the default quote character for CSV standard)
Custom Quote Character Enter the desired CSV Quote character. This field appears when you select Other from the Quote Character drop-down list.
Escape Character Select the desired escape character for parsing CSV files.
Custom Escape Character Enter the desired CSV escape character. This field appears when you select Other from the Escape Character drop-down list.
Detect Encoding Select Yes to auto detect file encoding and No to manually select the encoding.
File Encoding This option appears if you select No from the File Encoding drop-down list.
Add Filename Column Specify if BATCH_FILE_NAME column should be added to the final output or not.
Header Start Row Enter the row number from where the header starts.
Data Start Row Enter the row number from where the data starts.
Footer Rows To Skip Enter the number of rows at the end of the file to skip. For example, to skip the last two rows you should enter 2 .
Date Format Select the date format that should be used when you want to convert date columns.(For excel files, date format specified for the cell will have higher precedence).
Blank Rows If you encounter blank rows, either select Skip blank rows or Stop at the first blank row .
Empty Column Headers If you encounter, empty column headers, either select Add blank columns or Stop at the first blank column . If you choose Add blank columns , the column names are automatically generated for the new columns.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.