- Posts: 70
COMMUNITY FORUM
K2 CSV import tool
- Artur Neumann
- Topic Author
- Offline
- Senior Member
Less
More
14 years 3 weeks ago #83308
by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
oh yea there seems to be some errors in the CSV file
1. use everywhere " as text-separator, you missed it in the first column
2. at the end of the first line there is ," this is to much
test the attached file or the test file from my page: www.individual-it.net/en/Joomla/
You can try to create a table with OpenOffice and save it as a csv, there you can configure all the settings and it normally works fine
1. use everywhere " as text-separator, you missed it in the first column
2. at the end of the first line there is ," this is to much
test the attached file or the test file from my page: www.individual-it.net/en/Joomla/
You can try to create a table with OpenOffice and save it as a csv, there you can configure all the settings and it normally works fine
Please Log in or Create an account to join the conversation.
- Lollo Vestlund
- Offline
- New Member
Less
More
- Posts: 6
14 years 3 weeks ago #83309
by Lollo Vestlund
Replied by Lollo Vestlund on topic K2 CSV import tool
Worked better now, with your changes, thanks
Artur Neumann said:oh yea there seems to be some errors in the CSV file 1. use everywhere " as text-separator, you missed it in the first column
2. at the end of the first line there is ," this is to much
test the attached file or the test file from my page: www.individual-it.net/en/Joomla/
You can try to create a table with OpenOffice and save it as a csv, there you can configure all the settings and it normally works fine
Artur Neumann said:oh yea there seems to be some errors in the CSV file 1. use everywhere " as text-separator, you missed it in the first column
2. at the end of the first line there is ," this is to much
test the attached file or the test file from my page: www.individual-it.net/en/Joomla/
You can try to create a table with OpenOffice and save it as a csv, there you can configure all the settings and it normally works fine
Please Log in or Create an account to join the conversation.
- martinowich
- Offline
- New Member
Less
More
- Posts: 4
13 years 11 months ago #83310
by martinowich
Replied by martinowich on topic K2 CSV import tool
First of, thanks for providing af useful tool for import at a very fair price!
Only thing I'm missing, is a way to import item galleries. I know that K2 utilizes the JW_SIG for galleries and basically copies the images to a folder and then references that folder by a gallery_ID - still it would be great if the import tool supported it somehow :)
I thought I'd drop a few lines about my experience below. I managed to do the import quite easily.
- Save yourself a lot of trouble by using Open Office Calc instead of Excel - the default "CSV - Save as..." in Calc produces the CSV in the exact format required.
- regarding the timeout issue, I managed to extend the timeout settings without altering PHP settings, by adding this piece of code in the "class.upload.php" found in "/administrator/components/com_2k/lib".
Right after the first line"
Only thing I'm missing, is a way to import item galleries. I know that K2 utilizes the JW_SIG for galleries and basically copies the images to a folder and then references that folder by a gallery_ID - still it would be great if the import tool supported it somehow :)
I thought I'd drop a few lines about my experience below. I managed to do the import quite easily.
- Save yourself a lot of trouble by using Open Office Calc instead of Excel - the default "CSV - Save as..." in Calc produces the CSV in the exact format required.
- regarding the timeout issue, I managed to extend the timeout settings without altering PHP settings, by adding this piece of code in the "class.upload.php" found in "/administrator/components/com_2k/lib".
Right after the first line"
Please Log in or Create an account to join the conversation.
- Artur Neumann
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
13 years 11 months ago #83311
by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
I'm glad to hear the tool is useful.
The gallery is a good idea and it's on the wish list.
But its always the lack of money and time. Because of the low income from the import tool I cannot spend to much of my working time to code new features.
But soon there will be a new version. I nice guy paid me to code a possibility to import categories from the CSV.
Follow me on twitter to stay up-to-date: twitter.com/individualit
The gallery is a good idea and it's on the wish list.
But its always the lack of money and time. Because of the low income from the import tool I cannot spend to much of my working time to code new features.
But soon there will be a new version. I nice guy paid me to code a possibility to import categories from the CSV.
Follow me on twitter to stay up-to-date: twitter.com/individualit
Please Log in or Create an account to join the conversation.
- billwide
- Offline
- New Member
Less
More
- Posts: 8
13 years 11 months ago #83312
by billwide
Replied by billwide on topic K2 CSV import tool
[URGENT] How I can define the category of the itens? Or I just import without select a category???
After import I need to define what are the category?
After import I need to define what are the category?
Please Log in or Create an account to join the conversation.
- Artur Neumann
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
13 years 11 months ago #83313
by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
I will publish a new release today or the next week. In this release you can import the categories from the CSV.
I would like to wait before publishing till I got feedback from some testers.
If you could not wail drop me an email: www.individual-it.net/en/kontakt-impressum.html
and I will send the component to you.
I would like to wait before publishing till I got feedback from some testers.
If you could not wail drop me an email: www.individual-it.net/en/kontakt-impressum.html
and I will send the component to you.
Please Log in or Create an account to join the conversation.
- Artur Neumann
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
13 years 11 months ago #83314
by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
Hi,
I just published the new version of the tool (0.5a). Now you can import the categories via CSV. There could be main-categories or sub-categories. If there don't exist there will be created.
So have fun with it: www.individual-it.net/en/Joomla/
Please report bugs and wishes and if you like it vote for is or write a review: extensions.joomla.org/extensions/extension-specific/k2-extensions/12408
this would make me happy and help new users to see the advantage of the tool.
I just published the new version of the tool (0.5a). Now you can import the categories via CSV. There could be main-categories or sub-categories. If there don't exist there will be created.
So have fun with it: www.individual-it.net/en/Joomla/
Please report bugs and wishes and if you like it vote for is or write a review: extensions.joomla.org/extensions/extension-specific/k2-extensions/12408
this would make me happy and help new users to see the advantage of the tool.
Please Log in or Create an account to join the conversation.
- Artur Neumann
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 70
13 years 11 months ago #83315
by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
I'm just working already on next release. One change would be the possibility to import not just the URL of a link but also the "Link text" and the "Open in" field.
Do you have more ideas and wishes? Please post them here or twitter them:
www.twitter.com/home?status=@INDIVIDUALIT:+K2+import+wish
Do you have more ideas and wishes? Please post them here or twitter them:
www.twitter.com/home?status=@INDIVIDUALIT:+K2+import+wish
Please Log in or Create an account to join the conversation.
- Filip
- Offline
- New Member
Less
More
- Posts: 2
13 years 11 months ago #83316
by Filip
Replied by Filip on topic K2 CSV import tool
Hi,
What kind of code you added (and where) to "class.upload.php" to solve timeout issue.
Thanks for help.
Martin Christiansen said:First of, thanks for providing af useful tool for import at a very fair price! Only thing I'm missing, is a way to import item galleries. I know that K2 utilizes the JW_SIG for galleries and basically copies the images to a folder and then references that folder by a gallery_ID - still it would be great if the import tool supported it somehow :)
I thought I'd drop a few lines about my experience below. I managed to do the import quite easily.
- Save yourself a lot of trouble by using Open Office Calc instead of Excel - the default "CSV - Save as..." in Calc produces the CSV in the exact format required.
- regarding the timeout issue, I managed to extend the timeout settings without altering PHP settings, by adding this piece of code in the "class.upload.php" found in "/administrator/components/com_2k/lib".
Right after the first line"
What kind of code you added (and where) to "class.upload.php" to solve timeout issue.
Thanks for help.
Martin Christiansen said:First of, thanks for providing af useful tool for import at a very fair price! Only thing I'm missing, is a way to import item galleries. I know that K2 utilizes the JW_SIG for galleries and basically copies the images to a folder and then references that folder by a gallery_ID - still it would be great if the import tool supported it somehow :)
I thought I'd drop a few lines about my experience below. I managed to do the import quite easily.
- Save yourself a lot of trouble by using Open Office Calc instead of Excel - the default "CSV - Save as..." in Calc produces the CSV in the exact format required.
- regarding the timeout issue, I managed to extend the timeout settings without altering PHP settings, by adding this piece of code in the "class.upload.php" found in "/administrator/components/com_2k/lib".
Right after the first line"
Please Log in or Create an account to join the conversation.
- martinowich
- Offline
- New Member
Less
More
- Posts: 4
13 years 11 months ago #83317
by martinowich
Replied by martinowich on topic K2 CSV import tool
Oh yea.. I see it was left out in my previous comment :)
Right after the first line with the PHP tag, I added a new line with this code: ini_set("max_execution_time", 360);
So basically my first 4 lines look like below. Hope this helps... (remember to add the question mark in the PHP tag in the first line
< php
ini_set("max_execution_time", 360);
/*
// "K2" Component by JoomlaWorks for Joomla! 1.5.x - Version 2.1
Right after the first line with the PHP tag, I added a new line with this code: ini_set("max_execution_time", 360);
So basically my first 4 lines look like below. Hope this helps... (remember to add the question mark in the PHP tag in the first line
< php
ini_set("max_execution_time", 360);
/*
// "K2" Component by JoomlaWorks for Joomla! 1.5.x - Version 2.1
Please Log in or Create an account to join the conversation.