Skip to Content (Press Enter)
2022-08-26 11-04-22
Nitin Chavan
27Views
1Comments
[CSVUtil] System Format exception
Question
File
Forge
Import/Export Data
Service
csvutil
Service icon
CSVUtil (O11)
Forge asset by Wei Zhu
Application Type
Service

Hi,

When we call LoadCSV2RecordList action, we are getting IsSuccess = False and Debug Info with below message- 

Exception: System.FormatException: Input string was not in a correct format.

Attaching details error message. We have 500000 rows in CSV file and 50 columns.

Considering the large data size. How to know which row has error?

Best Regards,

Nitin

DebugInfo.txt
0
0
31 Aug 2023
Copy Link
2022-08-26 11-04-22
Nitin Chavan

I got the issue. The column order is different in the CSV file and the mapping structure.

Do we have any option to map CSV file by header names?

0
0
01 Sep 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.