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”, and “Sponsors”.
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, and Sponsors: 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 “Links / Social Media / Email / Phone” 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. 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 map the individual columns in your file to the corresponding fields of LineUpr. 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.
Alias: Unique identifier for the entry. A connected string which may consist exclusively of the following characters is allowed:
-. Spaces, umlauts or other special characters are not allowed.
Category Alpha, Category Beta. Categories which do not already exist will be created automatically.
br. Other HTML tags are automatically removed during import.
)and spaces. The respective column heading is used as the description.
°, for example
Space Alpha, Space Beta, Space Gamma.
/in the URL.
YYYY-MM-DD hh:mm, for example
/in the URL. If the schedule item has multiple contributors, separate their aliases with commas, for example