11/26/2025 10:30:14 AM : FileInspectionTool Version  ### IFI 21.0.3 ### Release Date 27-Nov-2024
11/26/2025 10:30:14 AM : MainForm.cs : StartProcess() Running_Status and LastRun_StartDateTime of ZylemFileInspectionTool   :  ### Update HelpDesk_ProjectInformation set Running_Status = 1,LastRun_StartDateTime=Getdate(),LastRun_EndDateTime=NULL where Info_Key = 'ZylemFileInspectionTool'
11/26/2025 10:30:14 AM : startProcess  ###  FIT Tool run for FITBulkImport - ***Start***
11/26/2025 10:30:14 AM : startProcess()  ### Info -> Check required Distributor exist in database:select pdistributor.distributorid,erpcode,distributor from pdistributor,DistributorFileTypeSettings  where  DistributorFileTypeSettings.distributorid= pdistributor.distributorid   and DistributorFileTypeSettings.IsDifferentialImport = 'true'  and pdistributor.ERPCode in ('2221146') union select '000000000000000' ,'COMPANYPRIM','COMPANYPRIM' from pdistributor,DistributorFileTypeSettings  where DistributorFileTypeSettings.distributorid='000000000000000'  order by pdistributor.distributorid
11/26/2025 10:30:14 AM : startProcess()  ### Info -> Check required Distributor exist in database DistributorFileTypeSettings : select FileSequence,NamingConvension,NoOfFiles, a.controlid as FileType, b.ControlId as FileExtension,DateFormat,DiffCutOffDate,IsDifferentialImport from DistributorFileTypeSettings, FileTypemaster a, FileTypeMaster b where  a.id=DistributorFileTypeSettings.filetype and b.id=DistributorFileTypeSettings.FileExtension and distributorid ='000000000000000'
11/26/2025 10:30:14 AM : Zip()  ### End
11/26/2025 10:30:14 AM : startProcess()  ### COMPANYPRIM : COMPANYPRIM Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
11/26/2025 10:30:14 AM : startProcess()  ### Info -> Check required Distributor exist in database DistributorFileTypeSettings : select FileSequence,NamingConvension,NoOfFiles, a.controlid as FileType, b.ControlId as FileExtension,DateFormat,DiffCutOffDate,IsDifferentialImport from DistributorFileTypeSettings, FileTypemaster a, FileTypeMaster b where  a.id=DistributorFileTypeSettings.filetype and b.id=DistributorFileTypeSettings.FileExtension and distributorid ='000000000001356'
11/26/2025 10:30:14 AM : Zip()  ### End
11/26/2025 10:30:14 AM : startProcess()  ### SKY STAR : 2221146 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
11/26/2025 10:30:15 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO -> strQuery :  ###  Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '2743253'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '9061358'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '9066916'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '9067041'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '3489984'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '000070'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '9067123'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '3908077'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '172675'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '1123438'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '9066867'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '3985879'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '9067110'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '9067109';
11/26/2025 10:30:15 AM : startProcess  ### ENVU_2221146_ADJUSTMENT.TXT file contains only Date range row
11/26/2025 10:30:15 AM : startProcess  ###  FileName - ADJUSTMENT import DateTime -11/26/2025 10:30:15 AM
11/26/2025 10:30:15 AM : startProcess  ###  FileName - CLOSINGSTOCK import DateTime -11/26/2025 10:30:15 AM
11/26/2025 10:30:15 AM : startProcess  ###  FileName - PRODUCT import DateTime -11/26/2025 10:30:15 AM
11/26/2025 10:30:15 AM : startProcess  ###  FileName - PURCHASE import DateTime -11/26/2025 10:30:15 AM
11/26/2025 10:30:15 AM : startProcess  ###  FileName - RETAILER import DateTime -11/26/2025 10:30:15 AM
11/26/2025 10:30:15 AM : startProcess  ###  FileName - SALE import DateTime -11/26/2025 10:30:15 AM
11/26/2025 10:30:15 AM : startProcess()  ###  Data posting done in IMP_StagingData
11/26/2025 10:30:15 AM : startProcess()  ###  Value of isExecuteProcedureForFITBulkImport True
11/26/2025 10:30:15 AM : startProcess()  ###  Procedure execution Started 
11/26/2025 10:30:17 AM : startProcess  ###  Procedure execution End 
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO -> dtIFIRejected.Rows.Count :  ### 1
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() strFileName:  ### ENVU_2221146
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_ADJUSTMENT.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_ADJUSTMENT.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO  strRejectedPath :  ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_ADJUSTMENT.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_CLOSINGSTOCK.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_CLOSINGSTOCK.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO  strRejectedPath :  ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_CLOSINGSTOCK.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_PRODUCT.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_PRODUCT.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO  strRejectedPath :  ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_PRODUCT.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_PURCHASE.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_PURCHASE.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO  strRejectedPath :  ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_PURCHASE.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_RETAILER.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_RETAILER.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO  strRejectedPath :  ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_RETAILER.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_SALE.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath :  ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_SALE.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO  strRejectedPath :  ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_SALE.TXT
11/26/2025 10:30:17 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method Info -> update if file is rejected  strQuery :  ###  Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '2221146';
11/26/2025 10:30:17 AM : MainForm.cs : StartProcess() Running status and LastRun_EndDateTime of ZylemFileInspectionTool   :  ### Update HelpDesk_ProjectInformation set Running_Status = 0,LastRun_EndDateTime=Getdate() where Info_Key = 'ZylemFileInspectionTool'
11/26/2025 10:30:17 AM : MainForm.cs : StartProcess() Running status and LastRun_EndDateTime of ZylemFileInspectionTool   :  ### Update HelpDesk_ProjectInformation set Running_Status = 0,LastRun_EndDateTime=Getdate() where Info_Key = 'ZylemFileInspectionTool'
11/26/2025 10:37:43 AM : FileInspectionTool Version  ### IFI 21.0.3 ### Release Date 27-Nov-2024
11/26/2025 10:37:43 AM : MainForm.cs : StartProcess() Running_Status and LastRun_StartDateTime of ZylemFileInspectionTool   :  ### Update HelpDesk_ProjectInformation set Running_Status = 1,LastRun_StartDateTime=Getdate(),LastRun_EndDateTime=NULL where Info_Key = 'ZylemFileInspectionTool'
11/26/2025 10:37:43 AM : startProcess  ###  FIT Tool run for FITBulkImport - ***Start***
11/26/2025 10:37:43 AM : startProcess()  ### Info -> Check required Distributor exist in database:select pdistributor.distributorid,erpcode,distributor from pdistributor,DistributorFileTypeSettings  where  DistributorFileTypeSettings.distributorid= pdistributor.distributorid   and DistributorFileTypeSettings.IsDifferentialImport = 'true'  and pdistributor.ERPCode in ('2221146') union select '000000000000000' ,'COMPANYPRIM','COMPANYPRIM' from pdistributor,DistributorFileTypeSettings  where DistributorFileTypeSettings.distributorid='000000000000000'  order by pdistributor.distributorid
11/26/2025 10:37:43 AM : startProcess()  ### Info -> Check required Distributor exist in database DistributorFileTypeSettings : select FileSequence,NamingConvension,NoOfFiles, a.controlid as FileType, b.ControlId as FileExtension,DateFormat,DiffCutOffDate,IsDifferentialImport from DistributorFileTypeSettings, FileTypemaster a, FileTypeMaster b where  a.id=DistributorFileTypeSettings.filetype and b.id=DistributorFileTypeSettings.FileExtension and distributorid ='000000000000000'
11/26/2025 10:37:43 AM : Zip()  ### End
11/26/2025 10:37:43 AM : startProcess()  ### COMPANYPRIM : COMPANYPRIM Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
11/26/2025 10:37:43 AM : startProcess()  ### Info -> Check required Distributor exist in database DistributorFileTypeSettings : select FileSequence,NamingConvension,NoOfFiles, a.controlid as FileType, b.ControlId as FileExtension,DateFormat,DiffCutOffDate,IsDifferentialImport from DistributorFileTypeSettings, FileTypemaster a, FileTypeMaster b where  a.id=DistributorFileTypeSettings.filetype and b.id=DistributorFileTypeSettings.FileExtension and distributorid ='000000000001356'
11/26/2025 10:37:43 AM : Zip()  ### End
11/26/2025 10:37:43 AM : startProcess()  ### SKY STAR : 2221146 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
11/26/2025 10:37:43 AM : startProcess  ### ENVU_2221146_ADJUSTMENT.TXT file contains only Date range row
11/26/2025 10:37:43 AM : startProcess  ###  FileName - ADJUSTMENT import DateTime -11/26/2025 10:37:43 AM
11/26/2025 10:37:43 AM : startProcess  ###  FileName - CLOSINGSTOCK import DateTime -11/26/2025 10:37:43 AM
11/26/2025 10:37:43 AM : startProcess  ###  FileName - PRODUCT import DateTime -11/26/2025 10:37:43 AM
11/26/2025 10:37:43 AM : startProcess  ###  FileName - PURCHASE import DateTime -11/26/2025 10:37:43 AM
11/26/2025 10:37:43 AM : startProcess  ###  FileName - RETAILER import DateTime -11/26/2025 10:37:43 AM
11/26/2025 10:37:43 AM : startProcess  ###  FileName - SALE import DateTime -11/26/2025 10:37:43 AM
11/26/2025 10:37:43 AM : startProcess()  ###  Data posting done in IMP_StagingData
11/26/2025 10:37:43 AM : startProcess()  ###  Value of isExecuteProcedureForFITBulkImport True
11/26/2025 10:37:43 AM : startProcess()  ###  Procedure execution Started 
11/26/2025 10:37:46 AM : startProcess  ###  Procedure execution End 
11/26/2025 10:37:46 AM : MainForm.cs : StartProcess() Running status and LastRun_EndDateTime of ZylemFileInspectionTool   :  ### Update HelpDesk_ProjectInformation set Running_Status = 0,LastRun_EndDateTime=Getdate() where Info_Key = 'ZylemFileInspectionTool'
11/26/2025 10:37:46 AM : MainForm.cs : StartProcess() Running status and LastRun_EndDateTime of ZylemFileInspectionTool   :  ### Update HelpDesk_ProjectInformation set Running_Status = 0,LastRun_EndDateTime=Getdate() where Info_Key = 'ZylemFileInspectionTool'