Re: [libreoffice-users] Does something like this exist for LO?
On 04.02.2019 06:30, Luuk wrote: On 2-2-2019 21:53, bunk3m wrote: I have been wondering how to export my Google Map Timeline so I can capture my mileage driven without having to get the kml file for each individual day. Today I found this add-in for Excel (Don't have Excel anymore :-( ) that runs a VBA script to do exactly what I'm looking for. https://github.com/Excel-projects/Excel-Timesheet Is there a way to run this in LO Calc? PS On digest mode. Please cc me directly on any replies. Thank you in advance. I did forget to mention that this tool: https://github.com/nerik/google-timeline-to-csv works with the: "Location History.json" from: https://takeout.google.com/ Thank you Luuk. After all my Googling, I never found this project. I will see if I can figure out how to get this google-timeline-to-cvs to work. I don't code so this will be a challenge. I have no idea how to install dependencies after doing a download of this project. Any suggestions appreciated. Thanks again. B. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Auto recovery problem
Carl, I have experienced this endless auto-recovery on startup problem before. Whenever I got it, I "reset" my user profile and it stopped doing it. Offhand, I don't remember the exact steps to do that, but a search of this forum should turn up the procedure or maybe someone out there who knows it can give it to you. I have developed the process of occasionally saving the good profile in a directory somewhere so I can just copy it back to resolve such a problem and still keep my settings. HTH. Girvin Herr On 2/4/19 4:13 PM, Carl Paulsen wrote: Windows 10. I think the LO version is either 6.1.4 or the previous one. Note that earlier in the day I was struggling with the same problems and saw that LO was telling me there was a new release. So in desperation I upgraded, which I think was to 6.1.4. That computer is down for the night but I can check again tomorrow. In any case that didn't fix it. Note that I eventually got the system to work...sometimes. I had de-registered the databases for my other issue, cleared the auto-recovery, started working with new files and got them to work sometimes. An example is a label document, where I saved the labels as a LO Writer document with the merge fields in it, and merged to a full sheet. That document continues to open with the auto-recover for itself, whether I discard the recovery point or not. When it opens it seems to work fine. With another document, a merge letter, I saved it with merge fields in place. That one appears to open without the auto-recovery, though this one opened with merge data in the place of the fields. And in this case I at some point I exchanged databases so I could build a merged file with a second data set. What seems like is happening is the documents get saved and closed, and then there's some kind of flag in the file that didn't get reset by the save, which marks it as damaged/needing recovery. So it triggers the auto-recovery system even when it's not needed. Carl On 2/4/19 6:06 PM, Dan Lewis wrote: Two things are needed to help you: your version of LibreOffice, and your operating system. Dan On 2/4/19 4:43 PM, Carl Paulsen wrote: I'm trying to create a mail merge document for a letter. I'm adding fields directly to retain formatting control and NOT have to deal with a text block which is how the wizard inserts addresses. I've had some success after a LONG time trying to figure out how to do this. Documentation is a bit lacking on this approach. The real problem is happening when I try to close and then reopen the document. The file appears to close fine but when I try to reopen it, LibreOffice seems to think the file is damaged. I can recover and the file opens fine, but same thing happens when I try to reopen again. I can also "discard" the auto-recovery which should fix the auto-recover so it doesn't come up again, but in fact it DOES. Even when discarding recovery points, the program continues to think there's a problem with the file and re-opens the auto recovery. I can't find any way to deal with this problem. BTW, it seems that I finally figured out how to generate the merged letters, so I assume the file is basically OK. But I still get the auto-recovery screen. I'd love to get this to stop. It's a hassle, slows me down, and doesn't show LO at it's best when I'm showing friends and clients. Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Mailing labels from mail merge
I was contacted off list to discuss this not long after I was able to get the system to work. See my reply below. In short, I did eventually get it to work, but I have no idea why. And the whole experience seemed a bit buggy. First, I was able to build a merge letter with the wizard, once using an address block and then, after some struggling, I figured out how to add the merge fields directly and NOT using the wizard address block. (Note that system is not at all helpful when starting with a pre-existing letter - it shifted blocks of text around and basically ruined the letter formatting.) But then I could not get that system to actually merge the data into letters. Somehow after closing and reopening that file and de-registering and then re-registering the spreadsheet, the commands for merging to document or printing showed up. But even then I was still not able to flip through the records to see how they would appear in the preview. I was able to merge the document to a file, though, and then print that. Then after similar stumbling around, opening and closing files, de-registering and re-registering databases, I was able to get the merge fields to show up for the labels. I've now printed the labels. But again, I have no idea what fixed the problem, and am not at all confident I can do it successfully in the future. Mail merges are one of the most important aspects of an office suite like this for me. I really wish it could be made more simple and reliable. Carl On 2/4/19 6:53 PM, Carl Paulsen wrote: Hi Wayne, This is off list so I should probably post this to the support list, but after a while of fiddling around, removing the databases I'd registered (Tools | Options | Base | Databases), closing LO, and then re-opening LO and re-registering them with the mail merge wizard, I was eventually able to get the spreadsheet to show in the labels picklist. I think it may be a slight bug, but it eventually let me build the labels. Hope something like that will work for you. Try de-registering the DBs, closing, restarting, re-registering, and see what happens. You've probably done that, but maybe it'll work? BTW, I'm on LO 6.1.4 I think, Windows 10, Intel processor (don't recall what and I'm off that computer now). Carl On 2/4/19 4:59 PM, stinson wrote: Carl, I'm having the same problem...not resolved. Platform: AMD Phenom(tm) II X2 555 Processor × 2 Ubuntu 16.04 LTS LibreOffice Version: 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial4 CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; Locale: en-US (en_US.UTF-8); Calc: group I've created a mailing DB - named columns (tables) - saved it - registered it ...but when attempting to print mailing labels only the DB name shows in the label window - no table names are made available to format the label. If I resolve this issue will post my solution Wayne On 2/4/19 4:37 PM, Carl Paulsen wrote: I'm trying to build a set of "Avery 5160" labels to match the letters I'm printing via mail merge, using the same spreadsheet data source. When I select Mailing Labels as the new document type, I am presented with a drop-down list of databases. I've registered the spreadsheet during the letter creation (though it has seemingly created the database multiple times, as it shows me 4 or 5 options with the same name) but when I select it in the labels dialog, it shows no tables and no fields. Help! How do I get the "registered" databases to show me the fields and data? The mail merge process seems to be pretty cumbersome. Aside from this problem, labels aren't created the same way Letters are, and I had to search and try things for hours to figure out how to insert address, salutation, and other fields manually (I don't like the address block approach of the wizard). The system seems to think my merge documents are damaged, launching the recovery system every time I open them (see my other post), and discarding the auto-recovery entries doesn't help. This really shouldn't be so hard to do. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Auto recovery problem
Windows 10. I think the LO version is either 6.1.4 or the previous one. Note that earlier in the day I was struggling with the same problems and saw that LO was telling me there was a new release. So in desperation I upgraded, which I think was to 6.1.4. That computer is down for the night but I can check again tomorrow. In any case that didn't fix it. Note that I eventually got the system to work...sometimes. I had de-registered the databases for my other issue, cleared the auto-recovery, started working with new files and got them to work sometimes. An example is a label document, where I saved the labels as a LO Writer document with the merge fields in it, and merged to a full sheet. That document continues to open with the auto-recover for itself, whether I discard the recovery point or not. When it opens it seems to work fine. With another document, a merge letter, I saved it with merge fields in place. That one appears to open without the auto-recovery, though this one opened with merge data in the place of the fields. And in this case I at some point I exchanged databases so I could build a merged file with a second data set. What seems like is happening is the documents get saved and closed, and then there's some kind of flag in the file that didn't get reset by the save, which marks it as damaged/needing recovery. So it triggers the auto-recovery system even when it's not needed. Carl On 2/4/19 6:06 PM, Dan Lewis wrote: Two things are needed to help you: your version of LibreOffice, and your operating system. Dan On 2/4/19 4:43 PM, Carl Paulsen wrote: I'm trying to create a mail merge document for a letter. I'm adding fields directly to retain formatting control and NOT have to deal with a text block which is how the wizard inserts addresses. I've had some success after a LONG time trying to figure out how to do this. Documentation is a bit lacking on this approach. The real problem is happening when I try to close and then reopen the document. The file appears to close fine but when I try to reopen it, LibreOffice seems to think the file is damaged. I can recover and the file opens fine, but same thing happens when I try to reopen again. I can also "discard" the auto-recovery which should fix the auto-recover so it doesn't come up again, but in fact it DOES. Even when discarding recovery points, the program continues to think there's a problem with the file and re-opens the auto recovery. I can't find any way to deal with this problem. BTW, it seems that I finally figured out how to generate the merged letters, so I assume the file is basically OK. But I still get the auto-recovery screen. I'd love to get this to stop. It's a hassle, slows me down, and doesn't show LO at it's best when I'm showing friends and clients. Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Auto recovery problem
Two things are needed to help you: your version of LibreOffice, and your operating system. Dan On 2/4/19 4:43 PM, Carl Paulsen wrote: I'm trying to create a mail merge document for a letter. I'm adding fields directly to retain formatting control and NOT have to deal with a text block which is how the wizard inserts addresses. I've had some success after a LONG time trying to figure out how to do this. Documentation is a bit lacking on this approach. The real problem is happening when I try to close and then reopen the document. The file appears to close fine but when I try to reopen it, LibreOffice seems to think the file is damaged. I can recover and the file opens fine, but same thing happens when I try to reopen again. I can also "discard" the auto-recovery which should fix the auto-recover so it doesn't come up again, but in fact it DOES. Even when discarding recovery points, the program continues to think there's a problem with the file and re-opens the auto recovery. I can't find any way to deal with this problem. BTW, it seems that I finally figured out how to generate the merged letters, so I assume the file is basically OK. But I still get the auto-recovery screen. I'd love to get this to stop. It's a hassle, slows me down, and doesn't show LO at it's best when I'm showing friends and clients. Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Auto recovery problem
I'm trying to create a mail merge document for a letter. I'm adding fields directly to retain formatting control and NOT have to deal with a text block which is how the wizard inserts addresses. I've had some success after a LONG time trying to figure out how to do this. Documentation is a bit lacking on this approach. The real problem is happening when I try to close and then reopen the document. The file appears to close fine but when I try to reopen it, LibreOffice seems to think the file is damaged. I can recover and the file opens fine, but same thing happens when I try to reopen again. I can also "discard" the auto-recovery which should fix the auto-recover so it doesn't come up again, but in fact it DOES. Even when discarding recovery points, the program continues to think there's a problem with the file and re-opens the auto recovery. I can't find any way to deal with this problem. BTW, it seems that I finally figured out how to generate the merged letters, so I assume the file is basically OK. But I still get the auto-recovery screen. I'd love to get this to stop. It's a hassle, slows me down, and doesn't show LO at it's best when I'm showing friends and clients. Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Mailing labels from mail merge
I'm trying to build a set of "Avery 5160" labels to match the letters I'm printing via mail merge, using the same spreadsheet data source. When I select Mailing Labels as the new document type, I am presented with a drop-down list of databases. I've registered the spreadsheet during the letter creation (though it has seemingly created the database multiple times, as it shows me 4 or 5 options with the same name) but when I select it in the labels dialog, it shows no tables and no fields. Help! How do I get the "registered" databases to show me the fields and data? The mail merge process seems to be pretty cumbersome. Aside from this problem, labels aren't created the same way Letters are, and I had to search and try things for hours to figure out how to insert address, salutation, and other fields manually (I don't like the address block approach of the wizard). The system seems to think my merge documents are damaged, launching the recovery system every time I open them (see my other post), and discarding the auto-recovery entries doesn't help. This really shouldn't be so hard to do. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Does something like this exist for LO?
On 2-2-2019 21:53, bunk3m wrote: I have been wondering how to export my Google Map Timeline so I can capture my mileage driven without having to get the kml file for each individual day. Today I found this add-in for Excel (Don't have Excel anymore :-( ) that runs a VBA script to do exactly what I'm looking for. https://github.com/Excel-projects/Excel-Timesheet Is there a way to run this in LO Calc? PS On digest mode. Please cc me directly on any replies. Thank you in advance. I did forget to mention that this tool: https://github.com/nerik/google-timeline-to-csv works with the: "Location History.json" from: https://takeout.google.com/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Does something like this exist for LO?
On 2-2-2019 21:53, bunk3m wrote: I have been wondering how to export my Google Map Timeline so I can capture my mileage driven without having to get the kml file for each individual day. Today I found this add-in for Excel (Don't have Excel anymore :-( ) that runs a VBA script to do exactly what I'm looking for. https://github.com/Excel-projects/Excel-Timesheet Is there a way to run this in LO Calc? PS On digest mode. Please cc me directly on any replies. Thank you in advance. This is a project which is 3 years old: https://github.com/nerik/google-timeline-to-csv it should be easy to import a csv in LibreOffice if above code shuold work. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy