Can't export search results

Hi, I'm using Logos 6 on Windows 7, trying to export search results/analysis but it won't export - I've tried all 3 options. When I use 'save as file: spreadsheet' it does save a document, but it's blank. When I use 'send to new document: Microsoft Excel' it auto-opens Excel but then nothing happens. When I use 'paste into open document: Microsoft Excel', nothing happens in the existing open document - it just stays blank.

I've had this problem ever since I got Logos - it's not just Excel, it also doesn't export to Word, it just gets stuck.

Any suggestions on how I can get export to work, or what I might be doing wrong?

Thanks

Kirrily

Find more posts tagged with

Comments

Dave Hooton

When I use 'send to new document: Microsoft Excel' it auto-opens Excel but then nothing happens. When I use 'paste into open document: Microsoft Excel', nothing happens in the existing open document - it just stays blank.

The issue from using these options is well known!

When I use 'save as file: spreadsheet' it does save a document, but it's blank.

This works for me in 32-bit Office 2013 and 2016.

Is your Office 64-bit? What version?

Kirrily Drew

https://community.logos.com/discussion/comment/778817#Comment_778817

Thanks Dave. I'm using Office 2007, I think that only has 32-bit, doesn't it?

Kirrily

Dave Hooton

https://community.logos.com/discussion/comment/778823#Comment_778823

Thanks Dave. I'm using Office 2007, I think that only has 32-bit, doesn't it?

I think you're right - 64-bit came with Office 2010 onward. So start Logos with CTRL key held (to get logs), login and run your search (post a screen shot). Then try Export and 'Save as file: spreadsheet'. Upload the log files folder as per https://wiki.logos.com/Diagnostic_Logging#What_do_I_do_with_the_logs.3f.

Kirrily Drew

https://community.logos.com/discussion/comment/778832#Comment_778832

OK, I tried that - turns out it works when I save the search as a .csv file rather than a .xml file. I'll include the screenshots and logs anyway though, just in case there's something else going wrong! Thanks again for your help!

Kirrily

5127.LogosError.zip 3051.Logos.zip 7183.cef.zip

Dave Hooton

https://community.logos.com/discussion/comment/779075#Comment_779075

Please explain the last screen shot in relation to the file that is highlighted - was that the saved xml file?

Kirrily Drew

https://community.logos.com/discussion/comment/779092#Comment_779092

Yes, that's right - I was trying to open the saved .xml file, but it wouldn't open. From past experience, if I turn off & restart the computer, it will probably open the .xml file but it'll be empty/blank.

Dave Hooton

https://community.logos.com/discussion/comment/779094#Comment_779094

But where does the "Save as" dialog and background XML come from?

Kirrily Drew

https://community.logos.com/discussion/comment/779156#Comment_779156

The 3 screenshots were my 3 steps: I searched, then (screenshot 1) I clicked 'Save as spreadsheet', then (screenshot 2) saved it as an xml file, then (screenshot 3) tried to open the xml file.

This was all before I discovered that csv worked - although interestingly, now that I have opened and closed the csv file, it won't open properly again - it's just full of question marks (see new screenshot). Lucky I saved it under a new name as an .xlsx file so I haven't lost it all.

I'm completely confused about what I'm doing wrong though, since it seems every time it's something different that does/doesn't work!

Thanks for walking me through the bafflement!

Kirrily

Dave Hooton

https://community.logos.com/discussion/comment/779173#Comment_779173

The 3 screenshots were my 3 steps: I searched, then (screenshot 1) I clicked 'Save as spreadsheet', then (screenshot 2) saved it as an xml file, then (screenshot 3) tried to open the xml file.

That didn't answer my question about the "Save as" dialog and the XML in the background.

Kirrily Drew

https://community.logos.com/discussion/comment/779191#Comment_779191

Sorry, I didn't realise that was a 'save as' box. That's just the box that popped up when I tried to open the XML file, and the XML in the background is the 'preview' that comes up in windows before you open a file.

Kirrily

Dave Hooton

https://community.logos.com/discussion/comment/779194#Comment_779194

I'm thinking that Excel 2007 isn't compatible with XML format i.e. it uses workbook formats, so XML isn't an option when you save a table.

Kirrily Drew

https://community.logos.com/discussion/comment/779345#Comment_779345

No worries - since the csv option seems to be sort of working, I guess I'll stick with that until I upgrade to a new laptop and newer Office (maybe someday!)

Thanks for all your help - I really appreciate it!

Kirrily