Hi All, I wanted to convert binary data from database to pdf. Following are the detailed steps Fetch the data from database which is in binary format. Eg In table ABC i have coloumn name as XYZdata which is binary data. Read each of the binary data and convert in to PDFfile. It would be really g…

Hi @sangeethasudha , First, install database activities from manage package Get the table from the database using database activity Use for each activity to loop the datatable Get the binary data and convert to byte Use invoke code activity and pass the converted byte and file name as arguments Ins…

[image] aanandsanraj: Get the binary data and convert to byte Hi @aanandsanraj Thank you for the response. I am actually looking for the 4th step “Get the binary data and convert to byte” . It would be great if you brief it more. Thank you

From database you will get the binary data as string in a column. We cannot directly use that as string, so we need to convert that string to byte. Then only we can save that byte as pdf file.

[image] aanandsanraj: so we need to convert that string to byte I understood the logic but I am not able to implement. Below is the sample table ItemID ItemData 1 0100100 (Binary format) 2 0100100 (Binary format) 3 …

Does binary code holds any pdf file? I thought entire pdf file stored as binary data in database. Please clarify the requirement I might understand it wrongly.

yes your understanding is correct. The entire PDFfile is stored as binary data in database. You have mentioned as to convert from string in to bytes. I am not able to get that coloumn in to string. Could you provide me the steps for this part. so that i can take it from there. Thank you

Please find the attachment Main.xaml (6.6 KB)

Thankyou very much . I incorporated your code and I am sucessfuly able to download the PDF. BUt i am unable to open the file "Its thorwing me a error message as " could not open xyz.pdf becuase it either supported file type or because the file has been damaged(For example it was sent as an email at…

Binary data in to pdf file

Help

aanandsanraj (Anandraj Rajendran) January 7, 2020, 5:48am 10

@sangeethasudha

Did you try to open that file in notepad++? If not please try it and check the result meanwhile I will try myself

HTTP Request Activity - Receiving data as Binary data and need to covert as PDF

Topic		Replies	Views
How to store PDF into database, the column is in nvarcharbinary type Studio studio , question , activities_panel	3	1211	July 28, 2023
Convertir un pdf en varbinary Ask in Your Language question	2	313	May 30, 2024
How to store entite pdf to Byte array (Var binary) Activities pdf , activities , question	1	860	August 2, 2023
Convert binary data to PDF Help excel , uiautomation , activities , question	0	1739	April 17, 2020
HTTP Request Activity - Receiving data as Binary data and need to covert as PDF Studio studio , question , activities_panel	6	866	February 1, 2024

Binary data in to pdf file

Related topics