2023-03-23 GnuCash IRC logs
00:00:00 <NoobAlice> I've had that issue in MS Excel a few times, where it interprets a column of dates as some being M/D and others D/M for no reason I can see.
00:00:50 <Robert847> I shall try your suggestion, maybe I need to save the file in native sprreadsheet format and massage it then convert back to csv.
00:01:55 <NoobAlice> You can open a CSV directly in Calc. I would try doing that, saving your fixes as a copy, and seeing what that looks like when you open it in a text editor or reopen it in Calc.
00:03:51 <Robert847> Maybe I need to declare those cells to be dates instead of general format
00:04:00 <NoobAlice> Yes you do.
00:07:25 <Robert847> aha! then I need to delete the leading apostrophe
00:07:46 <Robert847> I think I have it
00:07:51 <NoobAlice> Oh good :)
00:34:04 <Robert847> Found the solution in the help. it requires regular expressions, and it works beautifully
00:37:20 *** NoobAlice has quit IRC
02:11:19 *** chipxxx has joined #gnucash
02:27:28 *** gandalf has joined #gnucash
02:38:06 *** fell has quit IRC
02:39:26 *** fell has joined #gnucash
02:39:26 *** ChanServ sets mode: +o fell
02:59:03 *** Joc has joined #gnucash
02:59:04 *** ChanServ sets mode: +v Joc
03:14:44 *** chipxxx has quit IRC
05:33:16 *** Joc has quit IRC
05:48:00 *** chipxxx has joined #gnucash
07:47:33 *** chipxxx has quit IRC
08:28:27 *** gandalf1 has joined #gnucash
08:28:55 *** gandalf has quit IRC
08:28:55 *** gandalf1 is now known as gandalf
09:18:40 *** Treasurer has joined #gnucash
09:18:45 *** Treasurer has left #gnucash
09:18:49 *** Treasurer has joined #gnucash
09:30:33 *** Treasurer has left #gnucash
09:31:26 *** Treasurer has joined #gnucash
10:51:15 *** Joc has joined #gnucash
10:51:15 *** ChanServ sets mode: +v Joc
11:30:51 *** NoobAlice has joined #gnucash
11:30:51 *** ChanServ sets mode: +v NoobAlice
12:08:05 *** ArtGravity has joined #gnucash
12:08:05 *** ChanServ sets mode: +v ArtGravity
13:21:34 <jralls> fell, re REQUEST_URI, yes, it probably should be filtered. I found the behavior to be a little different from what's documented, too: It gave the host subdirectory containing the website but nothing inside the website, so e.g. if the request was for //hostname/gnucash-htdocs/news.phtml 'SERVER_NAME' had hostname and 'REQUEST_URI' had gnucash-htdocs. The PHP documentation sys that 'REQUEST_URI' should have been gnucash-htdocs/news.phtml.
13:34:58 <fell> jralls: The name "DEFAULT_URL" is missleading. we want the servers DOCROOT here.
13:37:14 <fell> usually, but not in this code specific hack.
13:52:19 <fell> We compose the URL in header.phtml as <meta property="og:url" content="<?=\DEFAULT_URL.make_lang_href($page, $get_parms)?>"/>
13:53:01 <jralls> fell, the objective is to make it not code-specific. On my server $_SERVER{'DOCUMENT_ROOT'] returns `var/www/html`. That's for accessing the filesystem not constructing URIs.
13:54:12 <fell> with $page set in the induvdual docs as $page = basename($_SERVER['SCRIPT_NAME']);
13:57:41 <fell> OK, DOCROOT is misleading, should have been the root of the docs as URI part.
13:58:44 <jralls> That's one place; there's also og.image and an anchor in header, 5 uses in atom.php, and $basepath in viewdoc.phtml.
14:35:03 *** Joc has quit IRC
14:38:46 *** Gorfou has quit IRC
14:43:12 *** palerider has joined #gnucash
14:44:39 *** palerider has left #gnucash
15:22:10 *** jervin has joined #gnucash
17:17:07 *** gandalf has quit IRC
18:06:37 <jralls> fell: CWehli put 2 docs PRs up in February. He pointed them at maint, but they're substantial rewrites so they should go to master. You haven't commented on either, I imagine because you were up to your ears in taxes at the time. Can you give them a quick once-over now?
18:07:18 <jralls> If they're reasonably OK--perfect is *not* necessary, they can be fixed up later--I can get them in the 5.0 docs release.
18:16:06 <jralls> BTW, I've tagged the 4.14 docs release and pushed it.