Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the Diverse Solutions Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Sep 2013
    Location
    Chesapeake, VA
    Posts
    29

    Creating IDX pages en masse using WP All Import Plugin

    I needed a way to streamline setting up IDX pages for a LOT of areas and zip code pages in our area for my real estate agent client.

    The secret was decoding the custom field URL string created by the filter box. To do that I opened up cPanel for my client site, and had a peek at the database. You're looking for the post meta related to the IDX page (which is still a post in WordPress).

    It helps to set up a sample of what you'd like to filter on, then you can decode it. I wanted to filter on a list of tracts and a list of zip codes. Basically you'll be building a formula based on that/those samples.

    Get the sample of the URL string from phpmyadmin: http://www.screencast.com/t/W73MpaedH

    Set up the spreadsheet (as a CSV) http://screencast.com/t/35DG2bcqTKwy

    Here's a wikihow page on using the concatenate function. http://www.wikihow.com/Concatenate-T...icrosoft-Excel

    Use WP All Import to map the information to the right parts of this custom post type. http://www.screencast.com/t/ClxVui3bJlwT

    WP All Import is not a cheap plugin, but it's highly useful. As a developer, I use it all the time, and the time it's saved me on this project alone makes it more than worth the money.

    Sorry for the rough edges on the videos. Wanted to share this, but not much spare time.

    http://wpallimport.com/ -- no affiliate link! would if I had one, though ;-)

    (I also use wpallimport.com to import RSS feeds of specific listings into another real estate site.)
    Valerie Cudnik
    1508 Percheron Ct.
    Chesapeake, VA 23322-1928
    (757) 271-4602
    cdgwebdesign.com

    Website Design | Printing | Graphic Design

  2. #2
    Super Moderator
    Join Date
    Mar 2011
    Location
    Bellevue, WA
    Posts
    760
    Quote Originally Posted by Valerama View Post
    I needed a way to streamline setting up IDX pages for a LOT of areas and zip code pages in our area for my real estate agent client.

    The secret was decoding the custom field URL string created by the filter box. To do that I opened up cPanel for my client site, and had a peek at the database. You're looking for the post meta related to the IDX page (which is still a post in WordPress).

    It helps to set up a sample of what you'd like to filter on, then you can decode it. I wanted to filter on a list of tracts and a list of zip codes. Basically you'll be building a formula based on that/those samples.

    Get the sample of the URL string from phpmyadmin: http://www.screencast.com/t/W73MpaedH

    Set up the spreadsheet (as a CSV) http://screencast.com/t/35DG2bcqTKwy

    Here's a wikihow page on using the concatenate function. http://www.wikihow.com/Concatenate-T...icrosoft-Excel

    Use WP All Import to map the information to the right parts of this custom post type. http://www.screencast.com/t/ClxVui3bJlwT

    WP All Import is not a cheap plugin, but it's highly useful. As a developer, I use it all the time, and the time it's saved me on this project alone makes it more than worth the money.

    Sorry for the rough edges on the videos. Wanted to share this, but not much spare time.

    http://wpallimport.com/ -- no affiliate link! would if I had one, though ;-)

    (I also use wpallimport.com to import RSS feeds of specific listings into another real estate site.)
    Hello Valerie,

    Thank you so much for sharing your work-around with the Forum. I'm sure this is something that a lot of people will find very helpful going forward, with mass-creating IDX Pages through our dsIDXpress Plugin.

    I will flag this as well so that more people can see it and can benefit from what you've discovered.
    David
    Support: 877.348.7654 Ext.2
    Website | Blog | Help Desk | Forum | Submit A Ticket

  3. #3
    Junior Member
    Join Date
    Sep 2013
    Location
    Chesapeake, VA
    Posts
    29
    Glad it helped. Someone had responded to the initial string asking about the clarification and I actually didn't even remember that I added this or made the screencasts. I made a video tonight showing how to do the same thing for tracts, and am providing a link to the excel file here in case folks want to use it.

    http://www.youtube.com/watch?v=r17_np1kTkE (please don't share out of this forum)

    EXCEL File withe formulas can be found here: https://www.dropbox.com/s/0zih9r5i58...ACTS.xlsx?dl=0
    Valerie Cudnik
    1508 Percheron Ct.
    Chesapeake, VA 23322-1928
    (757) 271-4602
    cdgwebdesign.com

    Website Design | Printing | Graphic Design

  4. #4
    Thank you.... this should have saved me time but took awhile to configure it to post to idxpages. But now I got it working and should save me alot of time in the future.

    Had to change column G for it to work for me and remove tracts column...

    =CONCATENATE("http://myurl.com/idx/listings/?idx-q-Cities=",C2)

    Again Thank You for your post and time to create the tutorials.
    Last edited by Jerzeeman; 01-03-2016 at 07:13 PM. Reason: bad english

 

 

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •