We have different domains/webs, with different forms. Every result of a completed form is now stored to an access-database on a windows-server. As we like to move to a more universal solution, we want to move to a linux server. As backend we´d like to have wordpress because the client who should use the backend is familar allready to wordpress. Also we could use then the user-level-access and other functionalitys of wordpress without programming then from a scratch.
It should be easy to implement new forms on new webs which sending the data to the server.
Sending Data to the final server should not happen transparently as button-action. The data should be send to a proxy-script which is placed on the same server like the form. The proxy-script itself should send the data to the final destination.
The intention behind this way of data-collection is to keep as much information as possible from their customers in only one place. Therefore the dataset should get better and better with each form the same person is filling out. There are some things which could identify the person exaktly: Full Name+Full Adress, Full Name+Phone-Number, Full Name+Mobile Number, Email-Adress With this identifiers the datasets should be enriched if possible.
If a person for example changes his adress, then the dataset should contain two addresses, but with timestamps and the newest should be listed first and should be used. Same with email or phone numbers.
For each completed form, there should be send out three emails:
One with a special text to the costumer.
One with more information like ip, browser, os-type, screen-resolution and whatever could be captured, to the client.
The last one also to us.
On the mainserver where wordpress is installed, there also should be a directory where the form-results are written as html-files.
These files have a special-design where the data is placed in and the link to the written file is placed then into the email, which is send out to our client and to us.
There should be an import/export-tool:
This should be able to import our old data and to export the complete data the same way.
The Data should be able to be exported also in the following ways:
- complete adress-list including last adress, email, phone-numbers as csv
- complete postal adress list (gender (Mr. / Ms.) full name, last adress like street, zip code, city, country) as csv
- complete mobile-phone-list (full name, last mobile phone number)
- complete email-list (full name, last email)
The Database should be searchable and it should be possible to open each Dataset with complete historie. Keep in mind, that we have at the beginning about 20.000 Datasets to be stored. Therefore it should be fast!
This could be integrated as part of the tool, or maybe it is easyer to do it with a newsletter-plugin. We would prefer it, if it´s a powerful plugin. The user should have it´s own id and therefore he should be able to allow or disallow the newsletter by using double-opt-in-method. Also he should be able to select html and text-version of newsletter.
The last part is a little xml-writer for some content interaction. This is used to keep some news/calender apps synchronized and is really a simple output.
It would be nice if this could be done over article-writing in kombination with tagging or something else. The tool would then generate the xml-files out of it.
If needed we can provide you a example-access-database, the sources of the old asp-backend, XML-files and the used forms. If you have more questions, don´t hesitate to ask. Please refer attached screenshot for further detaills.