Absent Member.
Absent Member.
1054 views

Connecting to Silk Central using VBA macros

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)?

Tags (3)
0 Likes
6 Replies
Micro Focus Expert
Micro Focus Expert

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

0 Likes
Absent Member.
Absent Member.

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
0 Likes
Micro Focus Expert
Micro Focus Expert

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

0 Likes
Lieutenant Commander
Lieutenant Commander

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.
0 Likes
Micro Focus Expert
Micro Focus Expert

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

 

0 Likes
Lieutenant Commander
Lieutenant Commander

Thank you Hubert

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.