How do I import or export
Excel or CSV files?

Instructions for importing and exporting lists with the lineup, schedule, locations or sponsors

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”.

Content

  1. Export
    1. Export of Lists (Lineup, Schedule, Locations, Sponsors)
    2. Export of Feedback (Schedule)
  2. Import
    1. Fields for “Lineup”
    2. Fields for “Locations”
    3. Fields for “Schedule”
    4. Fields for “Sponsors”

Export

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.

Export of Lists (Lineup, Schedule, Locations, Sponsors)

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”, “Category”, “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.

Export of Feedback (Schedule)

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.

Import

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.

Fields for “Lineup”

    Alias: Unique identifier for the entry. A connected string which may consist exclusively of the following characters is allowed: az, 09 and -. Spaces, umlauts or other special characters are not allowed.

  • Name: Name of the person
  • Subtitle: Subheading for the person (e.g. company name, position, …)
  • Category: Name of the category to be assigned in exact spelling; if it does not already exist, it will be created automatically.
  • Sorting: Here you can determine how to sort the entries in lists; you can either enter numbers to prioritize your entries (lower numbers come first) or use, for example, the last names of the respective persons and sort according to this (or even combine both).
  • Description: Description text of the entry. For structuring and formatting you can use the following HTML tags: p, h1h6, img, ul, ol, li, a, strong, em, b, i, br. Other HTML tags are automatically removed during import.
  • Links / Social Media / Email / Phone: Any number of attachments with URLs, email addresses and/or phone numbers. The respective type is automatically assigned based on the content. URLs must be listed completed with protocol (i.e. “http://” or “https://”), telephone numbers may consist of the characters 09, +, -, /, ., (, ) and spaces. The respective column heading is used as the description.

Fields for “Locations”

  • Alias: see above
  • Name: Name of the location
  • Category: see above
  • Sorting: see above
  • Street, House Number, City, Zip Code, State / Province / Region, and Country: Address of the location
  • Latitude and Longitude: 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.
  • Description: see above
  • Rooms: List with names of the rooms at the location; the individual entries in the string must be separated by commas, for example Space Alpha, Space Beta, Space Gamma.
  • Links / Social Media / Email / Phone: see above

Fields for “Schedule”

  • Alias: see above
  • Title: Title of the schedule item
  • Location: Location at which the schedule item takes place. Here you must refer to the alias of an existing location. You can either take the alias out of your location import data or open the corresponding location in the browser and then copy the part after the last / in the URL.
  • Room: Room within the location in which the schedule item takes place. Here you must refer to an existing room name in the corresponding location.
  • Category: see above
  • Sorting: see above
  • Start Time und End Time: Date and time with start and (optional) end of schedule item in format YYYY-MM-DD hh:mm, for example 2018-07-06 12:45.
  • Lineup: Lineup entries associated with the schedule item. You have to refer to aliases of already existing entries in the area Lineup. You can either use the aliases from your lineup import data or open the contributors in the browser and then copy the part behind the last / in the URL. If the schedule item has multiple contributors, separate their aliases with commas, for example dr-john-doe, prof-alice-smith.
  • Description: see above
  • Links / Social Media / Email / Phone: see above

Fields for “Sponsors”

See Lineup.