Intro
The Dataset via Email connector enables you to get your data into Domo quickly and easily by capturing and processing.xls,.xlsx, and.csv files that have been included as attachments to an email message. Additionally, the DataSet via Email Connector can parse through a Gzip or Zip file to return a.csv or.xlsx file. When you configure this connector, it generates a unique email address that corresponds to your Dataset via Email DataSet in Domo. Once the email address is created, you can send the spreadsheet as an attachment to that email address. The connector will then process the email and update your data accordingly. Please note that this connector currently pulls in data from only one attachment. If your email message includes more than one attachment, data is pulled from the first listed attachment. Note that each time you configure this connector, you do so for an attachment with a fixed set of characteristics. For instance, if you create a configuration for CSV files with specific parameters, you cannot then send XLS spreadsheets to the email address that is generated unless you go back into the connector interface and switch the file type to XLS. If you want to change the attachment file type, it is highly recommended that you create a new connection with its own email address. You configure settings for your DataSet via Email connection in the Data Center. This topic discusses the fields and menus that are specific to the DataSet via Email connector user interface. General information for adding DataSets and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.Prerequisites
None. No credentials are required.Configuring Your DataSet via Email Connection
This section enumerates the options in the Details pane in the DataSet via Email connector page. The components of the other pane in this page, Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.Details Pane
This pane contains various options for configuring your DataSet via Email connection.Menu | Description |
|---|---|
| Automatically generates the email address you will send your attachments to. Click Copy Email to copy this email address to your clipboard. | |
| File Location | Select a file location option:
|
| File Type | Select the type of file you want to send. GZip and Z ip compressed files are supported and will be decompressed and parsed from the selected file type. Select the file type for your attachments:
Notes:
|
| From Email Address | Enter a full email address or email domain (i.e. @ domo.com ) that this connector will accept files from. Emails from other addresses will be rejected. Enter NONE to accept email from any email address. Note: Make sure that the email in the configurations matches the email you are sending the file to. |
| Email Subject Expression | Enter a regular expression to validate the subject of the email you will send. Emails with a subject that do not match the expression will be rejected. Enter NONE to accept any email subject. Here is an example of a full match: Subject = 1900 Audit Report for Domo |
| Email Body Expression | Enter a regular expression that will be used to validate the body of the email you send. Emails with body content that do not fully match the expression will be rejected. Enter NONE to accept anything included in the body. Here is an example of a full match: Body = Here is the Audit Report file to upload to Domo. |
| Attachment Name Expression | Enter a regular expression that will be used to validate the filename of the attachment. Attachments that do not fully match the expression will be rejected. Enter NONE to accept any filename. Here is an example of a full match: Attachment = 1.audit_report_1.1.1900.1.00AM.xlsx |
Show advanced options (checkbox) | Select the checkbox to show advanced configuration options. |
Include HTML Body (checkbox) | Select this checkbox to include the HTML body of the message in your data. |
Process first file when the file type is zip (checkbox) | This checkbox appears when you select the Show advanced option checkbox. If a zip file contains two same file name of a particular file type, and if you want to process the first file type that appears, then select this checkbox. |
Data Contains Header Row | Set this field to true if the data contains a row containing column headers, or set this field to false if the data does not contain a header row. |
Header Row | Enter the header row number. If you do not enter a number, the first row is considered the header row. |
Skip Footer Rows | If there are one or more rows at the bottom of the file you do not want to import, enter the number of rows to skip. |
Starting Data Row | By default, the row following the Header Row is considered as the Starting Data Row . If the data starts on a different row, enter the row number. |
| Delimiter | Select the desired delimiter for parsing CSV files. |
| Escape Character | Select the desired escape character for parsing files. |
| Quote Character | Select the desired quote character for parsing CSV files. |
| Detect Encoding(checkbox) | Check this box if you want Domo to detect your encoding type automatically; leave it unchecked if you want to enforce UTF-8 encoding. |
| Encoding Options | By default the connector detects the encoding based on the confidence value, however the value must be greater than 50%. Even if the detected highest encoding value is less than 50%, you can use the Consider Highest Encoding option, to consider that encoding. You can use the Specify Encoding option to enter the encoding of your choice in the Enter Encoding text field below. |
| Enter Encoding | Specify the encoding. |
| Raw Headers | If you select Yes , the connector will use the headers in the sent file. If you select No , the connector will modify any special characters found in the header text. |
Date Format | Select the date format that is used in the sent file. |
| Numbers As Strings Columns | Selecting yes will add a column for all columns that are numbers and format them as strings to preserve their original format including any leading zeros. |
| Leading Zero As String | Select ‘yes’ to interpret the numbers that have a leading zero (e.g. ‘01234’) as a string. This will preserve the leading zero. |
| Ignore Decoding Errors | Select ‘yes’ to ignore decoding errors. Only data that is processed before the decoding error will be retrieved. This is recommended if there are extraneous characters at the end of the email file that are corrupt. |
| Allow Leading Digit in Column Name (checkbox) | Select if you want to allow column names to begin with a digit. Otherwise, every column name that starts with a digit will have the letter ‘C’ prefixed, i.e. ‘C123’. |
| Skip Empty Rows | Select this checkbox to avoid adding empty rows to the dataset. |
| Subject Regex | Enter a regex with grouping and each group found in the subject will be added as a column. |
| Body Regex | Enter a regex with grouping and each group found in the subject will be added as a column. |
| HTML Table Number | Select the number of the table, by default the first table found is used. |
| HTML Table Tag | Select the table tag of the table, by default table is used. This must be a valid HTML element. |
| HTML Row Tag | Select the row tag of the table, by default tr is used. This must be a valid HTML element |
| HTML Cell Tag | Select the cell tag of the table, by default td is used. This must be a valid HTML element or if nbsp is used to delimit the columns then specify ‘space’ as the cell tag. |
| Excel Sheet Name | Please enter the excel sheet name that you would like to parse. |
| File Password | Enter the password if the file is password-protected. |
| Excel Sheet Tab Number | Please enter the Excel sheet tab number that you would like to parse. |
| Use Raw Numbers | Check this box to pull the values as raw numbers. |
| Ignore File Content Type | Select this checkbox to ignore the file content type and process the file according to the selected file type. |
| Special Characters Present (checkbox) | This checkbox is enabled when you select the File Type as xlsx, and you need to select the Show advanced options checkbox. Select this checkbox if you have special characters in the XLSX file (for example, Double Quote(”), Comma(,), and so on). |
| Columns As String | Enter the comma-separated list of columns to be added as String columns |
| Include Attributes (checkbox) | Check to include XML attributes in your data. |
| Link Match | Set the link to download the file. When the ‘File Type’ is selected t hen the link must have the extension for the selected file type . If a different string is selected then, fill the string to match. The link that matches first will be used. |
| Wait | Number of seconds to wait before downloading file from link in email. |
| Attachment Match | Specify some text that is contained in the download link to uniquely identify the file download link. |
| Attachment Regex Match | Specify some text that is contained in the download link to uniquely identify the file download link. |
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.Troubleshooting
Data is parsed incorrectly, such as having more rows or columns than expected.
Ensure any literal quote character in a field’s data is escaped to avoid it being parsed as one of the quote characters that enclose the field. A quote character can be escaped by the following ways:- Using backslash (\ ): “dimensions”, “two-by-four: 2” x 4""
- Using the quote character twice: “dimensions”, “two-by-four: 2"" x 4"""