[Problem][Solved] How to convert CSV to XML in CLAD Genius Bulk Import

Another problem encounter, yet solved :)

Orite well first of all,
"what is CLAD Genius?"
to make things short, CLAD genius is an auto posting software to begin marketing! which you can use this piece of software to place your ads on Craigslist, Backpage, or Ebay Classifieds.

[The problem]
Someone asked me how to Convert a CSV data to XML which it uses CLAD Genuis xml tamplate?

-[CSV data content]
columnA,columnB,columnC,columnD
mike,where,we,foxtrot,
alpha,bravo,charlie,delta

-[Clad genius XML tamplate]

Eg:

  
    {{COLUMN A}}
    
    {{COLUMN B}}
    bpap$allowReplies='No';bpap$showJoinedDate='False';bpap$showAdLinks='No'
    
    
    <div style="width:650px;margin:0 auto;"> <div style="float:left;width:188px;clear:left;margin-top:20px;"> <a href="{{COLUMN E}}"><img src="http://s19.postimage.org/gdbcs6ttv/tickets_On_Sale_Stub.png" border="0" alt="{{COLUMN A}} Tickets For Sale Online" /></a> </div> <div style="float:right;width:447px;margin-left:15px;"> <br><br> <h1 style="text-align:center;"><b><a href="{{COLUMN E}}" style="color:#CC3300;text-decoration:none;">Buy {{COLUMN A}} tickets online</a></b></h1> <span> <a href="{{COLUMN E}}" title="Find and Purchase {{COLUMN A}} Tickets Online At http://ticketogre.com">{{COLUMN A}} tickets</a> are currently the #1 selling events this 2012. This high demanding event, {{COLUMN A}} will absolutly be sold out early. www.TicketOgre.com has one of the largest supply {{COLUMN A}} available. If you are hunting for {{COLUMN A}} seating charts/maps, last minute {{COLUMN A}} ticket savings, {{COLUMN A}} discounts, sold out {{COLUMN A}} seats, or {{COLUMN A}} 2012 and 2013 schedule, check www.TicketOgre.com for all your event needs. </span> <h2 style="color:#CC3300;text-align:center;">{{COLUMN A}} tickets are selling quick, act now</h2> <div style="padding:15px;"> <a href="{{COLUMN E}}"><img src="http://s19.postimage.org/yop56uw77/buy_Now_Button_Green.png" border="0" alt="Where To Buy {{COLUMN A}} Tickets Online" width=400 /></a> </div> </div> </div> <p><font size="1" color="aliceblue">$randomtext{88}</font></p><div style="clear:both;"></div>

    0001-01-01 00:00:00
    0001-01-01 00:00:00
    
      
        
          
        
        
          
        
      
      
      
    
  

After some writing program, i manage to generate the CSV data into the specific place in the XML tamplate. :) and here it is:

*The program :)

Want the source code? just PM me! :)

30saat[at]gmail[dot]com