Encrypt configuration in data source option

Hi,
Have you tried to change the security provider in File->Administration

If you set it to None, only your password will be encrypted. Please backup your database before changing the security provider or test it on a copy of the database. The other solution could also be a PowerShell export script

Regards

Hi David,

Thanks for the suggestion. Unfortunately the data is still encrypted in the source database despite the security provider being set and applied to "None".
Do you have any further information on the PowerShell export script? Would that be able to read the data and export it unencrypted to a CSV for example?

Thanks
Glenn

Hello,

Here is the script to extract the information and save it to a csv file.

$csvFile = "c:\temp\sessions.csv"

# Header
$line = "SessionName,ValueTitle,Value"
Out-File -FilePath $csvFile -InputObject $line -Encoding ascii

$sessions = Get-RDMSession | where {$_.Kind -eq "DataEntry"}
foreach ($sess in $sessions) {
[xml]$data = $sess.DataEntry.ConnectionTypeInfos.Data
$sessionName = $sess.Name
$valueTitle = $data.ArrayOfDataEntryOtherValue.DataEntryOtherValue.Name
$value = $data.ArrayOfDataEntryOtherValue.DataEntryOtherValue.Value
$line = "$sessionName,$valueTitle,$value"
Out-File -FilePath $csvFile -InputObject $line -Append -Encoding ascii
};
Best regards,

Hi Erica,

Thanks very much for the script.
Just one further request if I may. I'm not much of a powershell user and I'm not sure how to modify the script to have it appear the way I'd like.
The script outputs to CSV which looks like the following

SessionName ValueTitle Value
Test Notes SS Online Version SS Version Test 1 Test 2 Test 3 10.1.x 10.1.999 1 2 3


Would it be possible to alter the script so that it ends up with an output that looks like this:

SessionName ValueTitle Value
Test Notes SS Online Version 10.1.x
SS Version 10.1.999
Test 1 1
Test 2 2
Test 3 3


Many thanks,
Glenn

Hello,

Here is the solution to export, from a same session, each items on separate lines into the csv file.

$csvFile = "c:\temp\sessions.csv"

$line = "SessionName,ValueTitle,Value"
Out-File -FilePath $csvFile -InputObject $line -Encoding ascii

$sessions = Get-RDMSession | where {$_.Kind -eq "DataEntry"}
foreach ($sess in $sessions) {
[xml]$data = $sess.DataEntry.ConnectionTypeInfos.Data
$sessionName = $sess.Name
$nbItems = $data.ArrayOfDataEntryOtherValue.DataEntryOtherValue.count
if ($nbItems -gt 0) {
for ($item=0; $item -lt $nbItems; $item++) {
$valueTitle = $data.ArrayOfDataEntryOtherValue.DataEntryOtherValue[$item].Name
$value = $data.ArrayOfDataEntryOtherValue.DataEntryOtherValue[$item].Value
$line = "$sessionName,$valueTitle,$value"
Out-File -FilePath $csvFile -InputObject $line -Append -Encoding ascii
}
}
else {
$valueTitle = $data.ArrayOfDataEntryOtherValue.DataEntryOtherValue.Name
$value = $data.ArrayOfDataEntryOtherValue.DataEntryOtherValue.Value
$line = "$sessionName,$valueTitle,$value"
Out-File -FilePath $csvFile -InputObject $line -Append -Encoding ascii
}
}
Best regards,

Perfect! Thanks Erica