Comments for Attaching Supporting Documentation to Journals at http://www.erpassociates.com , comment 1 to 11 out of 11 comments http://www.erpassociates.com Fri, 30 Jul 2010 05:43:43 +0100 FeedCreator 1.7.3 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-1051 Jim Marion has a post about how to detach a file using PL/SQL. Check it out! [url]http://jjmpsj.blogspot.com/2008/05/export-peoplesoft-attachments-using.html[/url] - Brent Martin Thu, 29 May 2008 14:04:19 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-984 Hollowman - I don't have a tutorial for the attachment server. How I made it happen the first time was to find some delivered code that did the job and clone from that. It was a Financials system and I used the Journal Upload component. I'm sure you'll find at least one example in whatever app you're working on. Atul - That's a really good question. There's no way to do it "out of the box". One thought would be to modify the PCode so that after it saves it to the database, it detaches it into a directory with a real-time virus scanner running, then waits a few seconds and see if the file still exists. If the virus scanner quarantines it, the file will disappear and you can assume you have a virus and handle it accordingly. Okay I'm sure there are better ideas but that might be a start. Good luck! - Brent Martin Sat, 08 Mar 2008 20:16:27 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-983 is there a way anti virus scan be done for the attachment being stored in database ! - Atul Sat, 08 Mar 2008 17:17:10 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-981 Hi, I want to develope a page for uploading files. Can any one tell me any tutorial/book/article demonstrating the step by step procedure to do this? An example would suffice. I have read "Understanding File Attachments and PeopleCode" from PeopleCode Developer’s Guide - Enterprise PeopleTools 8.49 PeopleBook, but still it is not clear how to proceed. Thanks. - Hollowman Tue, 04 Mar 2008 11:46:41 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-782 Thanks again Brent. I think where I'm getting hung up is that I need to first add it to the database THEN I need to 'GetAttachment' and send it to a server. Every example I find is from the app server to a file server. Here is what I have for code: &RETCODE = AddAttachment(&URL_ID, &ATTACHSYSFILENAME, &FILEEXTENSION, &ATTACHUSERFILE, &FILESIZE); &GetAttach = GetAttachment(URL.AUC_TEMP, CHMC_CKRQ_ATTCH.ATTACHSYSFILENAME.Value, &ATTACHSYSFILENAME, "FILE"); The Addattachment is working but the getattachment is not. I'm pretty new to PeopleCode and honestly I have no idea what I need to do. Thanks again! - Susan Paden Fri, 28 Dec 2007 18:22:37 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-781 This code came out of the journal import app engine GL_JRNL_IMP. One thing i like is that it opens a file that you can write debug messages to. Hope it helps! SQLExec("SELECT UNICODE_ENABLED FROM PSSTATUS", &RtnCode); If &RtnCode = 1 Then &DBcharset = "U"; /* UNICODE */ Else &DBcharset = "ANSI"; /* ANSI */ End-If; &CharSet = LOAD_JRNL_AET.CHARSET; If None(&CharSet) Then &CharSet = &DBcharset; End-If; &LogFileName = "GL_JRNL_IMP_" | String(LOAD_JRNL_AET.PROCESS_INSTANCE) | ".LOG"; &LogFile = GetFile(&LogFileName, "W", &DBcharset, &#xFi;lePath_Relative); &DataFileName = LOAD_JRNL_AET.ATTACHUSERFILE; &LogFile.WriteLine(MsgGetText(5825, 106, "Flat File Journal Import")); &LogFile.WriteLine(" "); &LogFile.WriteLine(" " | Úte); &LogFile.WriteLine(Rept("-", 40)); try &RtnCode = GetAttachment(URL.GL_FILE_IMPORT, LOAD_JRNL_AET.ATTACHSYSFILENAME.Value, &DataFileName, "PS_FILEDIR"); catch Exception &Excp; &RtnCode = 99; If &Excp.MessageSetNumber = 2 And &Excp.MessageNumber = 788 Then MessageBox(0, "", 5825, 118, "Check PS_FILEDIR variable"); Else Error (&Excp.ToString()); End-If; end-try; If &RtnCode = 0 Then &ImportFile = GetFile(&DataFileName, "R", &CharSet, &#xFi;lePath_Relative); If &ImportFile.IsOpen Then &ImportFile.SetFileLayout(FileLayout.GL_JRNL_IMPORT); &LogFile.WriteLine(Left(String(&#xTi;me), 8) | " " | MsgGetText(5825, 104, "Processing file...", &DataFileName)); MessageBox(0, "", 5825, 104, "", &DataFileName); &File_RS = &ImportFile.CreateRowset(); ImportData(&File_RS); &ImportFile.Close(); Else /* Cannot open file */ &LogFile.WriteLine(MsgGetText(5825, 126, "GetFile error", &DataFileName)); &ERRcount = &ERRcount 1; End-If; Else /* Error getting attachment */ &LogFile.WriteLine(MsgGetText(5825, 125, "GetAttachment error", &DataFileName, &RtnCode)); &ERRcount = &ERRcount 1; End-If; If &ERRcount = 0 Then &LogFile.WriteLine(Left(String(&#xTi;me), 8) | " " | MsgGetText(5825, 116, "Validating imported data")); Else /***** Rollback all transactions *****/ &LogFile.Close(); MessageBox(0, "", 5825, 102, "Errors found - Rollback"); Exit (1); End-If; - Brent Martin Fri, 28 Dec 2007 17:52:20 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-780 Thanks Brent. I'm trying to use the GetAttachment and I keep getting failures. Do you have any code examples? - Susan Paden Fri, 28 Dec 2007 16:23:11 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-778 I believe you can configure multiple file attachment servers to do both ways, but it seems like the user would have to upload it twice (which I'm guessing isn't what you want). I'm not sure exactly what problem you're looking to solve, but sometimes users have files on their computers that they need to process with an SQR. I use the attachment functionality to let them attach the file in a run control page. Then I create an Application Engine process that invokes PeopleCode to detach the file to a directory on the server. Then I just point my SQR process to pick the file up from that directory location on the server. Create a job that runs the App Engine first, then the SQR and you're done. If you're running Financials, you can use "Flat File Journal Import Request" as a model for how this can be done. If you just need to store the file in the database, and in a directory on your application server, you could just add some FieldChange PCode to "detach" the file to a directory on your app server after the attachment has been loaded. Check out the PeopleCode function "GetAttachment" to save a database attachment to a file. Hope this helps... - Brent Martin Fri, 28 Dec 2007 14:44:08 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-777 This is great information. Thank you for posting. I actually need to do both storing the file in the database AND ftping it to a server. Have you seen this done? I think I'm making it way harder than it needs to be. If you have any tips they would be appreciated. THANKS MUCH! :) - Susan Paden Fri, 28 Dec 2007 14:07:35 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-750 If you click the View button, it'll open the attachment in whatever tool you have on your workstation (excel, adobe acrobat, etc). Once you have it on your workstation, you can print from there. - Brent Martin Fri, 16 Nov 2007 19:51:03 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/sarbanes-oxley/attaching-supporting-documentation-to-journals.html#comment-744 Hi I went through your post. Have you tried printing the attachments using SQR or crystal or any other reporting tool of PS. If yes, could you please let me know how you were able to do that. Regards Arshad - arshad Wed, 07 Nov 2007 09:00:17 +0100