Importing Your Data

The Aloompa CMS offers the ability to import data into the system, reducing manual data entry. 

We currently support data imports for most screens in the CMS, including Categories, Places and Stages, Performers, Events, FAQ, Partners, Products, Articles, Banners, and Translations.

These videos will help you get started but please also plan to review the guide below - especially the Index of Import Fields. Click the bottom right corner of the video to view it in full screen!

How to Import Your Data

Tip: Before beginning any data import, ensure that you have Categories created in the CMS. 

1. Navigate to https://cms.aloompa.com and in the Event Data tab, select the screen for the data you wish to import (Places, Stages, Performers, Events, FAQ)

Tip: You must import performers and places prior to importing events.

2. Click "Export CSV"

3. Open the file that you just downloaded and use this as your template. Enter your data.

It is important that you refer to the "Index of Import Fields" guide to ensure you are entering the correct data in each field and to ensure you are able to successfully import without errors. Any fields labeled with * indicate they are required fields. These must be included in your import!

4. When your spreadsheet is ready, save the file as a CSV.

Please do not delete columns or change column header names. Each column header is necessary for the import and removing any columns will cause the import to fail. 

5. Import the CSV

• 

  
  
  • Select the Import CSV button on either the Performers, Places, Events, or FAQ screen within the CMS.
    • Select Times are Unix Time Stamps if you have provided your date/times in Unix format vs. mm/dd/yyyy hh:mm:ss format
    • Multi-Value Separator is set to comma (,) by default. If you used a separator other than a comma in the spreadsheet, please select the appropriate value from the drop-down. 
    • Select the file
    • Select that the First Row is Header if you left the header row in the spreadsheet
    • Select Import

  • Timezone can be left blank for Places, Stages, Performers & FAQ but is required for Events

    

    
    

    6. Select Parse and review if the mapping is correct (i.e. in the image below, id matches to id in the dropdown, feedMappingId matches the dropdown below, the name of the Performer matches up to the "name" field, etc.)

    If there is data you do not want to import, select Do Not Import in the dropdown for that field. 

    

    
    

    7. Select Import

    If there are any issues with your data, you will receive an error. Review your spreadsheet carefully, checking that items have the correct case sensitivity and that there are no extra spaces around or between data that should be removed. If you continue to experience issues, send the spreadsheet to Client Support for review by clicking the Support beacon or Contact link.

    If you enter data such as Categories and PlaceType incorrectly (for example, if you entered the Category in your spreadsheet as "food" when it is "Food" in the CMS), you will likely not receive an error. In this case, the item will not get a Category or PlaceType assigned. You can always add these manually in the CMS after import.

    When the import is successful, you will receive this screen:

Tip: If you need to edit data after it has been imported, you need to use the same feedMappingId as was in the original import. If you assign a new feedMappingId, a duplicate item will be created. Please note that if you re-import using a spreadsheet and using the same feedMappingIds any manual changes you made in the CMS that you did not make in your spreadsheet will be overwritten.