- Posts: 3
COMMUNITY FORUM
Tool for importing / exporting items to / from K2
- Daniel Pulido
-
- Offline
- New Member
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
If you cannot download it please drop me an email in my contact form www.individual-it.net/en/kontakt-impressum.html
Please Log in or Create an account to join the conversation.
- Daniel Pulido
-
- Offline
- New Member
- Posts: 3
any suggestion?
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
If I cannot find the mistake there, it would be good it you send me the joomla admin details so I can debug on your host.
Please Log in or Create an account to join the conversation.
- Peter
-
- Offline
- New Member
- Posts: 19
importing items, please stand by
items were successful imported
Row: 10 / memory peak: 13.5 MB
importing items, please stand by
items were imported, but with some problems:
cannot open file: C:\xampp\htdocs\onthego/tmp\
Row: undefined / memory peak: 7.75 MB
Import finished
I tried increasing the memory_limit in xampp's php.ini file from 648MB to 1648MB and restarting Apache and MySQL, but it still fails at the same spot (row 10). It works fine if I split up my spreadsheet, but who wants to do that? ;)
Any ideas on how I can fix this?
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
this is strange if he finds the file ones and then not again.
please check first your joomla settings for the tmp directory C:\xampp\htdocs\onthego/tmp\ lools strange should ne C:\xampp\htdocs\onthego\tmp\
And then tell me the version of the extension you are using - see first post. and send me the CSV file
What you always can do is increase the number of rows that are imported in one go, but this will not solve the real problem
Please Log in or Create an account to join the conversation.
- Nick
-
- Offline
- Elite Member
- Posts: 190
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
does the export of less categories work? If yes you probably running in limitations of your server max_execution_time or memory_limit
Please Log in or Create an account to join the conversation.
- Nick
-
- Offline
- Elite Member
- Posts: 190
Please Log in or Create an account to join the conversation.
- Nick
-
- Offline
- Elite Member
- Posts: 190
I tried going through your code but its going to take a while to understand it.
Can't you just split up the queries and do just 100 each time? I have 3000+ items..
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
a loop that exports just 100 items would be possible but I would have to change a lot in the background.
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
I think I found the source of our problem.
fgetcsv is not really binary save, it depends on the environment variable LANG, I cannot predict it and not set it inside of joomla.
www.php.net/manual/en/function.fgetcsv.php
"Locale setting is taken into account by this function. If LANG is e.g. en_US.UTF-8, files in one-byte encoding are read wrong by this function. "
This means I need an own csv import function.
I will fix this problem, but it might take a while.
Please Log in or Create an account to join the conversation.
- emakki
-
- Offline
- New Member
- Posts: 3
Individual IT wrote: @All who have problems with international characters,
I think I found the source of our problem.
fgetcsv is not really binary save, it depends on the environment variable LANG, I cannot predict it and not set it inside of joomla.
www.php.net/manual/en/function.fgetcsv.php
"Locale setting is taken into account by this function. If LANG is e.g. en_US.UTF-8, files in one-byte encoding are read wrong by this function. "
This means I need an own csv import function.
I will fix this problem, but it might take a while.
Please put in mind JSon does not convert UTF characters. I faced this issue in Arabic when I installed a k2 article submit component (I thinks it is something Story). I used your import script and it really saves tons of time. However, it imports all characters except Arabic.
I would really be happy if this issue is resolved for all international users. Keep up the good work.
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
As I was to lazy to write an own one I've stolen it from: thuejk.blogspot.com/2010/01/phps-implementation-of-fgetcsv-and.html
This is the best csv parsing function I could find and it seems to work very well. I have positive feedback with Greek and Cyrillic items, so I hope all UTF8 characters should work fine now.
I also changes the peace of code that generates the alias, now the original code of K2 is used. Its more complex but it should work with the whole UTF8 range.
So have fun with the new version: extensions.joomla.org/extensions/extension-specific/k2-extensions/12408 and don't forget to rate it at
The Joomla! Extensions Directory if you like it.
As this forum has no RSS and no email notification in the case of a problem it might be faster to write me an email: www.individual-it.net/en/kontakt-impressum.htm or a twitter messege: twitter.com/individualit.
For people who didn't use the extension before here some pics:
Please Log in or Create an account to join the conversation.
- Guy Fraenkel
-
- Offline
- New Member
- Posts: 2
i have just purchased the tool and i want to do the following:
Import all K2 stuff from my old Joomla 1.5 (running latest K2) to my new Joomla 2.5 (running latest K2).
I install the component on both systems, they run on the same server (/ and /25/). When i export in the 1.5 i get a 5mb file. When i try to import this file in 2.5, all seems to be ok, but when i want to assosiate the rows the image (path to image) value is missing. What can i do about this? How can i fix it?
Thank you very much,
greets
Please Log in or Create an account to join the conversation.
- Guy Fraenkel
-
- Offline
- New Member
- Posts: 2
greets
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
The export does not export the image, but you still can import images but you would have to do this manually.
But if you are using the same K2 version in both joomla installations, try just to copy the MySQL tables via phpmyadmin
Please Log in or Create an account to join the conversation.
- Sanjiv Khullar
-
- Offline
- Senior Member
- Posts: 45
JFile: :copy: Cannot find or read file: $/home/film/public_html.
Unknown Archive type
Warning: strstr() [function.strstr]: Empty delimiter in /home/film/public_html/administrator/components/com_k2import/controller.php on line 890
Please advise
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
could you please tell me what joomla and PHP version do you use and when exactly this error occurs?
do you try to upload a ZIP file?
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
this version fixes some problems when exporting extra-field names or content with special characters line " or '
JED page
direct download
Ask questions and get support on twitter
Please Log in or Create an account to join the conversation.