Page Comparison

...

1. When the building does not exist in KFS, create an object id using java.util.UUID.randomUUID().toString() and set the version number to 1.
2. When the building status is “DISPOSED”, the set the active indicator to “N”, otherwise set it to “Y”.
3. Set the country code to “US”.
4. Truncate Building Address campus code and building address so that it matches the length in KFS (to prevent a SQL error).
5. When the building exists in KFS, just update the row with the supplied data, otherwise insert a new row using the supplied data.
6. Create a formatted report file to list all transactions.  The first line of the file is contains the process date and report title, the second line contains the column headings, and the last line of the file is “***End of Report ***”.
7. Send an email to inventorycontrol@uconn.edu with the input JSON in the body and the formatted report as an attachment.
8. If there are SQL errors, capture and print the error.

...

...