Mingle Macro for Excel

Comments

11 comments

  • Avatar
    Olivier Grandjean

    Is this supposed to work on Excel for Mac 2011? I'm getting a compile error

    0
    Comment actions Permalink
  • Avatar
    Mark Richter

    Oliver, I'm sorry, but we have not verified this macro on Mac Excel, yet.

    0
    Comment actions Permalink
  • Avatar
    yolandie

    Very usefull indeed, i have created a Story Card generator from this, and am working on a selection criteria driven version of the above. Many many thanks :)

    0
    Comment actions Permalink
  • Avatar
    Adam Monago

    @yolandie It would be great if you could share your story card generator with the community when you are ready. Glad you found this useful!

    0
    Comment actions Permalink
  • Avatar
    smarties31

    Interesting ; could be useful for me Tongue out


    Tried the above .xls file, but had the following error from the "LoadData" sub : "invalid at the top level of the document".


    What's going wrong ?


    (using Excel 2007 / Mingle 3.3)

    0
    Comment actions Permalink
  • Avatar
    Mark Richter

    @smarties31, thank you for checking this out! First, and you may have dones this, but make sure the Mingle URL and project name that you are using in Excel work in a browser. Copying and pasting the URL from Excel into a browser is a good way to do this. It's a good way to guarantee there's not a misspelling of something. Second, make sure that the list of field names begins in A4 on the Query page and goes down from there. I suggest trying a very simple list like number and name, which appear in all cards. This assures that the connection works and data is being retrieved. If you still have problems then shoot me an email at the address on my profile. I'll do my best to help you and post back the solution here for others if it's relevant.

    0
    Comment actions Permalink
  • Avatar
    smarties31

    Hi Mark,


    Sorry for this late reply, but I was off these days.


    Yes I checked the URL was good, and also that the targeted XML page (property_definitions.xml) was displayed when "manually" invoked in a browser. I also reduced the fields list to "number" and "name", starting at the right cell on the query page.


    Two questions :


    1) The logon I currently use grant me only read only permissions (I'm not the server adm). Does it matter for running the "Send Request" button (I suppose it does for running the "Save changes" function)?


    2) Is there a Mingle sample server on the Web that I could use to make tests, and share the results with you (the server I try to communicate with is on an enterprise intranet) ?


    Thx

    0
    Comment actions Permalink
  • Avatar
    Mark Richter

    @smarties31, I'll see about getting a public Mingle instance for you to hit. Give me a day or so.

    0
    Comment actions Permalink
  • Avatar
    smarties31

    What's up, doc Wink ?

    0
    Comment actions Permalink
  • Avatar
    yolandie

    Hi, so its gone through a couple of versions and this seems to be the most stable so far.....


    What does it do?


    Well, it nicks the basic retreve function from the sheet above to get the common story card variables listed in the left hand column. It then transforms the retrieved data, cleans it a little bit, splits out the acceptance criteria (bit of a fudge), and then throws it all together in the story cards page.


    The cleaning of cards "tries" to eliminate pagebreaks, html formatting and general mingle formatting.  <- it may not work for everyone, but its worth a shot.


    It looks at the template card for the colours and font sizing, It also tries to auto page break, and with the current template that works out to about 3 per A4 page which makes them very readable at a distance.


    You can also print single cards if need be.


    2 rules:



    1. Print perview is your friend.

    2. Dont change the number of fields on the main page.


    I use it every sprint for printing the cards, and have used it for printing the whole backlog.


    The VBA geeks may find some opportunities for re-factoring. :) ... my codes not that bad :)....


    Anyway enjoy. Any ideas for improvement post them here.


    Thanks,


    @Yolandie@.... <- the nickname.... it involved a few drinks!

    0
    Comment actions Permalink
  • Avatar
    yolandie

    BTW for those having the "invalid at the top level of the document" i rekon this could be:



    1. The url is wrong.

    2. Your username and password is wrong.

    3. The fields its trying to get are called summert different. (Story could be Story Number??? ..... etc....)


    MQL and a browser is your friend, try this as a starter:


    http://mingle//api/v2/projects/XXXXXXX/cards/execute_mql.xml?mql=SELECT 'sprint'


    Copy and paste that into a browser and replace "http://mingle//api/v2/projects/XXXXXXX/" with your project URL and your should get a basic sprint list.


    Thanks,


    @Yolandie@

    0
    Comment actions Permalink

Please sign in to leave a comment.