Warning: Please do not give out any FTP or ssh credentials to anyone, unless you trust them completely. Giving out login details is dangerous.

If the asker does not get an answer then they have 10 days to request a refund.

SRD | 01/22/12 at 2:00am Edit

Previous versions of this question: 01/22/12 at 5:29am | 01/23/12 at 5:08am

The experts have suggested, on average, a prize of $25 for this question.

(4) Possible Answers Submitted...

See a chronological view of answers?

Warning: Please do not give out any FTP or ssh credentials to anyone, unless you trust them completely. Giving out login details is dangerous.

• 
  Last edited:
  01/22/12
  2:04am
  Fahd Murtaza says:

  http://wordpress.org/extend/plugins/category-import/

  • 01/22/12 2:12am
    
    SRD says:

    Thanks. This does not import the category description, which is important in my scenario.

  • 01/22/12 2:15am
    
    Fahd Murtaza says:

    OK try CSV importer. i,e
    
    http://wordpress.org/extend/plugins/csv-importer/
    
    Create fake posts in CSV with all categories i.e 1 post per one category.
    
    Once the categories are imported, delete the fake posts in bulk using the bulk delete plugin
    
    http://wordpress.org/extend/plugins/bulk-delete/

  • 01/22/12 2:29am
    
    SRD says:

    Thanks. This plugin doesn't mention anything about category descriptions, nor do any of the example CSV files. Adding a test field for category description does not work either.

  • 01/22/12 2:43am
    
    Fahd Murtaza says:

    OK then you need to get one developed. I can develop a solution for you.

  • 01/22/12 2:47am
    
    SRD says:

    Thanks. Approximate cost?

  • 01/22/12 2:47am
    
    Fahd Murtaza says:

    Please inbox me.

• 
  Last edited:
  01/22/12
  2:08am
  Arnav Joy says:

  check this
  
  http://wordpress.org/extend/plugins/wordpress-importer/

  • 01/22/12 2:13am
    
    SRD says:

    This requires the import file to have been exported from an existing Wordpress website.
    
    It hasn't; my import file is just a CSV file.

• 
  Last edited:
  01/22/12
  3:51am
  John Cotton says:

  Can you show us a couple of sample records?

  • 01/22/12 5:07am
    
    SRD says:

    It's simply a CSV with data corresponding to the following columns:
    Region; City; Description
    
    Where Region is the parent category, City is the sub-category, and Description is the category description of the City.
    
    It is for a business directory.

  • 01/22/12 5:11am
    
    John Cotton says:

    Are you prepared to bump up the prize? Make it $50 and I'll write you something this morning.

  • 01/22/12 5:16am
    
    SRD says:

    Sounds fair, John.

  • 01/22/12 5:19am
    
    John Cotton says:

    Great - you bump the prize, I'll write some code.

  • 01/22/12 7:42am
    
    John Cotton says:

    Try this

  • 01/22/12 8:28am
    
    SRD says:

    Is this accessed through Tools > Category Import?
    
    If so, I select the taxonomy type for import as category, and upload it.
    
    I receive a message:
    

    13 parent terms added.
    418 child terms added.
    3 child terms updated.

    
    
    There are only 16 categories created, which are the parent categories. There are no subcategories created.

  • 01/22/12 8:30am
    
    John Cotton says:

    13 parent terms added.
    418 child terms added.
    3 child terms updated.
    

    
    That means it worked....
    
    Try adding a temporary category manually (you can delete it afterwards) to make sure your cache is showing the correct list.

  • 01/22/12 8:35am
    
    SRD says:

    Adding a temp category manually didn't fix it, nor did clearing the cache and doing a hard refresh.
    
    A search of the database in PHPMyAdmin says the subcategories are found in a table called wp_importtowns

  • 01/22/12 8:39am
    
    John Cotton says:

    A search of the database in PHPMyAdmin says the subcategories are found in a table called wp_importtowns

    
    
    ??? What's that?
    
    The plugin uses wp_insert_term/wp_update_term so, unless you've got a very odd set-up, then the data will go into wp_terms/wp_terms_relationships etc...
    
    If you'r happy PMing me your login details, I'll take a quick look.

  • 01/22/12 8:43am
    
    SRD says:

    Never seen it before. The filename of the first CSV I used was import_towns.csv, but this didn't work properly, I think because it had ; as field seperators.
    
    I changed ; to , and saved this as import_towns2.csv.
    
    I'll PM you some details. Note, the database table prefix is not the standard wp_, it is a custom prefix as a security precaution.

  • 01/22/12 8:51am
    
    John Cotton says:

    it is a custom prefix as a security precaution

    
    That's fine - mine aren't either.

  • 01/23/12 5:10am
    
    SRD says:

    Thanks John
    
    Your plugin has done the job.

• 
  Last edited:
  01/22/12
  7:48am
  Sébastien | French WordpressDesigner says:

  i have a software i have coded which transform a tabel to csv you can import into wordpress.
  
  I can do that in 2 minuts
  
  send me an email to maildeseb @ gmail .com if you are interested

This question has expired.

Gabriel Reguly, idt, Julio Potier, Kannan C, Luis Abarca, Francisco Javier Carazo Gil, SRD voted on this question.

Current status of this question: Completed

Warning: Please do not give out any FTP or ssh credentials to anyone, unless you trust them completely. Giving out login details is dangerous.

If the asker does not get an answer then they have 10 days to request a refund.