My website is a soon to be business directory. We will allow businesses to post their business via BreezingForms with all the sufficient info. What I want to do is import that form with all of the different info onto the website using mysql or whatever type of extension would be easiest. When I upload that form, all of the data should go in its corresponding place in a K2 Item. After that it should be searchable using a filter for K2-
K2 Filter and Search Module

I.e. A business submits a form with their name, address, business name, location, Logo, and a brief description. I download the form in either PDF, XML, or CSV format and then simply upload it to the database or mysql so the data goes into a K2 Item with extra fields.

What is the easiest way this can be done?
Can it be done at all?
What other ways can I do this?

Thank you for taking the time to read this.

Hello John,

CSV importing will work if you have the appropriate db skills. I do suggest however you add all these fields as extrafields (More flexible and easier to manage) and use K2's front end editing. It will save you a lot of time.

Thank you, would you suggest this extension? I am a newby with databases
www.individual-it.net/Instructions-for-K2-Import-Component.html

This sounds like a workround. I suggest you modify the itemform and have your users enter their items directly to K2.

Ok, thank you very much for the tip.

It is a great extension and works nicely. Breezing forms is one way to do it, but you will have double entries managing the page. What you really wanna do is modify the itemform like Krikor said, that way you only have data being entered once, with little manual work. Your users might have trouble understanding what extra fields are etc. So you need to go and change the layout a bit to what you want.

I actually did the exact same thing when I was building a business directory, and started using breezing forms. I am in the process of rebuilding the itemform at the moment.

Thank you Johan. What are you using with your website to input data? Also, what version of K2 are you using? The developers at www.individual-it.net/ only have the extension working on K2 2.4.x and 2.5.x
Im using K2 2.6.7

I am using that exact extension that you mentioned. I never had a problem, and I am using 2.5.8.

Why not ask them to upgrade it, or if you really have to. Do a downgrade, import the data and then upgrade. or lastly , upgrade the extension if possible.

The problem is extra fields dont do nicely with plain database imports and are quite complicated especially if you have special fields.

Regards,
Johan

btw: If you gonna do a downgrade, save all your articles first.

Ok, Thanks Johan.
Im just going to study the Breezingforms integrator to make the table.