Importing Link Library

  • Resolved ahau

    (@ahau)


    8 years, 6 months ago

    Hi,

    I am playing with link library to see if I am going to use it as I am migrating a very old site to WP and need a links directory. So far I like what I see but have now run into a few anomalies.

    I have a version running on my own machine (WP 4.8.3) – I’ll call it MySite – and a test site on the net using WP 4.9 which I will call TestSite. I am using the latest version of the plugin on both sites.

    A few days ago I used a csv and imported all of the links into MySite and it worked perfectly.

    Today I went to import all the links using the same CSV file that I had previously used into my TestSite on the net and got “Invalid column count for link on row”. I then went to my MySite to test the CSV and got the “Invalid column count for link on row” there as well.

    So I started again with the template, making sure that the delilmiter is ; and creating a test one in Open Office. I then opend the file in notepad to check all was correct which it was. But again I got the “Invalid column count for link on row”

    Not to be daunted I did an export sql using phpMyAdmin from MySite for the tables wp_linkcategorymeta, wp_links and wp_links_extrainfo with a “delete table if exists” and then ran the sql through phpmyadmin for TestSite. All the data is there nicely but the links are not linked to the categories and I have 100’s of sites so do not fancy going through each and every one of them.

    So looking for solutions so that I can get the links into TestSite and linked properly. I am hoping that I have just overlooked a table and it is not one of the default WP ones which will have alot of other stuff in and be tricky to export. Or a solution to the “Invalid column count for link on row” error would be even better!

    Thank you for your time 🙂

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Yannick Lefebvre

    (@jackdewey)

    8 years, 6 months ago

    Did you create the csv file with an older version of Link Library? I added an extra field to the csv format in the past few weeks. You would need to add that column in to get a proper import.

    If you did not update the plugin, then could you send me the csv file so I can test the import? If not, something I can suggest is to have a single link in the file and import.

    I will be travelling for the next week and will not be able to respond to e-mails during that time. I will be able to look more into your issue starting Dec 2nd.

    Thread Starter ahau

    (@ahau)

    8 years, 6 months ago

    Ahh – I have solved it!

    I was using the right csv but decided to download the template again to make sure. Yep, all the columns where the same as mine. Then I got the bright idea to check the template in NotePad and that is where I saw what my problem was.

    I was using a semi colon as the delimiter and not the comma!

    As soon as I made a new copy of my CSV file, saved it as new name (giving it an already used name and over writing it will not work) and choose the comma as the delimiter when saving and loaded it – it all worked!

    Thank you for pointing me in the right direction 🙂

    Oh, after my first post I checked out your profile, visited your site then bought the bookbook – working my way through it and it is great – thank you for wrting something this valuble 🙂

    Plugin Author Yannick Lefebvre

    (@jackdewey)

    8 years, 6 months ago

    Glad you figured it out. CSV can definitely be a bit finicky.

    And thanks for the good words on my book. After making plugins for a long time, I wanted to put out a good easy-to-use book to learn how to write plugins. Let me know if you publish something to the official repo! 😉

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Importing Link Library’ is closed to new replies.

Tags