How do I have the CCCApply downloader write the output file to a .txt file?

  • 1
  • Question
  • Updated 4 years ago
  • Answered
Hello,

I'm trying to setup the downloader so that when it fetches an application file from CCCApply it will write the full path name of the file to a .txt file and store it in the same location.

Reason is our college is using PeopleSoft and we're told since the downloader adds the date/time information in the file name, the best option for us would be to use what they call a "file list".  Basically I would need the downloader to download the file and then write a file "e.g. cccapply.txt" that would contain something similar to this:

C:\applications\application01_08212016_120114.txt
C:\applications\applicaiton01_08212016_122214.txt
C:\applications\application01_08222016_132400.txt

etc.

Any help would be appreciated.

Thanks!
Photo of Victor DeVore

Victor DeVore

  • 5 Posts
  • 0 Reply Likes

Posted 4 years ago

  • 1
Photo of severa

severa, Champion

  • 101 Posts
  • 10 Reply Likes

I think the easiest approach is to have your downloader launched by another process, and have that process do any additional work you need to have done (such as listing the file names in another file). The cccapply docs suggest a cron job, but that's specifically for automation, and any kind of wrapper script could achieve what you want, even if its primary goal were not automation.

Alternatively you could create a post-processing script that did nothing but place a list of filenames for a given folder into a list file. (or even explicitly combining multiple download files into a single file for import, though that would take more script expertise).

I don't know if your filenames are intended to be accurate, but if so, it implies you might be trying to combine the results of multiple downloads over a single day into a single PS load. Couldn't you achieve the same by only doing one download per day? Then you wouldn't need list file import type.

(Edited)
Photo of Victor DeVore

Victor DeVore

  • 5 Posts
  • 0 Reply Likes
Hi Severa,

Thanks for the response.  I'll probably take a look at the wrapper script solution.  Our goal is to download applications every hour (30 minutes is our ideal).  PeopleSoft doesn't have a way for us to fetch a file with variable information in the filename and we want to keep historical applicaiton files so our only option is to use a list file.

Victor
Photo of Maricela Pedroza

Maricela Pedroza

  • 1 Post
  • 1 Reply Like
Hello,

We have a vbs script that reads a list of files within a specific directory and creates a list of the files and places the list as contents within in a txt fle.  Then we use the txt file (which contains the list of files and their full path ) when we run PS FA Inbound and we select File List and indicate (within the Inbound File field) the name of the file that contains the list of files.  Given that ours is a vbs script, all we have to do when we change directory-names is edit the vbs script by opening the file with Notepad.
Photo of severa

severa, Champion

  • 101 Posts
  • 10 Reply Likes

Since you're running these downloads independently, Maricela's approach is the one you should take.

Note you can also find the current directory in a vbscript, so if the script were written to use the current directory instead of a manual value, you could copy the script directly into the directory with the download files and run it without having to change anything in the script. :-)