CSV or Excel Spreadsheet Pickup

<< Click to Display Table of Contents >>

Navigation:  Message Retrieval Accounts > Reading/Receiving Messages >

CSV or Excel Spreadsheet Pickup

ThinkAutomation can read CSV (Comma Separated Values) files and Microsoft Excel Spreadsheet files (Excel 2007 or higher). It can create a new message for each new row in the CSV file or Spreadsheet.

 

Click the CSV or Excel File Pickup option on the Ribbon bar.

 

account-csv

 

Click the Enable CSV & Excel Spreadsheet File Pickup option to enable.

 

Select the Pickup Folder on your PC that ThinkAutomation should watch for new files. Enter the File Name or enter *.xlsx for all Excel files or *.csv for all CSV files.

 

Enable the Delete File After Pickup option if you want ThinkAutomation to delete files after it has processed the contents. If this option is not selected then ThinkAutomation will remember the row number for each processed file. It will then only create messages for NEW rows added to the existing file.

 

Enable the CSV File Has No Header Row option if you are reading a CSV text file and the data starts on row one. By default when a CSV file is picked up the first row is assumed to be the header row containing the field names.

 

For Excel files you can optionally enter the Worksheet to use if the spreadsheet contains multiple worksheets. Leave blank to use the first worksheet. You can also enter the Header Row number. This is the row in the spreadsheet that contains the column headers. If zero then the first non-blank row will be used.

 

Default Pickup Method - How It Works

The CSV & Spreadsheet File Pickup option differs from the regular File Pickup option in that a new message will be created for each row - whereas the File Pickup will create a single message for the entire file.

 

For example, consider the following spreadsheet:

 

Product

Name

Quantity

Value

Item 1

Item 1 description

100

1.20

Item 2

Item 2 description

200

1.30

 

When ThinkAutomation reads this spreadsheet (or CSV file) it will create 2 messages in the following format:

 

Message 1:

 

Row: 1

Product: Item 1

Name: Item 1 description

Quantity: 100

Value: 1.20

 

Message 2:

 

Row: 2

Product: Item 2

Name: Item 2 description

Quantity: 200

Value: 1.30

 

The subject of the message will be '[filename] Row x'

 

The message body will be set to each column on a line of its own in the format 'header row text: column value'.

 

This layout will enable you to easily parse the contents.

 

ThinkAutomation assumes that new rows will be added to the end of the file. New messages will be created for each new row found.

 

Specific Cell Pickup Method - How It Works

Click Edit Cells in order to define the cell references you wish to pull values from.

account-csv-editcells

 

When the cell values are picked up, a message will be created containing the values of each of the specified cells. If no value was found, the value is shown as blank.

 

A10: test 1

G10: test2

D4:

I10: test4

 

 

 

 

ThinkAutomation © Parker Software 2016