Thread: Xml files/How to add data directly to database in a correct form

Xml files/How to add data directly to database in a correct form

I have both your classipress and jobroller installed and now I would
appreciate some help on my classipress site, which is for selling houses.

I have a chance to get a lot of new customers if only I would find a
solution to handle xml files that have all the data on those real estate
companies' ads. Those files are not in a same shape and form as my site has.
There's different titles and not all the ads have the same amount of
information. So far I've inserted new client ads by using csv files and
iMacros, but I haven't been able to find a working solution for converting
those xml files into functioning csv files. This is why I'm now wondering on
how could I insert data from those xml files directly into the database. I know that there's export and import tools available but I'm kind of lost as my original data is different from how it looks like when I exported the current data to see how it looks like.

I'm new to all this creating websites and using automation etc. so I would
really appreciate if you could tell me some sort of step by step instructions, what solutions there could be for
using these xml files as datasource. I tried to search the forum for answers but didn't really find anything suitable. Also the pictures should be added and there's many more pictures in the original data as classipress can take.

An example of one apartments codes:

Apartments>
-<Apartment newHouses="XX"
type="XX">
<Key>XX</Key>
<TotalArea unit="m2">XX</TotalArea>
<LivingArea unit="m2">XX</LivingArea>
<City>xx</City>
<Country>xx</Country>
<UnencumberedSalesPrice currency="EUR">xx</UnencumberedSalesPrice>
<RoomTypes>xx, xx, xx, xxxxx</RoomTypes>
<Region>xxx</Region>
<SupplementaryInformation>xxxxxxx </SupplementaryInformation>
<KitchenAppliances>xxx,xxx,xxxxx</KitchenAppliances>
<BathroomAppliances>xxxxx,xxxxx</BathroomAppliances>
etc...