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 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