[libreoffice-users] Re: Does something like this exist for LO?
On 05.02.2019 14:05, Luuk wrote: On 5-2-2019 02:55, bunk3m wrote: 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. Install nodejs (see https://nodejs.org/en/) Download, and install 'google-timeline-to-csv' in a directory. Now when you do this: 'node index.js' You might get an error about missing library's. To install those missing library's type: 'npm install fs path xmldoc json2csv moment' (npm should be installed together with nodejs) == Thanks so far Luuk. I have installed nodejs10 and npm6 using Macports as I didn't know any other way to get that installed. It is throwing errors on processing the 'Location History.json' file. 'node index.js ../Takeout/Location\ History/ > ../Takeout/location.csv' In the location.csv file I find this: Error: params should include "fields" and/or non-empty "data" array of objects at checkParams (/Users/bunk3m/Downloads/google-timeline-to-csv-master/node_modules/json2csv/lib/json2csv.js:95:11) at module.exports (/Users/bunk3m/Downloads/google-timeline-to-csv-master/node_modules/json2csv/lib/json2csv.js:48:5) at pointsToCsv (/Users/bunk3m/Downloads/google-timeline-to-csv-master/index.js:134:3) at Object. (/Users/bunk3m/Downloads/google-timeline-to-csv-master/index.js:39:1) at Module._compile (internal/modules/cjs/loader.js:689:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:700:10) at Module.load (internal/modules/cjs/loader.js:599:32) at tryModuleLoad (internal/modules/cjs/loader.js:538:12) at Function.Module._load (internal/modules/cjs/loader.js:530:3) at Function.Module.runMain (internal/modules/cjs/loader.js:742:12) I'm stuck as I don't understand what the error would refer to. But this is interesting! Should I be referring to the github project? Could you give me an idea how to search for such an error? Thanks. -- 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
Renaming user profile. Re: [libreoffice-users] Auto recovery problem
Hi :) This link might help; https://wiki.documentfoundation.org/UserProfile Renaming the profile, or backing it up before resetting it means you keep all your galleries and templates and stuff in a separate place. So you can copy stuff back into your fresh new profile if you want to. Regards from a Tom :) On Wed, 6 Feb 2019 13:20 Carl Paulsen Thanks for this suggestion. I'll try it next time I notice the problem > (which could be soon since I'm not convinced I've fixed it). > > Carl > > > On 2/4/19 8:09 PM, Girvin Herr wrote: > > 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 > -- 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/use
Re: [libreoffice-users] Auto recovery problem
Thanks for this suggestion. I'll try it next time I notice the problem (which could be soon since I'm not convinced I've fixed it). Carl On 2/4/19 8:09 PM, Girvin Herr wrote: 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