[Plugin: CSV Importer] Import data from Yii Application to WordPress

Hi,

I have an existing Yii application which I want to move to WordPress. I have created all entities (example, products, stores, etc.) as custom post types.

Now, I want to import all my existing data to the new WP site, but that’s where I’m stuck. The old application has separate tables for entities while WP has everything in a single table wp_posts.

I need help with the following:
Which format should I prepare the CSV in? How do I know the headers?
Some of the data from one table in old application is getting split into 2 tables in WP – wp_posts and wp_posts_meta. How do I handle that?
How do I assign post ids, permalinks and system generated fields in a CSV import?
I have forms to enter this data manually. Will it be better/simpler to write a function that mimics the functionality of the Save Draft/Publish buttons and submit my data one by one through forms?

Please help. I’m badly stuck and just a beginner in programming. Just trying to hack by reading tutorials.

Thanks,
Rahul.

http://ww.wp.xz.cn/extend/plugins/csv-importer/