Latest News

the latest news from our team

Importing CSV Records

To import CSV (Comma Separated Values) records into eFORMz, create a variable for each element of the CSV file.

1. Open the Composer and create a new project by selecting File > New Project.

CSV1

2. Right click the project and select Add Preprocessor > Flat File Parser to add the preprocessor.

CSV2

3. Set the following values and click OK.

CSV3

4. Right click the project and select Add Page.

CSV4a

5. Navigate to the XML Input tab and set the following properties.

CSV4

6. Right click the page and select Add Form.

CSV5

7. Select Blank.

CSV5b

8. In the Viewer, select Open Data > From File and bring in the CSV file. The variables will be added to the project.

CSV6

9. In the Viewer, right click Record > Add Variables to add the variables to the form.

CSV7

10. Rename the variables in the form to meaningful names. To do this, right-click a variable and selecting Rename.

CSV8

Leave a Reply

Your email address will not be published. Required fields are marked *