Here's the setup:
The client uses a proprietary custom-coded PHP CMS and is wanting to move to WordPress with BuddyPress.
The old, custom CMS has a roster functionality, which I'm using BuddyPress custom fields to replace.
The custom fields are basic contact info (Phone, Fax) and company info (Text field).
What is the best way to import these? It seems my two options are:
Create a pretty large SQL query that reformats this data between databases (I'm about 3 hours into doing it this way so far)
Export it into some sort of JSON format and use the Ning importer.
If the best option is using the Ning importer, know where I can get an example Ning user list CSV so I may format the user data accordingly? If the best option is using a big MySQL query, what are some things I should look at in terms of row values WordPress expects?