Skip to main content
Question
Anna RiderSemarchy Team
Customer Success Consultant at Semarchy
Asked a question 2 years ago

I’m struggling to import a spreadsheet to create a new LOV in my data model in the Application Builder. I see a red error dialog pop up and it blocks me from import. But there is no error message on the pop up or in the PDE log/Error View. Where can I track down what’s wrong with this LOV import?

Where am I?

In Semarchy Community you can ask and answer questions and share your experience with others!

Anna RiderSemarchy Team
Customer Success Consultant at Semarchy

@Peter Tse46 kindly taught me the solution to this problem. 

The Application Builder only imports the first tab, named 'Import'. In the tab, 'Import', there are several rows after the last code WD99 which are empty rows but have formatting. These formatted rows (containing shading and borders) is considered data even if it is empty of values. 

Delete these rows and the spreadsheet imports without any problems. 

NOTE: Learn more about how to create an LOV and import a spreadsheet to populate the values following this Community article54.