Hi there.

Sorry for this silly question, somebody know how consult or creat k2 items?

I was looking on the tables of **_k2_items but gave results of cero columns.


This is what i want to do, i have a tables in another database and i want to use that info to create new k2 items with extra fields.

I'm so frustrated because i can't find the way to do it :blush:

I hope somebody can help me.
Thanks in advance.

Hi. What kind of tables do you have? You need to write a script to do this.

To be honest, i don't know.

But i tried with this script:

SELECT
it.id, it.title, it.catid categoria, cat.name, extra_fields_search bolnum
FROM jos_k2_items it INNER JOIN jos_k2_categories cat ON it.catid = cat.id

then some rows appear, the rows if i want to create are from the category "88"; i just can't see all the columns of the rows.

Create new rows for that category could be do it by newbies on phpMyAdmin or i need contact to a expert.?


Im, attaching the results of the script.

I am sorry but i don't get what you want to do. First of all why use phpMyAdmin and not the K2 interface? Secondly, if you have some data from some other CMS/extension etc. and you want to convert it to K2 then you need to write a custom script. If you are not familiar with PHP/SQL then you probably need to hire a developer to do it for you.