Skip to main content
nikhilk162764
nikhilk162764
Participating Frequently
Dec 15, 2021 3:09 PM UTC
Question

Import excel to database

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 ?

    1 reply

    csteward
    csteward
    Brainy
    Dec 15, 2021 6:50 PM UTC

    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.  

    Terms & ConditionsAccessibility statement