- Posts: 3
COMMUNITY FORUM
K2 CSV import tool
- Thanos
- Offline
- New Member
Less
More
13 years 9 months ago #83338
by Thanos
Replied by Thanos on topic K2 CSV import tool
Hi,
I just installed the component, i tried the import with example.csv and it works.
But if I press export nothing happens, i get a blank screen. I tried with selecting a file (in case this was needed) and then press Export, I get again blank screen. Why is that?
In the component page, I get only a text field to select file and the import/export button. is this normal?
Thanks
I just installed the component, i tried the import with example.csv and it works.
But if I press export nothing happens, i get a blank screen. I tried with selecting a file (in case this was needed) and then press Export, I get again blank screen. Why is that?
In the component page, I get only a text field to select file and the import/export button. is this normal?
Thanks
Please Log in or Create an account to join the conversation.
- Thanos
- Offline
- New Member
Less
More
- Posts: 3
13 years 9 months ago #83339
by Thanos
Replied by Thanos on topic K2 CSV import tool
About my last post above. I turned error reporting to maximum and here's the error I get
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 5918721 bytes) in /Applications/MAMP/htdocs/xxxxxxx/administrator/components/com_k2import/views/export/tmpl/default.php on line 111
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 5918721 bytes) in /Applications/MAMP/htdocs/xxxxxxx/administrator/components/com_k2import/views/export/tmpl/default.php on line 111
Please Log in or Create an account to join the conversation.
- Artur Neumann
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
13 years 9 months ago #83340
by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
The component page you describe is 100% OK.
And at the moment there is no selective sync, all items from K2 are exported.
Your only problem seems to be to less allowed memory for a big export.
If you have the possiblity to access your php.ini you can change the line that looks like this:
memory_limit = 32M
try to set it e.g to 64M
If you don't have access to the php.ini edit the file administrator/components/com_k2import/k2import.php and insert this line in the function export() about line 555
ini_set('memory_limit', '32M');
And at the moment there is no selective sync, all items from K2 are exported.
Your only problem seems to be to less allowed memory for a big export.
If you have the possiblity to access your php.ini you can change the line that looks like this:
memory_limit = 32M
try to set it e.g to 64M
If you don't have access to the php.ini edit the file administrator/components/com_k2import/k2import.php and insert this line in the function export() about line 555
ini_set('memory_limit', '32M');
Please Log in or Create an account to join the conversation.
- shani
- Offline
- New Member
Less
More
- Posts: 3
13 years 9 months ago #83341
by shani
Replied by shani on topic K2 CSV import tool
Hello Artur,
I'm wonder if it possible, through your tool, to import data to certain extra field (not item):
I just want to make Countries field with all the Countries in the world, and there is no way I would go country by country manually (and then state by state..)
I want to import form my CSV all the data (in this case Countries..)
Thanks.
I'm wonder if it possible, through your tool, to import data to certain extra field (not item):
I just want to make Countries field with all the Countries in the world, and there is no way I would go country by country manually (and then state by state..)
I want to import form my CSV all the data (in this case Countries..)
Thanks.
Please Log in or Create an account to join the conversation.
- Artur Neumann
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
13 years 9 months ago #83342
by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
Hi shani,
this is not possible at the moment.
But if this is just a one-time job I could write a small script that generates a SQL statement from the CSV.
Please write a short email and then I could tell you how much it would cost.
this is not possible at the moment.
But if this is just a one-time job I could write a small script that generates a SQL statement from the CSV.
Please write a short email and then I could tell you how much it would cost.
Please Log in or Create an account to join the conversation.
- Artur Neumann
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
13 years 8 months ago #83343
by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
At the moment I'm working on an export from Wordpress and import to K2. Of course I do the import with my Import tool. Because I needed some more features for this job I implemented them. The actual beta has till now three new features:
support for the trash fieldyou can import items that are set automatically to "trashed" - I'm sure there are just very few people who need that :-)
support for user comments
automatically association of fieldsif the columns in the CSV and the fields has the same name they are associated automatically. e.g. name your columns in the CSV.e.g. "Title","Introtext","Fulltext","Tags","Published","Created","User ID","Meta Description","Meta Keywords","Trash","Comments","Image","Image caption","Image credits","Images for the Gallery","Attachment0","Attachment title0","Attachment1","Attachment title1"
If you buy the actual stable the beta is included: K2 Import / Export Tool
P.S. I included a update-support on my site. For every EUR you pay you can download updates for 10 days. So if you pay e.g. 3EUR you can download every update for one month.
support for the trash fieldyou can import items that are set automatically to "trashed" - I'm sure there are just very few people who need that :-)
support for user comments
automatically association of fieldsif the columns in the CSV and the fields has the same name they are associated automatically. e.g. name your columns in the CSV.e.g. "Title","Introtext","Fulltext","Tags","Published","Created","User ID","Meta Description","Meta Keywords","Trash","Comments","Image","Image caption","Image credits","Images for the Gallery","Attachment0","Attachment title0","Attachment1","Attachment title1"
If you buy the actual stable the beta is included: K2 Import / Export Tool
P.S. I included a update-support on my site. For every EUR you pay you can download updates for 10 days. So if you pay e.g. 3EUR you can download every update for one month.
Please Log in or Create an account to join the conversation.
- odeh.quraan
- Offline
- New Member
Less
More
- Posts: 5
13 years 8 months ago #83344
by odeh.quraan
Replied by odeh.quraan on topic K2 CSV import tool
Hi Artus,
I purchased this tool, I installed it, when I import i get everything successful. But when I check in K2 items there is no changes, I tested it heavily for more than 10 hours, on localhost and on live server.
I exported the k2 items, change the csv file and re-uploaded it and nothing changes.
I notice that when I export, the csv file that i get does not have a column for "Image" path!! Also I expoted the k2_items table from PhpMyAdmin as a csv and also there is no "Image" field!! Is this the normal case or I do have problems with my installation??
I use Joomla 1.5.22 with K2 2.4.1.
Please help
Thanks
I purchased this tool, I installed it, when I import i get everything successful. But when I check in K2 items there is no changes, I tested it heavily for more than 10 hours, on localhost and on live server.
I exported the k2 items, change the csv file and re-uploaded it and nothing changes.
I notice that when I export, the csv file that i get does not have a column for "Image" path!! Also I expoted the k2_items table from PhpMyAdmin as a csv and also there is no "Image" field!! Is this the normal case or I do have problems with my installation??
I use Joomla 1.5.22 with K2 2.4.1.
Please help
Thanks
Please Log in or Create an account to join the conversation.
- Artur Neumann
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
13 years 8 months ago #83345
by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
Hi,
what version of the import tool do you use? Please try the actual 0.7_beta2 www.individual-it.net/en/Joomla/#27
You should be able to download it for free with the link you got after payment.
And did you check the "overwrite" box when trying to import again? The overwrite function overwrites existing items with the items from CSV which have the same name
odeh.quraan said:
Hi Artus,
I purchased this tool, I installed it, when I import i get everything successful. But when I check in K2 items there is no changes, I tested it heavily for more than 10 hours, on localhost and on live server.
I exported the k2 items, change the csv file and re-uploaded it and nothing changes.
I notice that when I export, the csv file that i get does not have a column for "Image" path!! Also I expoted the k2_items table from PhpMyAdmin as a csv and also there is no "Image" field!! Is this the normal case or I do have problems with my installation??
I use Joomla 1.5.22 with K2 2.4.1.
Please help
Thanks
what version of the import tool do you use? Please try the actual 0.7_beta2 www.individual-it.net/en/Joomla/#27
You should be able to download it for free with the link you got after payment.
And did you check the "overwrite" box when trying to import again? The overwrite function overwrites existing items with the items from CSV which have the same name
odeh.quraan said:
Hi Artus,
I purchased this tool, I installed it, when I import i get everything successful. But when I check in K2 items there is no changes, I tested it heavily for more than 10 hours, on localhost and on live server.
I exported the k2 items, change the csv file and re-uploaded it and nothing changes.
I notice that when I export, the csv file that i get does not have a column for "Image" path!! Also I expoted the k2_items table from PhpMyAdmin as a csv and also there is no "Image" field!! Is this the normal case or I do have problems with my installation??
I use Joomla 1.5.22 with K2 2.4.1.
Please help
Thanks
Please Log in or Create an account to join the conversation.
- odeh.quraan
- Offline
- New Member
Less
More
- Posts: 5
13 years 8 months ago #83346
by odeh.quraan
Replied by odeh.quraan on topic K2 CSV import tool
Hi Artur,
Thanks for the quick reply.
I was using version 0.6a stable.
I installed version 0.7_beta2, after I upload the csv file, i follow the steps, when i get to this step "
importing items, please stand by"
I get "Error" and nothing is added to the items!
Artur Neumann said:
Hi,
what version of the import tool do you use? Please try the actual 0.7_beta2 www.individual-it.net/en/Joomla/#27
You should be able to download it for free with the link you got after payment.
And did you check the "overwrite" box when trying to import again? The overwrite function overwrites existing items with the items from CSV which have the same name
odeh.quraan said:
Hi Artus, I purchased this tool, I installed it, when I import i get everything successful. But when I check in K2 items there is no changes, I tested it heavily for more than 10 hours, on localhost and on live server.
I exported the k2 items, change the csv file and re-uploaded it and nothing changes.
I notice that when I export, the csv file that i get does not have a column for "Image" path!! Also I expoted the k2_items table from PhpMyAdmin as a csv and also there is no "Image" field!! Is this the normal case or I do have problems with my installation??
I use Joomla 1.5.22 with K2 2.4.1.
Please help
Thanks
Thanks for the quick reply.
I was using version 0.6a stable.
I installed version 0.7_beta2, after I upload the csv file, i follow the steps, when i get to this step "
importing items, please stand by"
I get "Error" and nothing is added to the items!
Artur Neumann said:
Hi,
what version of the import tool do you use? Please try the actual 0.7_beta2 www.individual-it.net/en/Joomla/#27
You should be able to download it for free with the link you got after payment.
And did you check the "overwrite" box when trying to import again? The overwrite function overwrites existing items with the items from CSV which have the same name
odeh.quraan said:
Hi Artus, I purchased this tool, I installed it, when I import i get everything successful. But when I check in K2 items there is no changes, I tested it heavily for more than 10 hours, on localhost and on live server.
I exported the k2 items, change the csv file and re-uploaded it and nothing changes.
I notice that when I export, the csv file that i get does not have a column for "Image" path!! Also I expoted the k2_items table from PhpMyAdmin as a csv and also there is no "Image" field!! Is this the normal case or I do have problems with my installation??
I use Joomla 1.5.22 with K2 2.4.1.
Please help
Thanks
Please Log in or Create an account to join the conversation.
- Artur Neumann
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
13 years 8 months ago #83347
by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
Could you provide me an admin access to your joomla instance, so I could debug on your server?
Send me an mail via my contact formular
Please backup everything before.
Send me an mail via my contact formular
Please backup everything before.
Please Log in or Create an account to join the conversation.