Highlighted
Absent Member.. Wade Walden Absent Member..
Absent Member..
94 views

How to trigger email notifications for new requirements via Excel import add-ins or Copy/Paste

How to get email notifications when importing new requirements via Excel import add-ins or by Copy/Paste of requirements?

Tags (1)
0 Likes
2 Replies
ameyjo Outstanding Contributor.
Outstanding Contributor.

Re: How to trigger email notifications for new requirements via Excel import add-ins or Copy/Paste

Dear Customer,

 

 

For this  doing a notification mail when copy and pasting requirements, first capture the copy/paste action.

Found the below example when copy and pasting  it may help you as guide:

 


Function ActionCanExecute(ActionName)
  'Use ActiveModule and ActiveDialogName to get
  'the current context.
  'On Error Resume Next


  If ActionName="act_req_paste_as_child" then
        dim tfactory
        dim cust
        dim td
        dim ProjectUsers
        dim ResponsibleUser
        Dim Cyclenames
        set td= TDConnection
        set cust = td.Customization
        cust.load
        set ProjectUsers=cust.users
        Set tfactory=td.ReqFactory
        set tequirement=tfactory.Item(0)
        Set tItem = tfactory.Item(Req_Fields.Field("RQ_REQ_ID").Value )
        set ResponsibleUser= ProjectUsers.User("admin")
        tItem.Mail  ResponsibleUser.Email , "349299",0,"Req copied under: " & Req_Fields.Field("RQ_REQ_NAME").Value  & " by User: " & user.username
end if

  'Use the following script to redirect this function to the module specific function:
  'Select Case ActiveModule
  '  Case "Defects"
  '    ActionCanExecute = Defects_ActionCanExecute(ActionName)
  '  Case "Test Lab"
  '    ActionCanExecute = TestLab_ActionCanExecute(ActionName)
  '  Case "Test Plan"
  '    ActionCanExecute = TestPlan_ActionCanExecute(ActionName)
  '  Case "Requirements"
  '    ActionCanExecute = Requirements_ActionCanExecute(ActionName)
  '  Case "Management"
  '    ActionCanExecute = Management_ActionCanExecute(ActionName)
  '  Case "Test Resources"
  '    ActionCanExecute = Resources_ActionCanExecute(ActionName)
  '  Case "Business Components"
  '    ActionCanExecute = Components_ActionCanExecute(ActionName)
  '  Case "Dashboard"
  '    ActionCanExecute = Analysis_ActionCanExecute(ActionName)
  '  Case "Business Models"
  '    ActionCanExecute = BusinessModels_ActionCanExecute(ActionName)
  'End Select
  ActionCanExecute = DefaultRes
  'On Error GoTo 0
End Function

 

 

 

Cordially

ameyjo

"HP Support
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution"
0 Likes
Absent Member.. Wade Walden Absent Member..
Absent Member..

Re: How to trigger email notifications for new requirements via Excel import add-ins or Copy/Paste

Thanks for your advice. I will pass this along to my fellow ALM admins to give it a try.

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.