AM - ImportUtil / WA - Load CSV - when keyfield NodeId is used could ends with error "input string was not in a correct format"

This article is about product releases

ALVAO Asset Management 10.3 and higher

Symptoms

- Input CSV contains rows with column "NodeId"
- In some rows there is no value in the NodeId column (new objects are to be created)
- Import is started with the "keyfields" parameter NodeId
- Import ends with error "input string was not in a correct format"

Cause

The cause is a bug in ALVAO products.

Solution

Fixed in release 11.1.1344 - 11.1/FIX2 (2023-06-01)

Workaround

Split the CSV into two different CSV files:
1. only rows with values in the NodeId column - start the import with the "keyfields" parameter
2. rows without values - run the import without the "keyfields" parameter

Issue number

T142244ALVAO

Did not find what you were looking for? Ask our technical support team.