CSV Import problem - Com-Property Forum

Welcome, Guest
Please Login or Register. Lost Password?

Com-Property Forum

Modules

Last Properties

CSV Import problem

(1 viewing) (1) Guest

Page: 1

TOPIC: CSV Import problem

Forum Tools

#3690

CSV Import problem 1 Year, 10 Months ago

Karma: 0

Hi, I have interest in the CSV import feature. But when I downloaded the .csv file it is not in separate columns (in excel) it's different rows but all in 1 column. And the second problem is that I don't understand what each word after the ; mean.

example:

;La Vina de Calpe 5G;la-vina-de-calpe-5g;;62;;1;1;1;1;;;03710;;;;370.00;1;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;1_0.jpg;38.650261;0.049696;;1;;2;1;60;;143;2010-04-16;;0000-00-00 00:00:00;;1;1;;1;1;1;;;;;;;;;;;;;;

It has no header which describes what is what.
And how can I add bulk images??????

Any help would be appreciated.
Luca

luca6899

Fresh Boarder

Posts: 3

The administrator has disabled public write access.

#3715

Re:CSV Import problem 1 Year, 10 Months ago	Karma: 2
The CSV option is a great and useful feature, but does it actually work? Is anyone using it? If so how? Thanks

Chris

Expert Boarder

Posts: 109

The administrator has disabled public write access.

#3716

Re:CSV Import problem 1 Year, 10 Months ago	Karma: 3
Hey try this out First export your _properties_product table and check the following bos. you would receive the table with labels then add your data and simply export your table. Best of luck.

khaleel

Expert Boarder

Posts: 105

The administrator has disabled public write access.

#3717

Re:CSV Import problem 1 Year, 10 Months ago	Karma: 2
Khaleel Hi, Thanks for you advise about exporting data from com-propeties. But has anyone IMPORTED data into com-properties? Does the import feature actually work? Is anyone using it? If so how do you bulk import into com-properties? When I try to use it I just get this: Chris

Chris

Expert Boarder

Posts: 109

The administrator has disabled public write access.

#3719

Re:CSV Import problem 1 Year, 10 Months ago	Karma: 3
Simply brows the CSV file and follow the instruction as in pic.

khaleel

Expert Boarder

Posts: 105

The administrator has disabled public write access.

#3724

Re:CSV Import problem 1 Year, 10 Months ago	Karma: 2
Khaleel Hi, Thanks for you help. Where are you doing this? I am relatively new to php and mysql. Presumably I first need to create a comma separated csv file to import. But with what header names, and in what order, and in what file location do I put it? Chris

Chris

Expert Boarder

Posts: 109

The administrator has disabled public write access.

#4884

Re:CSV Import problem 1 Year, 8 Months ago	Karma: 0
Oke I have exported successfully, Now I want to know how you can add multiple images for multiple houses. Luca