NB: Only import your class csv AFTER reading the rules for creating your Bulk Import below. 

Upload your Bulk Import Class CSV file

1. Download BulkClass Import Template file - Bulk Class Upload Template File (CSV UTF-8) (download document available below)

   • On date fields, NB - Use UK / Ireland Formats: DD-MM-YYYYorYYYY-MM-DD

   • DO NOT USE American format mm/dd/yyyy

2. Open file using excel or other spreadsheet reader

3. Enter your Show's Class data in the SuperShow Bulk Class Import file

• When happy that you understand what data should be entered, remove the sample data - keeping only the header data 
  • NB the column headings must not be altered
• Ensure to include 'Section' and Class Title' for each class (for each row of data)
  • Use the copy/drag option to populate quickly
• This file helps you to create a class structure quickly, remember that you can still edit classes from within SuperShow
• This import is only to get you started and/or for bulk updates

1. ​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​Save the file in a .CSV format (Recommended format Comma seperated value UTF-8) before uploading
   • This clears any formatting from the file - any formatting can be done once on the system
   • Differences in File Formats include some CSV formats that are not compatible with special characters (eg. € symbol and the Cyrillic alphabet). Most formats will support the English alphabet. 

2. Find the Show Event that you wish to upload your Classes to

3. Click on Classes > Import Classes tab > Click Choose File > Select your prepared file

   • Double-click or click on Open to upload (depending on your PC settings)

4. You have the option to PURGE EXISTANT CLASSES within this event upon import

   • ​​​​​​​PURGE IF you want to delete all classes that are currently listed

     • This will delete all class data there and replace it with the data in the file you are uploading

   • You will not see the PURGE option WHEN you have entries against any of the classes.

     • ​​​​​​​IF you have completed entries, you will need to create a service desk ticket and ask for the entries to be deleted by the technical team. 

     • ONLY test entries up to the cart - do not process the order, so the entry will stay as unfinished

   • DO NOT PURGE IF you want to update the data that already exists.

     • ​​​​​​​You must however keep the existing Category structure, and class title if you wish to AMMEND the class

     • If you need to add a new class, the Category structure and class title should be different

     • Eg. if you want to add overflow classes - the class title should have an appended note, eg. (Group 1), next class (Group 2) - no 2 classes should have the same category structure and class title. This will cause a conflict. There should be a difference in names if you need to create a separate account. 

5. Once selected, you will see your file name showing - click Import File

6. On the pop-up screen, you will be asked if you are sure you want to import - click Import if you are sure. 

   • Your Class import speed will depend on the amount of classes, and your local internet connection.

   • Please allow this page to load your data. 

7. Once uploaded, you will see all classes on the List Classes tab.

   • If any issues arose with the import file, a warning note will show. Please note the lines that were corrupted/not able to import. You will need to review these rows on your import file and correct any errors. 

   • This error report should be copied to somewhere you can access later. This note is not stored. 

8. Click EDIT to view or update your uploaded classes in the future. 

CATEGORIES

• Once the import is complete, you will be able to see the Category import structure also. 
• On your chosen event, click on Categories once the import is complete
• Any changes to the category structure can be made here 
  • + will expand the section and categories fully
  • - will contract the section and categories fully
• You can now update the Categories further within the system
  • Add opening notes and closing notes relative to the category
  • Assign Sponsors to the category
  • Assign judges to the category
  • Upload a Category image
  • Change the allowed events for this category.