Sometimes you want to import content you’ve already created with other programmes or platforms into LineUpr. Many events, for example, maintain guest lists that are created with registration portals or office software. In order to avoid having to enter existing information again, you can use our import function. We also offer you the possibility to export existing content from LineUpr so that you can continue to use it in a variety of ways.
Below we explain the import and export function of LineUpr. This works with lists in the areas of “Lineup”, “Schedule”, “Locations”, “Sponsors”, and “Attendees”.
With the export function you can download your lists as Excel or CSV files. This allows you to use the information you entered elsewhere, keep it for backup, or edit it locally on your computer and then import the changes again. You will find the export function in the areas of Lineup, Schedule, Locations, Sponsors, and Attendees: Click there on the heading Import / Export and then on the button Export.
If you are not sure, we recommend that you work with the Excel format; to do this, click on Download Excel. You can open and save this format with a variety of popular office programmes such as Microsoft Excel, Apple Numbers, LibreOffice or OpenOffice.
Click on one of the download buttons to start the Excel or CSV export. The downloaded file contains a row for each entry in your LineUpr list and a column for each piece of information that you can capture in LineUpr (e.g. “Name”, “Subtitle”, “Categories”, “Sorting”, “Description” and “Attachments” in the lineup). The first line of the table gives you information about the meaning of each column.
The first column, “Alias”, serves as a unique identifier of the entries (and is also part of the URL if you load it in the app). If you want to edit exported data and then import it again, it is important that you do not change the identifier.
If you have purchased a premium upgrade for your event app, you can also use the Export Feedback function in the area Schedule under Export. This will allow you to instantly download the ratings, comments and frequency of how many times these items have been favored by your guests.
If you click on Download Excel, you will get a file with several tables. The first table contains an overview of your schedule with one line for each schedule item and columns for the average rating (and the frequency of how often 1, 2, …, 5 stars were awarded), the number of comments submitted and the amount of users who have added the agenda item to their favorites.
More detailed information about each individual item can be found in the other tables in the file. The tables each carry the continuous “index” from the overview as a title. In these tables you will find each submitted feedback for the respective item individually broken down with date, comment and rating.
Use the Import function to add or modify data that exists locally on your computer. Just like the Export function, this function is available in the areas of “Lineup”, “Schedule”, “Locations”, and “Sponsors”. Click on the title Import / Export and then on the Import button.
Microsoft Excel or CSV files can be imported. CSV files must be UTF-8-encoded. The first line is treated as a column header and all lines beginning with a #
are ignored. CSV files can use either commas or semicolons as separators. For Excel files, please make sure that data is only imported from the first worksheet and that other worksheets are ignored.
Tip: To familiarize yourself with the data structure, we recommend that you first manually create some content in the respective areas before using the import function, then export it using the Export function and then use this file as a template for further steps.
If you want to import content into multiple sections, you should do so by first importing the “Lineup” and “Locations” and then the “Schedule”. This is because schedule items can refer to entries in the Lineup or Locations, and these already have to be present for a flawless import.
Click on Select Excel or CSV File to start importing and then select the file which is to be imported from your computer. As the next step, you can change the mapping of the individual columns in your file to the corresponding fields of LineUpr in case the automatic mapping failed. To do this, select the appropriate source column from the file to be imported for the individual target fields from the drop-down menus. Those fields marked with an * (such as “Name”) are mandatory. You can leave all other fields empty by selecting Skip in the menu.
The field “Alias” plays a special role, which serves as a unique identifier for your content within the respective areas and is also used as part of the respective URLs. If an entry with the same alias already exists in the system, it will be updated on import. If there is no entry with a corresponding alias, it will be created. In addition, aliases are automatically generated based on the title if you set the field to Skip. For example, from the name “Dr. John Doe”, the alias “dr-john-doe” is automatically generated.
When you have all the columns assigned, click the Next button. You will then see a summary that shows you how many entries are added or changed by the import. If the summary matches your expectation, you can start the import by clicking on Start Import.
Please note that the import function does not delete any entries — that means that existing content is retained, even if they do not appear in the file to be imported. If you want to delete unnecessary entries before importing them, we recommend that you use the list editing function, which you can use to delete all entries at once. Go to the corresponding list, for example the “Lineup”, click on the button with the gear wheel, select “Delete” in the menu, check individual or all entries and then delete them with one click.
Below is an exact specification of the fields for each area.
a
… z
, 0
… 9
and -
. Spaces, umlauts or other special characters are not allowed.Category Alpha, Category Beta
. Categories which do not already exist will be created automatically.p
, h1
… h6
, img
, ul
, ol
, li
, a
, strong
, em
, b
, i
, br
. Other HTML tags are automatically removed during import.0
… 9
, +
, -
, /
, .
, (
, )
and spaces. The respective column heading is used as the description.physical
or virtual
. As default, the type physical
is assumed.physical
): Coordinates of the location; Latitude and longitude must be specified as separate fields in WGS-84 format in decimal notation with periods and without °
, for example 49.1021
and 9.2117
.virtual
): Optional URL, which is shown in an iframe within the virtual location.Space Alpha, Space Beta, Space Gamma
./
in the URL.YYYY-MM-DD hh:mm
, for example 2018-07-06 12:45
./
in the URL. If the schedule item has multiple contributors, separate their aliases with commas, for example dr-john-doe, prof-alice-smith
.See Lineup.
If you want to define app-internal links for importing or want to understand the exported JSON structure, you’re in the right place. This section is for advanced LineUpr users.
There are basically three types of internal links: those that point to entire sections, such as the “lineup” or “program” lists, those that link directly to an individual entry, such as a schedule item and those that link to a single pdf file.
Please note, that app-internal links can only point to categories, entries or PDF files that already exist in the current event. Therefore, avoid “cyclic” links where you have links between two entries.
For example, the JSON format for links to lists looks like this (here with line breaks for better clarity):
{ "type": "list", "entityType": "contributor", "category": "Category Alpha" }
The type
must have the value list
. entityType
refers to the area you want to link to. Possible are the types contributor
, sponsor
, venue
, item
, announcement
, page
, survey
, and attendee
. Optionally, you can use category
to specify the name of an existing category in order to display only the entries of that category.
To link to individual entries, set the value of type
to entity
. entityType
refers to the area you want to link to (see above). entity
is the alias of the entry you want to link to.
{ "type": "entity", "entityType": "contributor", "entity": "john-doe" }
To link to individual pdf files, set the value of type
to file
. name
is the displayed name of the link. hash
is the SHA-256 checksum of the file to identify it in the system.
To upload PDF files you have to add a “PDF File” attachment to an entry. And if you then open the file overview of all the files of the current event you can upload other PDF files.
{ "type": "file", "name": "PDF File", "hash": "fa172579aea01cc10addde95aae6a67606d333b829a4e3db947" }
When importing CSV files, please make sure that the JSON content is surrounded by quotation marks — as the contents themselves contain quotes, this must be “worked around” by adding one more quotation mark before each “internal” quotation mark in the JSON:
"{""type"":""list"",""entityType"":""contributor""}"