- Posts: 70
COMMUNITY FORUM
K2 CSV import tool
- Artur Neumann
-
Topic Author
- Offline
- Senior Member
Please Log in or Create an account to join the conversation.
- Artur Neumann
-
Topic Author
- Offline
- Senior Member
- Posts: 70
Now its possible to import the userIDs and attachments.
Please Log in or Create an account to join the conversation.
- william white
-
- Offline
- Platinum Member
- Posts: 3722
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.
- Next Wave, Inc.
-
- Offline
- Junior Member
- Posts: 30
Please Log in or Create an account to join the conversation.
- Artur Neumann
-
Topic Author
- Offline
- Senior Member
- Posts: 70
Please Log in or Create an account to join the conversation.
- william white
-
- Offline
- Platinum Member
- Posts: 3722
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
-
Topic Author
- Offline
- Senior Member
- Posts: 70
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.
- Lollo Vestlund
-
- Offline
- New Member
- Posts: 6
Kindly
Lollo
Please Log in or Create an account to join the conversation.
- Artur Neumann
-
Topic Author
- Offline
- Senior Member
- Posts: 70
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.
- Lollo Vestlund
-
- Offline
- New Member
- Posts: 6
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?
Please Log in or Create an account to join the conversation.
- Artur Neumann
-
Topic Author
- Offline
- Senior Member
- Posts: 70
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
- Posts: 6
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
- Posts: 4
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
- Posts: 70
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
- Posts: 8
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
- Posts: 70
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
- Posts: 70
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
- Posts: 70
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
- Posts: 2
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
- Posts: 4
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.