Property Tasks - CSV Import

CSV Import - Overview

CSV Import allows users to import a .csv file straight into the Data Template of a Property Task. Users can now easily mass enter results without having to type them in manually, or copy-paste.

To import a .csv into a Data Template, click on the three dots (...) inline to the block select Import CSV.

Screenshot 2023-12-12 at 5.43.17 PM.png

Once selected, Albert will prompt the user to either drag the file into the selected file drop or to browse for the file from a folder on the computer.

Screenshot 2023-08-21 at 12.34.39 PM.png

Once the file is imported, the file will be automatically selected and attached as a Note in the Property Task. Click the NEXT button at the bottom right of the pop-up.

Screenshot 2023-08-21 at 12.38.19 PM.png

After file is uploaded and read, Albert will ask for the user to map the column names from the .csv into the appropriate data columns in the Data Template (Albert Field). To change the selected column map into Albert, click on the down arrow to the right of the Albert Field and select the new associated column. Once all columns are mapped properly, click SUBMIT at the bottom right of the pop-up.

Screenshot 2023-08-21 at 12.47.16 PM.png

(TIP: Having matching column names in the .csv and the Data Template make for simple column mapping in the mapping screen.)

Screenshot 2023-08-21 at 1.23.31 PM.png

After submitting, all data from the .csv will be automatically imported according to the column mapping from the previous step and will populate the Data Template accordingly.

Screenshot 2023-12-12 at 5.46.53 PM.png

Now all the data needed is inside of the Data Template with just a few clicks!

(TIP: CSV Import only maps columns, so if .csv file has results in rows, it will need to be transposed to columns prior to importing.)

CSV Import - Additional Functionality

Use first row as header

While importing the .csv file, the toggle for "Use first row as header" can be either on or off.

Screenshot 2023-08-21 at 2.21.46 PM.png

When on, the mapping will automatically use the first row as the column heading row and will skip to row 2 for the first trial of results in the Data Template. When off, the mapping will use row 1 for the first trial of results in the Data Template. This is an important differentiation when the .csv has results in the first row without column headers.

Uploaded CSV Files as Attachments

With the new CSV import feature, any .csv file uploaded as an Attachment in the Property Task will also be available for upload in the internal import data pop-up. 

Example: Albert Sync automatically uploads a .csv file into the Notes section of the Property Task, that file is now available for CSV import without having to reimport the file (it will automatically show up in the Import Data pop-up).

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.