- Posts: 4
COMMUNITY FORUM
Tool for importing / exporting items to / from K2
- Saifullah Sammo
-
- Offline
- New Member
I am using k2 import component for importing English and Turkish article by Csv format.
but getting a lots of error.
Joomla! 3.3.1 Stable [ Ember ]
K2 Version 2.6.8
some of them are:
Strict Standards: Declaration of K2importController::display() should be compatible with JControllerLegacy::display($cachable = false, $urlparams = Array) in /home/minaretr/public_html/administrator/components/com_k2import/controller.php on line 23
Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/k2import.php on line 29
Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/k2import.php on line 30
Strict Standards: Non-static method k2importToolbarHelper::upload() should not be called statically, assuming $this from incompatible context in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 28
Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/helper.php on line 14
Strict Standards: Non-static method k2importToolbarHelper::export() should not be called statically, assuming $this from incompatible context in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 30
Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/helper.php on line 24
Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 34
Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 56
Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 57
Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 144
Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/models/category.php on line 133
Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/tmpl/default.php on line 14
Even though i am using the sample csv file format from www.individual-it.net/en/Instructions-fo...mport-Component.html here.
what should i do??
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
Please Log in or Create an account to join the conversation.
- Saifullah Sammo
-
- Offline
- New Member
- Posts: 4
It works fine English Content. But there are some Turkish character which are like Ğ Ç Ş Ü İ , and this characters can not be imported with this component. Now what to do?
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
Please Log in or Create an account to join the conversation.
- Saifullah Sammo
-
- Offline
- New Member
- Posts: 4
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
Please Log in or Create an account to join the conversation.
- Marco Cevoli
-
- Offline
- New Member
- Posts: 10
I've exported a category with 6 items, made some modifications and tried to import the file, but I get this error:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 80 bytes) in /home/servername/public_html/libraries/legacy/exception/exception.php on line 130
Any ideas?
Thanks a lot
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
you will have to increase the memory_limit in your php.ini
Please Log in or Create an account to join the conversation.
- kelvin
-
- Offline
- New Member
- Posts: 5
row: 1 there is no user with the ID: 62 I'm using the ID:411
row: 1 - save item -
could not find item to overwrite I will create a new one. WHERE clause: title = 'Music | D-Eye - Caro [@Yungboy_D_Eye]' AND `catid` ='3'
row: 1 - save image - Local file doesn't exist. /home/content/93/9888393/html/media/k2/items/src/73d7edd1405081e5433c41d9ad2ee18c.jpg
row: 2 there is no user with the ID: 62 I'm using the ID:411
row: 2 - save image - Local file doesn't exist. /home/content/93/9888393/html/media/k2/items/src/ce93b7c97ea8831859bbe17c36b83648.jpg
row: 3 there is no user with the ID: 62 I'm using the ID:411
row: 3 - save item -
After which the exported category that had 197 items on the old site now has just only 9 items on the new site after importing. what happened to the remaining items and why are images not imported.
How do i export and import the complete amount of items that was in the category?
How do i export and import the images for all the items belonging to that category?
Please Log in or Create an account to join the conversation.
- JoomlaWorks
-
- Offline
- Admin
- Posts: 6225
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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
Did you select the option to overwrite items. If you did so then maybe some items are overwritten.
The export of images only exports the path. you have to transfer the images yourself to the new server and give its path in the CSV file.
the "path to an image" can be the path to an existing file on your server, starting from the joomla-root e.g. images/stories/pastarchives.jpg
Please check also the documentation:
www.individual-it.net/en/Instructions-for-K2-Import-Component.html
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
yes I'm glad its used a lot.
Do you mean that I should install a forum on my own domain? If possible I would prefer to stay on getk2.org. It's simply just less work for me.
Please Log in or Create an account to join the conversation.
- JoomlaWorks
-
- Offline
- Admin
- Posts: 6225
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- kelvin
-
- Offline
- New Member
- Posts: 5
Individual IT wrote: Hi kelvin.
Did you select the option to overwrite items. If you did so then maybe some items are overwritten.
The export of images only exports the path. you have to transfer the images yourself to the new server and give its path in the CSV file.
the "path to an image" can be the path to an existing file on your server, starting from the joomla-root e.g. images/stories/pastarchives.jpg
Please check also the documentation:
www.individual-it.net/en/Instructions-for-K2-Import-Component.html
I did not select the option to overwrite items. i worked with the default settings. i have tried to export and import the category again and am still getting the same result.
I also noticed that the category imported does not appear in the category tab.
this is very urgent as am under pressure from my client.
[Solved] Eventually i was able to find a way around this issue. I increased the "Import Rows Per Loop" from 10 to 500. this way i was able to import all my 197 items without issues. This was done on the test website i had installed on my laptop. I am yet to try this on the Live site, this may be an issue based on PHP max_execution_time. But am thinking if the Live site can handle it then its ok, if not then i can import 10-15 rows per loop and then continue by using "Start num row" to import 10 - 15 rows at a time. If there is any other way to make this easier for me i would appreciate it.
I hope this would help someone out there.
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 it works with 500rows in one go it should work with less.
can you post your CSV file?
Please Log in or Create an account to join the conversation.
- kelvin
-
- Offline
- New Member
- Posts: 5
Individual IT wrote: I'm happy to hear its working but its still strange.
If it works with 500rows in one go it should work with less.
can you post your CSV file?
been working on this for days now.. need help desperately, i have backed up my images from /media/k2/items/src. and copied them to my localhost on my laptop, when ever i edit the image column of the exported .csv file to point to the new image location, i get an endless looping and eventually the import page stops to load, i dont get to see a success on import page, but when i check k2 i see my items, also after creating a menu link to the category i get this error message on the frontpage;
An error has occurred.
The requested page cannot be found.
Home Page
If difficulties persist, please contact the System Administrator of this site and report the error below.
#403 You are not authorized to view this resource
here is the link to the export CSV file.
Pressplay360.opendrive.com/files/OF80ODUyNTMzMl9qNGxSeF85OTI4/Hype.zip
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
please try not to place the images into the same folder as on the source system. Place them into the tmp folder of joomla and in the CSV file give the path starting from the joomla root without leading slash.
Please check also the documentation www.individual-it.net/en/Instructions-for-K2-Import-Component.html
Afterwards please report if you still have problems.
Please Log in or Create an account to join the conversation.
- kelvin
-
- Offline
- New Member
- Posts: 5
Thanks a lot. I finally got it working, after i created a menu item for the imported category i noticed my imported items were not showing, i noticed that access level was set to 0 on the CSV file so i changed a few access level on some k2 items in the k2 component and the few i changed showed up on the front page with out issues.Individual IT wrote: Hi,
please try not to place the images into the same folder as on the source system. Place them into the tmp folder of joomla and in the CSV file give the path starting from the joomla root without leading slash.
Please check also the documentation www.individual-it.net/en/Instructions-for-K2-Import-Component.html
Afterwards please report if you still have problems.
My Question! when editing my other CSV files, in the access level column what value should i set for public access instead of the 0 value? thanks for your patience am almost done!
Solved! i simply changed the value from 0 to 1 in all my exported CSV files. that way they become public on the frontend. This is one plugin i enjoyed working with. thanks!
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 values do correspond directly to the values in the database.
If you like the extension a comment or rating at JED would be great
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
2.1 for Joomla 3.x
changes:
- small bugfixes
- better date checks
- import/export Hints + Item Parameters
1.3 for Joomla 1.5 - 2.x
changes:
- small bugfixes
- better date checks
- works better with K2 2.6.8 , actually K2 2.6.8 is now required. If you are using an older version of K2 please make an update of K2
As always: If you recently bought the extension please check the link you received after payment, it might be still valid (for every EURO you pay you get 10 days of free download)
Have fun: K2 Import/Export tool
Please Log in or Create an account to join the conversation.