Importing only the first line declaring columns, no users.

Hi,

We just bought this plugin and as suggested installed it on a test domain of the intended website.
We first made an export of some example users in the example groups.
We filled in some additional test users in the text file. deleted the existing ones, as on the live site it will be importing only new users.

We imported the saved text file, this shows us this message: Column declaration found on line 1, the following column order is assumed: user_email, user_login, first_name, last_name, user_url, user_pass, roles, groups, meta:description, meta:tsajq_capabilities, meta:tsajq_user_level

Indicating it reads the file.

But all the following lines are :
0 valid entries have been read.

0 entries have been skipped.

0 users have been imported.

0 users have been updated.

But there are 2 more lines.

When we create a csv with MS Excel, which adds ‘;’ instead of tabs. it gives an instant error. Indicating the lines are read.

I’ve tried multiple file extentions but no luck.

Any help here would be appreciated.

Kind regards,

Martijn

9 Responses to Importing only the first line declaring columns, no users.

  1. Arnold September 6, 2016 at 7:38 am #

    Hi Antonio,

    We have got it working now in combination with sublime text for mac os.

    The only thing that is not being imported correctly is the ‘meta:description’ column.
    On a user were i filled in a description then exported the text is exported in that column. But there is no such text being imported.
    For us this is after the groups and standard login information the most important column to import.

    Kind regards,

    Martijn

    • antonio September 6, 2016 at 8:12 am #

      Hi Arnold,
      please be sure that your description text doesn’t contain tabs.
      If the problem persists, please send me an example file to antonio[at]itthinx[dot]com
      Kind Regards,
      Antonio B.

      • Arnold September 6, 2016 at 8:21 am #

        Hi,

        Thank you for your reply.

        Send you a reply with the file that works fine for the rest of the columns except the discription, no tabs in there as far as i can see.

        Kind regards,

        Martijn

        • antonio September 7, 2016 at 8:56 am #

          Thanks,
          answered by email.
          Cheers

  2. antonio September 1, 2016 at 10:48 am #

    Hi Arnold,
    maybe there is a problem with the file codification (sometimes the software add extra hidden characters).
    If you send me the file to antonio[at]itthinx[dot]com indicating this topic, I can check if the problem is with the file.
    Kind Regards,
    Antonio B.

    • Arnold September 1, 2016 at 12:45 pm #

      Thank you for your reply, I mailed you the file with some additional steps I took with these files.

      Kind regards,

      Martijn

      • antonio September 1, 2016 at 3:16 pm #

        Hi Arnold,
        sorry I have not received the email. Please send me the email to antonio[at]itthinx[dot]com (maybe the server is filtering the message).
        Thanks,
        Antonio B.

        • Arnold September 1, 2016 at 4:08 pm #

          Resend.

          Kind regards,

          Martijn

          • antonio September 1, 2016 at 4:40 pm #

            Thanks,
            the problem is with the new line character used. Please try to edit the file with notepad, using the Enter key at the end of each line.
            Kind Regards,
            Antonio B.

We use cookies to optimize your experience on our site and assume you're OK with that if you stay.
OK, hide this message.

Affiliates · Contact · Jobs · Terms & Conditions · Privacy Policy · Documentation · Downloads · Useful Plugins · My Account

Share