How do I encrypt csv file generated from NAV database through C/AL coding

dipanwita_c

I am using one report (can switch to XMLPort if needed) to export the data in csv format. The exported data should be in encrypted format which can not be read / edited by people. The data exporting is bank details which has to be decrypted while uploading to the Bank web.

NAV version : 2013
SQL version : 2012

Kowa

You can use PowerShell for this:
https://gallery.technet.microsoft.com/scriptcenter/PowerShell-Encryption-45709b87
To verify the integrity of the file:
https://gallery.technet.microsoft.com/PowerShell-File-Checksum-e57dcd67

Kowa

You can use PowerShell for this:
https://gallery.technet.microsoft.com/scriptcenter/PowerShell-Encryption-45709b87
To verify the integrity of the file:
https://gallery.technet.microsoft.com/PowerShell-File-Checksum-e57dcd67

dipanwita_c

Hi Kowa, thanks for your suggestion... I will try this out at my end with the file and update if this works for the integration or not

dipanwita_c

Hi Kowa, I tried using the examples, but it seems cannot use as I am not having any RSA certificate with private key in my machine. I could encrypt my file using Navision encryption system though. However, I am not able to decrypt the file. Any idea on the working on Navision encryption in 2013 ?

Kowa

Example script No. 2 uses AES Encryption. Works fine for me, without a RSA key.

dipanwita_c

Hi Kowa, actually example 4 is nearer to my requirement... it requires RSA key... the bank specifications are as follows:

1) Type : RSA
2) Size : 4096/4096 or 2048/2048
3) Expiry Date : Required (Recommended life 3 years)
4) Ciphers Allowed : AES , AES256 (Preferred: AES)
5) Mode : ASCII mode or Binary mode

Kowa

RSA Keys can be generated with OpenSSL:
https://www.openssl.org/
To install it on a Windows OS you can use this tool:
http://slproweb.com/products/Win32OpenSSL.html