CMD: #htmleditformat( _dirCmd )#
#htmleditformat( _lineOfText )#
Dir Time = #_dirEnd - _dirStart# ms.
Dir & Parse Time = #_dirParseEnd - _dirStart# ms.
select gs1_gln, mfr_name, mfr_id from tblManufacturers with (nolock) where gs1_gln is not null and gs1_syncEnabled = 'Y' select fileId, name, directory, parseStatus, messageId, messageType, messageVersion, dateLastModified , ( select count(*) from tbl_1SYNC_FileInformationProviderGLNs g where g.fileId = f.fileId ) glnCount from tbl_1SYNC_Files f with (nolock) where directory = and name = update tbl_1SYNC_Files set messageId = , creationDateTime = , messageType = , messageVersion = , parseDate = where fileId = and directory = and name = select * from tbl_1SYNC_FileInformationProviderGLNs where fileId = and gln = insert into tbl_1SYNC_FileInformationProviderGLNs ( fileId, gln ) values ( , ) select dataRecipientGLN from tbl_1SYNC_FileInformationProviderGLNs with (nolock) where fileId = update tbl_1SYNC_FileInformationProviderGLNs set dataRecipientGLN = where fileId = insert into tbl_1SYNC_Files( directory, name, size, datelastModified, parseStatus, gln, mfr_id, messageId, creationDateTime, messageType, messageVersion, parseDate ) values( , , , , 'Y', null, null , , , , , ) insert into tbl_1SYNC_FileInformationProviderGLNs ( fileId, gln, dataRecipientGLN ) values ( , , ) insert into tbl_1SYNC_Files( directory, name, size, datelastModified, parseStatus ) values( , , , , 'N' ) Loop Time: #_loopEnd - _loopStart# ms

#_filesPatched# Files Patched

#_filesParsed# Files Parsed

#_filesAdded# Files Added

#_badFiles# Bad Files