Announcement

Collapse
No announcement yet.

Interfacing two data bases

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Interfacing two data bases

    I am very new to Scriptcase so my request may not be too well explained; but a bit of background:
    - I am converting a cattle breeding society database from MSAccess to a MYSQL hosted database
    - under MS Access we would ftp a csv file to our public web site (also in a MYSQL database) to enable the 7,500 cattle records to be displayed as pedigree charts
    - because we wanted backward compatibility the new MYSQL tables have replicated the data structure of the MSAccess tables
    - fortunately the MSAccess table, public website database tbales and the new MYSQl tables all have the same field names and types, except two date fields that are datetime in the new MYSQL and need to be Unix timestamp in the web site table.
    - I have got the guts of our database management system built using Scriptcase; all looking good

    I now need to get data from three tables in our new MYSQL database into the public web site database. The data will go into a single table that allows display of the pedigree.
    - I have a Select statement in Scriptcase that works Ok.
    - I want to be able to "push" the data from the new MYSQL database to the public web site database
    - I have tried creating a grid app to produce a csv file - in both development and production it works sometimes and on other occasions results in an error message
    "
    Error while accessing the database
    Lost connection to MySQL server during query" I also can't include a pipe for the column separator.

    A better solution would be to empty the public website table and use the Select statement from the new database tables to insert into the public web site blank table.

    Does anyone have solutions that would achieve this? The solution also needs to be able to convert two date fields that are in datetime in the new MYSQL but need to be in UNIX timestamp in the web site database table.

    Hopefully someone with expertise can suggest a solution and some detailed coding.
Working...
X