We know how it feels to get a "Whoops" email from Builder! This article lists common Error Messages you might receive when trying to import your template spreadsheets.
Please review the information below, make the appropriate changes, and re-import your spreadsheet.
Schedule Template and/or Custom List Template Errors
Invalid Date/Time Format
- Please make sure that your Date is written in MM/DD/YYYY format for each session.
- Please make sure your Start Time and End Time are in HH:MM AM/PM format for each session.
- Please ensure that there is a Date and Time in the Registration Starts column. If this is not required in your schedule, leave the column blank.
Keep an eye out for a stray apostrophe (') in any of your Date or Start/End Time cells. To check for and remove a hidden apostrophe, click on the column or the cell where you can see the apostrophe ('). Click on Data from the ribbon at the top of the screen and select Text to Columns. Under Separator, type an apostrophe (') in the box for Other. Check Other and click Apply. This should remove any hidden apostrophes and convert the cells to the right format.
Invalid Column Name. It appears you have renamed the template columns, or you are using an old template. Please correct.
This error indicates you may be using the incorrect template. The easiest way to troubleshoot this is to download a fresh copy of the import template and copy your data over, without modifying any of the column headers in Row 1. Click here for Schedule Template information; click here for Custom List Template information.
There are special characters that we cannot recognize. Take these out, then try reimporting your file.
If you are using Excel to create your file, please save it as a .xls file. Do not use the .csv filetype. This will ensure that characters are encoded in the appropriate format. If you are using LibreOffice or Apache OpenOffice, please ensure that you save your document as a .csv in the UTF-8 encoded format.
Your schedule track name is too long. The name you specified is: [track name]
When using the Schedule Template importer, each schedule track name may be no longer than 80 characters. After shortening your track names, your template will import. If the track title is too long, some users will not be able to see the entire track title on their device screens.
Either a .xls or .csv file is required.
Builder can only read .csv or .xls versions of the template spreadsheets. If you are using another filetype, please Save as either .csv or .xls. If you are using .xls and still receive this error we recommend switching to .csv to be on the safe side. Some versions of Microsoft Excel save certain items (typically dates) in a format that Builder has trouble reading.
Error: we could not find the specific image
If you are importing images along with your Custom List template, please review the instructions linked here. Builder will look for a filename of an image that exactly matches the filename you type in the spreadsheet. This means capitalization and filetype must match perfectly. Also be sure you import a zip file of pictures, not a zip file of a folder.
Session and/or Item Linking Template Errors
Could not find session [session title]. Please make sure this is a valid session name in your guide.
Please double-check the column with session names and make sure your session names exactly match the data in Builder. This includes special characters like accents and punctuation, as well as spaces.
Could not find item [custom list item name]. Please make sure this is a valid item name in your guide.
Please double-check the column with list item names and make sure your list item names exactly match the data in Builder. This includes special characters like accents and punctuation, as well as spaces.
"[Column Name] (Optional)" Column: Could not find this column. It appears you have renamed the template columns, or you are using an old template. Please correct.
This error indicates you may be using the incorrect template. The easiest way to troubleshoot this is to download a fresh copy of the import template and copy your data over, without modifying any of the column headers in Row 1. Click here for Linking Template information.
Multiple objects were found for "[Name of Object]". Please specify the object you want to link by entering its ID in the appropriate ID column.
This means that the name of this session or this list item appears more than once in your guide. Builder is having trouble figuring out which one you want to link. We recommend using the Session ID or the List Item ID numbers instead to avoid any potential hiccups over names.
To find the Session or Item ID, export your data. When you export data out of Builder, the system will show you all of the ID numbers it has generated for each piece of your content. Click here to learn how to export.