0 votes
258 views
by (16k points)

1 Answer

0 votes
by (16k 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 76 views
0 votes
1 answer 279 views
0 votes
1 answer 99 views
0 votes
0 answers 102 views
0 votes
0 answers 97 views
0 votes
0 answers 47 views
0 votes
0 answers 44 views
0 votes
0 answers 29 views
0 votes
2 answers 1.1k views
0 votes
1 answer 203 views

580 questions

482 answers

85 comments

1.7k users

Dosvak IBM BPM /BAW Products, Download Evaluation
Process & Performance Tools Process & Performance Tools
Code Analyzer Code Analyzer
UI Toolkit UI Toolkit
Integration Monitoring Integration Monitoring
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.
Created by Dosvak LLC
Our Youtube Channel
...