How to insert DataUri in Text to Blob in NAV 2018 AL

(0) Share

Report

Posted on by Olister Rumao

3,967

Hi,

I've created a JavaScript function ControlAdd-in which return a DataUri in Text, and save it in BLOB using AL extensions.
I've tried using Text Datatype but the uri exceeds 250 characters. Thus, cannot store it as a text.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

You can store it as a BLOB and convert/deconvert it as needed. Check here:

[View:https://stackoverflow.com/questions/23150333/html5-javascript-dataurl-to-blob-blob-to-dataurl]

Was this reply helpful? Yes No
Olister Rumao 3,967 on at

Like (0)

Report

Hi Stefano,

I've converted canvas to DataUri which is a text but since it exceeds 250 characters, it cannot be stored as text. Is it possible to convert Text having length >2500 to blob in AL??

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Text fields on tables have this limit. I think you can also directly save the Canvas as BLOB from JS. There are samples to do so on the net.

Was this reply helpful? Yes No
Olister Rumao 3,967 on at

Like (0)

Report

Hi Stefano,

Tried that as well but there is event trigger from JS to AL which doesnt allow BLOB as its parameter.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

What event do you mean? It's quite difficult without seeing the code.

Another idea could be to save the image as a temporary file and then from AL store it on a BLOB field.

Was this reply helpful? Yes No
Olister Rumao 3,967 on at

Like (0)

Report

Let me explain the scenario

Scenario:

In NAV 2017 we used a Signature Control Add-in. We created the signature add-in with its core as a canvas which was created using Javascript. The interaction with the Javascript was done with the help of events i.e ClearSignature Event, AcceptSignature Event. These events send the data in the form MemoryStream. In NAV 2018 we've used DataUri to send data via the AcceptSignature Event. As the event which is called from Javascript doesn't allow parameter as a BLOB file in AL.

Is there a way to convert the DataUri which is greater than 2500 characters be converted to BLOB?

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

You can save the DataUri in a BigText variable and then save it to a BLOB field. Something like:

myTable.BlobField.CREATEOUTSTREAM(outstr);

varBigText.WRITE(outstr);

myTable.INSERT;

Was this reply helpful? Yes No
Olister Rumao 3,967 on at

Like (0)

Report

Hi Stefano,

It worked. But I'm facing another issue as to convert the DataUri to Memory Stream. Can this be done through azure functions assuming that we can convert in some way and then store it as a BLOB.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Yes Azure Function could be a solution for converting MemoryStream. In NAV 2018 you've also codeunit 704 for handling MemoryStream objects.

Was this reply helpful? Yes No

Community site session details

How to insert DataUri in Text to Blob in NAV 2018 AL

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates

Community site session details

How to insert DataUri in Text to Blob in NAV 2018 AL

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates