{"id":3469,"date":"2015-09-09T20:10:03","date_gmt":"2015-09-09T20:10:03","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=3469"},"modified":"2018-07-23T23:08:46","modified_gmt":"2018-07-23T23:08:46","slug":"importing-csv-records","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/importing-csv-records\/","title":{"rendered":"Importing CSV Records"},"content":{"rendered":"

To\u00a0import CSV (Comma Separated Values) records into eFORMz, create a variable for each element of the\u00a0CSV file.<\/p>\n

1. Open the Composer and create a new project by selecting File > New Project<\/em>.<\/p>\n

\"CSV1\"<\/a><\/p>\n

2. Right click the project and select\u00a0Add Preprocessor > Flat File Parser<\/em> to add the preprocessor.<\/p>\n

\"CSV2\"<\/a><\/p>\n

3. Set the following values and click OK<\/em>.<\/p>\n

\"CSV3\"<\/a><\/p>\n

4. Right click the project and select\u00a0Add\u00a0Page<\/em>.<\/p>\n

\"CSV4a\"<\/a><\/p>\n

5. Navigate to the\u00a0XML Input<\/em> tab and set the following properties.<\/p>\n

\"CSV4\"<\/a><\/p>\n

6. Right click the page and select\u00a0Add\u00a0Form<\/em>.<\/p>\n

\"CSV5\"<\/a><\/p>\n

7. Select Blank<\/em>.<\/p>\n

\"CSV5b\"<\/a><\/p>\n

8. In the Viewer, select Open Data > From File<\/em> and bring in\u00a0the CSV file. The variables will be\u00a0added to the project.<\/p>\n

\"CSV6\"<\/a><\/p>\n

9. In the Viewer, right click Record > Add Variables<\/em> to add the variables to the form.<\/p>\n

\"CSV7\"<\/a><\/p>\n

10. Rename the variables in the form to meaningful names. To do this, right-click a variable and selecting Rename<\/em>.<\/p>\n

\"CSV8\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

To\u00a0import CSV (Comma Separated Values) records into eFORMz, create a variable for each element of the\u00a0CSV file. 1. Open the Composer and create a new project by selecting File > New Project. 2. Right click the project and select\u00a0Add Preprocessor > Flat File Parser to add the preprocessor. 3. Set the following values and click […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[425,111,110,109,424],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/3469"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=3469"}],"version-history":[{"count":1,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/3469\/revisions"}],"predecessor-version":[{"id":3480,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/3469\/revisions\/3480"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=3469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=3469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=3469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}