Client: University of Texas at Arlington Office of Business Affairs
Fastfield to PeopleSoft Submission Converter
Set the command line argument and call the program using PHP on your server, or visit the hosted link from a browser. To run it locally, drop the files into a localhost server running PHP and visit "localhost/transfer".
To input a lookup table to the FastField app, put a CSV file with the name "lookup_export" into the "in" folder and run the script with the command line argument "input".
To output the form submissions, change the command line argument to "output" and run the script. If you wish to return a date range, uncomment the noted line in the output function.
NOTE: The script current scales horribly due to the FastField App requiring multiple HTTP requests per entry returned. This is not currently fixable, so be patient when making large requests.
Due to incorrect asset input, a list of serial numbers appears in the file "duplicates.csv". This file is used to specify which serial numbers should be changed to blank when outputing the file and inputing the file for lookup purposes. To add to this file, simply open it in a text editor, and add a comma and string in question.
The rule script file is a file to store any custom javascript rules that were used to modify form fields. Do not change this file.