nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Siemens Community Catalyst Program

The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.

Nominate Now

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

KanikaAg15

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.

Quick Links

Upcoming Events

Advancing power electronics design with Simcenter PSIM and High-Performance Computing
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Getting Started with Faster Motor Building in Simcenter Simlab
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Practical hybrid solver workflows in Simcenter Feko
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…

View all community events