Keyword

K2 CSV import tool

  • Artur Neumann
  • Artur Neumann's Avatar Topic Author
  • Offline
  • Senior Member
More
14 years 2 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 1 month 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 4 weeks 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 4 weeks 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 4 weeks 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.


Powered by Kunena Forum