What a hectic week!
This week I mainly focused on programming an automated email system for event tracking. I had worked on it in previous weeks, but really set out to make it work this week. I had a goal of getting it working by friday.
This may seem like a lot of time to integrate an automated email system, but believe me, it's not. We didn't have any examples of this working at Austin Peay.
The main problem I had with setting up the system was sending attachments from Oracle. This is not an easy thing to do as there are no built in functions. I had to research and find multiple ways to do it. Eventually, I found a way to get it working, but the max attachment size was only 32k. This would hold data for about 500 students. Seeing no other ways to get it working, I implemented this process and tested it.
It worked!!! Now to test the size limit.
I made a file with 10k student records and tried to send it..... It Worked!!! Perplexed, I did further research on the size limit. It turns out that the size limit imposed is per line. Since I'm building the attachment with multiple line (CSV File), it have me no problems.
I finally got the automated email system up. It should be live on production by Tuesday!
No comments:
Post a Comment