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,
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.
In Bulk Configuration file for Columns feature use comma separators to specify the list of columns used as file names defined in Excel spreadsheet (as in screenshot below). By doing this you will be able to import more than one file using only one row in excel and that should not cause any issues (even if column in excel spreadsheet does not have any data but is defined in INI file as file name)
Regards,
Natalija
Did Solution provided by Natalija worked for you ?
if its ok for you then please mark it as answered.
Deepti
Answer Verified By: Alex Talbott