BUG: Sermon Manager export function not working

Page 2 of 3 (48 items) < Previous 1 2 3 Next >
This post has 47 Replies | 2 Followers

Posts 14
LogosEmployee
Joe Fradley (Faithlife) | Forum Activity | Replied: Thu, Feb 4 2021 11:33 AM

Hi Richard,

You can also export as 'csv' format (comma separated format). To do this:

  • Select save as spreadsheet
  • In the file save dialog, change the file type from XML to csv

Posts 1034
Richard Wardman | Forum Activity | Replied: Thu, Feb 4 2021 11:36 AM

Joe Fradley (Faithlife):

Hi Richard,

You can also export as 'csv' format (comma separated format). To do this:

  • Select save as spreadsheet
  • In the file save dialog, change the file type from XML to csv

That's really helpful. And can confirm that it works!  Thanks Joe! 

Posts 1034
Richard Wardman | Forum Activity | Replied: Thu, Feb 4 2021 11:37 AM

Philana R. Crouch:

I've let the developer know the issues you've reported. Thanks for reporting them.

Brilliant. Thanks Philana. 

Posts 3702
LogosEmployee
Philana R. Crouch | Forum Activity | Replied: Tue, Feb 9 2021 3:38 PM

Richard Wardman:

Philana R. Crouch:
It seems like some issues are no longer present for you and some are. Are you still having trouble saving as an XML file, this should open up in Excel? The date format needs to be Month, day, and year. Can you summarize what issues you are still experiencing?

Hi Philana.

Thanks for your response. Most of the issues above are still present. I can save as an XML file and open it in Excel IF the dates are correct, as you say.

But I still can't:

  • Save as Rich Text and then open in Word (just gives the Sermon Manager heading)
  • Copy to clipboard (just gives the Sermon Manager heading in Word, nothing in Excel)
  • Send to a new document (Word or Excel)
  • Paste into open document (Word or Excel)

I feel like this is an issue at my end rather than Logos? Happy to provide whatever you need to check! 

We fixed these issues in 9.3 Beta 3, in some cases we had to remove the option because of incompatibility with Microsoft Word.

Posts 1034
Richard Wardman | Forum Activity | Replied: Wed, Feb 10 2021 2:44 AM

Philana R. Crouch:
We fixed these issues in 9.3 Beta 3

I'm afraid not!! 

Still the same behaviour with "Send to new" and "Paste into" - nothing happens. Excel occasionally looks like it's opening but then closes straight away. Sometimes opens but with no Worksheet. And pasting into an open doc does absolutely nothing.

I still think Graham is onto something with the British date format?!? 

Is anyone in the US having similar issues? 

Posts 3702
LogosEmployee
Philana R. Crouch | Forum Activity | Replied: Wed, Feb 10 2021 9:25 AM

Richard Wardman:

Philana R. Crouch:
We fixed these issues in 9.3 Beta 3

I'm afraid not!! 

Still the same behaviour with "Send to new" and "Paste into" - nothing happens. Excel occasionally looks like it's opening but then closes straight away. Sometimes opens but with no Worksheet. And pasting into an open doc does absolutely nothing.

I still think Graham is onto something with the British date format?!? 

Is anyone in the US having similar issues? 

This is really weird because Send to works for me and the developer who fixed this. What version of Excel are you using?

Posts 3702
LogosEmployee
Philana R. Crouch | Forum Activity | Replied: Wed, Feb 10 2021 9:44 AM

Richard Wardman:
"Paste into" - nothing happens.

For me, it created a new sheet in the currently open document.

Posts 3702
LogosEmployee
Philana R. Crouch | Forum Activity | Replied: Wed, Feb 10 2021 9:56 AM

Richard Wardman:

Philana R. Crouch:
We fixed these issues in 9.3 Beta 3

I'm afraid not!! 

Still the same behaviour with "Send to new" and "Paste into" - nothing happens. Excel occasionally looks like it's opening but then closes straight away. Sometimes opens but with no Worksheet. And pasting into an open doc does absolutely nothing.

Richard,

Can you also reproduce these issues and ZIP and post the entire log folder to this thread?

Posts 3702
LogosEmployee
Philana R. Crouch | Forum Activity | Replied: Wed, Feb 10 2021 10:32 AM

Richard Wardman:

Philana R. Crouch:
We fixed these issues in 9.3 Beta 3

I'm afraid not!! 

Still the same behaviour with "Send to new" and "Paste into" - nothing happens. Excel occasionally looks like it's opening but then closes straight away. Sometimes opens but with no Worksheet. And pasting into an open doc does absolutely nothing.

I still think Graham is onto something with the British date format?!? 

Is anyone in the US having similar issues?

Richard,

