asked on

SQL Import Conundrum

Hello Amigos!

I have an import challenge and I'm simply not sure how to approach it. This table stores form submissions from multiple forms on my website, its structure is as follows:

submit_time_idx
form_name_idx
form_name_field_name_idx
submit_time
form_name
field_name
field_value
field_order
file

The field_name column from above stores the following data:

testimonial
headshot
permission
name
email
phone
state
country
condition
submitted_from
submitted_login

My issue is that I do not know how to import my testimonials spreadsheet which has the column headings that I outlined in the "field_name" section INTO into this new table column (field_name). Does this make sense?

field_name houses what equates to 11 columns of data in my spreadsheet. When I try and import it into MySQL-Front, and the field mapping window comes up, its a complete fail.

Any help is greatly appreciated and I hope I've been clear enough.

Thanks Amigos!

Daniel Reynolds

You may have to combine your columns in the spreadsheet into one column before attempting to import. Most Import tools view a single excel column as a single table column for import purposes.

pmagony

ASKER

Is there anyway to bypass this? If i have 300 lines of data, this could get ugly. There has to be a more graceful way.

SOLUTION

Daniel Reynolds

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

ASKER CERTIFIED SOLUTION

Kevin Cross

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

pmagony

ASKER

This is outside of my scope of abilities, but it appears to be promising. Can we discuss by email? Would this be something you would be interested in taking on?

Guy Hengel [angelIII / a3]

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.