Universal Data Exporter PHP Support Product Page

XML output

Asked 13 Aug 2011 00:23:54
1
has this question
13 Aug 2011 00:23:54 steve test posted:
Hello,
I've set up an export of a recordset to XML. I've made changes to rename the elements but that does not work. Is it required to create a table be the renaming to be tied together?


<?php
// Universal Data Exporter 1.1.4
// Type: xml
$Listings = new dmxXMLExporter();
$Listings->rootName = "Listings";
$Listings->rowName = "Listing";
$Listings->stripHtmlTags = true;
$Listings->fileName = "export";
$Listings->download = true;
$Listings->saveCopy = false;
$Listings->saveLocation = " ";
$Listings->sourceRecordset = $rsxml;
$Listings->sourceFieldsString = "mMHVillage,SellerID,50,C,L,0,T,Sales_Price,AskingPrice,50,C,L,0,T,invId,invId,50,C,L,0,T,invUser,invUser,50,C,L,0,T,invType,invType,50,C,L,0,T,invTitle,invTitle,50,C,L,0,T,invDescr,Description,50,C,L,0,T,InvImage,PhotoURL,50,C,L,0,T,invFloorPlan,invFloorPlan,50,C,L,0,T,invPreview,invPreview,50,C,L,0,T,invSlideShow,invSlideShow,50,C,L,0,T,invEmail,invEmail,50,C,L,0,T,invLoc,invLoc,50,C,L,0,T,invStatus,invStatus,50,C,L,0,T,invRemote,invRemote,50,C,L,0,T,invFeatCand,invFeatCand,50,C,L,0,T,invSaleRent,invSaleRent,50,C,L,0,T,Uniqueid,Uniqueid,50,C,L,0,T,markerID,markerID,50,C,L,0,T,Account_no,Account_no,50,C,L,0,T,addInfoID,addInfoID,50,C,L,0,T,name,name,50,C,L,0,T,Address,Address,50,C,L,0,T,City,City,50,C,L,0,T,County,County,50,C,L,0,T,State,State,50,C,L,0,T,Zip,Zip,50,C,L,0,T,Make,Make,50,C,L,0,T,Model,Model,50,C,L,0,T,Year,Year,50,C,L,0,T,sqr_ft,sqr_ft,50,C,L,0,T,Width,Width,50,C,L,0,T,Length,Length,50,C,L,0,T,BedRooms,BedRooms,50,C,L,0,T,BathRooms,BathRooms,50,C,L,0,T,Community,Community,50,C,L,0,T,Comments,Comments,50,C,L,0,T,Serial_No,Serial_No,50,C,L,0,T,Space,Space,50,C,L,0,T,Prev_Owner_name,Prev_Owner_name,50,C,L,0,T,Submit_date,Submit_date,50,C,L,0,T,Sold_date,Sold_date,50,C,L,0,T,List_expire,List_expire,50,C,L,0,T,Decal_Lic,Decal_Lic,50,C,L,0,T,list_price,list_price,50,C,L,0,T,Rent,Rent,50,C,L,0,T,Commission,Commission,50,C,L,0,T,List_source,List_source,50,C,L,0,T,ParkId,ParkId,50,C,L,0,T,HUD_NO,HUD_NO,50,C,L,0,T,Private_comments,Private_comments,50,C,L,0,T,Keyloc,Keyloc,50,C,L,0,T,status,status,50,C,L,0,T,parsefilename,parsefilename,50,C,L,0,T,lender,lender,50,C,L,0,T,hometype,hometype,50,C,L,0,T,mailstatus,mailstatus,50,C,L,0,T,ASSIGN_DATE,ASSIGN_DATE,50,C,L,0,T,lat,Latitude,50,C,L,0,T,lng,Longitude,50,C,L,0,T,domain,SellerWebsite,50,C,L,0,T";
$Listings->doExport();
?>




This is basically the only related code in my file. I don't see the point of generating an html table if the extension can already export based on the recordset.

Any advice?

Steve

Replies

Replied 13 Aug 2011 00:38:45
13 Aug 2011 00:38:45 steve test replied:
You can see in the snippet above that the field value of MHVillage should relabel as SellerID. This never happens and the result fails, only showing the original field name.
Ref:
......
<domain></domain>
<geoD>1</geoD>
<mMHVillage>23454xxx</mMHVillage>
</Listing>

Note also that the sorting values assigned do not put the mMhvillage value 1st which is what is set.

Not good.

Reply to this topic