Import CSV File

Narday's profile image Narday posted 4 years ago in Import/Export Permalink

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?

1 attachment(s):
Narday's profile image Narday posted 4 years ago Permalink

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 /

Narday's profile image Narday posted 4 years ago Permalink

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 /

ansgar's profile image ansgar posted 4 years ago Permalink

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

Narday's profile image Narday posted 4 years ago Permalink

**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!

3 attachment(s):
ansgar's profile image ansgar posted 4 years ago Permalink

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.

Narday's profile image Narday posted 4 years ago Permalink

Updated as such. Installed latest version.

Still throwing up this error.

Appreciate your help.

2 attachment(s):
Narday's profile image Narday posted 4 years ago Permalink

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

Narday's profile image Narday posted 4 years ago Permalink

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

Narday's profile image Narday posted 4 years ago Permalink

VARCHAR?

1 attachment(s):
  • Capture3
Narday's profile image Narday posted 4 years ago Permalink

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

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

1 attachment(s):
  • Capture4
ansgar's profile image ansgar posted 4 years ago Permalink

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.

Narday's profile image Narday posted 4 years ago Permalink

Yes, populated. Almost...

How do i check in Heidi?

ansgar's profile image ansgar posted 4 years ago Permalink

Data grid?

Description

Narday's profile image Narday posted 4 years ago Permalink

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...

ansgar's profile image ansgar posted 4 years ago Permalink

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.

Please login to leave a reply, or register at first.