11/24/2025 7:04:32 AM : FileInspectionTool Version ### IFI 21.0.3 ### Release Date 27-Nov-2024 11/24/2025 7:04:33 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/24/2025 7:04:33 AM : startProcess ### FIT Tool run for FITBulkImport - ***Start*** 11/24/2025 7:04:33 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','9067109','9067110','IN01-000035') union select '000000000000000' ,'COMPANYPRIM','COMPANYPRIM' from pdistributor,DistributorFileTypeSettings where DistributorFileTypeSettings.distributorid='000000000000000' order by pdistributor.distributorid 11/24/2025 7:04:33 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/24/2025 7:04:33 AM : Zip() ### End 11/24/2025 7:04:33 AM : startProcess() ### COMPANYPRIM : COMPANYPRIM Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:04:33 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 ='000000000000351' 11/24/2025 7:04:33 AM : Zip() ### End 11/24/2025 7:04:33 AM : startProcess() ### AADITYA PEST SPECIALIZERS PVT LTD. MR AKHILESH K G RAO : 9067110 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:04:33 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 ='000000000000492' 11/24/2025 7:04:33 AM : Zip() ### End 11/24/2025 7:04:33 AM : startProcess() ### M/S KRISHI SEWA KENDRA : 9067109 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:04:33 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/24/2025 7:04:33 AM : Zip() ### End 11/24/2025 7:04:33 AM : startProcess() ### SKY STAR : 2221146 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:04:33 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 ='000000000001369' 11/24/2025 7:04:33 AM : Zip() ### End 11/24/2025 7:04:33 AM : startProcess() ### Aadi Enterprises : IN01-000035 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:04:33 AM : startProcess ### ENVU_2221146_ADJUSTMENT.TXT file contains only Date range row 11/24/2025 7:04:33 AM : startProcess ### FileName - ADJUSTMENT import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - CLOSINGSTOCK import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - PRODUCT import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - PURCHASE import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - RETAILER import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - SALE import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - TEMPLATE1 import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### ENVU_9067109_ADJUSTMENT.TXT file contains only Date range row 11/24/2025 7:04:33 AM : startProcess ### FileName - ADJUSTMENT import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - CLOSINGSTOCK import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - PRODUCT import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - PURCHASE import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - RETAILER import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - SALE import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - TEMPLATE1 import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### ENVU_9067110_ADJUSTMENT.TXT file contains only Date range row 11/24/2025 7:04:33 AM : startProcess ### FileName - ADJUSTMENT import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - CLOSINGSTOCK import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - PRODUCT import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - PURCHASE import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - RETAILER import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - SALE import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess ### FileName - TEMPLATE1 import DateTime -11/24/2025 7:04:33 AM 11/24/2025 7:04:33 AM : startProcess() ### Data posting done in IMP_StagingData 11/24/2025 7:04:33 AM : startProcess() ### Value of isExecuteProcedureForFITBulkImport True 11/24/2025 7:04:33 AM : startProcess() ### Procedure execution Started 11/24/2025 7:04:37 AM : startProcess ### Procedure execution End 11/24/2025 7:04:37 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/24/2025 7:04:37 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/24/2025 7:36:46 AM : FileInspectionTool Version ### IFI 21.0.3 ### Release Date 27-Nov-2024 11/24/2025 7:36:46 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/24/2025 7:36:46 AM : startProcess ### FIT Tool run for FITBulkImport - ***Start*** 11/24/2025 7:36:46 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','IN01-000035') union select '000000000000000' ,'COMPANYPRIM','COMPANYPRIM' from pdistributor,DistributorFileTypeSettings where DistributorFileTypeSettings.distributorid='000000000000000' order by pdistributor.distributorid 11/24/2025 7:36:46 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/24/2025 7:36:47 AM : Zip() ### End 11/24/2025 7:36:47 AM : startProcess() ### COMPANYPRIM : COMPANYPRIM Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:36:47 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/24/2025 7:36:47 AM : Zip() ### End 11/24/2025 7:36:47 AM : startProcess() ### SKY STAR : 2221146 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:36:47 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 ='000000000001369' 11/24/2025 7:36:47 AM : Zip() ### End 11/24/2025 7:36:47 AM : startProcess() ### Aadi Enterprises : IN01-000035 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:36:47 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO -> strQuery : ### Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = 'IN01-000035'; Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '2221146'; 11/24/2025 7:36:47 AM : startProcess ### ENVU_2221146_ADJUSTMENT.TXT file contains only Date range row 11/24/2025 7:36:47 AM : startProcess ### FileName - ADJUSTMENT import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - CLOSINGSTOCK import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - PRODUCT import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - PURCHASE import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - RETAILER import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - SALE import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - TEMPLATE1 import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### ENVU_IN01-000035_ADJUSTMENT.TXT file contains only Date range row 11/24/2025 7:36:47 AM : startProcess ### FileName - ADJUSTMENT import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - CLOSINGSTOCK import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - PRODUCT import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - PURCHASE import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - RETAILER import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - SALE import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess ### FileName - TEMPLATE1 import DateTime -11/24/2025 7:36:47 AM 11/24/2025 7:36:47 AM : startProcess() ### Data posting done in IMP_StagingData 11/24/2025 7:36:47 AM : startProcess() ### Value of isExecuteProcedureForFITBulkImport True 11/24/2025 7:36:47 AM : startProcess() ### Procedure execution Started 11/24/2025 7:36:50 AM : startProcess ### Procedure execution End 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO -> dtIFIRejected.Rows.Count : ### 2 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() strFileName: ### ENVU_2221146 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_ADJUSTMENT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_ADJUSTMENT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_ADJUSTMENT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_CLOSINGSTOCK.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_CLOSINGSTOCK.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_CLOSINGSTOCK.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_PRODUCT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_PRODUCT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_PRODUCT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_PURCHASE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_PURCHASE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_PURCHASE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_RETAILER.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_RETAILER.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_RETAILER.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_SALE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_SALE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_SALE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_TEMPLATE1.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_TEMPLATE1.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_TEMPLATE1.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() strFileName: ### ENVU_IN01-000035 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_IN01-000035_ADJUSTMENT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_IN01-000035_ADJUSTMENT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_IN01-000035_ADJUSTMENT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_IN01-000035_CLOSINGSTOCK.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_IN01-000035_CLOSINGSTOCK.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_IN01-000035_CLOSINGSTOCK.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_IN01-000035_PRODUCT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_IN01-000035_PRODUCT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_IN01-000035_PRODUCT.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_IN01-000035_PURCHASE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_IN01-000035_PURCHASE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_IN01-000035_PURCHASE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_IN01-000035_RETAILER.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_IN01-000035_RETAILER.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_IN01-000035_RETAILER.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_IN01-000035_SALE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_IN01-000035_SALE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_IN01-000035_SALE.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_IN01-000035_TEMPLATE1.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_IN01-000035_TEMPLATE1.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_IN01-000035_TEMPLATE1.TXT 11/24/2025 7:36:50 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method Info -> update if file is rejected strQuery : ### Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = 'IN01-000035'; 11/24/2025 7:36:50 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/24/2025 7:36:50 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/24/2025 7:39:15 AM : FileInspectionTool Version ### IFI 21.0.3 ### Release Date 27-Nov-2024 11/24/2025 7:39:15 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/24/2025 7:39:15 AM : startProcess ### FIT Tool run for FITBulkImport - ***Start*** 11/24/2025 7:39:15 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/24/2025 7:39:15 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/24/2025 7:39:15 AM : Zip() ### End 11/24/2025 7:39:15 AM : startProcess() ### COMPANYPRIM : COMPANYPRIM Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:39:15 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/24/2025 7:39:15 AM : Zip() ### End 11/24/2025 7:39:15 AM : startProcess() ### SKY STAR : 2221146 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:39:15 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO -> dtIFIRejected.Rows.Count : ### 1 11/24/2025 7:39:15 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() strFileName: ### ENVU_2221146 11/24/2025 7:39:15 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/24/2025 7:39:15 AM : startProcess ### ENVU_2221146_ADJUSTMENT.TXT file contains only Date range row 11/24/2025 7:39:15 AM : startProcess ### FileName - ADJUSTMENT import DateTime -11/24/2025 7:39:15 AM 11/24/2025 7:39:15 AM : startProcess ### FileName - CLOSINGSTOCK import DateTime -11/24/2025 7:39:15 AM 11/24/2025 7:39:16 AM : startProcess ### FileName - PRODUCT import DateTime -11/24/2025 7:39:16 AM 11/24/2025 7:39:16 AM : startProcess ### FileName - PURCHASE import DateTime -11/24/2025 7:39:16 AM 11/24/2025 7:39:16 AM : startProcess ### FileName - RETAILER import DateTime -11/24/2025 7:39:16 AM 11/24/2025 7:39:16 AM : startProcess ### FileName - SALE import DateTime -11/24/2025 7:39:16 AM 11/24/2025 7:39:16 AM : startProcess ### FileName - TEMPLATE1 import DateTime -11/24/2025 7:39:16 AM 11/24/2025 7:39:16 AM : startProcess() ### Data posting done in IMP_StagingData 11/24/2025 7:39:16 AM : startProcess() ### Value of isExecuteProcedureForFITBulkImport True 11/24/2025 7:39:16 AM : startProcess() ### Procedure execution Started 11/24/2025 7:39:18 AM : startProcess ### Procedure execution End 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO -> dtIFIRejected.Rows.Count : ### 1 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() strFileName: ### ENVU_2221146 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_ADJUSTMENT.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_ADJUSTMENT.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_ADJUSTMENT.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_CLOSINGSTOCK.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_CLOSINGSTOCK.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_CLOSINGSTOCK.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_PRODUCT.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_PRODUCT.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_PRODUCT.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_PURCHASE.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_PURCHASE.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_PURCHASE.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_RETAILER.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_RETAILER.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_RETAILER.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_SALE.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_SALE.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_SALE.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_TEMPLATE1.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_TEMPLATE1.TXT 11/24/2025 7:39:18 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_TEMPLATE1.TXT 11/24/2025 7:39:18 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/24/2025 7:39:18 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/24/2025 7:39:18 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/24/2025 7:42:36 AM : FileInspectionTool Version ### IFI 21.0.3 ### Release Date 27-Nov-2024 11/24/2025 7:42:36 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/24/2025 7:42:36 AM : startProcess ### FIT Tool run for FITBulkImport - ***Start*** 11/24/2025 7:42:36 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/24/2025 7:42:36 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/24/2025 7:42:36 AM : Zip() ### End 11/24/2025 7:42:36 AM : startProcess() ### COMPANYPRIM : COMPANYPRIM Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:42:36 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/24/2025 7:42:37 AM : Zip() ### End 11/24/2025 7:42:37 AM : startProcess() ### SKY STAR : 2221146 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\ 11/24/2025 7:42:37 AM : startProcess ### ENVU_2221146_ADJUSTMENT.TXT file contains only Date range row 11/24/2025 7:42:37 AM : startProcess ### FileName - ADJUSTMENT import DateTime -11/24/2025 7:42:37 AM 11/24/2025 7:42:37 AM : startProcess ### FileName - CLOSINGSTOCK import DateTime -11/24/2025 7:42:37 AM 11/24/2025 7:42:37 AM : startProcess ### FileName - PRODUCT import DateTime -11/24/2025 7:42:37 AM 11/24/2025 7:42:37 AM : startProcess ### FileName - PURCHASE import DateTime -11/24/2025 7:42:37 AM 11/24/2025 7:42:37 AM : startProcess ### FileName - RETAILER import DateTime -11/24/2025 7:42:37 AM 11/24/2025 7:42:37 AM : startProcess ### FileName - SALE import DateTime -11/24/2025 7:42:37 AM 11/24/2025 7:42:37 AM : startProcess ### FileName - TEMPLATE1 import DateTime -11/24/2025 7:42:37 AM 11/24/2025 7:42:37 AM : startProcess() ### Data posting done in IMP_StagingData 11/24/2025 7:42:37 AM : startProcess() ### Value of isExecuteProcedureForFITBulkImport True 11/24/2025 7:42:37 AM : startProcess() ### Procedure execution Started 11/24/2025 7:42:39 AM : startProcess ### Procedure execution End 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO -> dtIFIRejected.Rows.Count : ### 1 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() strFileName: ### ENVU_2221146 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_ADJUSTMENT.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_ADJUSTMENT.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_ADJUSTMENT.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_CLOSINGSTOCK.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_CLOSINGSTOCK.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_CLOSINGSTOCK.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_PRODUCT.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_PRODUCT.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_PRODUCT.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_PURCHASE.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_PURCHASE.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_PURCHASE.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_RETAILER.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_RETAILER.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_RETAILER.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_SALE.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_SALE.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_SALE.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() before if condition value fi : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection\ENVU_2221146_TEMPLATE1.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() After if condition value str ReadyFilesForInspectionPath : ### E:\Bayer\Zylem\ZylemImportFolders\ReadyFilesForInspection/ENVU_2221146_TEMPLATE1.TXT 11/24/2025 7:42:39 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO strRejectedPath : ### E:\Bayer\Zylem\ZylemImportFolders\Rejected\ENVU_2221146_TEMPLATE1.TXT 11/24/2025 7:42:39 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/24/2025 7:42:39 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/24/2025 7:42:39 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'