chipbite/JiraToExcel

Automation error

Opened this issue · 2 comments

Hi Marcus, I've managed to recreate the automation error again.

It seems to run fine when there are only the 2 sheets, but once you add a new sheet and then add a graph in or a pivot table, then the automation error appears.

image

Also, is it possible to get it working with test execuction? I've tried using the JQL for tests but it seems that the XML isn't structured the same way and you get the following error:

image

Hi Nick,
sorry for late reply. Busy weekend.

  1. Re general automation error
    Not sure about this one. Likely need to try it myself and debug. Principally, should work.
  2. Re testdata
    I can check how the testdata is to be saved, and add an instructional note.

In short, I believe I allowed the XML to be fetched in the script, added a breakpoint at a point when I could access the reply and then I used the immediate window in the vb editor to log the string and then copy pasted that string into a text file.

The code to load the testdata from the file is there.

Hopefully, I will be able to check both issues tonight, CET.

BR! /marcus

Thanks Marcus. Much appreciated, really no rush.
On Mon, 28 Sep 2015 at 12:06, Marcus notifications@github.com wrote:

Hi Nick,
sorry for late reply. Busy weekend.

Re general automation error
Not sure about this one. Likely need to try it myself and debug.
Principally, should work.
2.

Re testdata
I can check how the testdata is to be saved, and add an instructional
note.

In short, I believe I allowed the XML to be fetched in the script, added a
breakpoint at a point when I could access the reply and then I used the
immediate window in the vb editor to log the string and then copy pasted
that string into a text file.

The code to load the testdata from the file is there.

Hopefully, I will be able to check both issues tonight, CET.

BR! /marcus


Reply to this email directly or view it on GitHub
#4 (comment).