0 votes
61 views
by (10.6k points)

1 Answer

0 votes
by (10.6k points)
 
Best answer
You can use the regular OOB Document upload control which binds to a DocumentInfo object, from this bound object you can get the content of the uploaded document as follows

Using Content Integration Pallete Item retrieve the contentStream by passing in the documentid which is available in the DocumentInfo Object

tw.local.BPMDocument[0].docId

The content stream can be processed as follows

var byteValue = Packages.java.lang.String(tw.local.contentStream.content).getBytes();

we need to base64 decode the content

var content = Packages.org.apache.commons.codec.binary.Base64.decodeBase64(byteValue);

tw.local.csvcontent = new java.lang.String(content, 'UTF-8');
you can try other encodings like UTF-16 or UTF32 also if the ccontent is not readable

after that you can split the csvcontent into a array of lines

var csvlines = tw.local.csvcontent.split("\n");

you can further split the individual lines based on a delimiter and then process them

Related questions

0 votes
0 answers 47 views
0 votes
1 answer 131 views
0 votes
1 answer 46 views
0 votes
0 answers 263 views
0 votes
0 answers 15 views
0 votes
0 answers 58 views
0 votes
0 answers 23 views
0 votes
0 answers 27 views
0 votes
0 answers 16 views
0 votes
2 answers 584 views
0 votes
1 answer 28 views
0 votes
1 answer 123 views

494 questions

404 answers

81 comments

1.6k users

Created By Dosvak LLC (WWW.DOSVAK.COM)
Our Public Git Repository

Dosvak UI Toolkit --- Download --- Demo

Subscribe us at

Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
...