Trying to import links

  • zzz1845

    (@zzz1845)


    5 years, 8 months ago

    Yannick,

    A couple of months ago I asked about the limitation of links via this thread:
    https://wordpress.org/support/topic/limitations-on-the-number-of-links-link-library-can-search/

    Now, I’m ready to import the 32,000+ links. I have run a test by importing via phpmyadmin. The imported links are showing in the Dashboard. However, the imported are not appearing as part of the search results. I think it’s because my imported links are not connected to a category and the category field beside the link in the Dashboard is blank.

    I found a database called wp_linkcategorymeta but there is no way I can tell to connect a link to these categories.

    Is there another database I should be looking in?

    How do I connect an imported link to a category so the newly imported links could be part of the search?

    Rob

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

    (@jackdewey)

    5 years, 8 months ago

    The wp_linkcategorymeta table is no longer used by Link Library. It was only used in version 5.9 and older.

    You are saying that you are trying to import links via phpmyadmin, so are you writing direct insert statements into the post table? Link Library no longer uses the wp_links table, so you should not be trying to import links in there.

    To assign categories, you need to use a combination of the wp_terms, wp_term_taxonomy and wp_term_relationships tables to associate a post to a taxonomy.

    Is there a specific why you are trying to import links directly via SQL? Link Library provides a CSV importer in its Global Options | Import section. There is a template showing the format for links to be imported.

    Another solution could be to use a plugin like WP Ultimate CSV Importer (https://wordpress.org/plugins/wp-ultimate-csv-importer/)

    Thread Starter zzz1845

    (@zzz1845)

    5 years, 8 months ago

    >Is there a specific why you are trying to import links directly via SQL?

    Because I was using an older version of your plugin and hadn’t updated to find the import function! Ha!

    I have updated and I’m importing now. Up to 5901 links at the moment and finding out that my web page with the search is not loading. I’m going through deleting links (20 at a time on a page) trying to see if it’s corrupt data or the amount to data. Once I know more, I’ll start a new thread if needed.

    Thank you for getting me moving forward!

    Rob

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Trying to import links’ is closed to new replies.