Skip to main content
Known Participant
Sep 17, 2023 10:53 AM UTC
Question

Error to import CSV to Appian

Hi! I´m trying to import a CSV to Appian via Cloud Database

When I finish to enter my data and try to import, the following error appears:

It seems like the table has been created but I have no access for some reason/permissions (I´m the admin of my site so I don´t know what to do).

I wanted to ask:

1) ¿How can I correct fix this error?

2) ¿Is this the correct way to create a database in appian from a CSV?

Thanks a lot

    4 replies

    mathieud0001
    Genius
    Sep 17, 2023 8:53 PM UTC

    Technically, I don't think you should be creating a new schema to import your csv. You probably should choose a schema first and then do the import.

    Known Participant
    Sep 18, 2023 6:57 AM UTC

    Thanks Mathieu, but in this case I would like to understand how to fix this permissions issue/error. 

    Any recommendation would be helpful

    Thanks a lot!

    stefanhelzle0001
    Brainy
    Sep 18, 2023 8:03 AM UTC

    I think there is no way to fix this. The problem is, that the PHPMyAdmin software created the table using a different user account. And you do not have the permission to change that.

    Create the table first, then import the data.

    nelisb3690
    New Participant
    Sep 20, 2023 12:47 PM UTC

    Hi, did you manage to solve this *csv file? My boss sent me a database in the same format, and the file seems to be corrupt.