Database build and scripts
5016
$$
- Posted:
- Proposals: 0
- Remote
- #30360
- Archived
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.
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.
Adrian J.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
19 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies