Import CSV: mapping fields

Problems, tips, hints - all about usage.

Import CSV: mapping fields

Postby ralvy » Wed Aug 09, 2017 5:27 am

Will a future version allow us to map fields for an import?
ralvy
 
Posts: 28
Joined: Sun Jul 10, 2016 4:46 pm

Re: Import CSV: mapping fields

Postby Googie » Wed Aug 09, 2017 2:19 pm

What do you mean? Can you elaborate?
Googie
Site Admin
 
Posts: 780
Joined: Wed Jul 27, 2011 8:04 pm

Re: Import CSV: mapping fields

Postby ralvy » Wed Aug 09, 2017 4:01 pm

When I choose to Import Into Table, and choose a CSV file, I am not offered a two-column display of fields, where one column shows fields from the Source file and the other column shows fields from the Target Table. A typical import display like this would allow me to move fields around so I can map how data will come into the table during the import. Right now, data imports in the field order present in the Source file, and fails to import at all if there are more fields in the Target Table than are in the Source File.
ralvy
 
Posts: 28
Joined: Sun Jul 10, 2016 4:46 pm

Re: Import CSV: mapping fields

Postby Googie » Tue Aug 22, 2017 1:36 pm

Right.

Since such future has low demand, I don't think it will be implemeneted anytime soon. For a intermediate solution I would suggest to import into an inexisting table (it will be created with all columns necessary) and then copy needed columns in order that you like using SQL:
Code: Select all
INSERT INTO target_table SELECT column_x, column_y FROM newly_created_table
Googie
Site Admin
 
Posts: 780
Joined: Wed Jul 27, 2011 8:04 pm


Return to Usage

Who is online

Users browsing this forum: No registered users and 1 guest

cron