1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.
  2. Better Analytics for WordPress Get It Free

Making XML for my website or conversion of XLS to XML HEELLPPPP!!!!!

Discussion in 'XML & RSS' started by afridz, Aug 6, 2010.

  1. #1
    Hello all

    I own a used car website(www.usedcarsinkerala.com) where we can sell used cars, recently i got in contact with another site www.trovit.com. Here we can submit the xml feed of my website so that my car listings will be available in trovit also

    For that i imported whole listings of my website and it came out .xls format. So i converted it to xml using a software and uploaded the file in my server. But trovit has a type of format which is different from what i made. GUIDELINES FROM TROVIT

    The xml i made from the software is different from the example gave in above guideline. Can you plaese help me in solving the problem. I will be very thankful
     
    afridz, Aug 6, 2010 IP
  2. cubicaaron

    cubicaaron Guest

    Messages:
    104
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Please post some of the XML that you have generated. You need your feed to be in the form of:

    <trovit>
    <ad>
    <id>7004578</id>
    <url>http://www.yourdomain.com/ad/7004578</url>
    <title>2007 Toyota Qualis</title>
    <content>
    Cruise control, Climate control,....
    </content>
    <price>450000</price>
    .......
    <car_type>hatchback</car_type>
    <warranty>until 2011</warranty>
    </ad>
    </trovit>

    (with a few extra tags missed out for simplicity.)

    What content management system does your site use? It may be a case of adding a simple plugin which pulls data from your database.
     
    cubicaaron, Aug 9, 2010 IP
  3. afridz

    afridz Peon

    Messages:
    164
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    <Listings>
    −
    <ROW>
    <id>439</id>
    <listing_type>Car</listing_type>
    <username>girishankar</username>
    <active>1</active>
    −
    <keywords>
    2004 18000 180000 ALTO LX Maruti Alto Hatchback White Manual petrol 2 wheel drive Air Conditioning AM/FM Radio Compact Disc Player Power Door Locks
    </keywords>
    <featured>0</featured>
    <views>839</views>
    <pictures>pictures/439_1.jpeg;</pictures>
    <activation_date>2010-02-15 00:07:42</activation_date>
    <expiration_date>2010-03-17 00:07:42</expiration_date>
    <Year>2004</Year>
    <Mileage>18000</Mileage>
    <Video/>
    <Price>180000</Price>
    <SellerComments>ALTO LX</SellerComments>
    </ROW>
    −
    <ROW>


    Its coming as like this, and the the CMS, its a php script i bought online,
     
    afridz, Aug 9, 2010 IP
  4. cubicaaron

    cubicaaron Guest

    Messages:
    104
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Might need to build a custom function to output the rss in that format.

    Can you identify which php file is building this. I'd assume that it loops through a database to output everything in the table's row order, but I could be wrong.

    You might need to do a little reading up on the PHP DOM Document element - check it out on php.net.
     
    cubicaaron, Aug 9, 2010 IP
  5. afridz

    afridz Peon

    Messages:
    164
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Bro its vast site, i dont know much about this stuffs, is that a difficult stuff to do?
     
    afridz, Aug 9, 2010 IP
  6. afridz

    afridz Peon

    Messages:
    164
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    no body knows xml here?
     
    afridz, Aug 9, 2010 IP
  7. cubicaaron

    cubicaaron Guest

    Messages:
    104
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Ok, so when you exported it, the row headings were taken as the new row headings in the .xls file. What software did you use to convert this? - There might be options in there to change structure /tag names.

    In php, you'll need a file that creates an empty XML DOM, and then build up a custom structure in the form of the Trovit Feed (above), injecting into it your database data on the way.

    If you provide a database schema, I might be able to offer a little more help. What level of server access do you have? Are you on shared hosting?

    More information on this can be found at php.net http://www.php.net/manual/en/ref.domxml.php
     
    cubicaaron, Aug 17, 2010 IP
  8. cubicaaron

    cubicaaron Guest

    Messages:
    104
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I've also just found this article on Tech Republic http://articles.techrepublic.com.com/5100-10878_11-6141415.html

    The cod eyou should be interested in is:

    <?php
    // create doctype
    $dom = new DOMDocument("1.0");

    // create root element
    $root = $dom->createElement("toppings");
    $dom->appendChild($root);
    $dom->formatOutput=true;

    // create child element
    $item = $dom->createElement("item");
    $root->appendChild($item);

    // create text node
    $text = $dom->createTextNode("pepperoni");
    $item->appendChild($text);

    // create attribute node
    $price = $dom->createAttribute("price");
    $item->appendChild($price);

    // create attribute value node
    $priceValue = $dom->createTextNode("4");
    $price->appendChild($priceValue);

    // create CDATA section
    $cdata = $dom->createCDATASection("\nCustomer requests that pizza be sliced into 16 square pieces\n");
    $root->appendChild($cdata);

    // create PI
    $pi = $dom->createProcessingInstruction("pizza", "bake()");
    $root->appendChild($pi);

    // save tree to file
    $dom->save("order.xml");

    // save tree to string
    $order = $dom->save("order.xml");
    ?>

    This is making an XML document for a pizzaria order, however you can see the potential for swapping out some variables for your car data. You'dprobably want to make this a function or subroutine in PHP, and loop through your database extracing the cell data that you need.

    This could all then be placed under a button or link in your administration area called something like "Update XML" - saving a file in your root directory called cars-feed.xml etc...

    Hope this helps.
     
    cubicaaron, Aug 17, 2010 IP
  9. cubicaaron

    cubicaaron Guest

    Messages:
    104
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    cubicaaron, Aug 17, 2010 IP
  10. dpavlis

    dpavlis Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Hmm, why not to try some open source ETL tool - they are designed to do exactly this - convert between formats. They come with UI which is graphical thus easier to debug.
    You may look at tools like CloverETL ( also Talend or Pentaho).
     
    dpavlis, Mar 5, 2012 IP