Keyword

K2 CSV import tool

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
14 years 9 months ago #83298 by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
No, K2Store support is not implemented, maybe It could be a feature in the future

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

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
14 years 9 months ago #83299 by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
A new version (0.4) is online bit.ly/992Ivh
Now its possible to import the userIDs and attachments.

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

More
14 years 9 months ago #83300 by william white
Replied by william white on topic K2 CSV import tool
Good, Keep them coming
Can your routines export and then reimport into articles?
Ive seen several posts about this

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

More
14 years 9 months ago #83301 by Next Wave, Inc.
Replied by Next Wave, Inc. on topic K2 CSV import tool
People interested in this might also like www.freakedout.de/joomlaextensions/content-uploader-pro.html - it uses Excel files directly, and allows updating existing items by passing in the item id.

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

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
14 years 9 months ago #83302 by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
Export is not possible with the component, just import. Or do you know an K2 export tool?

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

More
14 years 9 months ago #83303 by william white
Replied by william white on topic K2 CSV import tool
I have read about the above link, www.freakedout.de/joomlaextensions/content-uploader.html
but do not know if it will export. I figure that it would work if you used phpmyadmin and created a xls from the table and then used it to put either articles or items - untested
I think the same thing would work with your import tool, for K2 items, correct me if im wrong

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

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
14 years 9 months ago #83304 by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
The freakedout solution (the pro version) seems to be more powerfull than mine. I'm not sure if they can import images and attachments but it looks like they did a nice work!

You can use the CSV Export from phpmyadmin if you want to export the data for my extension.
Just go to the jos_k2_items table klick on "export", choose CSV and theese options:
Fields terminated by: ;
Fields enclosed by: "
Fields escaped by:
Lines terminated by: AUTO
Replace NULL by: NULL

and check "Put fields names in the first row"
Then you have an export of the fields, witch you could import again.

If you also need to export the extrafields you will need an more complicated SQL statement, but it should also work.

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

More
14 years 8 months ago #83305 by Lollo Vestlund
Replied by Lollo Vestlund on topic K2 CSV import tool
I just downloaded your nice tool. I am trying it with a test file, try to follow the instructions, and get a success message after the import, but no data seem to be uploaded. What can I do wrong?
Kindly
Lollo

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

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
14 years 8 months ago #83306 by Artur Neumann
Replied by Artur Neumann on topic K2 CSV import tool
Hi lollo,
check if you have the permission to write into the joomla-tmp file

what versions of PHP, Joomla and K2 do you use?

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

More
14 years 8 months ago #83307 by Lollo Vestlund
Replied by Lollo Vestlund on topic K2 CSV import tool
The permissions to tmp is 777
PHP version 5.2.13
Joomla 1.5.20
and K2 v2.3
Uploaded my small test file, maybe I make some mistake there
Thanks Lollo


Artur Neumann said:Hi lollo, check if you have the permission to write into the joomla-tmp file

what versions of PHP, Joomla and K2 do you use?
Attachments:

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

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