PDA

View Full Version : Rets / IDX Import



Anonymous
06-06-2003, 05:08 PM
Hello,

I've seen a few discussions on this but no solid answers...

Our MLS feeds us updates via ftp in a bunch of text files. We download and have to process through about five different things to get data on our site using a bunch of antiquated soft. As I'm infinitely more familiar with php I'd like to go with Open-Realty. The only barrier is getting data into mysql...???

Here's a code snip from one of the daily updates:


<RETS ReplyCode="0" ReplyText="SUCCESS">
<DELIMITER value="1c"/>
<COLUMN>MLLPINTERNET_LISTINGIDDOFFICE_NAMEOFFICE_PHO NEAGENT_FORM_NAMEAGENT_PHONEHSNSTRCTPUB_RMK1 PUB_RMK2PUB_RMK3PUB_RMK4STY1BABRSCHAGEFAM DINGARACRGARDBASARSBAZIPLA1LOVLMAPLOC PSRMSMODATTCLDRYAMENINTFEXTFAPPLOTLOTD ROOFEXTPRKCONDAGDHANDFPWSSURVDIRAGSFBGS FHEATFUELFCSTCOOLWTRPOSHOAHOAFHOAISWRGT AXVTAXSTAXTAXSPAOTRMASMBALRATEOR1OR11OR 12OR13OR1BOR1FOR2OR21OR22OR23OR2BOR2FOR3 OR31OR32OR33OR3BOR3FFB1FB2FB3FBBFBFPB1 PB2PB3PBBPBF</COLUMN>
<DATA>231236783500.00YYGAGE REALTY518-372-7653ED ROSENBERG518-399-00813012COX AVROTTERDAMPROPERTY BEING REHABBED PRICE REFLECTS NEW KITCHENNEW FURANACE, NEW VINYL AND NEW ELECTRIC SERVICEOWNER IS A CONTRACTOR CAN BE LIKE NEW FOR RIGHT PRICEWWW.HOMESEEKER4U.COM 518-372-SOLDCOL2.03MOHONASEN-DRAPE75NO &#40;1F&#41; OR NEITNO10.00DETCHFULL460461123064387507A QUIET79CE938D,GJ4CEN00OFF BROADWAY NEAR 5 CORNERS00ABFACLOSING0A000000 DEN1000FOYER10000000110000 00</DATA>
<DATA>2312927159900.00YYRE/MAX PREMIER518-869-8500ANTHONY M. GUCCIARDO518-724-24142KENT PLGUILDERLAND3 BR SPACIOUS CAPE IN WESTMERE. HW FLOORS, NEW WINDOWSC/AIR, NEW HOT WATER TANK, FINISHED BSMNT, GUILD SCHOOLS3 SEASON ROOM OVERLOOKING LANDSCAPED YARD. LOW TAXES!CALL ANTHONY GUCCIARDO AT 331-3785. WILL NOT LAST LONG!CAPE1.13GUILDERLAND55YES &#40;1F ONLY&#41;FO10.13ATTCHFIN-A140141122035845130A95DA107WESTMERE7EXP ANDEDKEA,K,M,NC,D,FC,D,RA,K,M,N50 X 110D,IHA0BEN10BWESTERN AVE PAST CGATES, TO R ON GIPP, L ON KENT PL1550750AB175AAIMMEDIATELYN0A0002 600000000000000000100 0001</DATA>
<DATA>231338844500.00AYREALTY USA518-370-3170KELLI GRANT518-372-252869LORRAINE AVSCHENECTADYWONDERFUL STARTER HOME W/TONS OF POTENTIAL.2 CAR GARAGE AND FENCED YD. DEFINITE SPACE FOR3RD BEDROOM. GREAT NEIGHBORHOOD. AWARDWINNING SCHOOL DISTRICT.BUNG1.12SCHENECTADY80NO &#40;1F&#41; OR NEITFO20.00ATTCHFULL4104221230462671057C WOODLAWN0006EEXHC,NA,B30X200AC0B EN00OFF BALLTOWN ROAD BETWEEN STATE AND CONSAUL00ABFAN0A00016000H03 SEAS10000000000010001000 </DATA>
<DATA>231495484900.00AYREALTY USA518-370-3170REISA FARBER518-448-62951084KEYES AVSCHENECTADYTAXES ARE W/O STAR!PACK YOUR BAGS &amp; MOVE RIGHT IN-NOTHINTO DO/GLEAMING HARDWOOD FLOORS/NEW HTWTR HEATER/NEW WIR-ING,INSULATION &amp; SHEETROCK/NEW PLUMBING/OVS GARAGE,FNCDYD,PATIO&amp;PORCH/NEW CT BATH/UP UNION LOC-GREAT NEIGHBRHDCOTTG1.03SCHENECTADY60NO &#40;1F&#41; OR NEITFO10.00DETCHFULL,FIN-A410413123098321057C80CL91UPPER UNION ST6FEA,O,VC,JC,K,PAAA1BEN00BU NION ST EAST, LEFT KEYES00AA,BFAIMMEDN0A1604017293332 00REC RM00010000000001000000</DATA>
<DATA>2316591109700.00YYCIVILL REALTY518-369-2016JON F. CIVILL518-369-20161064MARYLAND AVSCHENECTADYLOVELY HOME ON QUIET CONVENIENT STREET, NEAR COLLEGE,HOSPITALS, SHOPPING &amp; HIGHWAYS. MUCH CHARACTER FRENCHDOORS TO PORCH, CORNER BUILTIN HUTCH IN FORMAL DINING RMCOVERED PATIO, LARGE MSTR BEDRM, GARAGE ON ALLEYCOL1.13SCHENECTADY78NO &#40;1F&#41; OR NEITFO10.00DETCHFULL,RECRM410413123082439 68A80CK91UNION COLLEGE/HOSPIT6A,D,GD,EA,J,O,VC,DC,E,I,K,PB,C,D4 0X184DAA,K0BAN10WEST ON UNION BELOW BRANDYWINE 7TH RT MARYLAND17450B,DBFAARRANGED0A245401 850430500PORCH1000REC RM0001FINISH001001001000</DATA>
<DATA>2316883159000.00AYSCOTT FILM REALTY, LLC518-274-8001SCOTT FILM518-274-800121BROOKSIDE AVMENANDSCURRENTLY USED AS 2-FAMILY BUT CAN EASILY BEUSED AS A SINGLE FAMILY. LARGE HOME WITH FINISHEDATTIC ON A GREAT LOT. NEW ROOF AND SIDING. CLOSETO PARK AND LIBRARY. VIEW AT WWW.SCOTTFILM.COMCOL2.07MENANDS83YES &#40;1F ONLY&#41;AR20.38DETCHFULL130131122047031114A MENANDS96DQ107CORNER OF VILLA12D,GEO,PCP,QA,B65 X 254D,FAJ9CAN00ABROADWAY TO BROOKSIDE&#40;AT FIREHOUSE&#41;23600BBFACLOSINGN0A590429 160126200N00000000000001 1000000</DATA>
<DATA>231697969000.00YYYANKEE REALTY, INC518-371-5055DONNA T. CHOW518-852-762645MYRTLE AVALBANYHISTORIC HOME COMPLETELY REMODELED ACROSS FROMGOVERNORS MANSION/NEW WINDOWS &amp; FURNACE/ROOF 5 YRSOLD/INTERCOM SYS/ZONED HEATING/2 GAR SPACES AVAIL FORRENT/CONT ON OWNER FINDING HOME OF CHOICE1ST2.02ALBANY150YES &#40;1F ONLY&#41;NO00.00FIN-A1101141220257671381B110DM1138A,BF,P ,VB,PA,CPER DEEDFB,K0AEN00MADISON TO EAGLE TO MYRTLE00BB135FAAT CLOSING0A6650455110000OFFICE1000 LNDRY0001000010010000</DATA>
<DATA>231735273500.00AYCENTURY 21 - PURTELL REALTY518-842-1243NANCY A. GIAQUINTO518-883-8295145SHADY BAY LABROADALBINCAMP1.02BROADALBIN-PERT50NO &#40;1F&#41; OR NEITAR00.00CRAWL856856120253943199A196 6HB,I,O,P,XHE,I,K,P,QA,B,K70X100C,KA K4BEN00LAKEVIEW RD 1/4 MI LEFT ON SHADY BAY CAMP ON LEFT00ADFCAT CLOSING0C000000100000000 000010000000</DATA>
</RETS>



As you can see it's very xml like (Rets). Any ideas? Point me in any directions?