PROJECT in a box includes a facility for checking-in files from external sources, for instance spreadsheets exported from a third party applications. Use the command line tool piabcheckinexternal.exe called from a Windows command file. This tool can be found in the bin folder of your PROJECT in a box installation folder.
In the PROJECT in a box client, use the Option to show Database ID Numbers to get the ID of the Project and the File that you want to check in.
Create a Windows command file, like the one below, specifying your login details to the PROJECT in a box server and the details of the file you want to check in:
Example Windows Command File:
-u Admin ^
-p admin ^
-f “C:\Data Export\Project Finance.xls” ^
-pid 101 ^
-fid 106 ^
-desc “Project Finance Export Spreadsheet”
You can then run the command file directly, from another script (e.g. an export script from the thrid party application) or as a conventional Windows Scheduled Task.
Command Line Options for piabcheckinexternal.exe
-w (Use Windows Authentication to IIS)
-t (HTTP Timeout, s)
-noproxy (Ignore the default client proxy settings)
-pid N (The Project ID)
-fid M (The File ID)
-desc “Some Description” (The Check-in Description)