Direct DB access, custom fields, front-end display

Hey all!

Playing around with several custom fields plugins and just not getting the hang of it – yet!

But, before my head explodes, maybe someone can at least tell me if I’m heading in the right direction.

I have a .csv file of posts – with url’s, url’s to image locations, average of 200 word description text, and 35 other columns.

Using Wp AllImport – it works great! I can put the “name” from the .csv name column right into the “post_title” column in the DB. I can also take the majority of my fields and easily display them in the “post_content” area.

BUT – I’d like to create a field, within the db, to import each column in my .csv into it’s own column in the wp_posts table (or any table that gives me the results I need).

Then I’d like to create a front-end access directly to the db to be able to do advanced searching and filtering of results based on those fields – fields that currenlty don’t exist in the database.

FYI – I’m using Xataface (very cool if you’re looking to display your database directly onto the web!) to access the db, WP All Import to import the .csv. I’ve tried WP-CSV to DB plugin – but MANY issues with it.

If anybody has some suggestions, on doing any of this or all of it, I’d love to hear them!

Thanks!
Rob