Database build and scripts

  • Posted
  • Proposals 0
  • Remote
  • #30360
  • Archived
  • 1

Description

Experience Level: Intermediate
The project is to take the flat file (.CSV) and deposit on the FTP site and extract it to a bespoke database. The database would be a single table on My SQL, with a scheduler designed to;
a) extract the data from the FTP site on a nightly basis
b) load the SQL database
c) run a trigger based routine that looks for records that have minus 7 days and minus 21 days where the record Date of Birth is minus 21 or 7 days from todays date. Therefore if todays date is Today (19th July) and the Birth date is 26th July or 9th of August then place the Record details in to a flat file and send to an Email system) the send to Lyris HQ will use the API of the Email system. d) produce a text based report of the records sent and the number.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board

    There are no clarification messages.