VehicleManager component support

ok, I had this working the other day.. now I'm having more problems...

I download an xml file from the site administration area, and open it in excell... if I leave the "version" field in place, it tells me that id is already in the database. If I delete the version field.. it imports, but the data is all in the wrong slots... the cat id becomes two fields somehow, and the description gets moved one field over and all data is broken after that...

so I can't even download and re-import your own export as a csv...

How do I make this into an xml file without having to write in all those codes?????? I paid for this feature because I thought it would be useful, and I can't even use it...

I use this set of fields -
vehicleid catid description link vmodel vtype listing_type price priceunit price_type vtitle vlocation vlatitude vlongitude contacts map_zoom year vcondition mileage listing_status engine transmission drive_type cylinder num_speed fuel_type city_fuel_mpg highway_fuel_mpg wheelbase wheeltype rear_axe_type brakes_type exterior_color doors exterior_amenities interior_color seating dashboard_options interior_amenities safety_options w_basic w_drivetrain w_corrosion w_roadside_ass image_link featured_clicks featured_shows hits date published maker owneremail country region city district zipcode rents rent_from rent_until rent_request user_name user_email user_mailing status buyingrequests reviews thumbnail_img main_img


This is the data:
002047G|46|97 Chevrolet Conversion Van, AC, All Power, Bucket Seats, Rear AC|1|Chevrolet|van|vehicle for sale|Call|USD||1997 Chevrolet Conversion Van |Tucson|||||1997|used||active||automatic|Rwd|||Gas||||||||||||||||||||||||1|Chevrolet

This is what it looks like when I export it...

version vehicleid catid description link vmodel vtype listing_type price priceunit price_type vtitle vlocation vlatitude vlongitude contacts map_zoom year vcondition mileage listing_status engine transmission drive_type cylinder num_speed fuel_type city_fuel_mpg highway_fuel_mpg wheelbase wheeltype rear_axe_type brakes_type exterior_color doors exterior_amenities interior_color seating dashboard_options interior_amenities safety_options w_basic w_drivetrain w_corrosion w_roadside_ass image_link featured_clicks featured_shows hits date published maker owneremail country region city district zipcode
2.2 PRO 002047G 46 46 97 Chevrolet Conversion Van, AC, All Power, Bucket Seats, Rear AC 1 0 Call 1997 Chevrolet Conversion Van Tucson used active Gas 0 0000-00-00 00:00:00 0 1 Chevrolet


Notice that there are 2 "46" entries... shifting the description over to the next field.. and every other data field...

ok, so, after a lot of screaming, I deleted the catid column.. then they all imported.. but they're not really categorized.

I'll head over to the wishlist part of this forum to wish that I could include that catid and it would understand it.. so that I only have to have one file, not one for each category.

I'd also like the importer to at least see if there's any info that's different in a record before rejecting it out of hand.. In case I want to update the info that's already there. I have to delete a vehicle and then re-import it to change details in bulk...

If the importer didn't make me delete the first row of column names, I wouldn't have to have a million extra pipes.. it could put the data from the correct field into the correct field, and not be limited to how any columns over it was.. then I wouldn't have to keep column names I don't use in the csv.

And pipe delimited might work well in some cases, but having to change my computer to use it seems odd.. you could just as easily scan for a pipe or a comma delimiter.

The importer needs a little more work.

The csv export could stand to have the column names included as well... It would be a big help...

This is the field list that worked for me...
vehicleid description link vmodel vtype listing_type price priceunit price_type vtitle vlocation vlatitude vlongitude contacts map_zoom year vcondition mileage listing_status engine transmission drive_type cylinder num_speed fuel_type city_fuel_mpg highway_fuel_mpg wheelbase wheeltype rear_axe_type brakes_type exterior_color doors exterior_amenities interior_color seating dashboard_options interior_amenities safety_options w_basic w_drivetrain w_corrosion w_roadside_ass image_link featured_clicks featured_shows hits date published maker owneremail country region city district zipcode rents rent_from rent_until rent_request user_name user_email user_mailing status buyingrequests reviews thumbnail_img main_img

If you export a csv, then paste the column names into the top row... they should line up and you'll be able to see from the sample data what it's looking for.

I'd still love to know an easy way to make all this into the xml file you claim is more reliable.

Hello,

sorry, Vehicle ID and category ID - must be unique !!!!!
And important save structure !!!!

Every category ID - connected with every vehicle - with that connect - we recover full structure.

Please install test site.
Create on it two vehicles and two categories for these vehicle - after that please check how work import - export

Thanks,
OrdaSoft team