Export Blob Field

pschartz

Hello, I want to export a compressed Blob field to a file (in a decompressed state) so I can upload it to a MySQL db. The Data in the field are XML Files. I do only have read access to the SQL Server, therefore I cannot change any property neither create a NAV page etc. Please help. Regards Philippe

Slawek_Guzek

Not possible in old NAV.

Versions pre 2013 use bespoke compression alghoritm, so the only way is to make NAV to decompress the field before "plain text" data become available on the SQL Server table level.

If you can't change anything in your production database install demo Cronus side-by-side, create or modify a table there which could keep your BLOB data, copy data between databases (even using a SQL query) and then change table definition in Cronus setting Compressed to No. NAV Client will decompress the data for you. You will be then copy uncompressed data to MySQL database.

Unfortunately such a workaround is only good for one-off excercise of extracting data from NAV database.

pschartz

Hi @Slawek_Guzek

many thanks for your return.
We're using Microsoft Dynamics NAV 2015 ... so what do you call "old NAV" ?

Regards

Slawek_Guzek

You have posted in "Navision Classic Client" - so I've assumed you are talking about NAV 2009 R2 or a prior version, as "Navision Classic Client" is for posting issues regarding thses versions only.

NAV 2013 and onwards BLOBs can be decompressed using C# methods. Read this to find more details and sample C# code acceesing data in compressed BLOB fields outside NAV

pschartz

Well as 2015 is 3 years ago, I taught it would already be a Classic product
Thanks I will have a look at this post ... but ... actually I'm looking for a webapp implementation, so C# won't do it

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]