Import csv file with the TAB delimiter

PHPMaker General Discussion (PHPMaker)
1

How can i import CSV file with the TAB Delimiter

when I check on the Advance settings → Import from CSV delimiter = ,
how can I add the TAB here.

CSV file example
orderid Number Name RequestTime ResponseTime
93239708 95247125 Tom 4/13/2020 1:51:34 AM 4/13/2020 1:51:59 AM
93237866 14258963584 James 4/12/2020 11:30:40 PM 4/12/2020 11:30:42 PM

2

You may try enter \t.

3

I have the Advance settings → Import from CSV delimiter = \t
In my csv file I have 580 records and 1 field is primary.
When I import it show the error as (Success 1, Failure 579)

When I check the database it insert 1 record with all the fields NULL

4

More info about the failures should be found from the HTTP response returned by the API. you may press F12 in Chrome, go to the Network panel, find /api?action=import, check the HTTP response, see: https://developers.google.com/web/tools/chrome-devtools/network/reference.

5

I get all the value as ‘’ (NULL)
ERROR MESSAGE
row 2: Failed to execute SQL. Error: Duplicate entry ‘’ for key ‘PRIMARY’ (1062)

This means that my csv value has imported with all empty string ‘’

My csv file is showing as (Field delimiter is TAB and the value/data is without quotation mark " " )
orderid Number Name RequestTime ResponseTime
93239708 95247125 Tom 4/13/2020 1:51:34 AM 4/13/2020 1:51:59 AM
93237866 14258963584 James 4/12/2020 11:30:40 PM 4/12/2020 11:30:42 PM
93239952 95212425 jack 4/13/2020 1:59:34 AM 4/13/2020 1:59:34 AM
93240521 14525384 James 4/12/2020 10:35:41 PM 4/12/2020 10:35:41 PM

6

Bishu wrote:

row 2: Failed to execute SQL. Error: Duplicate entry ‘’ for key ‘PRIMARY’

If orderid is your primary key, you cannot use the same order id again or you get duplicate primary key.

If you actually want to allow update (not insert) the record, you may disable the advanced setting “Import records by insert only”, see the topic Tools → Advanced Settings in the help file.

7

arbei wrote:

If orderid is your primary key, you cannot use the same order id again or you get
duplicate primary key.

All my csv record while importing are getting empty string ‘’
the row 1 is inserted with the empty string ‘’
that’s why the row 2 is getting error in primary because all the records are getting as empty string.

My problem is when I import my particular csv all the records are showing as empty string.

8

Which field is primary key? You better post your table schema (CREATE TABLE) so other can try.

9

Error has been Identify - but unable to resolved.

when I change the Advance settings → Import from CSV delimiter = \t
and generate the project

In the generated source code of ewcfg.php I get as
“IMPORT_CSV_DELIMITER” => “\t”, // Import to CSV delimiter

The is double slash before t as “\t” but in the project I have put only one slash
When I change this “\t” in ewcfg.php to “\t” it is working fine.

Now what I have to enter in Advance settings → Import from CSV delimiter to get “\t” in generated code of ewcfg.php

10

Put this code in “Global Code” section (assume v2020):

Config(“IMPORT_CSV_DELIMITER”, “\t”);