Hi Richard,
You can also export as 'csv' format (comma separated format). To do this:
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!
Philana R. Crouch: I've let the developer know the issues you've reported. Thanks for reporting them.
I've let the developer know the issues you've reported. Thanks for reporting them.
Brilliant. Thanks Philana.
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!
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:
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.
How to Enable and Submit Log Files
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 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?
Richard Wardman:"Paste into" - nothing happens.
For me, it created a new sheet in the currently open document.
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?
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.
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
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.
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
Joe Fradley (Faithlife):When you export 'My Library' do you see the same behavior?
Yes! Identical.
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?
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.
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!
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.
Richard Wardman: Here's what I found -
I'm running the same version of Excel as Richard.
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.
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!