select formatId, formatName from tbl_EAI_inboundFileFormats where formatName = 'STOCKING_GUIDE_TXT' and ownerId = 0 and ownerType = 'BRO' SELECT case when bsr.fspro_userid is not null then bsr.firstName else case when rm.fspro_userid is not null then rm.firstName else pm.firstName end end cmFirstName, case when bsr.fspro_userid is not null then bsr.lastName else case when rm.fspro_userid is not null then rm.lastName else pm.lastName end end cmLastName, case when bsr.fspro_userid is not null then bsr.email else case when rm.fspro_userid is not null then rm.email else pm.email end end cmEmail, coalesce( bsr.fspro_userid, coalesce( rm.fspro_userid, pm.fspro_userid )) cmUserId FROM tbl_CDR_Distributors cdr INNER JOIN tbl_TER_Territories t ON t.territoryid = cdr.cdr_territoryid AND t.ownerid = cdr.ownerid AND t.fsl_tablecode = cdr.fsl_tablecode left outer join tbl_FSPro_Members pm on pm.fspro_userId = t.primaryManager and pm.ownerId = t.ownerId and pm.fsl_tablecode = t.fsl_tablecode left outer join tbl_FSpro_Members bsr on bsr.fspro_userid = cdr.mfr_bsr_id left outer join tbl_SMA_BrokerOfficeLink sma on sma.territoryId = t.territoryId and sma.primaryOffice = 'Y' left outer join tbl_SEC_MemGrpLink rml on rml.partnerId = t.ownerId and rml.partnerTyp = t.fsl_tablecode and rml.brokerOfficeId = sma.brokerOfficeID and rml.groupId = left outer join tbl_FSpro_Members rm on rm.fspro_userid = rml.fspro_userId WHERE cdr.fsl_tablecode = AND cdr.ownerid = and cdr.cdr_recordId =

Importing Stocking Guide is not immediate. Once the import has been started you can perform other functions in the portal. An email will be sent to you when the import is complete. For file format instructions, please see the 'View Format' link below.

Your request to import Stocking Guide Status has been received, validated and queued for processing.

Your request will be processed within 24 hours. Once your request has been processed you will be notified by email.

fileReader.init( qmd_batch.fileName ); bufferedReader.init( fileReader ); reader = bufferedReader; multiLineReader.init( bufferedReader, _fileFormat.multiLineStartRegEx ); reader = multiLineReader; _heading = reader.readLine(); reader.close(); if( isDefined( "multiLineReader" )) { StructDelete( variables, "multiLineReader" ); } StructDelete( variables, "bufferedReader" ); StructDelete( variables, "fileReader" );

Your import request CANNOT BE PROCESSED at this time due to format incompatibilities.

Please review the information below and make the necessary adjustments to the import file before uploading it again.

Click here to view the Stocking Guide Import file format specification.
File Layout Problems
Field # Name Type Len. Message
#right( "000#currentRow#", 3 )#XXX #fieldName# #fieldDataType#&##160; #fieldLength#&##160; #_message#&##160;
select message, count(*) lineCount, min( lineNumber ) firstLine from tbl_EAI_InboundBatchMessages where batchId = and lineNumber > 0 group by message order by message
File Content Problems
Message First Line Total Lines
#htmleditformat( message )# #firstLine# #lineCount#