I am trying to use the Bulk Transfer Configuration Tool for the first time and am having problems getting it to add files to the documents that I am adding. It is adding the documents fine but I am getting the following text in the log file for adding the file.
GetFileList: Either from or To column has not got value in this row.
Path mapping for Electronic Files are as follows:
Path on the Server - D:\BulkImports
Path from the client pc (UNC Path) - \\mseb000\BulkImports
File Path - D:\BulkImports\20131217_ScannedCases\temp1\13206_MainFile.pdf
File name in the F column in the spreadsheet - 20131217_ScannedCases\temp1\13206_MainFile.pdf
Columns F - J from the spreadsheet
Ini File contents
#Configuration File[DOCUMENT]PREFIX=NMIDDLE=REVISION=TITLE=OCLASS=MSTATUS=LSUBJECT TO CC=EFFECTIVE DATE=REMARKS=TEMPLATE NAME=ASCOPE=KFLAG=PFIRST ROW=2[ATTRIBUTES]1=APPLICATION NO,D2=APPLICATION TYPE,BRETAIN VALUES=Y[CROSS REFERENCES]RETAIN VALUES=Y[ITEMS]RETAIN VALUES=Y[DOCUMENT LINKS]RETAIN VALUES=YEXCLUDE PARENT CHILD=N[RESPONSIBILITIES]RETAIN VALUES=Y[PROJECTS]RETAIN VALUES=Y[VIRTUAL ITEM STRUCTURES]RETAIN VALUES=Y[CHANGE REQUESTS][ROLES]RETAIN VALUES=Y[FILE PLANS]RETAIN VALUES=Y[TAGS]RETAIN VALUES=Y[COPIES]1=^^^^^F,J,^,,^Proj Plan Index - VIEW,MODIFYRETAIN VALUES=YCOPY FILES=YOVERWRITE FILES=YDELETE OLD FILES=Y[LOCATIONS]RETAIN VALUES=Y
Hi Alex,
In Bulk import only UNC path value must be used in the Path to the Files as below.
Regarding Bulk Transfer Configuration tool it seems you hit a bug, I’ll create Service Request for this and let you know a number. As workaround try to use Columns feature as shown below.
Regards,
Natalija
can you send us an attachment with the spreadsheet you are using?
Also, if you use just a filename without path in the F-J columns, does it work or do you get the same error.
Address: Bentley | 10052 Mesa Ridge Court Suite100 | San Diego | CA | 92121 | USA
It is loading files but it is is inconsistent on the files it loads. I have a spread to load 8 files. I run it and it will load 4 out of the 8 files. It gives the following error on the files that it doesn't load "Failed at Add document copy. Error Input string was not in a correct format." I open the spreadsheet delete the lines for the files it did load and run it and it will load another file giving me the above error on the others. I am able to do this until all of the files have loaded.
Alex,
when you do the line delete and re-run, does it loads all the files within the same copy?
Yes, it added all of the files within the same copy.