MySQL data conversion for WordPress CIMY User Fields


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.

Skills: MySQL, PHP, Software Testing, Website Testing

See more: www salesforce, wordpress theme for software developer, wordpress software developer theme, wordpress mysql database developer, wordpress developer functions, wordpress custom theme developer, using wordpress as a developer, theme for wordpress, testing user, software developer ii, salesforce one, one key data, experience wordpress plugin developer, example thank you letters, developer site in wordpress, developer for wordpress, custom wordpress plugin developer, certification developer php, capital one com, value stores, salesforce developer certification, key value stores, developer salesforce, contact account now

Project ID: #4329057

7 freelancers are bidding on average $714 for this job


Quality work assured. Ready to get started. Thanks.

$1200 USD in 7 days
(341 Reviews)

Hi, I'm interested to work on your project. Waiting for your reply Thanks Dev

$999 USD in 13 days
(88 Reviews)

Hello Please read more than private message thank you

$700 USD in 10 days
(36 Reviews)

i can do it

$250 USD in 21 days
(51 Reviews)

Hi, Please Check PM

$250 USD in 5 days
(31 Reviews)

we have good team for wordpress plugin can do it......please check your pmb

$600 USD in 8 days
(1 Review)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$700 USD in 25 days
(2 Reviews)

gone through your requirements completely..ready to start the project asap..please check PM

$600 USD in 7 days
(0 Reviews)

on2itonline: Hi, KIWI Team here at on2itonline would love to work for you on this project, we do "full service" websites on a clear and fixed budget. We have lots of offer that others don't, like our li More

$650 USD in 20 days
(0 Reviews)