Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

How to return byte array output from the script into the pipeline

Hi,
I have implemented a script for decoding an xlsm file but somehow I am facing issue in using the decoded data into the next operator within a pipeline.
I have used macros to store output but it has capability of storing data in the string format.
It would be great if some alternative can be suggested.

Find more posts tagged with

AI Studio

Accepted answers

MartinLiebig

Hi,

I think you want to use something like this:

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.commons.codec.binary.Base64;
import com.rapidminer.operator.Operator;
import com.rapidminer.operator.OperatorDescription;
import com.rapidminer.operator.nio.file.SimpleFileObject;

String originalString = "Just a text";
byte[] decodedBytes = Base64.decodeBase64(originalString);
File tempFile = null;
try {
    tempFile = File.createTempFile("rm-", ".tempFile");
    tempFile.deleteOnExit();
    FileOutputStream fos = new FileOutputStream(tempFile);
    fos.write(decodedBytes);
    fos.close();

} catch (IOException e) {
    throw new RuntimeException(e);
}
SimpleFileObject fileObject = new SimpleFileObject(tempFile);
return fileObject

This give you a purple fileObject which can be used with any other Read operator.

Best,

Martin

All comments

MartinLiebig

Hi,

not sure what "decoded" is, but this is surely a tough one to do with operators. Why can't you just use Read Excel?

If this is a commercial request, please consult support.rapidminer.com so we can assign more resources.

Best,

Martin

KanikaAg15

@MartinLiebig
thanks fore revert. we cannot raise any commerical request. My only limitation is the I have a data within byte array which I need as output from the execute script operator. If you can suggest a method around that would be a great help.

MartinLiebig

What should the output be? a purple file object you can push into Read Excel or so?

KanikaAg15

@MartinLiebig I want to use the output as normal exampleset so that the attributes values can be further utilized in the further pipeline.

MartinLiebig

Can you share an example?

KanikaAg15

@MartinLiebig
Please find the below script. The output that is getting stored in byte array i.e decodedByte. I need that as an output from execute operator and dont want to store the file in local repository.

import java.util.Base64;
import java.io.FileOutputStream;
import java.io.IOException;

public class ExcelFromBase64 {
    public static void writeExcelFromBase64(String base64) throws IOException {
        byte[] decodedBytes = Base64.getDecoder().decode(base64);
        FileOutputStream fos = new FileOutputStream("%{Path}");
        fos.write(decodedBytes);
        fos.close();
    }

    public static void main(String[] args) throws IOException {
        String base64 = "%{base64}";
        writeExcelFromBase64(base64);
    }
}

MartinLiebig

Hi,

I think you want to use something like this:

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.commons.codec.binary.Base64;
import com.rapidminer.operator.Operator;
import com.rapidminer.operator.OperatorDescription;
import com.rapidminer.operator.nio.file.SimpleFileObject;

String originalString = "Just a text";
byte[] decodedBytes = Base64.decodeBase64(originalString);
File tempFile = null;
try {
    tempFile = File.createTempFile("rm-", ".tempFile");
    tempFile.deleteOnExit();
    FileOutputStream fos = new FileOutputStream(tempFile);
    fos.write(decodedBytes);
    fos.close();

} catch (IOException e) {
    throw new RuntimeException(e);
}
SimpleFileObject fileObject = new SimpleFileObject(tempFile);
return fileObject

This give you a purple fileObject which can be used with any other Read operator.

Best,

Martin

KanikaAg15

Hi Martin, I cannot thank you enough. This really helped. A big thanks for your help.