Flat File Schema Wizard with restriction upto 80 characters per row


hi,

i have create target flat file schema purchase order using wizard, consists of header, body & footer.

the requirement consists of below mentioned things:

  1. each row must consist of 80 characters only.
  2. also, major content in file positional.
  3. in body part, "+" symbol has been used delimiter.

do exact idea of how file looks, please click on url here: https://github.com/gizur/gizurcloud/wiki/system_documentation%23client%23cikab%23sales-order-export

actual file description mentioned along positional details.

in url, detailed explanation of file present, "set file specification".

please let me know how can proceed this.

thanks in advance.

hi abdul,

this can solved following approach,

1) create flat file using flat file wizard considering set file having 1 record. header, detail records , footer in 1 single file. take sample file given in reference link , open in notepad++, join lines. please make sure verify final file specification position per spec. understand, after header, there detail record.there no + symbol before detail record , after have 6 detail records separated + , repeating record (189 type) , footer.

2)you need run flat file wizard , give input file created in step 1. select complete line , split delimiter (+). first detail record under header there no + sign.you need define fields under header , first detail record positions.

3)repeat other detail records , footer. have flat file schema. make sure validate schema against instance , generate new instance , check if matches flat file input.

4) create custom pipeline component add after flat file assembler pipeline component in send pipeline.

this custom component should split file after 80 characters. need add "\r\n" after every 80 chars final output per requirement. can stream way without making whole process memory intensive.

regards,

sajith c p nair



BizTalk Server  >  BizTalk Server General



Comments

Post a Comment

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

having same error microsoft.azure.documents.documentclientexception: message: {"errors":["owner resource not exist"]} , scenario. when deployed webapp azure , try document docdb throws error. docdb exists in azure , contains document looking for. weird local machine(running vs) works fine. i'm using same settings in azure , local. have , idea this. thanks Microsoft Azure  >  Azure Cosmos DB
Read more

RFC_ERROR_SYSTEM_FAILURE with SAP ECC 6 Unicode

hi all, i using biztalk 2006 r2, microsoft biztalk adapter v2.0 mysap business suite sp1 & sql server 2005 database server. we have developed orchestrations communicating sap version 4.7.   currently sap has been upgraded in ecc 6(unicode) system. i have configured new send port on dev server. orchestration can communicate sap ecc 6.0 (non- unicode) system while trying connect sap ecc 6.0 (unicode) getting error. a message sent adapter "sap" on send port "ecc 6 sendport" uri "sap://as:***.**.***.***/**/***/" suspended.   error details: rfc_error_system_failure   messageid:   {b7dd677e-0ef3-480b-835a-d389f2e24179} is there can configure setting unicode ?   thanks in advance     ajay dabhade problem solved: standard table data types appear not unicode compatible in sap ecc 6.0. make rfcgetfunctiondesc raise error. solution: used other data types scratch in rfcs in sap   ajay dabhad...
Read more

C# System.Data.Common DbCommand and getting Datasets from Oracle

i found no oracle specific forum area, decided post here. getting dataset oracle c# system.data.common library's dbcommand seems tricky task. i using command object in project along dbproviderfactory , dbdataadapter because meant allow use same library multiple database providers, , don't have clutter data access layer of project separate classes accessing each individual database provider. my problem is, stored procedures fetching data oracle require refcursor object added in parameters. however, dbtype library not contain definition object. using "object"-type not work. i have read many places not have add refcursor parameter, endless failed attempts @ running command without refcursor object has brought me conclusion leaving out refcursor object not option when using system.data.common library. here coded example connectionstring purposefully left out.                 dbconnection.ope...
Read more