RSS
Home Forum v3
Welcome, Guest
Please Login or Register.    Lost Password?
Com-Property Forum
Component v3
General Discussion

[solved]Import csv
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: [solved]Import csv
#4676
[solved]Import csv 1 Year, 9 Months ago Karma: 14
Hi there, i have been searching and looking at several posts handling with the csv import.

but there is no answer on how to setup the csv file for import.

ist this because no one knows how to? i was able to generate the csv by clicking on the button. but when i click on download i have an empty file. so no clue in which order i have to make a file for import.

has anyone used this import funktion? is the any faq or something?

i would like to give users the permission to bulk upload data, instead of the one by one funktionality...

is there any clue how o make this?
wulfseidel
i simply love this component :D
Gold Boarder
Posts: 258
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hamburg GER Birthday: 08/28
Last Edit: 2010/08/23 13:02 By wulfseidel.
The administrator has disabled public write access.
contact
  
#4687
Re:Import csv 1 Year, 9 Months ago Karma: 59
is a deprecated function, not found, sorry
administrator
Admin
Posts: 544
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4712
Re:Import csv 1 Year, 9 Months ago Karma: 14
what do you exactly mean? the funktion is in the control panel but not usable?

i also found the code which is handling this function, and will do the drop the field into the table. i just need to know the format of the csv to be importet
wulfseidel
i simply love this component :D
Gold Boarder
Posts: 258
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hamburg GER Birthday: 08/28
The administrator has disabled public write access.
contact
  
#4725
Re:Import csv 1 Year, 9 Months ago Karma: 59
www.com-property.com/downloads/admin.controller.txt
download this file replace .txt to .php
replace your file in
\administrator\components\com_properties\admin.controller.php

in your properties panel click in "Create CSV"
system create file called
\administrator\components\com_properties\properties.csv

you can edit this file

first field is ID of property
if you use ID then property will be updated
if is empty ID system will be create new property.

when finish in your properties panel click in "Import CSV"
test please in test server
administrator
Admin
Posts: 544
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4734
Re:Import csv 1 Year, 9 Months ago Karma: 14
cool i will test this tomorrow and give you a feedback
wulfseidel
i simply love this component :D
Gold Boarder
Posts: 258
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hamburg GER Birthday: 08/28
The administrator has disabled public write access.
contact
  
#4740
Re:Import csv 1 Year, 9 Months ago Karma: 14
testet it

i somehow have to give the com_properties folder 777 to create the first csv ... but i still can turn it off afterwards.

the export createt 2 objekts (of 4) in 1 line

on import, i added 1 line for another objekt. and the new objekt was insertet. but without any information, like title etc..

i will do some further testing this weekend
wulfseidel
i simply love this component :D
Gold Boarder
Posts: 258
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hamburg GER Birthday: 08/28
The administrator has disabled public write access.
contact
  
#4741
Re:Import csv 1 Year, 9 Months ago Karma: 14
to get every entry into one line i changed

line 231

//$linecsv.="\n";

in

$linecsv.="\n";

now every entry (even the one woth no data from the import) is exportet with an one line.



as soon as i have more i will post

actually i should be working for my boss. . .
wulfseidel
i simply love this component :D
Gold Boarder
Posts: 258
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hamburg GER Birthday: 08/28
The administrator has disabled public write access.
contact
  
#4757
Re:Import csv 1 Year, 9 Months ago Karma: 0
please post any update you have
urielt
Junior Boarder
Posts: 30
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4759
Re:Import csv 1 Year, 9 Months ago Karma: 59
download again
www.com-property.com/downloads/admin.controller.txt
administrator
Admin
Posts: 544
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4815
Re:Import csv 1 Year, 8 Months ago Karma: 14
sorry had no time this weekend ,
spent a lot of time in customizing the templates

will test this today.

Tanks a lot
wulfseidel
i simply love this component :D
Gold Boarder
Posts: 258
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hamburg GER Birthday: 08/28
The administrator has disabled public write access.
contact
  
#4829
Re:Import csv 1 Year, 8 Months ago Karma: 14
YOU ARE BEST!!!!

works fine just have to look why in one objekt the description was kickt into several columns (on export), this is propably because there are   codes in the description which causes the export to define new fields ^^

import AND export work fine! thanks a lot you save me a hell of a time
wulfseidel
i simply love this component :D
Gold Boarder
Posts: 258
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hamburg GER Birthday: 08/28
The administrator has disabled public write access.
contact
  
#4830
Re:Import csv 1 Year, 8 Months ago Karma: 59
good!
administrator
Admin
Posts: 544
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4831
Re:Import csv 1 Year, 8 Months ago Karma: 26
administrator wrote:
is a deprecated function, not found, sorryI hope what will be presented in the next update
sigouil
New job => Less time :(
Platinum Boarder
Posts: 411
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: France Birthday: 12/31
The administrator has disabled public write access.
Sorry for my English. It is a Google translation.
 
#4835
Re:Import csv 1 Year, 8 Months ago Karma: 59
yes
administrator
Admin
Posts: 544
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4926
Re:[solved]Import csv 1 Year, 8 Months ago Karma: 0
CANT WAIT TO TEST THIS!! YOU ARE THE BEST ADMIN!!

does this import pics too?
lorenzofp
Expert Boarder
Posts: 116
graphgraph
User Offline Click here to see the profile of this user
lorenzofp lorenzofln@hotmail.com
The administrator has disabled public write access.
Lorenzo Federico Pascucci
Skype: lorenzofp
MSN: lorenzofln@hotmail.com
  
#4927
Re:[solved]Import csv 1 Year, 8 Months ago Karma: 0
i see that the properties.csv has no UTF support, is it possible? i see fields with words like CONCEIÇÃO and this word should be CONCEIÇÃO;

ANY HINT?

thanks as always...
lorenzofp
Expert Boarder
Posts: 116
graphgraph
User Offline Click here to see the profile of this user
lorenzofp lorenzofln@hotmail.com
The administrator has disabled public write access.
Lorenzo Federico Pascucci
Skype: lorenzofp
MSN: lorenzofln@hotmail.com
  
#4928
Re:[solved]Import csv 1 Year, 8 Months ago Karma: 59
for me woek fine, maybe you have problems with excel in windows, use other editor for test
administrator
Admin
Posts: 544
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4934
Re:[solved]Import csv 1 Year, 8 Months ago Karma: 14
i also have no problems with utf8

problem must be somewhere else..

all my german ü, ä & ö are displayed correctly
wulfseidel
i simply love this component :D
Gold Boarder
Posts: 258
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hamburg GER Birthday: 08/28
The administrator has disabled public write access.
contact
  
#4940
Re:[solved]Import csv 1 Year, 8 Months ago Karma: 0
OK I will try to see with other editors. I was using excel 2010 though. I will post results here, and thanks again admin! I LOVE THIS COMPONENT
lorenzofp
Expert Boarder
Posts: 116
graphgraph
User Offline Click here to see the profile of this user
lorenzofp lorenzofln@hotmail.com
The administrator has disabled public write access.
Lorenzo Federico Pascucci
Skype: lorenzofp
MSN: lorenzofln@hotmail.com
  
#7793
Re:[solved]Import csv 1 Year, 5 Months ago Karma: 0
can't wait to try it!!
udrive
Fresh Boarder
Posts: 15
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 12
Com-Property Forum
Component v3
General Discussion
Powered by Kunenaget the latest posts directly to your desktop