I am trying to import data into a movie website, where I will import data into custom fields such as director, productionyear,internationaltitle, imdblink and so on. The data is from an exotic database that I have converted into a csv file. I have built MySQL queries and managed to insert all the posts, and relating categories. The posts and categories went fine and they are part of WordPress-core. I'm really happy I managed to get that far.
But what I am having trouble with is this: Importing data into custom fields in wordpress. I know WordPress is using key-values for custom fields, and it all goes into wp_postmeta. This is documented in the WordPress Codex: http://codex.wordpress.org/Custom_Fields
When I import the data and create new unique "meta_id" and relate to the post using "post_id" and then using key-values for the custom fields eg "director" which is the key and "Del Toro" as value. It simply doesn't show up on my website. I know this is correct because when I use the admin-frontend, this is exactly what the front-end does.
What am I missing here? Again, when I create values in post_meta using mysql-queries the data is not showing up on the website. When I use the admin-panel and manually plot the data, it works.
I spent weeks trying to solve this, and aalmost about to give up now