CSV files (Import & Export addon)

 > BLOG > CSV files (Import & Export addon)


We realised that some users could have some troubles with Import and Export Addon.

This FAQ section will help you to avoid some importing ERRORS, most common related in CSV parameter format.

  • HOW TO CREATE CSV BASE FILE FOR IMPORT
    1. Create an event, organizer or place
    2. Export events, organizers or places to CSV file
    3. Work on exported CSV 

 

  • CSV FORMATS
    1. Date (From - To)
    2. Title
    3. Description
    4. Image
    5. URL
    6. Categories, Organizers, Places
    7. Repeat parameters
    8. Tickets (not used at the moment)

 

  • HOW TO CHANGE FORMATS

CSV file logo

HOW TO CREATE CSV BASE FILE FOR IMPORT

To create a CSV base file, i.g. import events, organizers or places in bulk we recommend:

1.- Create an event, organizer or place

This event, organizer or place should contain all the parameters that should appear on the imported data.

 

 

2- Export events, organizers or places to CSV file.

Select from EXPORT CSV the wished option (events, organizers or places)

Export formats for Import & Export Addon

 

 

3- Work on exported CSV file including your new data and keeping CSV original formats.

In this sample there are 2 different events, and when open the exported CSV file from Chronosly (i.g. Excel) it should look like this:

Exported Chronosly events to CSV file
Exported Chronosly events to CSV file

 

To create new events, delete all old data from imported CSV and keep row 1 for headers.

Insert your new events, organizers or places  Import CSV file to Chronosly.

In the example below, we added 10 new events for 2015. We took special attention keeping original formats, in special in "From" and "To" columns:

Exported Chronosly events to CSV file
CSV file sample used to import events using Imp & Exp addon

chronosly-tips-logo

CSV FORMATS

There is no existing standardised CSV file because each project could have its own parameters

Take those 8 basic parameters as a must:

  1. Date (From - To)
  2. Title
  3. Description
  4. Image
  5. URL
  6. Categories, Organizers, Places
  7. Repeat parameters
  8. Tickets (not used)

chronosly-tips-logo

1- Date formats are:

yyyy-mm-dd hh:mm 

and

mm-dd-yyyy hh:mm 

WARNING: sometimes Excel changes formats to "dd-mm-yyyy" (for example to ISO - EURO for european users). See image below: 

Wrong formats for CSV file
Wrong formats for CSV dd-mm-yyyy (ISO - EURO)

chronosly-info-logo Learn how to change CSV formats

 

2- Title format: al text introduced will be displayed on title as plain text.

3- Description: formated text is available using html code like "<strong>" for bold text or "</br> " for line break. Learn more about WordPress html tags.

Use TAB to separate parameters. Text delimiter is ".  (By default in CSV export)

4- Image parameter is defined as an URL, it will be automatically downloaded, added to your site and included to your event.

5- URL: URL for your event. Better leave blank for importing.

6- Categories, Organizers, Places: use double pipe || to separate multiple elements for categories, organizers and places (i.g "Org1||Org2||Org3″).

7- Repeat parameters:

- Repeat every is defined by a number and parameter: day, week, month, year (always in singular), i.g "3 day", "5 week", "2 month", "1 year".

- Repeat end could be two types of parameters, number or date:

-Number: defines number of times repeated.

-Date: defines date Y-m-d when repeats end (i.g 2015-01-30). Pay special attention if Excel changes it into format to Y-m-d like first steps in this point 3.

Is repeated is not used at the moment, but must be 0.

8- Tickets is not used at the moment, better leave blank.

chronosly-tips-logo

 

HOW TO CHANGE FORMATS

If formats have been changed when you open CSV file or when you are editing CSV file, follow these steps to format cells as original:

1- Select cell range you want to change date format

2-Right click on selected cell range and choose "Format Cells..." option

Format cell options in Excel
Format cell options in Excel

3- Choose "Number" format

4- Choose "Custom"

5- Set "Type:" to yyyy-mm-dd hh:mm or mm-dd-yyyy hh:mm

6- Save changes

How to change date format in CSV file (all steps)
Format Cells options in Excel

 

 

 chronosly-info-logo For further information contact Chronosly Support team.