Banner Trombinoscope Contacts

Pro
Trombinoscope Contacts Pro offers an extra tool to help import contacts into the Joomla! core Contacts component.

Go to the menu Components -> Trombinoscope Contacts Pro -> Import Contacts

delimiter the column delimiter of the file
update existing if set to 'yes', the contacts are going to be updated with the new data. Otherwise, new contacts are created
publish all publish all contacts or none of them
upload the .csv or .txt file to use for import

There are a few sets of rules to follow for a successful import:

  1. The first line of the file must contain the column names,
  2. column names of the file must match the column names found in the following table,
  3. catid is a mandatory column. This is the contact category id the contact will belong to (from the core Contacts component),
  4. name is a mandatory column, unless the columns firstname and lastname exist. In that case, the name will be created from those two columns instead,
  5. to separate meta keys or tags, or if the data contains commas, choose a different delimiter for the columns (; or |).
Supported columns Examples Default Notes
name John Doe firstname + ' ' + lastname   
firstname John    
lastname Doe    
alias john-doe   aliases are unique in a category. In case of duplicates, the second alias will be called name-1, the third name-2 and so on
user_id 42   optional id of a user linked to the contact
catid 13   Contact component category id the contact belongs to
con_position Developer    
address 4520 N. Martin Drive/n#3   adding /n creates a new line
suburb Chicago    
state IL    
country USA    
postcode 60640    
telephone 773 400 2133   format to your liking
fax 773 400 2134    
mobile 312 966 3453    
email_to This email address is being protected from spambots. You need JavaScript enabled to view it.    
webpage http://johndoe.com   the path must start with http:// or https://
misc <p>A <i>great</i> developer!</p>   can contain basic html formatting
image images/johndoe.jpg   the path must start with images/. The image must be present in the media manager at the specified path
published 1 publish all parameter value from the import form  
linka_label ... linke_label Facebook    
linka ... linke http://facebook.com/...   the paths must start with http:// or https://
access 1 1 (means 'public') for the list of available values, go to the User Manager -> Viewing access levels
sortname1 Doe   recommended for accurate sorting of contacts
sortname2 John  
sortname3    
language en-GB * (means 'all')  
metakey developer, computing    
metadesc A great developer    
featured 1 0 1 is featured, 0 is not featured
tags staff, board   tags must exist prior to import (in the core Tag component)

Additional fields

These fields come from the content plugin Add key contact fields. The plugin and the corresponding columns must be enabled prior to import.

Supported columns Examples Notes
gender m m for male, f for female, c for other
birthdate 1975-11-03 the format YYYY-MM-DD is required
company Company, Inc.  
department Accounting  
map goo.gl/maps/uPUaO  
summary A <i>great</i> developer!  
facebook jdoe  
twitter jdoe   
linkedin jdoe  
googleplus jdoe  
skype jdoe  
youtube jdoe  
instagram jdoe  
pinterest jdoe  
Joomla 3.7+

Custom fields

It is possible to import data into custom fields.

There are a few conventions for the naming of the column:

  • start the column name with customfield:
  • use the custom field's name as second part of the column name
Supported columns Examples Notes
customfield:name value  
customfield:name value1,value2 for list, imagelist, checkboxes and gallery field types

Note Other than the mandatory columns, just use the columns that are necessary for your requirements.

Warning A compatibility issue with files saved on Mac (IOS) has been reported. Saving files as text solves the problem.

Warning The importing may not work when K2 is installed in Joomla! 3.1+ (when clicking on 'import', nothing happens). Disable the system plugin System - k2 just for the time needed for import. Re-enable the plugin once the upload of contacts has been terminated successfully.

Trombinoscope Contacts v2.7.0
Trombinoscope Contacts Pro v2.7.0