Data import to the event agenda!

How to save data for import

Data should be saved as a .csv file. The following software allows for saving files in this format: Excel, Numbers and Google Docs. Before exporting make sure that your file will be saved in Unicode UTF 8. If your file is saved in another coding scheme, an error will occur while importing it to the panel. To fix this, convert your file with a free online tool.

Import data to Agenda component

Prepare the .csv file for importing the agenda with the following column names: uuid, title, description, day, start_date, end_date, place, path, tags. All the columns must be in order as above, to import the data successfully. A spelling error in the name of the columns or omitting any of them, results in the incorrect import of data.

How to enter data into the file

uuid – It’s the identifier for the session. We recommend populating it with any number from 1 to infinity – this identifier should be unique for each agenda session. 

In the  “day” column you have to provide the date when the session takes place. The date must be in a format as follows YYYY-MM-DD. Remember to put a dash “-” between the year, month and day. 

start_date and end_date  – in these columns enter the time that the session starts and finishes, following the YYYY-MM-DD 00:00:00 format. Hours should be based on a 24-hour clock.

TIP: If the session exceeds midnight, enter in the “day” column the date to which the session should be assigned, whereas in the start_date and end_date columns you should add the real dates and time of start and end of the session. The start date/ end date and time should be separated by a space, as in the above example.

Example: The music festival takes place at night on the 22nd of September 2020 but the concert lasts until the morning the next day September 23, 2020. For example: from 23:00 22.09.2020 to 02:00 23.09.2020 and the next concert is from 2:00 to 3:30 at night. To extend the day 22 of September 2020 in the Agenda Component, in the “day” column in both cases you should enter the date 2020-09-22, (in this format). While the “start_date” and “end_date” columns should contain the actual start and end dates of the session. Respectively in the first case: start_date 2020-09-22 23:00:00 and end_date 2020-09-23 02:00:00, in the second case: start_date 2020-09-23 02:00:00 and end_date 2020-09-23 03:30:00.

place is the column for space/ room where the session occurs, e.g Great Hall, Room Madrid, Main Stage. It creates a “Place Tag”, which can be edited in the panel.

path is responsible for adding a “Path Tag” to the agenda. The path tag defines the type of session, e.g. workshop, training, coffee break.

tags this column is responsible for adding the specified groups of users to the session in the agenda component. In the case of leaving empty cells,”All users” tag will be added automatically and the session will be visible for all users. In order to make the session visible for the selected group, you have to write in this column the names of “user tag” assigned to this group of users, e.g. Logged In Users, VIP, Group A, Speaker.

TIP: The tags like: Place, Path and Tags imported via the file to the agenda will be automatically created in the panel and visible in the “Tag Database” section as tags “Agenda places”, “Agenda path” and “User groups” respectively.

TIP: If you want to add more than one tag to the session, enter them in the cell of imported file listing them after the decimal point without spaces, e.g. VIP,Group A,Group B

Adding language layers

Translating sessions in the Agenda component ​​is possible only if language layers have been added to the administrative panel in the Basic Info section.

To import the next language layer to the Agenda component, you need to prepare a new .csv file with translated data in the title and description columns. The rest of the columns should remain unchanged. The sessions in both files should have the same order and UUIDs numbers.

Attention!
Importing the language layers is only possible when the main data were also imported.

Related Articles

Adding partners to the event application by importing data!

Create partner profiles in the application through import. Prepare the .csv file and add it to the application.

Import exhibitors into the application!

Import exhibitors to the mobile application. Create their complete profiles visible in the application and website of your event.

How do you import speakers into the application?

Create complete speaker profiles and import them into the application with one click. When importing, you can easily assign speakers to selected lectures on the agenda.

Import users to the application!

Import users into the application and send them invitations to your event!