Hi
I'm using 'Import excel to database' smart service in the process model. When I run the process:-
1. It works when we unfreeze the first header row otherwise it throw error
2. It sometimes throw error like "???Invalid Content ID???" or "Index: 1, Size: 1"
Does anyone have suggestions regarding the proper configuration of excel required while uploading ?
Discussion posts and replies are publicly visible
Instead of importing an excel directly to the database, I will typically import using fn!readexcelsheetpaging() from the Excel Tools plugin, then convert the data to a CDT via expression rule, then persist using the Write to Datastore Entity service. This allows additional points to debug and also allows any data manipulation/cleaning to be performed between the document and database as needed.