Now we're ready to create an Extract to link our Source to our Target. From the main menu go ahead and click Create from the Extract menu. Creating an Extract
- Step one asks for the name, Source and Target. It would be a good idea to name it the same as your Source to keep up with it. Choose the cooresponding source and our target we created in the previous tutorial. Click Apply.
- The next step is for Batch Parameters. I kept the defaults except Batch_Size, set it to 100. This setting is really up to you. This is 10 by default but runs fine for me at 100. Clicked Apply.
- Step three in my case warns me my provider does not have a media server, which is fine since we will be downloading everything anyway. Click Apply.
- Step four ask about refreshing values. Set this to false. Click Apply.
- Step five is very important. Here is where you tell it which fields go to which database table columns. I generally place my mls number, class, type, status in the first few fields. Also it is a very good idea to write these down! As you create more Sources and Extracts you will want to keep the columns as similar as possible to search across all types of listings. (keep price in the same column so no matter if you're searching Land or Condos, its always going to be in that column).
- Step six is the same thing but with the image table. You should be able to include all the fields, but keep these the same throughout all of your extracts.
Now we have our Extract. Our next step is to alter our batch file to retrieve listings with an Active Status only, and execute our batch via command line. * RETS Retrieval with PHP and VieleRETS: Part 1, Introduction * RETS Retrieval with PHP and VieleRETS: Part 2, Creating a Source * RETS Retrieval with PHP and VieleRETS: Part 3, Creating a Target * RETS Retrieval with PHP and VieleRETS: Part 4, Creating an Extract * RETS Retrieval with PHP and VieleRETS: Part 5, Executing the Batch * RETS Retrieval with PHP and VieleRETS: Part 6, Creating a Cron Job