파일(템플릿) 업데이트 시 자주 발생하는 오류

팔로우

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:

  1. Invalid Date/Time Format
  2. Invalid Column Name
  3. Unrecognizable special characters
  4. Schedule Track Name is too long
  5. Invalid file. Either a .xls or .csv file is required.
  6. Error: we could not find the specific image

Session and/or Item Linking Template Errors:

  1. Could not find session
  2. Could not find item
  3. Column not found
  4. Multiple objects were found


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.

Note: 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 40 characters. Just shorten your track names, and your template will import properly!

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 pictures, not 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 - especially special characters (accents & 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 - especially special characters (accents & 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

 


If you continue to receive error messages repeatedly, or you see an error message not listed below, email us at Support@guidebook.com.

Please be sure to:

  1. tell us the name of your guide,
  2. attach the spreadsheet you're working on, and 
  3. provide the error message(s) you receive.
도움이 되었습니까?
0명 중 0명이 도움이 되었다고 했습니다.
또 다른 질문이 있으십니까? 문의 등록

댓글

Zendesk 제공