11/27/2025 7:07:58 AM : FileInspectionTool Version  ### IFI 21.0.3 ### Release Date 27-Nov-2024
11/27/2025 7:07:58 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/27/2025 7:07:58 AM : startProcess  ###  FIT Tool run for FITBulkImport - ***Start***
11/27/2025 7:07:58 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/27/2025 7:07:58 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/27/2025 7:07:58 AM : Zip()  ### End
11/27/2025 7:07:58 AM : startProcess()  ### COMPANYPRIM : COMPANYPRIM Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
11/27/2025 7:07:58 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/27/2025 7:07:58 AM : Zip()  ### End
11/27/2025 7:07:58 AM : startProcess()  ### SKY STAR : 2221146 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
11/27/2025 7:07:58 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO -> strQuery :  ###  Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '2221146';
11/27/2025 7:07:58 AM : startProcess  ### ENVU_2221146_ADJUSTMENT.TXT file contains only Date range row
11/27/2025 7:07:58 AM : startProcess  ###  FileName - ADJUSTMENT import DateTime -11/27/2025 7:07:58 AM
11/27/2025 7:07:58 AM : startProcess  ###  FileName - CLOSINGSTOCK import DateTime -11/27/2025 7:07:58 AM
11/27/2025 7:07:58 AM : startProcess  ###  FileName - PRODUCT import DateTime -11/27/2025 7:07:58 AM
11/27/2025 7:07:58 AM : startProcess  ###  FileName - PURCHASE import DateTime -11/27/2025 7:07:58 AM
11/27/2025 7:07:58 AM : startProcess  ###  FileName - RETAILER import DateTime -11/27/2025 7:07:58 AM
11/27/2025 7:07:58 AM : startProcess  ###  FileName - SALE import DateTime -11/27/2025 7:07:58 AM
11/27/2025 7:07:58 AM : startProcess()  ###  Data posting done in IMP_StagingData
11/27/2025 7:07:58 AM : startProcess()  ###  Value of isExecuteProcedureForFITBulkImport True
11/27/2025 7:07:58 AM : startProcess()  ###  Procedure execution Started 
11/27/2025 7:08:00 AM : startProcess  ###  Procedure execution End 
11/27/2025 7:08:00 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/27/2025 7:08:00 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/27/2025 7:55:43 AM : FileInspectionTool Version  ### IFI 21.0.3 ### Release Date 27-Nov-2024
11/27/2025 7:55:44 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/27/2025 7:55:44 AM : startProcess  ###  FIT Tool run for FITBulkImport - ***Start***
11/27/2025 7:55:44 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/27/2025 7:55:44 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/27/2025 7:55:44 AM : Zip()  ### End
11/27/2025 7:55:44 AM : startProcess()  ### COMPANYPRIM : COMPANYPRIM Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
11/27/2025 7:55:44 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/27/2025 7:55:44 AM : Zip()  ### End
11/27/2025 7:55:44 AM : startProcess()  ### SKY STAR : 2221146 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
11/27/2025 7:55:44 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO -> strQuery :  ###  Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '2221146';
11/27/2025 7:55:44 AM : startProcess  ### ENVU_2221146_ADJUSTMENT.TXT file contains only Date range row
11/27/2025 7:55:44 AM : startProcess  ###  FileName - ADJUSTMENT import DateTime -11/27/2025 7:55:44 AM
11/27/2025 7:55:44 AM : startProcess  ###  FileName - CLOSINGSTOCK import DateTime -11/27/2025 7:55:44 AM
11/27/2025 7:55:44 AM : startProcess  ###  FileName - PRODUCT import DateTime -11/27/2025 7:55:44 AM
11/27/2025 7:55:44 AM : startProcess  ###  FileName - PURCHASE import DateTime -11/27/2025 7:55:44 AM
11/27/2025 7:55:44 AM : startProcess  ###  FileName - RETAILER import DateTime -11/27/2025 7:55:44 AM
11/27/2025 7:55:44 AM : startProcess  ###  FileName - SALE import DateTime -11/27/2025 7:55:44 AM
11/27/2025 7:55:44 AM : startProcess()  ###  Data posting done in IMP_StagingData
11/27/2025 7:55:44 AM : startProcess()  ###  Value of isExecuteProcedureForFITBulkImport True
11/27/2025 7:55:44 AM : startProcess()  ###  Procedure execution Started 
11/27/2025 7:55:46 AM : startProcess  ###  Procedure execution End 
11/27/2025 7:55: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/27/2025 7:55: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/27/2025 8:04:13 AM : FileInspectionTool Version  ### IFI 21.0.3 ### Release Date 27-Nov-2024
11/27/2025 8:04:13 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/27/2025 8:04:13 AM : startProcess  ###  FIT Tool run for FITBulkImport - ***Start***
11/27/2025 8:04:13 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/27/2025 8:04:13 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/27/2025 8:04:13 AM : Zip()  ### End
11/27/2025 8:04:13 AM : startProcess()  ### COMPANYPRIM : COMPANYPRIM Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
11/27/2025 8:04:13 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/27/2025 8:04:13 AM : Zip()  ### End
11/27/2025 8:04:13 AM : startProcess()  ### SKY STAR : 2221146 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
11/27/2025 8:04:13 AM : startProcess  ### ENVU_2221146_ADJUSTMENT.TXT file contains only Date range row
11/27/2025 8:04:13 AM : startProcess  ###  FileName - ADJUSTMENT import DateTime -11/27/2025 8:04:13 AM
11/27/2025 8:04:13 AM : startProcess  ###  FileName - CLOSINGSTOCK import DateTime -11/27/2025 8:04:13 AM
11/27/2025 8:04:13 AM : startProcess  ###  FileName - PRODUCT import DateTime -11/27/2025 8:04:13 AM
11/27/2025 8:04:13 AM : startProcess  ###  FileName - PURCHASE import DateTime -11/27/2025 8:04:13 AM
11/27/2025 8:04:13 AM : startProcess  ###  FileName - RETAILER import DateTime -11/27/2025 8:04:13 AM
11/27/2025 8:04:13 AM : startProcess  ###  FileName - SALE import DateTime -11/27/2025 8:04:13 AM
11/27/2025 8:04:13 AM : startProcess()  ###  Data posting done in IMP_StagingData
11/27/2025 8:04:13 AM : startProcess()  ###  Value of isExecuteProcedureForFITBulkImport True
11/27/2025 8:04:13 AM : startProcess()  ###  Procedure execution Started 
11/27/2025 8:04:16 AM : startProcess  ###  Procedure execution End 
11/27/2025 8:04:16 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/27/2025 8:04:16 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'