Start a new topic
Answered

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

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


Best Answer

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: 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:
https://support.royalapplications.com/support/solutions/articles/17000027866-powershell-script-to-create-a-royal-ts-document-based-on-a-csv-file

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:


Regards,

Stefan

1 Comment

Answer

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: 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:
https://support.royalapplications.com/support/solutions/articles/17000027866-powershell-script-to-create-a-royal-ts-document-based-on-a-csv-file

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:


Regards,

Stefan

Login or Signup to post a comment