Are you able to save it as an .XML file? Can you open that within Excel? Would you be willing to share it with us? This might let us take a look at your data.

Posts 12149
Forum MVP
NB.Mick | Forum Activity | Replied: Wed, Feb 10 2021 1:59 PM

Philana R. Crouch:

Richard Wardman:

Philana R. Crouch:
We fixed these issues in 9.3 Beta 3

I'm afraid not!! 

Still the same behaviour with "Send to new" and "Paste into" - nothing happens. Excel occasionally looks like it's opening but then closes straight away. Sometimes opens but with no Worksheet. And pasting into an open doc does absolutely nothing.

I still think Graham is onto something with the British date format?!? 

Is anyone in the US having similar issues? 

This is really weird because Send to works for me and the developer who fixed this. What version of Excel are you using?

I see the same as Richard: Send to new and Send to open Excel both won't work. Save as Spreadsheet (i.e. XML) does work - and Excel opens it just fine. My files is here: 6378.Homily Manager2.xml

(called Homily Manager since I exported from Verbum). I'm running Office Professional 2016 on a Windows 10 OS, both installed in German language while my Verbum used the English UI today - not sure if this makes a difference.

Running Logos 9 latest (beta) version on Win 10

Posts 1034
Richard Wardman | Forum Activity | Replied: Wed, Feb 10 2021 2:51 PM

Hi Philana

I'm running the latest beta, with MS Office Home and Student 2019. 

Here is the XML file - 7624.Sermon Manager XML.xml

I can't seem to upload the log files ZIP - it says there is an error uploading. I'm happy to email if needed. 


Posts 14
LogosEmployee
Joe Fradley (Faithlife) | Forum Activity | Replied: Thu, Feb 11 2021 4:40 AM

Richard / NB.Mick,

When you export 'My Library' do you see the same behavior? To get there:
* Open your Library
* Click the "Open in floating window" icon in the top right
* In the resulting window click the kebab button in the top right to select Print/Export

Posts 1034
Richard Wardman | Forum Activity | Replied: Thu, Feb 11 2021 4:43 AM

Joe Fradley (Faithlife):
When you export 'My Library' do you see the same behavior?

Yes! Identical. 

Posts 3702
LogosEmployee
Philana R. Crouch | Forum Activity | Replied: Thu, Feb 11 2021 9:15 AM

Richard,

I need to know what build of Excel you are running? It should be in the About panel. For example here is what mine says:

What version are you running? Are you up to date?

Posts 1034
Richard Wardman | Forum Activity | Replied: Thu, Feb 11 2021 10:28 AM

Thanks Philana

Sorry for all the trouble being caused! 

Here's what I found - 

I actually just installed an update and tried again to no avail. 

Posts 25339
Forum MVP
Graham Criddle | Forum Activity | Replied: Thu, Feb 11 2021 10:49 AM

NB.Mick:
I see the same as Richard: Send to new and Send to open Excel both won't work. Save as Spreadsheet (i.e. XML) does work - and Excel opens it just fine.

I'm seeing exactly the same results as Richard and Mick.

It is interesting - and may not be a coincidence - that all three of us are not in the US!

Posts 3702
LogosEmployee
Philana R. Crouch | Forum Activity | Replied: Thu, Feb 11 2021 10:50 AM

Richard Wardman:

Thanks Philana

Sorry for all the trouble being caused! 

Here's what I found - 

I actually just installed an update and tried again to no avail. 

No worries, I'm just trying to figure out what is going on because I'm stumped. Can you reproduce the issue and post your logs from this session? It might help in diagnosing the problem.

Posts 25339
Forum MVP
Graham Criddle | Forum Activity | Replied: Thu, Feb 11 2021 10:52 AM

Richard Wardman:

Here's what I found - 

I'm running the same version of Excel as Richard.

Posts 3702
LogosEmployee
Philana R. Crouch | Forum Activity | Replied: Thu, Feb 11 2021 10:52 AM

Graham Criddle:

NB.Mick:
I see the same as Richard: Send to new and Send to open Excel both won't work. Save as Spreadsheet (i.e. XML) does work - and Excel opens it just fine.

I'm seeing exactly the same results as Richard and Mick.

It is interesting - and may not be a coincidence - that all three of us are not in the US!

Is there some type of difference between the version of Office that is released outside the US? I would think it would be the same, but that is an interesting possibility.

Posts 25339
Forum MVP
Graham Criddle | Forum Activity | Replied: Thu, Feb 11 2021 10:55 AM

Philana R. Crouch:
Is there some type of difference between the version of Office that is released outside the US? I would think it would be the same, but that is an interesting possibility.

Not that I'm aware of (although I haven't researched it) - but we will be using different date formats!

Page 2 of 3 (48 items) < Previous 1 2 3 Next > | RSS