Answers to: how can i read File from Database

Comment by Reto Weiss on Reto Weiss's answer

Reto Weiss — Fri, 09 Jun 2017 05:16:35 -0400

Hi Eugene

This seems to be more a support topic than a simple Q&A now. Can we continue this on our Support channel? To do so please send a mail to ivy@axonivy.com.

Regards

Reto Weiss, Axon.ivy Support

Comment by Eugene on Reto Weiss's answer

Eugene — Thu, 08 Jun 2017 12:59:10 -0400

Hi,

thank you very much for your great support.

Cast a objekt to binary is working now. But if I download the file (tried with text and PDF files) by using DefaultStreamedContent, I am not able to open it, because there are some special characters: ¨Ìsr'ch.ivyteam.ivy.scripting.objects.Binary[bytest[Bxpur[B¨Û¯T‡xpTestHalloTest

It seems that the encoding is wrong.

Best Regards, Eugene

Answer by Reto Weiss

Reto Weiss — Thu, 08 Jun 2017 11:36:52 -0400

You can do it like this:

Binary binary = in.Data.document.document.getField("File") as Binary;
File file = new File(in.Data.document.document.getField("Name").toString());
file.writeBinary(binary);

You first have to cast the Object returned from getField to a Binary using the as operator of IvyScript

Regards

Reto Weiss, Axon.ivy Support

Comment by Eugene on metehan's question

Eugene — Thu, 08 Jun 2017 08:22:31 -0400

We save the file over the database process element as a blob with in.file.readBinary() Runtime log by using in.Data.document.document.getField("File").getClass().toString() give us: class ch.ivyteam.ivy.scripting.objects.Binary I tried this: File file = new File(in.data.document.document.getField("Name").toString()); file.writeBinary(in.Data.document.document.getField("File")); But I get the following error: Method writeBinary(Object) for class file of classloader org.eclipse.osgi.internal.loader.EquinoxClassLoader@44c54463[ch.ivyteam.ivy.scripting.objects:6.6.1.201705151238(id=84)] not found.

Comment by Reto Weiss on metehan's question

Reto Weiss — Thu, 08 Jun 2017 02:38:47 -0400

Object can be anything. What is the type of the Object returned by getField() at runtime? You can log that by the following code: ivy.log.info(in.Data.document.document.getField("File").getClass().toString()) If we know the type that is returned there we can find a solution to store the data to a file.

Comment by metehan on metehan's question

metehan — Wed, 07 Jun 2017 03:34:19 -0400

Yes the Record is the parameter. I would like to convert the object from the record into a file Type.

Comment by Reto Weiss on metehan's question

Reto Weiss — Wed, 07 Jun 2017 02:45:12 -0400

Do your read the Record with the Database Step process element?