Results 1 to 2 of 2

Thread: Importing Existing Jobs

  1. #1
    Unregistered
    Thread Starter
    Guest Unregistered's Avatar

    Importing Existing Jobs

    I have a MySQL database of 6,000 jobs with Job Title, Category, Company, Location and a Details hyperlink fields for each. It appears there is no CSV importer for JobRoller. So what is the procedure for importing these records or is it even possible.

    Thanks

  2. #2
    pepsi's Avatar
    Join Date
    Mar 2009
    Location
    New Zealand
    Posts
    14,883
    Thanks
    91
    Thanked 804 Times in 718 Posts
    You are correct, there is no .csv importer built into JobRoller, so it will rely on your knowledge of mysql admin in order to migrate this existing data into JobRoller. I found a thread related to this within our forums which had some tips from the developer which may give you some idea of what is involed:

    1. JobRoller uses it's own tables only for storing job packs, job alerts and orders.
    2. The first and main step would be to import all your posts and users to WP tables ('wp_posts' and 'wp_users').
    3. After having this data imported, you will need to update the post type of your posts to 'job_listing' using an MySQL Update..
    4. From here you should be able to update all the additional data directly from the backend or frontend (custom fields, user roles, etc...).
    Hopefully this helps. Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Importing Indeed jobs instead of showing them
    By thesiege in forum JobRoller General Discussion
    Replies: 2
    Last Post: September 4th, 2012, 02:43 PM
  2. Job Location when importing jobs form xml
    By bluesalman in forum JobRoller General Discussion
    Replies: 6
    Last Post: August 9th, 2012, 01:55 PM
  3. Job Location when importing jobs form xml
    By bluesalman in forum Report JobRoller Bugs
    Replies: 1
    Last Post: August 8th, 2012, 10:41 AM
  4. Job Location when importing jobs form xml
    By bluesalman in forum Help Using JobRoller
    Replies: 0
    Last Post: August 7th, 2012, 09:46 AM