Here is the issue. We are using a plugin to manage Contact form entries (cforms II form for WordPress), and another plugin to manage Registrations for WordPress (CIMY User fields). They store data very differently in separate tables.
When someone submits to a Contact form, it is stored in the database using key/value pairs. Many of the questions on the Contact form are based on groups. If you view here ([url removed, login to view], and click the "get started blue button"), you will see grouped answers that belong to one question.
For example, click General Public, and see the question of "Improve or Reverse my Condition:" With the current Contact form plugin, and it's key/value system, if someone chose "Lower my Blood Pressure" and "Lower my Heart Disease", those answers would be stored with the key being "Improve or Reverse my Condition:" (colon and capital letters included), and the values being comma-separated "Lower my Blood Pressure,Lower my Heart Disease".
A while back, we had a developer map the Contact Form database tables to feed into a [url removed, login to view] account. Now that we have the registration system, we would also like new registration data (which is nearly identical to Contact form questions) to map to Salesforce. The developer who did the mapping for Salesforce says the new system is *very* different and more time-consuming to map. Under the registration system, when someone answers the question above, it's stored in the database as field_id, with values for YES, or NO. So, instead of the question being label/key, with comma-separated values, the values themselves are not comma separated, but separately identified as individual field_ids with YES for checked and NO for unchecked. The Salesforce developer recommended we reconfigure the registration system to use key/value pairs like the Contact form.
So, if we can have a custom built registration system in Wordpress that allows us to manage fields, manage DB Validation keys (a custom extension of the CIMY Extra fields plugin we had developed), and stores data in key/value pairs, that would be great. Alternatively, perhaps there are custom functions to run or include in Wordpress routines that will not require a plugin, but will simply be enabled for us to use with the theme. Or, perhaps the existing CIMY plugin can be rewritten to store data in a key/value system like above. Of course, we are open to other ideas.
Please describe experience and ideas. Thank you.