Joomla Extensions Club 20,483 posts

[ryanek20 Friend ryanek20Join date: August 2016Posts: 7Downloads:14Uploads:0]

#967683

Hey guys, just bought K2 Filter Component. Love it.
I am revamping a website that used a different software to obtain a search by keyword/location etc…
I have a spreadsheet containing hundreds of entries of information (header: http://prntscr.com/ch6ewk), is there a way I can import this information/copy and paste it into a datasheet on the server? I’d love to do the same for categories as well (for filtering locations).

Any tips guys? Thanks.

Goal: http://www.huronmanufacturing.ca/directory/search.php

What I have so far (just installed): http://virtualexs.com/hma/index.php/search-manufacturers

[Mo0nlight Moderator Mo0nlightJoin date: September 2014Posts: 707Downloads:38Uploads:107 Thanked: 99 times in 97 posts]

#967801

Hi.

you could not import the datasheet to k2 extrafield data. Because the k2 items save all the data of extrafield by json string.

You need to code or save all your data match the json string type of k2. then you could import.

For example 1 row of the extrafield column.

[{"id":"1","value":"4"},{"id":"2","value":"7"},{"id":"4","value":"6"},{"id":"3","value":"85.00"},{"id":"5","value":"Test"}]

id : ID_EXTRAFIELD.
value : VALUE OF 1 EXTRAFIELD ITEM

Regards

[Author]

Posts