Import multiple connections via CSV

[stefan_koell]

Hi Stefan,

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

Here, for example, you can find the documentation of all properties available in the web page connection:

https://content.royalapplications.com/Help/RoyalTS/V5/index.html?scripting_objectproperties_royalwebconnection.htm

To set the properties to use an existing credential you need to set the following properties accordingly:

CredentialMode: 3

CredentialId: 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

You can also use other sources, of course (like a DB or Active Directory, etc.). One of our customers already posted a great tutorial on youtube:

RoyalTS Dynamic Folders

Regarding your last question about setting Auto Fill Options: this is a bit tricky as we store the auto fill configuration in a special structure depending on the UI elements. You can configure an auto fill for one connection and save the document to disk to see how we store the configuration.

I hope this helps. If you have any further questions, please let me know.

Stefan