Beschreibung
Ich möchte Klein anzeigen von einem Anbieter über die zu Verfügung gestellte API aus lesen und in ein anderes System was eine Import Funktion für csv und xml Daten hat importieren.Die Api Funktionen.
Verwendetes Protokoll der API: SOAP
Die Daten werden in XML angefordert und geliefert
Webservice-Methoden: Search, GetCategories und GetCities.
Die API kann mit jeder webbasierten Programmiersprache (z. B. PHP, Perl, Ruby usw.) angesteuert werden
Das Iportierende system:
Listing data import from CSV/XLS format
Listing data export to XLS format added to iLister PHP Classifieds Script
---- beispiel----
Import Listings
Top Previous Next
The format of the file to import listings can be CSV or XLS.
The administrator can create a file with data for new listings and import it to the database:
• Define column names in the file to be imported in accordance with field IDs, except for fields of the 'Tree' type (StateProvince).
For example, the 'Price' field has ID=Price, so use Price for the name of the corresponding column.
• The column for listing category IDs should be named 'category'.
• For the 'featured' system field, set 'featured' in a column name (note all characters are lower case).
• For the 'pictures' system field, set 'pictures' in a column name (note all characters are lower case). The 'pictures' column should contain either full URL of a picture with 'http://' (http://www.YourSite.com/files/pictures/picture.jpg) or relative URL from the temp/import/ directory of the script (pictures/picture.jpg). Picture URLs should be separated with ";" (semicolon). In the CSV file, all listed picture URLs must be surrounded with double quotes: "pictures/picture_1.jpg;pictures/picture_2.jpg" - please refer to a sample CSV below.
• The Tree type (as the 'StateProvince' field) should be defined as follows: in two columns, first is 'StateProvince[1]' - it is for the 1st level (State), second is 'StateProvince[2]' - it is for the 2nd level (Province).
• Import is not supported for the File and Video field types.
• You can assign new listing to a user: set 'username' (all characters must be in lower case) in a column. The user must be registered on your site.
Please see below an example of the imported file in XLS format:
listing-import-excel.zoom70
Here is the sample of the CSV file for the automobile website:
category;pictures;MakeModel[1];MakeModel[2];ZipCode;BodyStyle;Year;ExteriorColor;Vin;Mileage;Price;SellerComments;Address;City;State;ChildSeat;FuelType
Car;"pictures/406_1.jpg;pictures/406_2.jpg;pictures/406_3.jpg;pictures/406_4.jpg;pictures/406_5.jpg;pictures/406_6.jpg;pictures/406_7.jpg;pictures/406_8.jpg;pictures/406_9.jpg;pictures/406_10.jpg;pictures/406_11.jpg;pictures/406_12.jpg";Lexus;RX 350;34741;SUV;2007;White;2T2GK31U37C005295;23450;33500;
ENGINE: 24 Valves,3.5L V6 Engine,Double Overhead Cam,Horsepower: 270,Horsepower At: 6200,Max Hp: 270 Hp @ 6200 Rpm,Torque: 251 Ft-lbs. @ 4700 Rpm,Torque At: 4700,Variable Valve Timing DRIVETRAIN: 5-speed automatic,Front Wheel Drive
;1820 West Vine Street;Kissimmee;Florida;false;GasolineCar;"pictures/436_1.jpg";Ford;Super Duty F-250;29424;Truck;2005;Black;JF1SG77777H712134;65000;14000;
04 FORD F250 LARIAT 4WD 4X4 TURBO DIESEL CREWCAB FX4
;66 George Street;Charleston;South Carolina;true;DieselCar;"pictures/437_1.jpg;pictures/437_2.jpg";Mercedes-Benz;E320;90001;Hatchback;1994;White;JF1SG63667H712134;105000;5200;The German workmanship at its finest.;2851 Winchester Rd.;Lexington;Kentucky;false;Alternative
listing-import-form.zoom70
In order to import listings please do the following:
1. go to Admin Panel -> Import Listings
2. complete the 'System Import Values' form with the appropriate data:
• Category — choose a necessary listing category from the drop down menu. Imported listings will belong to the chosen type. If you want to import listings of several categories, please ignore thus parameter — each listing record from the importing file will be added to the specified category of this record. In this case the listing fields which do not exist for some categories will be ignored while importing data. For example, the filed "Price" does not exit for the category "ForRent", thus price values will be ignored when importing listing records in any case (either they are filled or not).
• Listing Package — choose a necessary package from the drop down menu. Imported listings will belong to the chosen package. Along with the Listing Package, you can choose which free listing features from the selected Listing Package should be activated for imported ads.
free-listing-features-activation
If no free listing features are available within the Package, you will not be able to activate any during the import.
• Check to activate all imported listings — this flag means that the imported listings will be activated after importation;
• Set activation date — the date of activation (the current date by default).
3. complete the 'Data Import' parameters:
• File — indicate a file to import. A file can have the following extensions:
o csv (Comma-separated values),
o xls (MS Excel),
o zip (zip archive), containing an .csv or an .xls file in the root of the archive,
o tar.gz (tar gzip archive), containing an .csv or an .xls file in the root of the archive.
• File Type — choose the type of file to import. The type can be either with .csv or .xls extension.
• Field Delimiter — for CSV-files choose a field delimiter here (Comma | Tabulator | Semicolon);
• Not found values in DB will be — ignored or added to DB (only for values of the List or Tree type).
When you import an archive file, pictures must be in the root of archive in the /pictures directory.
When you import a .csv or .xls file, pictures must be copied to the /temp/import/pictures directory in the root of your iLister script.
After filling in all fields, click the ‘Import’ button.
Natürlich ist mir bewust das fragen wie was machen wir wenn ein FEld nicht vorhanden ist oder was machen wir mit feld formaten die nicht passen auf kommen dafür bin ich ja telefonisch errrecihbar.