Skip to main content
C
carlosp5114
September 17, 2023
Question

Error to import CSV to Appian

  • September 17, 2023
  • 4 replies
  • 0 views

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
    mathieud0001
    Brainy
    September 17, 2023

    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.

    C
    carlosp5114Author
    September 18, 2023

    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
    stefanhelzle0001
    Brainy
    September 18, 2023

    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
    nelisb3690
    September 20, 2023

    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.

    Terms & ConditionsAccessibility statement