8/1/2026 11:50:06 AM : FileInspectionTool Version  ### IFI 21.0.3 ### Release Date 27-Nov-2024
8/1/2026 11:50:06 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'
8/1/2026 11:50:06 AM : startProcess  ###  FIT Tool run for FITBulkImport - ***Start***
8/1/2026 11:50:06 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 ('722734','IN01-000041') union select '000000000000000' ,'COMPANYPRIM','COMPANYPRIM' from pdistributor,DistributorFileTypeSettings  where DistributorFileTypeSettings.distributorid='000000000000000'  order by pdistributor.distributorid
8/1/2026 11:50:06 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'
8/1/2026 11:50:06 AM : Zip()  ### End
8/1/2026 11:50:06 AM : startProcess()  ### COMPANYPRIM : COMPANYPRIM Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
8/1/2026 11:50:06 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 ='000000000000814'
8/1/2026 11:50:06 AM : Zip()  ### End
8/1/2026 11:50:06 AM : startProcess()  ### Mukesh Seeds & Gen.Suppliers : 722734 Zip file created on path - E:\Bayer\Zylem\ZylemImportFolders\MailUploadedData\
8/1/2026 11:50:06 AM : MainForm.cs : MoveFilesFromReadyFilesForInspection() method INFO -> strQuery :  ###  Update IMP_IFI_BulkImportingLogCompleted set IsFilesMovedInWholeFileBackup = 1 where ClientAlias = 'ENVU' and ERPCode = '2221146';
8/1/2026 11:50:06 AM : startProcess  ### ENVU_722734_ADJUSTMENT.TXT file contains only Date range row
8/1/2026 11:50:06 AM : startProcess  ###  FileName - ADJUSTMENT import DateTime -8/1/2026 11:50:06 AM
8/1/2026 11:50:06 AM : startProcess  ###  FileName - CLOSINGSTOCK import DateTime -8/1/2026 11:50:06 AM
8/1/2026 11:50:06 AM : startProcess  ###  FileName - DISTINFO import DateTime -8/1/2026 11:50:06 AM
8/1/2026 11:50:06 AM : startProcess  ###  FileName - PRODUCT import DateTime -8/1/2026 11:50:06 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - PURCHASE import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - RETAILER import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - SALE import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - TALLYTCPSTATUS import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - TEMPLATE1 import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - ADJUSTMENT import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - CLOSINGSTOCK import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - PRODUCT import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - PURCHASE import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - RETAILER import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - SALE import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - TALLYTCPSTATUS import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess  ###  FileName - TEMPLATE1 import DateTime -8/1/2026 11:50:07 AM
8/1/2026 11:50:07 AM : startProcess()  ###  Data posting done in IMP_StagingData
8/1/2026 11:50:07 AM : startProcess()  ###  Value of isExecuteProcedureForFITBulkImport True
8/1/2026 11:50:07 AM : startProcess()  ###  Procedure execution Started 
8/1/2026 11:50:13 AM : startProcess  ###  Procedure execution End 
8/1/2026 11:50:14 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'
8/1/2026 11:50:14 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'