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.
Video - DataSet Via Email 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 file type for your attachments:
Notes:
|
From Email Address |
Enter the email address you will be sending attachments from. Emails sent from other email addresses will be rejected. Enter NONE to accept emails 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 that will be used to validate the subject of the email you send. Emails with a subject that do not fully match the expression will be rejected. Enter NONE to accept any email subject. 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 |
Check the box to show advanced configuration options. |
Header Row (Optional) |
Enter the header row number. If you do not enter a number, the first row is considered the header row. |
Skip Footer Rows (Optional) |
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 (Optional) |
Enter the starting data row number. If you do not enter a number, the first row after the header row is considered the starting row. |
Delimiter | Select the delimiter used to parse your CSV file. If you select Detect the delimiter, the appropriate delimiter is determined automatically. |
Escape Character | Select whether or not to use an escape character. |
Quote Character | Select whether to use double quotes or single quotes as a quote character, or no quote character at all. |
Detect Encoding | Check this box if you want Domo to detect your encoding type automatically; leave it unchecked if you want to enforce UTF-8 encoding. |
Excel Sheet Name |
Enter the sheet name of the Excel file you want to create a DataSet from. |
Excel Sheet Tab Number |
Enter the tab number of the Excel sheet you want to create a DataSet from. |
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 used in the attachment. If you want dates to be represented as text, select Show Dates as Strings. |
Data Contains Header Row | Set this to true if the data contains a row containing column headers. Set this to false if the data does not contain a header row. |
Number 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. |
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 | 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. |
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"""
Comments
0 comments
Please sign in to leave a comment.