{"id":1818,"date":"2016-03-03T13:40:15","date_gmt":"2016-03-03T12:40:15","guid":{"rendered":"http:\/\/www.factuur-software.nl\/?p=1818"},"modified":"2026-03-03T06:09:55","modified_gmt":"2026-03-03T05:09:55","slug":"csv-2","status":"publish","type":"post","link":"https:\/\/www.factuur-software.nl\/en\/csv\/","title":{"rendered":"Importing data"},"content":{"rendered":"

If you already have a list of customers or products\/items from another program. Then you can read these into PERIFACT. It is all about importing so-called CSV files. Menu: EXTRAs - IMPORT CSV\u00a0<\/span><\/p>\n

<\/blockquote>\n<\/div><\/div>
\"PERIFACT<\/span><\/div>
\n

READ THIS CAREFULLY BEFORE GETTING STARTED<\/p>\n<\/blockquote>\n

CSV files<\/h3>\n

\"csv<\/a>Text files with comma-separated values (CSV files), in which individual text fields are separated by a comma (,).<\/p>\n

A comma-separated file, or CSV file, is a text file<\/strong> in which values are separated by a comma (,). CSV is an English term and stands for Comma Separated Value. The CSV format is the simplest and oldest database format in existence. It consists only of text data, making it easy to read in. Values are basically separated by commas<\/strong>, and lines by the new-line sign. Yet it turns out that in practice a comma NOT convenient<\/strong><\/em> is. For example, if you bring in a long sentence that has a comma in it, the program thinks it is a new column. Therefore, rather grab another separator such as pipe '|' or a colon ':' or a semicolon ';'. However, the pipe '|' is recommended.<\/p>\n

The 1st line in a CSV file should contain the column names you want to pull in. PERIFACT has a number of columns that can be pulled in. The column names must therefore match exactly as PERIFACT prescribes. Thus, if you supply a file with a column 'Telephone\" and PERIFACT only recognizes the column \"Telelefoon_THUIS\" then this field cannot be retrieved. Also note upper and lower case<\/strong>!<\/p>\n

The position of a column is not important<\/strong>. So if you first offer, for example, NAME, PHONE,.... or PHONE, NAME,.... it doesn't matter.<\/p>\n

<\/blockquote>\n<\/div><\/div>
\ue060<\/span><\/span><\/div>

Tip<\/h4>

First, create a small CSV file, with a small portion of the desired data. If it works well, then do the same action again for the actual file<\/p>\n<\/div><\/div><\/div><\/div>

<\/div><\/div><\/div><\/div>
Download sample file CONTACTS<\/a><\/div><\/div>
Download sample file PRODUCTS<\/a><\/div><\/div><\/div>
<\/div><\/div>

CONTACTS structure<\/h2>\n

Below you can see how the structure is structured for all clients. As mentioned before\u00a0pay close attention to the column name<\/strong><\/span> this must match exactly otherwise the corresponding column will not be included during the import. Not all fields are required.<\/p>\n

Download here is an example<\/a> From a CONTACTS CSV file<\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
Column name<\/th>Value<\/th>Comments<\/th>\n<\/tr>\n<\/thead>\n
COMPANY NAME<\/td><\/td><\/td>\n<\/tr>\n
SECTION<\/td><\/td><\/td>\n<\/tr>\n
FULL NAME<\/td><\/td><\/td>\n<\/tr>\n
ADDRESS<\/td><\/td><\/td>\n<\/tr>\n
ADDRESS2<\/td><\/td><\/td>\n<\/tr>\n
POSTCODE<\/td><\/td><\/td>\n<\/tr>\n
RESIDENCE<\/td><\/td><\/td>\n<\/tr>\n
COUNTRY<\/td><\/td><\/td>\n<\/tr>\n
DELIVERY ADDRESS<\/td><\/td><\/td>\n<\/tr>\n
DELIVERY ADDRESS LINE2<\/td><\/td><\/td>\n<\/tr>\n
DELIVERY ZIP CODE<\/td><\/td><\/td>\n<\/tr>\n
DELIVERY RESIDENCE<\/td><\/td><\/td>\n<\/tr>\n
BEHIND<\/td><\/td><\/td>\n<\/tr>\n
EMAIL<\/td><\/td><\/td>\n<\/tr>\n
TELEPHONE_HOME<\/td><\/td><\/td>\n<\/tr>\n
PHONE_WORK<\/td><\/td><\/td>\n<\/tr>\n
PHONE_MOBILE<\/td><\/td><\/td>\n<\/tr>\n
BIRTH DATE<\/td>date<\/td>format dd-mm-yyyy<\/td>\n<\/tr>\n
CITIZEN SERVICE NUMBER<\/td><\/td><\/td>\n<\/tr>\n
NOTES<\/td><\/td><\/td>\n<\/tr>\n
BANK ACCOUNT NUMBER<\/td><\/td><\/td>\n<\/tr>\n
BANK ACCOUNT<\/td><\/td><\/td>\n<\/tr>\n
KVKNUMBER<\/td><\/td><\/td>\n<\/tr>\n
VAT NUMBER<\/td><\/td><\/td>\n<\/tr>\n
WEBSITE<\/td><\/td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<\/div><\/div>
<\/div><\/div>

COLUMNS PRODUCTS\u00a0<\/h2>\n

As previously mentioned\u00a0pay close attention to the column name<\/strong><\/span> this must match exactly otherwise the corresponding column will not be included during the import. Not all fields are required.<\/p>\n

Download here is an example<\/a> from a PRODUCTS CSV file<\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
Column name<\/th>Value<\/th>Comments<\/th>\n<\/tr>\n<\/thead>\n
DESCRIPTION<\/td><\/td><\/td>\n<\/tr>\n
PRODUCT CODE<\/td><\/td><\/td>\n<\/tr>\n
PRODUCT GROUP<\/td><\/td><\/td>\n<\/tr>\n
UNIT<\/td><\/td><\/td>\n<\/tr>\n
PRICEXCLBTW<\/td>Numbers only, comma allowed<\/td><\/td>\n<\/tr>\n
VATPERCENTAGE<\/td>Numbers only, comma allowed<\/td><\/td>\n<\/tr>\n
COST PRICEEXCLBTW<\/td>Numbers only, comma allowed<\/td><\/td>\n<\/tr>\n
COST PRICE VAT RATE<\/td>Numbers only, comma allowed<\/td><\/td>\n<\/tr>\n
CURRENT STOCK<\/td>Numbers only, comma allowed<\/td><\/td>\n<\/tr>\n
STOCK THRESHOLD<\/td>Numbers only, comma allowed<\/td><\/td>\n<\/tr>\n
STOCK COUNT<\/td>Enter J or N<\/td><\/td>\n<\/tr>\n
LOCATION<\/td><\/td><\/td>\n<\/tr>\n
FACTOR NAME<\/td><\/td><\/td>\n<\/tr>\n
SUPPLIER NAME<\/td><\/td><\/td>\n<\/tr>\n
NOTES<\/td><\/td><\/td>\n<\/tr>\n
VATPERCENTAGE<\/td>Numbers only, comma allowed<\/td><\/td>\n<\/tr>\n
SPECIALPRICESEXCLBTW
\n<\/td>		Numbers only, comma allowed<\/td><\/td>\n<\/tr>\n
SPECIAL PRICE VAT RATE
\n<\/td>		Numbers only, comma allowed<\/td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

No rights can be derived from this information.<\/em><\/p>\n<\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":8045,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"formats":[],"class_list":["post-1818","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-extra"],"dsm_author":{"name":"PERIFACT Administrator","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/8de22c10ded195630d871461d3f2cee972bd784092b110c358657ffaa08b81ab?s=96&d=mm&r=g","archive_link":"https:\/\/www.factuur-software.nl\/en\/author\/emile\/","biodata":"Beheer PERIFACT factuur software"},"dsm_categories":[{"term_name":"extra","term_id":19,"term_link":"https:\/\/www.factuur-software.nl\/en\/extra\/"}],"dsm_attachment_categories":[],"dsm_featured_image":{"thumbnail":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand-150x150.png","medium":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png","medium_large":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png","large":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png","1536x1536":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png","2048x2048":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png","trp-custom-language-flag":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png","et-pb-post-main-image":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand-400x250.png","et-pb-post-main-image-fullwidth":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand-764x675.png","et-pb-portfolio-image":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand-400x284.png","et-pb-portfolio-module-image":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand-510x382.png","et-pb-portfolio-image-single":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png","et-pb-gallery-module-image-portrait":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand-400x516.png","et-pb-post-main-image-fullwidth-large":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png","et-pb-image--responsive--desktop":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png","et-pb-image--responsive--tablet":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png","et-pb-image--responsive--phone":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand-480x684.png","woocommerce_thumbnail":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand-400x400.png","woocommerce_single":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand-510x726.png","woocommerce_gallery_thumbnail":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand-100x100.png","full":"https:\/\/www.factuur-software.nl\/wp-content\/uploads\/2019\/04\/Man-met-doosje-in-zijn-hand.png"},"dsm_comment_count":0,"_links":{"self":[{"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/posts\/1818","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/comments?post=1818"}],"version-history":[{"count":2,"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/posts\/1818\/revisions"}],"predecessor-version":[{"id":236459,"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/posts\/1818\/revisions\/236459"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/media\/8045"}],"wp:attachment":[{"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/media?parent=1818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/categories?post=1818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/tags?post=1818"},{"taxonomy":"post_format","embeddable":true,"href":"https:\/\/www.factuur-software.nl\/en\/wp-json\/wp\/v2\/formats?post=1818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}