CSV files (Import/Export)

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

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)

 

 

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:

 

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:

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)

1- Date formats are:

yyyy-mm-dd hh:mm 

and

mm-dd-yyyy hh:mm 

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

 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 "1 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.

 

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 cell..." option

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

 

 

  Any questions? Contact Support team.