(paid of course) - xml import

[ferdgua]

A software hause has a softwware for professional car seller. This software create a xml file with the archive of all car for sale. That file is send to same ads classified website for tha pubblication.
I'd like to be one of those sites and import the xml file in my database, via direct insertion into  mysql or through any other way possible.
The file xml is updated everyday with new ads, deleting of same old and a mofify of some.
Peraph it needs a special sector of mysql for a deleting all yesterday list and post the today list, without modify my personal user list of ads.
I find the xml export plugin but i need the reverse.
how much for all this?
Sarebbe meglio un contatto italiano
it is better but non essential a italian person

Update my controll pannel of database can import xml file.
But is necessary to add the item and formatting the field in a compatible version with the mine.

The essential functions

Function 1 :  Delete all the item that id begin with the number ##### (##### is a selectable number)

Function2: choose the match between the personal and XML fields
                          example:
                  My field                xml field
                  item id                  ##### (##### is a selectable number) + item id by xml file
                  Title                      <marca><![CDATA[Ducati]]></marca>
                                              <modello><![CDATA[MONSTER 900]]></modello>
                                              <condizione><![CDATA[usato]]></condizione>
                                               ...and other of my chose from the list

                 Description                       <colore><![CDATA[Nero]]></colore>
                                                         <descrizione><![CDATA[euro 0]]></descrizione>
                                                          ...and other of my chose from the list
                                                           <uniproprietario>0</uniproprietario>  If there is a 0 then write "unico proprietario" (not importante)
[...]
                 City                                    <provincia><![CDATA[FI]]></provincia>
                                                             if provincia= fi
                                                                  write "firenze"
                                                                  if provincia= ba
                                                                  write "bari"

Function 2.1: import the xml file by url http://externalwebsite.dfhbhfhdgasdhgfjkhjdfkljhsdfj.xml

Function 3: export a xml of all the  all the item that id begin with the number ##### and save it on http://MYWEBSITE.kljhsdfj.xml

[_CONEJO]

Hi ferdgua,


I think you will encounter problems if you try to modify the item id or create one on your own.

Let's say you chose 1000 as the number. XML items will be 1001, 1002, 1003, .... if your XML has 40 items, the last id will be 1040, if someone publish a new item ON YOUR WEBSITE, their item id will be 1041 (Since OSClass will look for the next available item id)


Also,... Is the external website going to ping your site? Is it going to push you the XML or are you going to pull it?

Instead of having modify the item id, I would suggest you, that if the XML is from only one seller, then you could delete all items from that seller, export them,... etc etc

I think I could help you with this, PM me if you're interested.

Thanks

[ferdgua]

Thank you for surgery.

Let's say you chose 1000 as the number

and if i chose 99999999 ?
 
 There is not a single seller but different name and email.
 I'm going to pull  the xml from link to each day

As soon as I organize the ideas i recall you in Pm

[_CONEJO]

Let's say you chose 1000 as the number

and if i chose 99999999 ?
 There is not a single seller but different name and email.

No matter how big the item id you choose, the "on the web" listing will have the next item's id. I will suggest to create a separate list to know which ads are from the XML and which not, if there're few items (<100) it could be stored in a variable, if there're more, it would be needed a separate table.


Thanks

[ferdgua]

You should understand what is the best thing.
 As soon as I can contact you in private for an agreement
Thanks