Copy PeopleSoft File Attachments
I was doing some work with file attachments in PeopleSoft over the past couple of weeks and I have to say PeopleSoft’s ability to handle attachments is flat out bad. However, it does work. The client I was working with found that storing documents in the database was starting to consume an extreme amount of space which made the database have issues.
In PeopleTools 8.54 there is a batch copy attachment feature that lets you move attachments from one URL to another. So you can define a URL for sftp and another for the database record and copy attachments to/from those URLs. In 8.53 there is just an online page for this, however, if you are doing a copy of more than about 1000 documents you will want to switch to a batch mode.
Read More
|