Import CSV File

Hey all

I'm trying to import files via HeidiSQL.

• I selected relevant table
• Imported but errors;

SHOW WARNINGS; / Warning (1261): Row 1 doesn't contain data for all columns / / Warning (1261): Row 1 doesn't contain data for all columns / / Warning (1261): Row 1 doesn't contain data for all columns / / Warning (1261): Row 1 doesn't contain data for all columns / / Warning (1366): Incorrect integer value: 'idskustatusdigital_filedigital_namedigital_expireis_featuredis_digitalproduct_namein_stock "326""4032277007020""1"""""0""0""Vega' for column 'id' at row 1 /

Can anyone provide help?

Update:

SHOW WARNINGS; / Warning (1366): Incorrect integer value: 'id,sku,status,digital_file,digital_name,digital_expire,is_featured,is_digital,product_name,in_stock ' for column 'id' at row 1 / / Warning (1261): Row 1 doesn't contain data for all columns / / Warning (1261): Row 1 doesn't contain data for all columns / / Warning (1261): Row 1 doesn't contain data for all columns / / Warning (1261): Row 1 doesn't contain data for all columns / / Warning (1261): Row 1 doesn't contain data for all columns / / Warning (1261): Row 1 doesn't contain data for all columns / / Warning (1261): Row 1 doesn't contain data for all columns /

Update:

I followed image on; Importing .csv files (text files) REF: heidisql .com/help.php

Following warning:

SHOW WARNINGS; / Warning (1366): Incorrect integer value: 'id' for column 'id' at row 1 / / Warning (1366): Incorrect integer value: 'status' for column 'status' at row 1 / / Warning (1265): Data truncated for column 'digital_expire' at row 1 / / Warning (1366): Incorrect integer value: 'is_featured' for column 'is_featured' at row 1 / / Warning (1366): Incorrect integer value: 'is_digital' for column 'is_digital' at row 1 / / Warning (1262): Row 1 was truncated; it contained more data than there were input columns / / Warning (1262): Row 2 was truncated; it contained more data than there were input columns / / Warning (1262): Row 3 was truncated; it contained more data than there were input columns / / Warning (1262): Row 4 was truncated; it contained more data than there were input columns / / Warning (1262): Row 5 was truncated; it contained more data than there were input columns / / Warning (1262): Row 6 was truncated; it contained more data than there were input columns / / Warning (1262): Row 7 was truncated; it contained more data than there were input columns / / Warning (1262): Row 8 was truncated; it contained more data than there were input columns / / Warning (1262): Row 9 was truncated; it contained more data than there were input columns /

You should probably ignore/skip the first row in the file.

**Hey Ansgar

That didn't work...

LOG: * SHOW WARNINGS; / Warning (1262): Row 1 was truncated; it contained more data than there were input columns / / Warning (1262): Row 2 was truncated; it contained more data than there were input columns / / Warning (1262): Row 3 was truncated; it contained more data than there were input columns / / Warning (1262): Row 4 was truncated; it contained more data than there were input columns / / Warning (1262): Row 5 was truncated; it contained more data than there were input columns / / Warning (1262): Row 6 was truncated; it contained more data than there were input columns / / Warning (1262): Row 7 was truncated; it contained more data than there were input columns / / Warning (1262): Row 8 was truncated; it contained more data than there were input columns */

BUT, attachment Capture1.jpg shows that the ID field imported...

Thanks!

According to the error messages and the screenshots you posted, you have the two columns "product_name" and "in_stock" in your CSV file, but not in your table. You could create these in the table and try again.

Updated as such. Installed latest version.

Still throwing up this error.

Appreciate your help.

I changed the Encoding to: UTF8MB4: and that seemed to have a better result...its just the digital name that doesnt import.

SHOW WARNINGS; / Warning (1366): Incorrect string value: '\xF6ner 2...' for column 'digital_name' at row 1 /

VARCHAR?

I managed to clear the errors. There was an ö that ruined the import!

But, still i cant seem to import the full digital name.

Ok, remaining columns are populated now? Only digital_name not so? You could check that in HeidiSQL directly, not in that application you send screenshots from. Perhaps the app does something unobvious in that column.

Yes, populated. Almost...

How do i check in Heidi?

Data grid?

It's a brilliant piece of software!

Do you know how I can import to multiple tables at once?

It seem's as though, the digital_name column refers to another column and not the one i meant to target...

For multiple tables import, I suggest to look at the LOAD DATA command in the bottom log panel, copy it to a query tab, and modify that for your further tables.