Bulk Import // Assign imported credentials when importing connections / generate subfolders from csv

[stefan_wahl]

Hi all,

I create a lot of connections for different customers.

Currently I import everything and afterwards I assign the necessary credentials to the connections.

1. Is there a way to do it with a separate field in the csv file directly without manually changing the connections?

2. Is it possible to generate subfolders automatically with a separate field in csv?

Thanks

Stefan

[stefan_koell]

Hi Stefan,

I’ve seen you also created a support ticket. I will also include the ticket response here:

The CSV import feature is a bit limited. You can find a tutorial with some tips on how to set advanced properties here:
https://blog.royalapplications.com/2011/11/03/royal-ts-v2-how-to-import-csv-files/

To find out which properties are available for each connection type, or for advanced scenarios check out the Scripting API documentation:
https://www.royalapplications.com/go/help-ts-win-powershellmodule-gettingstarted

To set the properties to use an existing credential you need to set the following properties accordingly:
CredentialMode: 3CredentialId: the GUID of the credential you want to assign to the connection

This can be done using the CSV import or the PowerShell API. A PowerShell sample script on how to build a connection file from a CSV can be found here:

PowerShell Script to create a Royal TS Document based on a CSV File

This is a sample PowerShell script that demonstrates how to create Royal TS/X documents based on the content of a CSV file. Remark: You need to import the Royal TS PowerShell module to get this running (assuming you have installed Royal TS to the default location): Install-Module -Name RoyalDocument.PowerShell -Scope CurrentUser Import-Module -Name RoyalDocument.PowerShell function CreateRoyalFolderHierarchy() { param( [string]$folderStructure, [string]$splitter, $Folder ) …

With V5, we also have a new feature called Dynamic Folder which allows you to build your tree from a script by returning a special formatted JSON. This allows for nearly endless customizations and possibilities to be able to use external data within Royal TS/X with ease.

Here’s an example for CSV:
https://github.com/royalapplications/toolbox/tree/master/Dynamic%20Folder/CSV

Alternatively, you could also use our "bulk edit’ feature to change the credentials for multiple connections at the same time. You can find out how to do this here:

https://www.royalapps.com/go/kb-ts-win-bulkedit

Regards,

Stefan