CSV import: Available field properties

  • Published by
    George Papadakis
  • Last modified
    08 November 2023
  • Up to date
    Yes
  • Profile concerned
    End user, Webdesigner, Developer
  • Concerns
    Component
  • Since Version
    1.5.6
  • Voting
    Average rating
    2 votes
    • 1
    • 2
    • 3
    • 4
    • 5
  • Favourites
    298 CSV import: Available field properties /documentation/tutorials-english/80-advanced-usages/298-csv-import-available-field-properties.html

In order to use import tool you can use this format
multi value field : value1%%value2%%value3
multi-propriety field : [-proprietyname1-]=value!![-proprietyname2-]=value!!

Here is a list of the available field properies names that can be used in your CSV import files:

Email field property names:
- addr    (email URL)
- text     (Linked Text)

ex :  [-addr-]=This email address is being protected from spambots. You need JavaScript enabled to view it.!![-text-]=flexicontent support email!!

Weblink field property names:
- link      (www URL)
- title      (Linked Text)
- hits      (Hits so far)

ex :  [-link-]=https://flexicontent.org!![-title-]=Flexicontent official website!![-hits-]=1500!!

Extended Weblink field property names:
- link      (www URL)
- title      (Tooltip Text)
- id         (an HTML tag ID)
- class    (a CSS Class Name)
- linktext (Linked Text)
- hits      (Hits so far)

ex :  [-link-]=https://flexicontent.org!![-title-]=Flexicontent official website!![-id-]=officiallink!![-class-]=readmorelink!![-linkedtext-]=Flexicontent official website!![-hits-]=1500!!

Address field property names:
- name (text name location)
- addr1 (text first field address)
- addr2 (second field address)
- addr3 (third field address)
- city (text)
- country (text)
- zip (number)
- lat (number)
- long (number)
- zip_suffix
- url
- zoom 

ex :  [-name-]=Effel tower!![-addr1-]=5 Avenue Anatole France!![-city-]=Paris!![-country-]=France!![-lat-]=43.9464752!![-lon-]=4.8033969!![-zip-]=75007!!

Image field property names :
- originalname (name of image)
- alt (text alt for image)
- title (title of image)
- desc (desc of image)
- urllink (link to content)

ex :  [-originalname-]=effel-tower.jpg!![-alt-]=the effel tower inparis!![-desc-]=Discover the effel tower in Paris!![-urllink-]=https://www.flexicontent.org!!

File field property names :
- originalname (name of file)
- title (title of file)
- desc (desc of file)
- urllink (link to file)

Read this for more information about files and image upload

Related field just use catid:id of item, like 10:451%%10:567%%15:321

NOTE: that for weblink, extend weblink field you can also choose not to use property names and write it in your CSV file as if it is a single property field (like it is text field), in this case you will only use link value for weblink and extended weblink field and (email) addr value for email field