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

Comparing PWM control strategies - Impact on E-Motor performance
Join us for a community conversation on Pulse Width Modulation (PWM), a fundamental technique in electric motor control, and explore how different PWM strategies can yield significantly different results. This webinar provides a comparative analysis of various PWM methods and their effects on motor efficiency, torque…
Advanced Iterative Solver (AIS) for large models in Simcenter Feko
Join us for a community conversation to discover the Advanced Iterative Solver(AIS) in Simcenter Feko and its application to electrically large and computationally demanding electromagnetic models. The session will provide a general overview of how iterative solution methods can help improve efficiency of large scale…
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…

View all community events