Keyword

Tool for importing / exporting items to / from K2

More
12 years 1 month ago #58780 by mikexcite
Hi,

This is a great utility and I have tried to follow the instructions very carefully. Everything works except I am having the same problem a couple other users reported, that K2 import is putting something strange in the "start publishing" field:

-0001-11-30 00:00:00

Which is stopping the items from appearing. I thought it might be that I was using templates, so I actually made a fresh install of Joomla and K2 just to test this, but it is still giving me the issue. The time zone is set to UTC.

The file that I am trying to upload is attached. I will PM my testing site and super user details. Thanks.

I am just at a loss.

M

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

More
12 years 1 month ago #58781 by mikexcite
About the previous issue, the solution I found was to create a column and force something to go in to the "Publish Up" field. This will then put something in that field instead of the bad text.

You must be extremely careful that whatever spreadsheet program you use (and libreoffice does handle it better than excel - i chased that problem for at least an hour) does not make the field into a date field with a different format. Go into cell formatting and override the cells to be text fields, and make sure the date is entered exactly YYYY-MM-DD HH:MM:SS or it will not work. I don't know if specifying a date field to use that format would work.

Disappointed in this bug, because as far as I can tell I followed the instructions perfectly, but still a useful product at a reasonable price.

Mike

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

More
12 years 1 month ago #58782 by stavroch
The file that I am trying to upload is 8MB and it has 10.000 items but I get error message while I am trying to upload it.

How can I upload that items?

Also how the images are imported to k2 items?

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

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
12 years 4 weeks ago #58783 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Sorry I was on holidays when you wrote your messages.

@mikexcite How would you like the extension to react on wrong formated date. I'm happy to implement good suggestions.

@stavros What an error do you get?
Images can be imported by the full path. Check the Instruction for that: www.individual-it.net/Instructions-for-K2-Import-Component.html

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

More
12 years 4 weeks ago #58784 by stavroch
I install the new versions of k2 import component and everything works fine.

Thank u ;)

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

  • Tom Miller
  • Tom Miller's Avatar
  • Offline
  • New Member
  • 360 onDemand Solutions Group
