Question

Importing Excel File using ExcelImporter

0

Hi Guys, I get the following error when I try to import an Excel file, can anyone tell me where I'm going wrong? Error: Domain Model: Template: Sample Data: Thanks Adrian

asked 2017-12-22

Adrian Teale

5 answers

🚴René van Hofwegen🎓 · Answer 1 · 2017-12-22

My guess is that the letter ł in the name Michał is causing this exception;

guess is based on this part: lineNumber: 1 ; columnNumber: 1 ; Content is not allowed in prolog

Adrian Teale · Answer 2 · 2017-12-22

Also tried this but still no joy:

Austin McNicholas · Answer 3 · 2017-12-23

From the error message, its saying to make sure your model reflection is updated. Did you import this template? Have you tried running model reflection with the module that contains this domain model checked?

also it could be an issue with the type of excel file you are using. Ive run into this issue with google sheets and older versions of excel. Try opening the file you are importing in microsoft excel, and save as > with the extension "excel workbook"

Tim v Steenbergen · Answer 4 · 2017-12-25

Two possible causes:

Is B2B present as a value in the contract-enumeration?

In the excel-sheet in column ID: is the value 1 an integer? If it has the value '1, so starting with the single quote, Excel will hardcode the value to be a string and hide the single quote.

Adrian Teale · Answer 5 · 2017-12-26

Hi Tim,

Here is the enum:

It seems that importing records with B2B defined in the Contract field is fine but for other records where I wish it to be blank I get a NULL exception?

Do you know of a workaround for this type of problem?

Regards

Adrian

Merry Christmas one and all!