Purpose & Scope:
Use Spitfire‘s sfLoadFile utility to create folders in the Spitfire Catalog based on an existing set of folders you already have on your local or network drive.
Procedure:
To replicate a folder structure from a network drive to the Spitfire Catalog:
- Download the sfLoadFile zip file from the Spitfire Download page at www.spitfiremanagement.com/only/download/downloads.htm
- Extract the files to a convenient folder that you can access in a DOS command window (for example: c:sfLoadFile).
- Map a drive to the network or local folder (for example: z:sfTestNet).
- In the Spitfire Catalog, create the top-level folder into which you want to create the folder structure (for example: sfTest).
- Open a DOS command window.
- Navigate to the drive and folder where the sfLoad File files are located (in our example: c:sfLoadFile).
- Run the following command with the appropriate switches:
sfLoadFile -sSQLServer -dsfDocSys -c/SpitfireDev -mD:SpitfireDev*.nXn -pGC123003 –n
Note: Using the mask *.nxn will upload the folders and none of the files in the folders, since no files will match the mask *.nxn.
Switches:
-s the SQL server name **
-d the Spitfire database name ***
-c the target folder into which the new folders are placed; must start with a slash (/) and end with a semicolon (;)
-p required and must a be an active project (Note: the project is not actually used in this scenario)
-n to process the tree
-v for verbose output
-m the source path and mask, must be last (spaces allowed)
Notes:
** SQL Server name should not contain any spaces. If so, run the utility from the SQL server and substitute (local) for the SQL Server name, for example: -s(local).
*** Uses a trusted connection to SQL (DBO access required).
Additional Comments:
This tool can also be used to upload files. Modify the mask in the -m switch to a valid extension to load files that match the mask.C:>sfLoadFile -sSTANY2012 -dsfSalesDocSys -pGC0005 -n -c/; -mD:tempCatalogExporttest*.*
KBA-01262; Last updated: October 27, 2016 at 10:25 am;