BUG: Sermon Manager export function not working

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

Posts 1034
Richard Wardman | Forum Activity | Posted: Tue, Feb 2 2021 5:05 AM

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

I can't get Sermon Manager to export anything to either Word or Excel. 

With a series selected, I click "Send to new Word document." Word opens but the only thing that appears is the text "Sermon Manager." 

I click "Send to new Excel document." Sometimes Excel appears to open but then immediately closes. Sometimes it opens but with no actual workbook opened. 

With Word or Excel open, "Paste into open document" has the same behaviour. 

Copy to clipboard doesn't appear to work either. When I go to paste into Excel - nothing. When I paste into Word just the "Sermon Manager" text.

When I "Save file as Spreadsheet," and then attempt to open that file, Internet Explorer opens with some weird stuff...

Basically, nothing works for me!! 

Am I doing it wrong? Have I missed a step? 

Thanks!

Posts 12492
Forum MVP
NB.Mick | Forum Activity | Replied: Tue, Feb 2 2021 6:14 AM

Richard Wardman:
When I "Save file as Spreadsheet," and then attempt to open that file, Internet Explorer opens with some weird stuff...

It seems, you need to update the default assignment of XML-files from being opened by Internet Explorer to Excel

Running Logos 9 latest (beta) version on Win 10

Posts 1034
Richard Wardman | Forum Activity | Replied: Tue, Feb 2 2021 6:33 AM

NB.Mick:
It seems, you need to update the default assignment of XML-files from being opened by Internet Explorer to Excel

Thanks! Windows doesn't seem to want me to do that, though. There's no option to select Excel next to XML files. There are a bunch of other apps, and then "Look for an app in the Microsoft Store."

Do you know of a way to circumnavigate that?! 

And, would this solve the other issues as well, or just the XML one? 

Thanks again! 

Posts 1034
Richard Wardman | Forum Activity | Replied: Tue, Feb 2 2021 7:02 AM

OK, I think I've fixed the XML issue with Right click .xml > properties > Opens with: Windows 11 > Change to Excel > Apply 

Thanks for your help NB! I can at least now get Sermon Manager exported into Excel with that workaround. All the other issues remain. 

Posts 12492
Forum MVP
NB.Mick | Forum Activity | Replied: Tue, Feb 2 2021 7:54 AM

Richard Wardman:
OK, I think I've fixed the XML issue

Good to hear!

Running Logos 9 latest (beta) version on Win 10

Posts 1034
Richard Wardman | Forum Activity | Replied: Wed, Feb 3 2021 3:01 AM

All the above issues are still present in 9.3 beta.

Save as Spreadsheet (XML) is no longer working either. I get the following error in Excel when opening the document:

Opening that log lists:

XML ERROR in Table
REASON: Bad Value
FILE: C:\Users\richa\Desktop\Sermon Manager.xml
GROUP: Cell
TAG: Data
VALUE: 0001-01-01

XML ERROR in Table
REASON: Bad Value
FILE: C:\Users\richa\Desktop\Sermon Manager.xml
GROUP: Cell
TAG: Data
VALUE: 0001-01-01

XML ERROR in Table
REASON: Bad Value
FILE: C:\Users\richa\Desktop\Sermon Manager.xml
GROUP: Cell
TAG: Data
VALUE: 0001-01-01

Posts 12492
Forum MVP
NB.Mick | Forum Activity | Replied: Wed, Feb 3 2021 4:35 AM

Richard Wardman:

All the above issues are still present in 9.3 beta.

Save as Spreadsheet (XML) is no longer working either.

Hm. The XML I just got from Verbum 9.3 Beta 2 opens without any issue in my Excel 2016 (the rtf from Save To Word only has the header line "Homily Manager", as does a Word 2016 document from Send To Word). Are you free to share the xml here in the forums? Otherwise maybe send it to FL. But it looks like it can't read the date data.

Running Logos 9 latest (beta) version on Win 10

Posts 1034
Richard Wardman | Forum Activity | Replied: Wed, Feb 3 2021 5:39 AM

OK, the dating issue seems to be causing the problem.

When I export my most recent series, all with the correct dates, it saves and opens in Excel without any issues. 

But, earlier I was saving all sermons in the Sermon Manager, some of which have no dates at all assigned, and some of which appear to have the date "1 Jan 1". It seems Excel doesn't like one or both of these.

Here's the XML file with all sermons included: 

7633.Sermon Manager_ALL.xml

(Also, I meant beta 2, not beta 3!)

Thanks. 

Posts 12492
Forum MVP
NB.Mick | Forum Activity | Replied: Wed, Feb 3 2021 7:00 AM

