Our project involves automating flow between databases.
Our "start" database allows push-button export as XML, XLS, or CSV with field names that we define. We would like to export 50-60 fields from this database to a "working" database.
The "working" database will be a Zoho app. It needs to define the record key, prevent duplicates, and accept incoming data from various sources. For example, after accepting records from the "start" database we might update them using a separate Zoho form, and later upload documents and communications, etc.
From the "working" Zoho database we need to transfer data from up to 200 fields to a "finish" database, managed by another entity, via XML web service. The entire project will use field names that match those in the "finish" database.
The managers of the "finish" database require user name and password authentication prior to data upload. They have provided a detailed schema to instruct the winning developer in the construction of the XML.
Data export, or reporting, from the "start" database is already automated. As stated previously "start" will create an XML, XLS, or CSV document the developer can use. We will be responsible for assuring that the data we want exports from "start" to this document. The first export will contain 700-1000 records. Subsequent exports will contain from 1-5 records.
When accepting this project please do so with the understanding that the end-user may not be extremely computer-literate and will need a few easy-to-recognize "buttons" they can press to initiate processes. We would like these buttons to reside within Zoho. There should be a button they can press to import from "start" to "working", and another to export from "working" to "finish".
Thank you for considering our project. We plan on automating several other processes and are hoping to find a developer we can trust to work with us over the long term.