More
12 years 3 days ago - 12 years 3 days ago #58785 by Tom Miller
Using Joomla 2.5.8 with K2 2.6.5 with 0.9a and the issue with newly imported items not showing UNLESS you edit+save is the LANGUAGE field. Imports as blank and needs the ' * ' (star, shift + # eight).



Is there a quick fix for this? Working great besides this!

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

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
12 years 1 day ago #58786 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Soory at the moment this tool is just tested with k2 2.5 and 2.6

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

More
11 years 11 months ago #58787 by Diana Myers
I'm testing the export from Joomla 1.5.26 locally (xammp) into a clean install of Joomla 2.5.9 and I keep getting a "403 - You are not authorized to view this resource error" when I create a menu item with K2 categories. I changed the "Access" column from 0 to 1, but it didn't solve the problem. What's causing this issue and how can I fix it? Working on a client site and need an answer as soon as possible.

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

More
11 years 11 months ago #58788 by Balázs Dániel
Replied by Balázs Dániel on topic Re: Tool for importing / exporting items to / from K2
Hi All!

I need priority support for this extension. I'd like to use it daily to update my k2 items/products.

My problem: There is few hundred items in my database and I'd like to update only few extrafields of them daily. The current version of the import tool set the value of non-existing fields (in csv) to default. I need it to leave the current value in database of non-existing fields and update only the fields that exists in csv file.

Sorry for my english, I hope it's understandable.

I can pay for this modification. Best regards

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

More
11 years 11 months ago #58789 by Johnno
Hi there,

I am trying to export approx. 180 items from K2 on Joomla 1.5 install to K2 on Joomla 3.0 install. Any idea when this component will be 3.0 compatible? I really hope I didn't waste my money on this.

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

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 11 months ago - 11 years 11 months ago #58790 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
@Balázs Dániel - Sorry I don't understand you. Do you just need to change the default setting of the checkbox?

@Johnno The component is not Joomla 3.0 redy yet and I cannot tell you when it will

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

More
11 years 11 months ago #58791 by Sanjiv Khullar
Replied by Sanjiv Khullar on topic Re: Tool for importing / exporting items to / from K2
I would be happy to donate towards updating your import tool to joomla 3.0
It is definitely needed

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

  • Thomas Hickinbottom
  • Thomas Hickinbottom's Avatar
  • Offline
  • New Member
More
11 years 10 months ago #58792 by Thomas Hickinbottom
Replied by Thomas Hickinbottom on topic Re: Tool for importing / exporting items to / from K2
I too would be willing to donate towards this plugin becoming Joomla 3.0 compatible.

It would be also be great if it could support the popular "Additional Categories for K2" plugin.

Would this be feasible?

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

More
11 years 10 months ago #58793 by Jesus
Hi!

This is a great tool!

I have bought it some days ago and it's working perfectly.

Just one question, it is posible to import videos from local storage? How can I do that?

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

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 10 months ago #58794 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
sorry but that is just possible with images

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

More
11 years 10 months ago #58795 by Mike

Individual IT wrote: first create the extra field in K2, associate it with a group and greate 2 or 3 items in this group with the different possible extra field values.
The make an export with the k2 import / export tool and you have an example file you can work with,



hi! where exactly is the example file?
i am trying to export k2 items from joomla 1.5x and then import them to 2.5.x

items description are in greek and during the export the fonts do not came up well. can you pls assist me?

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

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 10 months ago #58796 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
I mean you can use the file you exported as an example.
What you mean by "the fonts do not come out well"?
The export is a text file, so if you have formated the fonts by HTML they will not look the same in the text file. And after import all the HTML code is imported but the formating also depends on the CSS and other formats on your page

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

More
11 years 10 months ago #58797 by Mike
As mentioned elsewhere when opening the exported csv in Excel it does not handle well non-english based languages. i found out a solution by opening first an empty excel file and then importing the csv instead of opening it directly.

i wanted to concatenate the item details as each one had different entries / info. for example in one item you might have values for the following fields:

Title Alias Introtext Fulltext Tags Published Created User ID Category Name Category Description

and for another

Title Alias Introtext Fulltext Tags Published Created User ID Category Name Category Description Length Width Height Cockpit Weight Load

with the last entries applying to extra fields.

q1: the end of each item is denoted by 2 commas ?
q2: in the guidelines you say that : text-fields must be enclosed within double-quote characters => ", what do you mean? in the export file i see every field enclosed like this "field"
q3: when i export the image path is not captured. why? how can i fix this so that to avoid manual update of images for each item?
q4: can i upload price as an extra field and then associate it to kmart price field?

thank you for your support!

Individual IT wrote: I mean you can use the file you exported as an example.
What you mean by "the fonts do not come out well"?
The export is a text file, so if you have formated the fonts by HTML they will not look the same in the text file. And after import all the HTML code is imported but the formating also depends on the CSS and other formats on your page

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

More
11 years 10 months ago #58798 by Sanjiv Khullar
Replied by Sanjiv Khullar on topic Re: importing k2 items joomla 3
I need to import k2 items into joomla 3 - and it seems this component is not ready for that - is there another way to import - ie - via php admin ?

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

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 10 months ago #58799 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2

Mike wrote: As mentioned elsewhere when opening the exported csv in Excel it does not handle well non-english based languages. i found out a solution by opening first an empty excel file and then importing the csv instead of opening it directly.

Try to use LibreOffice its copes much better with CSV files

Mike wrote: q1: the end of each item is denoted by 2 commas ?

no it should be one comma. But in case of an empty field you get 2. e.g. if there is no alias it looks like:
Mike wrote: q2: in the guidelines you say that : text-fields must be enclosed within double-quote characters => ", what do you mean? in the export file i see every field enclosed like this "field"

Thats exactly what I mean, sorry for my bad english. if you have an idea how to explain it better, please tell me.

Mike wrote: q3: when i export the image path is not captured. why? how can i fix this so that to avoid manual update of images for each item?

Image export is not supported because of the ay K2 stores the images

Mike wrote: q4: can i upload price as an extra field and then associate it to kmart price field?

You can upload it as an extra field, but I never tried touse it as a kmart filed.
thank you for your support!

Individual IT wrote: I mean you can use the file you exported as an example.What you mean by "the fonts do not come out well"?
The export is a text file, so if you have formated the fonts by HTML they will not look the same in the text file. And after import all the HTML code is imported but the formating also depends on the CSS and other formats on your page

[/quote]

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


Powered by Kunena Forum