Not configured to run....

---> ---> select gs1_gln from tblManufacturers with (nolock) where mfr_id in ( ) and nullif( gs1_gln, '' ) is not null and gs1_syncEnabled = 'Y'

System	PRODUCTIONDEVELOPMENT
GLNs	#htmleditformat( _informationProviderGLN )#ALL
Inbox	#htmleditformat( _inbox )#
Filter	#htmleditformat( _filter )#
Start Date	#htmleditformat( _startDate )#
End Date	#htmleditformat( _endDate )#&##160;
Process Images	#_processImages#

select *, 'N' process, '' GLN, '' Manufacturer from qmd_files where datelastModified >= and dateLastModified < order by dateLastModified ---> select gln from tbl_gs1_GLNs where partnerId = and partnerType = 'MFR' select gs1_gln, mfr_name from tblManufacturers with (nolock) where gs1_gln is not null and gs1_syncEnabled = 'Y' and gs1_gln in ( ) ---> select fileId, directory, name, size, dateLastModified, 'Y' process, messageId, messageType, messageVersion, name + '.xml' as receiptFileName from tbl_1SYNC_Files with (nolock) where messageType = 'catalogueItemNotification' and messageVersion = '2.0' and messageId = and dateLastModified >= and dateLastModified < and fileId in ( select fileId from tbl_1SYNC_FileInformationProviderGLNs with (nolock) where GLN in ( ) ) order by dateLastModified, messageId, fileId

MaxFiles set to #_maxFiles#

select * from qmd_files where process = 'Y' order by dateLastModified

Testing Connection...

#_result#

#_error#

Processing Stopped!

Processing #qmd_files.recordCount# files
select distinct b.batchId, b.batchTime from tbl_1SYNC_Transactions t with (nolock) inner join tbl_1SYNC_Documents d with (nolock) on d.txId = t.txId inner join tbl_EAI_inboundBatches b with (nolock) on b.batchId = d.fseBatchId where t.messageId = and right( t.receiptFileName, CHARINDEX('\', REVERSE(t.receiptFileName))-1 ) =

#lsdateformat( dateLastModified, "MM/DD/YYYY" )# #lstimeformat( dateLastModified, "hh:mm:ssTT" )# - #messageType# #messageVersion# - #htmleditformat( messageId )# - Skipping - Already Batched Today - #valueList( qmd_batchCheck.batchId )#

#lsdateformat( dateLastModified, "MM/DD/YYYY" )# - #messageType# #messageVersion# - #htmleditformat( messageId )#

#_receiverCmd#

Result

#_result#

#_error#

select creationDateTime, parseDate from tbl_1Sync_Files with (nolock) where creationDateTime >= dateAdd( mm,-1,getdate()) and name = update tbl_EAI_InboundBatches set batchTime = where ownerType = 'MSC' and ownerid = 78 and batchid = and status = 'PENDING'

BatchId #_batchid# start time has been updated to: #timeFormat(_batchDateTime, "hh:mm:ss tt")#

Not configured to run....

MSC 78 Batches Created:#numberformat(_Msc78BatchesCreated)#