[thelist] MySQL data to corp. sites

[Anthony Baratta]

Ken Moore wrote:
> Hi, all.
> 
> Sorry. It is vague. I have got lots of uncontrollable variables. All items 
> are plain text - name, phone, email. I collect the data into a MySQL 
> database, sort it by client into MS Access run-time files, and send it to 
> them. They can bring the info up and use as a summary when that person calls 
> them. But much of the information needs to be stored in corporate SQL 
> databases. I have no control over corporate sites.
> 
> I developed a system in DOS about 15 years ago. You could define a screen by 
> a unique set of characters in a specific location and a unique field by row 
> and column. The software would then sense when it was at the correct screen 
> and field, read data from the drive, and plug it into that field.
> 
> I am looking for that same functionality using Linux, Apache, and PHP (or 
> other). If anyone knows of such a thing, it would be a big help.

Here's what I would do. Setup an XML schema, and a script that they can 
"log into" using an automated method and download an XML file.

They can then use the Schema to map your data to their corporate data 
and inject it themselves.