Keyword

K2 CSV import tool

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
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

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.

More
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"

Please Log in or Create an account to join the conversation.

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
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

Please Log in or Create an account to join the conversation.

More
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?

Please Log in or Create an account to join the conversation.

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
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.

Please Log in or Create an account to join the conversation.

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
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.

Please Log in or Create an account to join the conversation.

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
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

Please Log in or Create an account to join the conversation.

More
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"

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum