Damodar-Reddy Acclaimed Contributor.
Acclaimed Contributor.

Re: An Excel utility to export ALM project customization

Jump to solution

Gary,

You brought this utility to far extent, Kudo's.

you have anything like, which can be applied as a customization to ALM?

I mean, i can add few field values to a field, via an utility.

Apply customization to project utility, in short.

May be..!!

(If this helped, accept as solution )
(Posts and opinions made here are my own and do not reflect the opinions of my employer)
0 Likes
Respected Contributor.. garychen Respected Contributor..
Respected Contributor..

Re: An Excel utility to export ALM project customization

Jump to solution

That idea has crossed my mind, too.

I always plan the ALM customization on the Excel before I goto project customization. I have though that if I finished the plan on Excel, then I can click a button the excel marco will do the customization work for me automatically. So wonderful.

BUT I think use Excel marco to modify project customization is more dangerous than just query the customization dats. So I developed this utility for practice and preparing first. I might develope #2 Excel utility for this idea, but not a promise. I am a little busy to help customer implement ALM Project Planning and Tracking (PPT) now, and ALM business seems getting hotter in my region. I don't know when I will have time to do it.

Damodar-Reddy Acclaimed Contributor.
Acclaimed Contributor.

Re: An Excel utility to export ALM project customization

Jump to solution
Thanks for sounding back Gary,
Appreciate that.
Just make a astonishing post again & again
(If this helped, accept as solution )
(Posts and opinions made here are my own and do not reflect the opinions of my employer)
0 Likes
Respected Contributor.. garychen Respected Contributor..
Respected Contributor..

Re: An Excel utility to export ALM project customization

Jump to solution

Another idea in my mind is post-customization after create a new project from template project. When create a new project from template project, there is a lot of post-customizations to do like create Reports on Analysis View, create Favorites, Automail and Alert Rules settings. All these things has been done on Template Project, and I want to automate it.

0 Likes
Highlighted
Respected Contributor.. garychen Respected Contributor..
Respected Contributor..

Re: An Excel utility to export ALM project customization

Jump to solution

Working on user group's permissions.Get Permissions Bata.png

0 Likes
Outstanding Contributor.. Venkat457 Outstanding Contributor..
Outstanding Contributor..

Re: An Excel utility to export ALM project customization

Jump to solution

Thanks Gary,this will be of great help!!

Venkat
0 Likes
tman786 Absent Member.
Absent Member.

Re: An Excel utility to export ALM project customization

Jump to solution

Hi Gary

 

Great job.. just tried your latest utility now and its works a treat.

If you develop this further to include the ability to apply customisation based on an output generated from another project.. that would useful indeed.

Thanks

 

Tman

0 Likes
Absent Member.. Tom_Janouskovec Absent Member..
Absent Member..

Re: An Excel utility to export ALM project customization

Jump to solution

Hi garychen.

 

I checked your List report and I can provide you better solution with no limit of subItems. I did it with recursive call.

It looks like: 

Dim i As Integer
Dim j As Integer
Dim maxLevel As Integer

Sub customSub()
    On Error GoTo ErrHandler
    Dim cust As Customization

    Set cust = TD.Customization
    maxLevel = 0
    GetProjectLists cust, 2

    MsgBox "Done! " 
    GoTo GoEnd
    
ErrHandler:
    MsgBox Err.Number & " - " & Err.Description    
GoEnd:
set cust = nothing
End Sub

Sub Process(objNode As Object, Name As String, sheetName As Integer, Level As Integer)
    Dim objNode2 As Object

    Worksheets(sheetName).Cells(j, 1).Value = Name
    Worksheets(sheetName).Cells(j, 2 + Level).Value = "'" & objNode.Name
    j = j + 1
    If objNode.ChildrenCount <> 0 Then
      For Each objNode2 In objNode.Children
        If maxLevel < Level + 1 Then maxLevel = Level + 1
        Process objNode2, Name, sheetName, Level + 1
      Next
    End If
End Sub

Sub GetProjectLists(objCustomization As Object, intSheet As Integer)
    Dim objCustomizationLists As Object
    Dim objCustomizationList As Object
    Dim objCustomizationListNode As Object
    Dim objNode1 As Object
    Dim l As Integer
    
    Worksheets(intSheet).Cells.ClearContents
    Worksheets(intSheet).Name = "Project Lists"
    
    Set objCustomizationLists = objCustomization.Lists
    
    Worksheets(intSheet).Cells(1, 1).Value = "List Name"
    Worksheets(intSheet).Cells(1, 2).Value = "List Item L1"
    
    j = 2
    For i = 1 To objCustomizationLists.Count
        Set objCustomizationList = objCustomizationLists.List(objCustomizationLists.ListByCount(i).Name)
        Set objCustomizationListNode = objCustomizationList.RootNode
        For Each objNode1 In objCustomizationListNode.Children
            Process objNode1, objCustomizationLists.ListByCount(i).Name, intSheet, 0
        Next
    Next
    
    For l = 1 To maxLevel
        Worksheets(intSheet).Cells(1, 2 + l).Value = "List Item L" & (l + 1)
    Next
    
    Set objNode1 = Nothing
    Set objCustomizationListNode = Nothing
    Set objCustomizationLists = Nothing
    Set objCustomizationList = Nothing

End Sub
[If my advice solves your issue or query, please mark the thread as solved. Clicking on KUDOS star is the best way how to say thank you.]
Absent Member.. ThirupathiG Absent Member..
Absent Member..

Re: An Excel utility to export ALM project customization

Jump to solution

Hi Gary,

can you please share the password of excel macro if possible.

Thanks,

Thiru

0 Likes
PakBrain Absent Member.
Absent Member.

Re: An Excel utility to export ALM project customization

Jump to solution

Good work. There is a company called "Assure"; they had very similar utility that was used by customers. Not sure if it is still around. Based on my experience with projects updates and migrations, I would recommend you take it to the next level with not just fetching data but giving admins the ability to make updates as well.

A while back I tried to launch a product and designed screenshots to help admins manage their projects in a better way. Since I dont do ALM Administration anymore I'll post those screenshots on forums to help the community. Well done! Keep up the good work ..!

0 Likes
SanjeevR Honored Contributor.
Honored Contributor.

Re: An Excel utility to export ALM project customization

Jump to solution

Hey Gary,

Were you able to progress on optimization of this tool. Thanks for your all efforts. Actually we are so eager to see some more updates from you on this tool 🙂

 

Thanks

SanjeevR

 

 

0 Likes
Sathyan_S Absent Member.
Absent Member.

Re: An Excel utility to export ALM project customization

Jump to solution

Thanks a lot for the very much useful macro.

Is it also possible for us to export the workflow scripts?

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.