Skip to main content
nikhilk162764
nikhilk162764
Participating Frequently
December 15, 2021
Question

Import excel to database

  • December 15, 2021
  • 1 reply
  • 0 views

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
    December 15, 2021

    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