Richard Wardman:

OK, the dating issue seems to be causing the problem.

When I export my most recent series, all with the correct dates, it saves and opens in Excel without any issues. 

But, earlier I was saving all sermons in the Sermon Manager, some of which have no dates at all assigned, and some of which appear to have the date "1 Jan 1". It seems Excel doesn't like one or both of these.

Yep. Excel can't handle dates prior to Jan 1, 1900. I opened the xml with Notepad++ and simply changed the three 0001-01-01 dates to 2001-01-01 and Excel will open it just fine (great that your version of Excel gave detailed error messages for the faulty data, mine just refused to open the file prior to my correction). The updated file is here: 3755.7633.Sermon Manager_ALL.update.xml

It's a strange thing that most information is just character strings, but the dates are strictly formatted (don't try to export the xml of a preaching series emulating when it was preached e.g. by Martin Luther, John Wesley or Charles Spurgeon and working in Excel).  

Running Logos 9 latest (beta) version on Win 10

Posts 1034
Richard Wardman | Forum Activity | Replied: Wed, Feb 3 2021 11:38 AM

Thanks NB. 

I wonder if anyone else is having these problems, or if anyone from FL has spotted this thread yet?! 

Posts 3897
LogosEmployee
Philana R. Crouch | Forum Activity | Replied: Wed, Feb 3 2021 4:08 PM

Richard Wardman:

Thanks NB. 

I wonder if anyone else is having these problems, or if anyone from FL has spotted this thread yet?! 

Richard,

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?

Posts 1034
Richard Wardman | Forum Activity | Replied: Thu, Feb 4 2021 5:26 AM

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! 

Posts 25768
Forum MVP
Graham Criddle | Forum Activity | Replied: Thu, Feb 4 2021 5:53 AM

This issue may be similar to Richard's so I thought I would add it to the thread

I've just tried an export but when looking at the resulting document in Excel, the date information is not displayed correctly.

I know the date format in the XML file does not match what Philana mentioned but that is what came out of the Sermon Manager!

Is this because I am initially entering the dates in UK time format (Day / Month / Year)?

Posts 1034
Richard Wardman | Forum Activity | Replied: Thu, Feb 4 2021 5:58 AM

Graham Criddle:
Is this because I am initially entering the dates in UK time format (Day / Month / Year)?

Same here!! That would make a lot of sense. 

Posts 12492
Forum MVP
NB.Mick | Forum Activity | Replied: Thu, Feb 4 2021 6:12 AM

Graham Criddle:
I've just tried an export but when looking at the resulting document in Excel, the date information is not displayed correctly. (...)

I know the date format in the XML file does not match what Philana mentioned but that is what came out of the Sermon Manager!

Is this because I am initially entering the dates in UK time format (Day / Month / Year)?

No, what you see is just the general cell display format, as it has no information about ho you want it to be displayed. If you tell Excel that this column is a date, it will show in the format you want. Internally, Excel stores dates as integers i.e. a count of days starting from Jan 1, 1900.  

Running Logos 9 latest (beta) version on Win 10

Posts 25768
Forum MVP
Graham Criddle | Forum Activity | Replied: Thu, Feb 4 2021 6:27 AM

NB.Mick:
No, what you see is just the general cell display format, as it has no information about ho you want it to be displayed. If you tell Excel that this column is a date, it will show in the format you want

Thanks Mick that works.

Now, however, when I export all of my sermons (as opposed to just this year's) I see the same error Richard mentioned above (https://community.logos.com/forums/p/198584/1151261.aspx#1151261) and it may well be due to some sermons not having correct date fields (there was some issue over dates during one of the betas and I haven't got round to tidying it up)

Posts 1034
Richard Wardman | Forum Activity | Replied: Thu, Feb 4 2021 6:31 AM

Graham, can you export in other ways other than XML? E.g. "Send to new document"? 

Posts 25768
Forum MVP
Graham Criddle | Forum Activity | Replied: Thu, Feb 4 2021 6:47 AM

Richard Wardman:
Graham, can you export in other ways other than XML? E.g. "Send to new document"? 

No that doesn't seem to do anything - I'll need to look into if further.

Posts 1034
Richard Wardman | Forum Activity | Replied: Thu, Feb 4 2021 8:29 AM

Graham Criddle:

Richard Wardman:
Graham, can you export in other ways other than XML? E.g. "Send to new document"? 

No that doesn't seem to do anything - I'll need to look into if further.

Glad that it's not just me! 

Posts 3897
LogosEmployee
Philana R. Crouch | Forum Activity | Replied: Thu, Feb 4 2021 10:06 AM

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! 

Hi Richard,

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

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