Dokumentation zu: CustomCmdTools_2016_04 (C) J.Feuerstein 
Erstellt: 21.04.2016 S.Gueth

--------------------------------------------------------------------------------------------------------------------------------------------------------------------
#Doc: SubAction: ArrangementsChangeOwnerEval 
#Beschreibung: subaction for arangements change owner ship evaluation
[#New: 3.1234;21.04.2016;S.Gueth]
      
CLA CommandLineArguments:
-------------------------

JobManagerCmdTools.exe -Action   "CustomCmdTools_2016_04" 
 -SubAction                      "ArrangementsChangeOwnerEval"
 -JobRoot_DP                     "xx"                                                   #Doc: Root.Verzeichniss in dem die JobDaten liegen
 -ArrangementsResultLog_DPNE     "c:\temp\arrangementsResult.txt"                       #Doc: full path and name of change arrangements ownership log file

Examples:
#New: 3.1234;21.04.2016;S.Gueth

-Action "CustomCmdTools_2016_04" -SubAction "ArrangementsChangeOwnerEval" -JobRoot_DP "xx" -ArrangementsResultLog_DPNE "c:\temp\arrangementsResult.txt" -JobData1ToProcessDoPrint -JobData2ResultsDoPrint -JobParaDoPrint -PauseOnEnd

--------------------------------------------------------------------------------------------------------------------------------------------------------------------


--------------------------------------------------------------------------------------------------------------------------------------------------------------------
#Doc: SubAction: RefileRepair_PrtOverwrite 
#Beschreibung: subaction for refile repair, copys non refiled prt file to refiled prt file (overwrites it)
[#New: 3.1234;21.04.2016;S.Gueth]
      
CLA CommandLineArguments:
-------------------------

JobManagerCmdTools.exe -Action   "CustomCmdTools_2016_04" 
 -SubAction                      "RefileRepair_PrtOverwrite"
 -JobRoot_DP                     "xx"                                                   #Doc: Root.Verzeichniss in dem die JobDaten liegen
 -TcSQL_DP				         #TcSQL_DP#                                             #Doc: path to Custom TcSQL files
 -ShellExecProg_DPNE
 -ShellExecArguments
 -ShellMaxDurationSEC

Examples:
#New: 3.1235;20.05.2016;S.Gueth

-Action "CustomCmdTools_2016_04" -SubAction "RefileRepair_PrtOverwrite" -JobRoot_DP "V:\CustomersDataL\Renk\2016-05-23-ExampleData\UATEST01_LT_Check_U_47818_MTU" -ShellExecProg_DPNE "V:\CustomersDataL\Renk\2016-05-23-ExampleData\CB\Bin\NxCheckBox_64_10_V.2.0.1.16.exe"




--------------------------------------------------------------------------------------------------------------------------------------------------------------------
#Doc: SubAction: ResetOwningSite
#Beschreibung: subaction for ResetOwningSite, resets the owning site for all objects under an item
[#New: 3.1234;21.04.2016;S.Gueth]
      
CLA CommandLineArguments:
-------------------------

JobManagerCmdTools.exe -Action   "CustomCmdTools_2016_04" 
 -SubAction                      "ResetOwningSite"
 -JobRoot_DP                     "xx"                                                   #Doc: Root.Verzeichniss in dem die JobDaten liegen
 -OwningSiteOnExportTemp         "site3"                                                #Doc: owning site that should be set temporarily on item_export
 -NewOwningSite                  "site2"                                                #Doc: defines the new owning site
 -ShellMaxDurationSEC

Examples:
#New: 3.1235;20.05.2016;S.Gueth




--------------------------------------------------------------------------------------------------------------------------------------------------------------------
#Doc: SubAction: AttributeSync 
#Beschreibung: subaction for attribute sync from NX dataset to TC ir
#Custom: WuH/2017
[#New: 3.1306;09.03.2017;S.Gueth]
      
CLA CommandLineArguments:
-------------------------

JobManagerCmdTools.exe -Action		"CustomCmdTools_2016_04" 
 -SubAction							"AttributeSync"
 -JobRoot_DP						"xx"									    #Doc: Root.Verzeichniss in dem die JobDaten liegen
 -CBConfVersionExt					"VER1"									    #Doc: CB config version extention
 -CBConfigXml						"c:\temp\CbConfig.xml"					    #Doc: full path of cb config file
 -JobTemp_DP						"d:\temp\jobTemp"						    #Doc: path to jobtemp dir
 -AttrSyncInputTemplateFile_DPNE	"c:\inputFile.csv"						    #Doc: full path to input csv file for attribute sync
 -AttrSyncInputCsvFileDelimiter		";"											#Doc: delimiter char for csv file [default is ;]
 -AttrSyncDryRun															    #Doc: optional, if set, attribute sync will not be executed
 -ShellExecProg_DPNE                "tcpb_data_import.exe"						#Doc: full path of tcpb_data_import.exe
 -ShellExecArguments                "'-update_mode=MatchOnly -full_csv '"		#Doc: parameters for tcpb_data_import.exe (-log= -input= -nodryrun will automatically be set in cmd tools)
 -ShellMaxDurationSEC               900											#Doc: max duration of tcpb_data_import.exe process in seconds, after that duration, process will be terminated
 -u                                 infodba										#Doc: username of TC User that should execute the command
 -p                                 infodbapw									#Doc: password of TC User that should execute the command
 -g                                 dba											#Doc: group of TC User that should execute the command
 

 Example Input CSV file for tcpb_data_import process:

#;#;;;;;;;
#01#;;;;;;;;
#Wuh UGPART ATTRS;;;;;;;;
ItemID;REV;SF_CUSTL;SF_REVDT;SF_REVNM;SF_REVNO;WH_ORDNR;WH_ORPOS;WH_EQUIP
ITEM.item_id;REV.item_revision_id;REV.wh4_naming_en;REV.wh4_change_date_str;REV.wh4_person_last_changed;REV.wh4_sap_change_number;REV.wh4_order_for_sap;REV.wh4_order_position_for_sap;REV.wh4_equipment_for_sap
STRING 128;STRING 3;STRING;STRING;STRING;STRING;STRING;STRING;STRING
;;;;;;;;
#Item#;#Rev#;#SF_CUSTL#;#SF_REVDT#;#SF_REVNM#;#SF_REVNO#;#WH_ORDNR#;#WH_ORPOS#;#WH_EQUIP#

gitter variables will be replaced with object data or cb attribute data


Examples:

#New: 3.1307;10.03.2017;S.Gueth
-Action "CustomCmdTools_2016_04" -SubAction "AttributeSync" -JobRoot_DP "V:\CustomersDataL\WuH\2017-03-10-ExampleData\tc10e3_AS_Execute_M_00003_WuH" -JobTemp_DP	"V:\CustomersDataL\WuH\2017-03-10-ExampleData\tc10e3_AS_Execute_M_00003_WuH\JobTemp" -JobData1ToProcessDoPrint -JobData2ResultsDoPrint -JobParaDoPrint -CBConfVersionExt "VER1" -CBConfigXml "V:\CustomersDataL\WuH\2017-03-10-ExampleData\tc10e3_AS_Execute_M_00003_WuH\CBMgrConfig_AttrSync.xml" -AttrSyncInputTemplateFile_DPNE	"V:\CustomersDataL\WuH\2017-03-10-ExampleData\tc10e3_AS_Execute_M_00003_WuH\startup\WuH_AttrSync_InputFile_Template.csv" -AttrSyncInputCsvFileDelimiter	";" -AttrSyncDryRun -ShellExecProg_DPNE "tcpb_data_import.exe" -ShellExecArguments "' -update_mode=MatchOnly -full_csv '" -ShellMaxDurationSEC 900 -u "refileusr01" -p "rf" -g "dba" -verbose -pause -pauseOnEnd





#Doc: SubAction: AttributeSyncKBA
#Beschreibung: subaction for attribute sync from NX dataset to TC
#Custom: KBA.Iberica/2018
[#New: 3.1306;02.02.2018;A.Stein]
      
CLA CommandLineArguments:
-------------------------

JobManagerCmdTools.exe -Action		"CustomCmdTools_2016_04" 
 -SubAction							"AttributeSync"
 -JobRoot_DP						"xx"									    #Doc: Root.Verzeichniss in dem die JobDaten liegen
 -CBConfVersionExt					"VER1"									    #Doc: CB config version extention
 -CBConfigXml						"c:\temp\CbConfig.xml"					    #Doc: full path of cb config file
 -JobTemp_DP						"d:\temp\jobTemp"						    #Doc: path to jobtemp dir
 -AttrSyncInputTemplateFile_DPNE	"c:\inputFile.csv"						    #Doc: full path to input csv file for attribute sync
 -AttrSyncInputCsvFileDelimiter		";"											#Doc: delimiter char for csv file [default is ;]
 -AttrSyncDryRun															    #Doc: optional, if set, attribute sync will not be executed
 -ShellExecProg_DPNE                "tcpb_data_import.exe"						#Doc: full path of tcpb_data_import.exe
 -ShellExecArguments                "'-update_mode=MatchOnly -full_csv '"		#Doc: parameters for tcpb_data_import.exe (-log= -input= -nodryrun will automatically be set in cmd tools)
 -ShellMaxDurationSEC               900											#Doc: max duration of tcpb_data_import.exe process in seconds, after that duration, process will be terminated
 -u                                 infodba										#Doc: username of TC User that should execute the command
 -p                                 infodbapw									#Doc: password of TC User that should execute the command
 -g                                 dba											#Doc: group of TC User that should execute the command
 

 Example Input CSV file for tcpb_data_import process:

#;#;;;;;;;
#01#;;;;;;;;
#Wuh UGPART ATTRS;;;;;;;;
ItemID;REV;SF_CUSTL;SF_REVDT;SF_REVNM;SF_REVNO;WH_ORDNR;WH_ORPOS;WH_EQUIP
ITEM.item_id;REV.item_revision_id;REV.wh4_naming_en;REV.wh4_change_date_str;REV.wh4_person_last_changed;REV.wh4_sap_change_number;REV.wh4_order_for_sap;REV.wh4_order_position_for_sap;REV.wh4_equipment_for_sap
STRING 128;STRING 3;STRING;STRING;STRING;STRING;STRING;STRING;STRING
;;;;;;;;
#Item#;#Rev#;#SF_CUSTL#;#SF_REVDT#;#SF_REVNM#;#SF_REVNO#;#WH_ORDNR#;#WH_ORPOS#;#WH_EQUIP#

gitter variables will be replaced with object data or cb attribute data


Examples:

#New: 3.1307;10.03.2017;S.Gueth
-Action "CustomCmdTools_2016_04" -SubAction "AttributeSync" -JobRoot_DP "V:\CustomersDataL\WuH\2017-03-10-ExampleData\tc10e3_AS_Execute_M_00003_WuH" -JobTemp_DP	"V:\CustomersDataL\WuH\2017-03-10-ExampleData\tc10e3_AS_Execute_M_00003_WuH\JobTemp" -JobData1ToProcessDoPrint -JobData2ResultsDoPrint -JobParaDoPrint -CBConfVersionExt "VER1" -CBConfigXml "V:\CustomersDataL\WuH\2017-03-10-ExampleData\tc10e3_AS_Execute_M_00003_WuH\CBMgrConfig_AttrSync.xml" -AttrSyncInputTemplateFile_DPNE	"V:\CustomersDataL\WuH\2017-03-10-ExampleData\tc10e3_AS_Execute_M_00003_WuH\startup\WuH_AttrSync_InputFile_Template.csv" -AttrSyncInputCsvFileDelimiter	";" -AttrSyncDryRun -ShellExecProg_DPNE "tcpb_data_import.exe" -ShellExecArguments "' -update_mode=MatchOnly -full_csv '" -ShellMaxDurationSEC 900 -u "refileusr01" -p "rf" -g "dba" -verbose -pause -pauseOnEnd



--------------------------------------------------------------------------------------------------------------------------------------------------------------------
#Doc: SubAction: ChangeOwnerShipIrToI 
#Beschreibung: subaction for change owner for ItemRev to Item owner
[#New: 3.1405;19.05.2017;S.Gueth]
      
CLA CommandLineArguments:
-------------------------

JobManagerCmdTools.exe -Action		"CustomCmdTools_2016_04" 
 -SubAction							"ChangeOwnerShipIrToI"
 -JobRoot_DP						"xx"									    #Doc: Root.Verzeichniss in dem die JobDaten liegen
 -JobTemp_DP						"d:\temp\jobTemp"						    #Doc: path to jobtemp dir
 -u                                 infodba										#Doc: username of TC User that should execute the command
 -p                                 infodbapw									#Doc: password of TC User that should execute the command
 -g                                 dba											#Doc: group of TC User that should execute the command

 Examples:

#New: 3.1408;24.05.2017;S.Gueth
-Action "CustomCmdTools_2016_04" -SubAction "ChangeOwnerShipIrToI" -JobRoot_DP "V:\CustomersDataL\TBVC\2017-05-24-ExampleData\tcint_CO_IToIR_M_00006_VC" -JobTemp_DP "V:\CustomersDataL\TBVC\2017-05-24-ExampleData\tcint_CO_IToIR_M_00006_VC\JobTemp" -u infodba -p infodbapw -g dba
-Action "CustomCmdTools_2016_04" -SubAction "ChangeOwnerShipIrToI" -JobRoot_DP "V:\CustomersDataL\TBVC\2017-05-26-ExampleData\tcint_CO_IToIR_M_00019_VC" -JobTemp_DP "#JobRoot_DP#\JobTemp" -u infodba -p infodbapw -g dba -pauseonend -pause -JobData1ToProcessDoPrint -JobData2ResultsDoPrint -JobParaDoPrint
-Action "CustomCmdTools_2016_04" -SubAction "ChangeOwnerShipIrToI" -JobRoot_DP "V:\CustomersDataL\TBVC\2017-05-29-ExampleData\tcint_CO_IToIR_M_00028_VC" -JobTemp_DP "#JobRoot_DP#\JobTemp" -u infodba -p infodbapw -g dba -pauseonend -pause -JobData1ToProcessDoPrint -JobData2ResultsDoPrint -JobParaDoPrint


--------------------------------------------------------------------------------------------------------------------------------------------------------------------
#Doc: SubAction: PropertySwap 
#Beschreibung: subaction for swap 2 properties for item or otem rev
[#New: 3.1433;10.10.2017;S.Gueth]
      
CLA CommandLineArguments:
-------------------------

JobManagerCmdTools.exe -Action		"CustomCmdTools_2016_04" 
 -SubAction							"PropertySwap"
 -JobRoot_DP						"xx"									    #Doc: Root.Verzeichniss in dem die JobDaten liegen
 -JobTemp_DP						"d:\temp\jobTemp"						    #Doc: path to jobtemp dir
 -prop1                             object_name                                 #Doc: property 1 to swap
 -prop2                             object_desc                                 #Doc: property 2 to swap
 -ShellExecProg_DPNE                "c:\Data\AttributeSwap.exe"					#Doc: full path to AttributeSwap.exe
 -ShellExecArguments                "'-bypass=true'"		                    #Doc: parameters for AttributeSwap.exe (all parameters, except of -bypass=true will automatically be set in cmd tools)
 -ShellMaxDurationSEC               900											#Doc: max duration of AttributeSwap.exe process in seconds, after that duration, process will be terminated
 -u                                 infodba										#Doc: username of TC User that should execute the command
 -p                                 infodbapw									#Doc: password of TC User that should execute the command
 -g                                 dba											#Doc: group of TC User that should execute the command



 --------------------------------------------------------------------------------------------------------------------------------------------------------------------
#Doc: SubAction: PLMEasyBatchRenameForItem 
#Beschreibung: subaction for rename an item in tc via PLMEasy tool tcpb_batch_rename
[#New: 3.1433;13.10.2017;S.Gueth]
      
CLA CommandLineArguments:
-------------------------

JobManagerCmdTools.exe -Action		"CustomCmdTools_2016_04" 
 -SubAction							"PLMEasyBatchRenameForItem"
 -JobRoot_DP						"xx"									    #Doc: Root.Verzeichniss in dem die JobDaten liegen
 -JobTemp_DP						"d:\temp\jobTemp"						    #Doc: path to jobtemp dir
 -ItemRenameFormat                  #ItemId#_neu                                #Doc: defines the format for the new item id you can use the gitter variable #ItemId# that will be replaced with current item id
 -ShellExecProg_DPNE                "c:\Data\tcpb_batch_rename.exe"				#Doc: full path to tcpb_batch_rename.exe
 -ShellExecArguments                " -preserve_modification -bypass"		    #Doc: parameters for tcpb_batch_rename.exe (all parameters, except of -preserve_modification and -bypass will automatically be set in cmd tools)
 -ShellMaxDurationSEC               900											#Doc: max duration of tcpb_batch_rename.exe process in seconds, after that duration, process will be terminated
 -u                                 infodba										#Doc: username of TC User that should execute the command
 -p                                 infodbapw									#Doc: password of TC User that should execute the command
 -g                                 dba											#Doc: group of TC User that should execute the command
 -RemoveSuffixFromItem              _NX                                         #Doc: optional, if given then the defined string will be removed from the end of the item id (example: 0815_NX will be renamed in 0815)
 -RemovePrefixFromItem              NX_                                         #Doc: optional, if given then the defined string will be removed from the start of the item id (example: NX_0815 will be renamed in 0815)








  --------------------------------------------------------------------------------------------------------------------------------------------------------------------
#Doc: SubAction: VPMapProTextExportFromTif 
#Beschreibung: subaction for exporting texts from tif files via vmap pro and import the texts into jobmanager db (Drawing Indexing Search data)
[#New: 3.1433;13.10.2017;S.Gueth]
      
CLA CommandLineArguments:
-------------------------

JobManagerCmdTools.exe -Action		"CustomCmdTools_2016_04" 
 -SubAction							"VPMapProTextExportFromTif"
 -JobRoot_DP						"xx"														#Doc: Root.Verzeichniss in dem die JobDaten liegen
 -TiffTextExtractFolder_DP          "c:\temp\JobRoot"											#Doc: Defines the folder where tiff files will be copied to, for the text extraction
 -TifRDVDataExportFolder            "c:\temp\TargetExport\Folder"								#Doc: Defines the path to the rdv export folder"
 -BatchJobFile_DPNE                 "c:\temp\JobRoot\batchJob.bjb"								#Doc: Defines name and path to the batch job file, attention: batch job file has to be configured correctly
 -ExportetTextsCsvFile_DPNE         "c:\temp\ExportedTexts\file.csv"                            #Doc: Defines the full path and name of the exported texts csv file
 -ShellExecProg_DPNE                "C:\Program Files\softelec\VPmapproV68\BatchExecutor.exe"	#Doc: full path to BatchExecutor.exe
 -ShellExecArguments                " -x"														#Doc: parameters for BatchExecutor.exe (all parameters, except of BatchJobFile)
 -ShellMaxDurationSEC				0															#Doc: max duration of BatchExecutor.exe process in seconds, after that duration, process will be terminated -> "0" process will NOT be 'canceled'
 -CleanUpRVDFiles                                                                               #Doc: optional, if set, rvd files will be deleted after the job


 Example:

 #New: 3.1488;04.12.2018;S.Gueth
 -JobRoot_DP "V:\CustomersDataL\Renk\2018-10-23-ExampleData\tiffArchive_VPMapProTiffTxtExtract_00007_Renk" -JobData2ResultsDoPrint -JobParaDoPrint -SubActionSettingsXML "C:\Data\addPLM\JobManager\ProgEntw\Ver03\JobManagerV3\90-DATA\CustomerNameShort_SettingsGlobal\10-JobScripts\RefileNX10\ClientScripts\SubActionSettings\vpmap_#CustomCmdTools_2016_04_#VPMapProTextExportFromTif.xml" -Verbose -PauseOnEnd -Pause 