Connecting to Silk Central using VBA macros

[Vishnuraj1175]

Hi,

I am trying to do an automation to import Test plan from excel to Silk Central through Excel VBA.

Is there any Addins or plugins available ?

In HPQC we have OTA COM library through which Excel can communicate HPQC , Similarly any other OTA library's to connect Silk Central from Excel (VBA)?

[Hubert Inreiter]

Hi Vishnuraj1175,

In Silk Central you can import directly from Excel (.xlsx files). It is described here:

http://documentation.microfocus.com/help/topic/com.microfocus.sctm.doc/GUID-75C95D8D-33F3-406A-B4C6-2A6BD44BBF02.html?cp=9_0_2_3_2_0_0_5

Regards,

Hubert

[Vishnuraj1175]

Hi Hubert,

Thanks for your quick response.

Please let me know if there is any add-ins available to interact Excel with Silk Central to extract requirement folders details , run SQL queries from Excel , and import and export requirements from Silk Central to Excel.

Regards
Vishnu Raj

[Hubert Inreiter]

Hi Visnu Raj,

There is not an Excel add-in. Silk Central can import requirements from Excel (.xlsx) files via UI.

As described here there are several other possibilities for manipulating requirements in Silk Central.

You can also integrate Silk Central with an external requirement management system, see http://documentation.microfocus.com/help/topic/com.microfocus.sctm.doc/SCTM-9AC25597-EXTERNALRMTOOLS-CON.html?cp=9_0_2_2_0_1

What's the exact use case?

Regards,

Hubert

[sunjb]

Hi Hubert Inreiter,
I am unable to access the URL's provided by you.
Receiving the following error.
This documentation.microfocus.com page can’t be found
Could you please share the updated URL/Let me know the steps to access.
Thank you.

[Hubert Inreiter]

Hi @sunjb,

The links have changed, these are the updated links for Silk Central 20.6:

Test Export, Update, and Import:

https://www.microfocus.com/documentation/silk-central/206/en/silkcentral-help-en//GUID-75C95D8D-33F3-406A-B4C6-2A6BD44BBF02.html

Requirements Management Tools Integration:

https://www.microfocus.com/documentation/silk-central/206/en/silkcentral-help-en/SCTM-9AC25597-EXTERNALRMTOOLS-CON.html

Regards,

Hubert

[sunjb]

Thank you Hubert