I am converting a custom site to WordPress but I have a problem. I have about 20,000 posts for one Custom Post Type that has custom fields for both "source_name" and "source_url". Both these Custom Field Values need to be entered into the "wp_postmeta.meta_key" column for each article that has the custom field data. Each unit of custom field data also needs to be imported into the "wp_postmeta.meta_value" column. While every "post_id" is unique, both the "meta_key" and "meta_values" share the same "post_id".
I am working with SQL and CSV. Does anyone have insight into how I can get all this custom data into the wp_postmeta table correctly?
Thank you in advance!