Bulk Transfer Configuration Tool

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

F G H I J
20131217_ScannedCases\temp1\13206_MainFile.pdf 20131217_ScannedCases\temp1\13206_Development Plan.pdf 20131217_ScannedCases\temp1\13206_Notices.pdf
20131217_ScannedCases\temp2\13206_MainFile.pdf 20131217_ScannedCases\temp2\13206_Development Plan.pdf 20131217_ScannedCases\temp2\13206_Notices.pdf 20131217_ScannedCases\temp2\13506_Notices.pdf 20131217_ScannedCases\temp2\13506_MainFile.pdf

  
  Ini File contents

#Configuration  File
[DOCUMENT]
PREFIX=N
MIDDLE=
REVISION=
TITLE=O
CLASS=M
STATUS=L
SUBJECT TO CC=
EFFECTIVE DATE=
REMARKS=
TEMPLATE NAME=A
SCOPE=K
FLAG=P
FIRST ROW=2
[ATTRIBUTES]
1=APPLICATION NO,D
2=APPLICATION TYPE,B
RETAIN VALUES=Y
[CROSS REFERENCES]
RETAIN VALUES=Y
[ITEMS]
RETAIN VALUES=Y
[DOCUMENT LINKS]
RETAIN VALUES=Y
EXCLUDE 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,MODIFY
RETAIN VALUES=Y
COPY FILES=Y
OVERWRITE FILES=Y
DELETE OLD FILES=Y
[LOCATIONS]
RETAIN VALUES=Y
  
  
  
  
  
  
  
  
 
 
 

Parents
  • 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 Suite
    100 | 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.

Reply
  • 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.

Children