Skip to main content
kerlinc3558
Known Participant
Jul 28, 2023 8:45 AM UTC
Question

Imports Not appearing in Data Store

Hello,

When I import either a csv or excel file. the records do not appear on the data store. 

I do not have access to view the database but the files make it to the target folder.

Thank you for the help

    21 replies

    mathieud0001
    Genius
    Jul 28, 2023 10:59 AM UTC

    Is there an error in the process? Did you check the logs for more details?

    kerlinc3558
    Known Participant
    Jul 30, 2023 9:13 AM UTC

    Hello Mathieu,

    When I use the Import Excel To Database smart service, I do not get an error and I am unable to access the system logs.

    When I to use the readexcelsheetpaging() function, I am able to view the data in the Expression Test Output (RAW).

    When I to try write the data to a CDT, I get a CastInvalid error. I am really not sure what else to try here.

    Expression

    a!writeToDataStoreEntity(
    dataStoreEntity: 'recordType!{5d8ec9f2-52c8-4946-a0e8-9ae5ed74aac5}AIC Demographic',
    valueToStore: fn!readexcelsheetpaging(
    excelDocument: ri!importdata,
    sheetNumber: 0,
    pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 1000,
    )
    ),
    )

    Test Output Error

    Expression evaluation error at function a!writeToDataStoreEntity: Could not cast from RecordType to Data Store Entity. Details: CastInvalidCould not cast from RecordType to Data Store Entity. Details: CastInvalid

    stefanhelzle0001
    Brainy
    Jul 30, 2023 9:33 AM UTC

    The error message you see is pretty much self explaining. You try to pass a record type to the datStoreEntity parameter. That will not work. A constant pointing to that entity in the data store would be a better fit.

    Now, without access to the database or log files this will become a tough job.

    Can you share a bit more details about what you exactly tried before and what you observed when trying?