Skip to main content
D
damianop0672
January 10, 2025
Question

Import CSV to Database - Column names doesn't match

  • January 10, 2025
  • 5 replies
  • 0 views

Hello,

I have a problem with the smart service ‘import csv to database’, as the column names in the CSV do not match those in the table. Is there any way to create a mapping between the two values, or do I necessarily have to create a new table that has the same field names as the csv? I would like to avoid the latter solution if possible. Thank you all.

    5 replies

    stefanhelzle0001
    stefanhelzle0001
    January 10, 2025

    In the smart service, you can disable parsing the header line and configure the columns yourself.

    D
    damianop0672Author
    January 10, 2025

    How can I do it? I've already tried changing "File has header" to false, but maybe I'm doing something wrong

    stefanhelzle0001
    stefanhelzle0001
    January 10, 2025

    I do not have any current example, but I suggest toying around with the "Column Names", "Csv Header Names", and "Database Field Names" parameters.

    And, you can download the plugin from the app market and study the included documentation.

    Terms & ConditionsAccessibility statement