Keyword

Re: Tool for importing / exporting items to / from K2

  • Cristian Negruzzi
  • Cristian Negruzzi's Avatar Topic Author
  • Offline
  • New Member
More
12 years 4 months ago #66108 by Cristian Negruzzi
Greetings, I have a question, could you help me o direct to how to import items into k2 from code?
I've made a program to import intems into my product category, items are inserted into k2 intems, i can edit them there but none of them are displayed in frontend. I did it by a mysql query like that:
INSERT INTO `jos_k2_items` (
      `title`, `alias`, `catid`, `published`, `introtext`, `fulltext`, `image_caption`, `image_credits`,
      `video`, `video_caption`, `video_credits`, `gallery`, `extra_fields`, `extra_fields_search`,
     `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `publish_up`,
      `publish_down`, `checked_out`, `checked_out_time`, `trash`, `access`, `ordering`,
      `featured`, `featured_ordering`, `hits`, `metadata`, `metadesc`, `metakey`, `params`,
      `plugins`, `language`
     ) values (
     'Product Item Title', 'product-item-title-alias', 15, 1, '', '', '', '', NULL, '','',NULL, '[{"id":"2","value":"23"},{"id":"5","value":"0"},{"id":"4","value":"0"},{"id":"6","value":"1"},{"id":"7","value":"5404"}]', '', "2012-05-12 19:00:00", 62, "", "0000-00-00 00:00:00", 62, "2012-05-12 19:00:00", "0000-00-00 00:00:00", 0,  "0000-00-00 00:00:00", 0, 0, 0, 0, 0, 1, '', '', '', '', '', ''
     )
Would you be so kind to tell what i did wrong? What else is to be done to make items displayed in frontend?

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


Powered by Kunena Forum