We are in process to Replace existing standalone system with an alternative solution with Clarity. As part of this we need to move existing records from old system to clarity. The old system used to save documents attached any instances into database but with Clarity we use file-store to store attachments to store documents belongs to any object instances. Now I need to write gel script that retrieve the file stored in table column and FTP it to file-store location.
I got the script to FTP file from local folder to remote folder but I need script to retrieve the file from database to store in local folder.
Any sample script or suggestion to achieve the goal.