[bug] server 500 error when ignoring extra columns on csv import

[batonac]

When I try to import a csv file that has extra columns I don't want imported, I get a server 500 error after confirming the extra data should be left out, and telling fabrik to import the rest. If I manually delete the extra columns from the csv, fabrik imports the data fine without a hitch.

Oddly enough, I can't track down a server log error for this bug...

 

[rob]

This one should be fixed now

-Rob

 

[batonac]

It seems that this is improved, but not completely fixed. In my testing, the extra column is not created in the db table, but the data from the extra column is still injected into the insert statement. This totally screws up the data being imported.

FYI, in my case the column I'm ignoring is the first column in the csv file.

 

[cheesegrits]

Works for me:

http://screencast.com/t/yD0d1JeVTT

-- hugh

 

[cheesegrits]

Ah, I take that back. I tried adding the extra column(s) at the start of the CSV, and I see what you are reporting.

Working on it.

-- hugh

 

[cheesegrits]

OK, I can see what's happening, but hit my time limit fortrying to fix it, I need to carry on working through the forums. I'm raising an issue for Rob:

https://github.com/Fabrik/fabrik/issues/851

-- hugh