**** BEGIN LOGGING AT Thu Jun 14 03:00:04 2018 Jun 14 03:41:48 Got section('@',1,1). The only function remaining is getJourneyDetailsData. Just where does the url come from - no idea. But I can write json handler in, regardless. Jun 14 03:46:43 When using a spreadsheet as a database, in this case an .xls workbook in LibreOffice Calc, is it possible to get a list of rows in which a certain column has a certain value or even only in which a certain column has a non-blank value? In a real database, I can simply query something like “SELECT * FROM table_name WHERE column_name CONTAINS (?) keyword;” but can I do something similar with a spreadsheet? Jun 14 03:53:55 My use case: my credit union is changing their credit card provider, which means that my credit card is being replaced, which means that I have to manually update my payment information with all of the merchants who automatically bill this credit card account. I have a local spreadsheet file containing logins/credentials and other details for most of my accounts. This spreadsheet, which I use as a database, has a column/field for payment method. I enter Jun 14 03:53:55 “MasterCard” in this column/field if I pay with my credit card account. I want to get a list of all of my accounts where I pay with my credit card account. Jun 14 03:53:58 brolin_empey: I think this is the wrong channel for that question :) Jun 14 03:54:35 I dont think LibreOffice can even RUN on an N900 :P Jun 14 03:57:07 FreOffice can, and it supports spreadsheets Jun 14 03:58:32 jonwil: I think LibreOffice can run on a Nokia N900, especially considering that OpenOffice.org/go-oo can run on an OpenMoko GTA02, which is slower and less capable than the N900. Jun 14 03:59:17 Its still not the right place to ask about LibreOffice, the right place would be #libreoffice (which does exist) Jun 14 05:05:07 brolin_empey: convert to CSV and grep? Jun 14 05:12:14 Maxdamantus: I queried DuckDuckGo and found this Q&A: Jun 14 05:12:14 https://ask.libreoffice.org/en/question/57507/calc-select-rows-which-contain-a-number-from-a-list-of-numbers-which-is-in-a-column-in-a-different-sheet/ Jun 14 05:12:14 I spent a while trying to use a filter to copy the rows of interest to a different sheet until I realised that I can simply sort the worksheet by the “payment” column/field, same as I would do when editing a table in a real database. It took me a while to determine how to get the desired result by sorting but I finally got it. Jun 14 05:15:18 Now the problem I have is that this table, effectively database, of accounts does not distinguish between merchants for whom I have a subscription and merchants from whom I bought something at least once even if it was years ago but do not have a subscription. Jun 14 05:22:46 Maybe I should have the merchants for whom I have a subscription charge me via PayPal, if possible, instead of updating my credit card account information with the merchant because then, theoretically, I have to update my credit card account information only once, with PayPal, every time my credit card account information changes instead of having to update my payment information with every merchant for whom I have a subscription every time my credit card Jun 14 05:22:46 account information changes. I considered this years ago but never actually did it because the burden with the current situation is not too bad if it has to be done only every few years. Jun 14 05:25:30 The far greater burden will be manually updating all of the accounts that have my home address if I move again for the first time since 2010 January. Jun 14 05:26:40 Or if my telephone number changes for the first time since 2008. Jun 14 07:58:35 jonwil : What is getJourneyDetailsData expected to be? I don't understand route from TransLink [fromStation and toStation are self-explanatory], and I can hardly read MVV-Germany results [Tram 18 Destination SomeStreet is difficult to understand] Jun 14 07:59:48 ana> {version, systemMessages, journeys: [{rating, isAdditional, interchanges, legs: [{duration, origin, destination, transportation, hints, stopSequence, infos, coords, properties},{}]},{}]} Jun 14 08:01:52 And putting into "info" field [about leg of a journey] the text "Duration: 60" doesn't sound good [since it's 60 seconds] Jun 14 08:03:22 What's the difference between toStation and toInfo for a leg of a journey? Jun 14 08:05:09 * Oksana goes outdoors Jun 14 08:05:52 And MVV-Germany sometimes gives "Error opening the details" Jun 14 08:27:16 i hate autotools Jun 14 08:27:19 i also hate cmake Jun 14 08:27:21 and i also hate scons Jun 14 08:27:24 hate them all Jun 14 08:27:30 it's all an undecipherable mess Jun 14 08:27:46 how do you achieve portability then/ Jun 14 08:28:20 with lots of pain Jun 14 08:28:36 so not much different Jun 14 08:28:44 i have a 100 line scons python script don't i don't ever touch again Jun 14 08:28:52 and then i can use small scons files Jun 14 08:29:00 but i still hate it all Jun 14 08:29:42 i hate that it's nonstandard and has no standard way of setting compilation options, cross compiler, etc, it's just a hack passing arguments after the call to scons Jun 14 08:29:56 i've tried at least 8 times to understand autotools and i just can't get it Jun 14 08:30:43 it's the most common thing out there, the most standard, but it's all just a gigantic hack of different macro languages with confusing macro names and weird syntax Jun 14 08:31:06 i just use sh Jun 14 08:31:40 in the end it's always needing manual touches, so why bother Jun 14 08:35:23 it's all a pain in the ass Jun 14 08:37:37 you're absolutely right with the fact that they're just all a gigantic hack, but I still prefer this standard gigantic hack, than having to handle/patch every single package for crosscompilation Jun 14 08:38:50 i know, and that's why i wanted to autotoolize my software... yet i've failed once again, I get so frustrated that I never manage to do the simplest thing Jun 14 08:38:58 since it appears that most handcrafted build "system" (ie makefile/script) fail with crosscompilation at some point (unless the authors tried to crossbuild it, and even then, they always miss some case) Jun 14 08:39:41 bencoh, that's what i mean by manual touches Jun 14 08:39:59 KotCzarny: I dont need "manual touches" when building a properly written autotools package Jun 14 08:40:21 sure, and then one day it happens to fail on some system/new distro revision Jun 14 08:41:13 especially if you rely on some external libs Jun 14 08:42:02 then you properly fix what needs to be fixed, for "everyone" Jun 14 08:42:38 in a perfect world, yeah Jun 14 08:42:42 instead of adding another hacky bunch of lines to your handcrafted thing Jun 14 08:43:46 my problem is... i don't know how to begin writing an autotools package :( Jun 14 08:43:49 not saying this whole stuff is "perfect" in any way, just that I still prefer it by far than having to read/understand/patch every single homebrew makefile when crosscompiling it Jun 14 08:43:49 i'm completely useless Jun 14 08:44:03 ceene: lib or program? Jun 14 08:44:18 and i also think it's the best solution (not that i think it's good at all, but the best nonetheless) Jun 14 08:44:19 both Jun 14 08:44:34 (not that it's too different, but I have a simple autotools base to build a program, if you want) Jun 14 08:44:44 i have several pieces of software that i want to autotoolize: libs and programs, and some repositories contain both a lib and a couple of programs that use them Jun 14 08:44:45 (not that good, but working on maemo) Jun 14 08:44:55 ah Jun 14 08:45:13 https://github.com/msune/autotools-skeleton Jun 14 08:45:16 :) Jun 14 08:45:21 (just a random google) Jun 14 08:45:28 :) Jun 14 08:47:13 i really hate it all Jun 14 08:47:18 aww Jun 14 08:47:41 Much chaos seems to persist in the documentation of the various autotools (part of the GNU Build System). I don't know how others sort it out. I am inclined to think that they just copy an example and ignore or don't check the warnings Jun 14 08:47:43 hehe Jun 14 08:47:46 nice quote Jun 14 08:48:16 i also hate that there have to be so many files around the directory Jun 14 08:48:34 i don't want them, they're just sitting there taking mental space Jun 14 08:49:09 better to trim down, than desperately look for docs Jun 14 08:50:00 [autoproject] - This tool creates a skeleton source package for a new program Jun 14 08:50:41 let's try that Jun 14 08:51:19 https://directory.fsf.org/wiki/Autoproject Jun 14 08:52:30 seems beta, version is 0.20 Jun 14 08:52:45 $ ls -1|wc -l Jun 14 08:52:45 41 Jun 14 08:52:56 y don't really want a thing that creats 41 files Jun 14 08:53:19 and creates an xmalloc.c file Jun 14 08:53:21 what the hell Jun 14 08:53:35 if my system doesn't have an standard malloc i don't give a shit Jun 14 08:54:05 let's see the autotools-skeleton repo Jun 14 08:57:53 well, it seems simpler than the libabc repo Jun 14 08:58:20 a bit more comprehensible Jun 14 09:00:53 http://inti.sourceforge.net/tutorial/libinti/autotoolsproject.html Jun 14 09:01:00 this is also nice explanation of the files Jun 14 09:01:37 thanks! Jun 14 09:02:22 the smallest autotools project is just makeile.am and configure.in Jun 14 10:21:37 Oskana: The best way to see how things work would be to use a web browser that supports network transaction logging, visit www.translink.com.au and do a journey plan search and look at the JSON output to see for yourself how it looks. Jun 14 10:22:10 You could put "Beenleigh Station" into one box and "Strathpine Station" in the other box to get some good output. Jun 14 13:43:18 Yo, anyone alive? Jun 14 13:43:33 somehow :) Jun 14 13:43:39 Ayy - Success Jun 14 13:44:02 You wouldn't know what Fremantle repo to use, would you? Jun 14 13:44:18 I'm getting KEYEXPIRED on both Muarf and Linenoise mirrors Jun 14 13:44:54 as per https://wiki.maemo.org/Repository Jun 14 13:45:05 they're only mirrors, so they just host the original files, which were signed by nokia with a now expired key Jun 14 13:45:30 to avoid that, someone would need to resign packages with a trusted key Jun 14 13:46:07 Ah okay so, even with the keyexpired warning, updates, etc should still be working fine? Jun 14 13:46:27 yeah Jun 14 13:47:31 Awesome - Having both the Linenoise and Muarf mirrors enabled in my catalogue list shouldn't cause any issues either, right? Jun 14 13:48:06 the repositories for which you get KEYXPIRED errors haven't been updated since nokia stopped working on maemo, btw. only extras-* and cssu-* get updates nowaday Jun 14 13:48:18 +s Jun 14 13:50:12 Yeah, I have repository.maemo.org/community in my catalogue list Jun 14 13:50:22 :) Jun 14 13:50:25 Have only just started using my N900 again after a couple of years Jun 14 13:50:36 yay :) Jun 14 13:50:57 So, trying to make sure it's actually got all the right repos, etc and is updated with whatever has been released in the last few years haha Jun 14 13:51:44 welcome back then :) Jun 14 13:52:08 Community SSU Version I'm using is 21.2011.38-1Tmaemo12 -- Flavor: Testing Jun 14 22:37:57 ~tell Nihlander about lf Jun 14 22:38:39 follow links from there Jun 14 22:38:46 links and advice Jun 14 22:39:19 and having double repos will make your apt-get update (and HAM) take twice as long to finish Jun 14 22:39:31 also Jun 14 22:39:34 ~jrtools Jun 14 22:39:35 i heard jrtools is http://wiki.maemo.org/User:Joerg_rw/tools Jun 14 23:30:23 jonwil : I have JSON output, I just don't quite understand the structure of DetailedResultsItem . I guess I should read parser_abstract.h Jun 14 23:31:23 Yeah probably Jun 14 23:31:49 Anyhow, its great that you are putting in the effort to make this backend work again. Jun 14 23:32:14 And once its done I will for sure add it to the git repo and spin another binary package for the forum post Jun 14 23:56:43 * Oksana thinks that this backend will likely have a problem or two, so, I am sprinkling the code with qDebug Jun 14 23:59:06 Ok. Jun 14 23:59:08 Great. **** ENDING LOGGING AT Fri Jun 15 03:00:10 2018