Tips for preparing CSV files for upload: Difference between revisions

From Planfix
Jump to: navigation, search
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 18: Line 18:
**single-digit day numbers and two-digit years are not supported
**single-digit day numbers and two-digit years are not supported
**a period (".") or slash ("/") can be used in place of the dash ("-").
**a period (".") or slash ("/") can be used in place of the dash ("-").
*to correctly import CSV files, the file encoding must be '''UTF-8'''
*To correctly import CSV files, the file encoding must be '''UTF-8'''
   
   
The resulting file is used to [[Importing contacts | import contacts]] into Planfix.
The resulting file is used to [[Importing contacts | import contacts]] into Planfix.



Latest revision as of 05:30, 27 February 2021

Importing contacts allows you to upload company and contact data into Planfix from different sources and update this data as needed. Import is done using a prepared file in one of the following supported formats: CSV, XLS, XLSX.


CSV is a common format for files downloaded from various programs and services. CSV files contain values ​​separated by commas or semicolons. Another type of import file is an Excel file with a table containing the contact data you use when creating contacts in your account: first name, last name, phone number, etc.


h11WGy.png


The file can be formatted in any way, and the column names do not need to match the field names in the contact card. You can map them to the fields when importing.


Please note

  • You must include at least one of the standard fields for contact/company name. Without at least one of these fields, the import will not work.
  • When importing into fields containing dates and times:
    • for Date fields, data must be entered in the following format: dd-mm-yyyy
    • for Date and time fields, data must be entered in the following format dd-mm-yyyy mm:hh
    • single-digit day numbers and two-digit years are not supported
    • a period (".") or slash ("/") can be used in place of the dash ("-").
  • To correctly import CSV files, the file encoding must be UTF-8


The resulting file is used to import contacts into Planfix.


Go To