Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Javier Carazo

    (@carazo)

    Hello and thanks for writing here ??

    Look at your CSV data:

    Username,Password,Email,zip,note,user_url
    "[email protected]","passw","[email protected]",1396,," TEST,MORE,LINE2",www.wp.com

    We have:

    • First line: 6 items
    • Second line: 7 items

    The CSV parser is prepared for reading commas inside fields (because they are between quotes).

    The extra item is here: 1396,,”

    Tell me if changing it, the plugin is working.

    And thanks for telling me by mail the typo error, I have to solve this!

    Thread Starter Callemann

    (@callemann)

    The Field “TEST,MORE,LINE2,maybemor,,,,end of note.”

    I need some way of import the character ‘,’ (COMMA) inside a filed

    Would be a great solution if you accept text enclosed With “
    like “this is a text” and Count this as ONE field.

    I would like you to strip of the enclosing “”

    Plugin Author Javier Carazo

    (@carazo)

    Sorry but the plugin supports it correctly.

    The problem is what I told (the problem I am seeing). If you want send me CSV directly by mail and I tell you what is wrong and if plugin is the responsible I fix it.

    Thanks.

    Thread Starter Callemann

    (@callemann)

    sample csv file in your mail now…

    Plugin Author Javier Carazo

    (@carazo)

    Perfect, tomorrow you will have an answer.

    Plugin Author Javier Carazo

    (@carazo)

    I have seen the problem. First version support it, but later, to make the plugin compatible with hebrew and others UTF-8 characters.

    I have to redo this part in order to make it compatible with both, commas inside and utf-8 characters.

    Plugin Author Javier Carazo

    (@carazo)

    I have solved it rewriting this part, you will have a new version in minutes, this is uploaded and the update notification will arrive in minutes.

    Thanks for telling me it, tell me here if you have any problem.

    We have used another way, now it is compatible with hebrew and other utf-8 characters and at the same time it will work with commas inside fields.

    Thread Starter Callemann

    (@callemann)

    Tried the latest version, but now i get:

    “First row represents the form of sheet
    Warning: Invalid argument supplied for foreach() in /home/54/w181302/test/wp-content/plugins/import-users-from-csv-with-meta/import-users-from-csv-with-meta.php on line 92
    File must contain at least 3 columns: username, password and email”

    Tried With both ; and , as delimiters
    And tried UTF-8 and ANSI format.

    Please help ??

    Thread Starter Callemann

    (@callemann)

    Removed line 90 with a comment, and it WORKS now.

    see:

    $data = str_getcsv ( $fdata , $delimiter);
    	//	$data = $data[0];
    
    					foreach ($data as $key => $value)   {
    						$data[$key] = trim($value);

    }
    Thanks ??

    Plugin Author Javier Carazo

    (@carazo)

    Yes, I have uploaded another version. Sometimes $data is an array with only one element and all is inside, so I have changed the code now to solve this.

    Thanks for helping!

    Thread Starter Callemann

    (@callemann)

    Perfect !
    Version 1.1.4 does the job.

    Thanks for great support !

    Calle
    ??

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Note-field containing comma’ is closed to new replies.