2021-01-06 GnuCash IRC logs
00:01:27 *** Mechtilde has joined #gnucash
00:07:42 *** Mechtilde has quit IRC
00:11:21 *** Mechtilde has joined #gnucash
00:53:16 <chris> time to retire gnc_module_load... there's no C API compatibility guarantee
00:53:23 <chris> oops still in gnucash-commands
01:11:08 *** sbluhm has joined #gnucash
01:11:08 *** ChanServ sets mode: +v sbluhm
01:16:23 *** sbluhm has quit IRC
01:22:59 *** jervin has quit IRC
01:27:26 *** fell has quit IRC
01:28:45 *** fell has joined #gnucash
01:28:45 *** ChanServ sets mode: +o fell
01:29:28 *** jervin has joined #gnucash
01:31:10 *** frakturfreak has quit IRC
01:43:14 *** sbluhm has joined #gnucash
01:43:14 *** ChanServ sets mode: +v sbluhm
01:45:15 *** frakturfreak has joined #gnucash
02:08:02 *** chris has quit IRC
02:11:52 *** Mechtilde has quit IRC
02:22:07 *** jervin has quit IRC
03:04:42 *** jervin has joined #gnucash
03:05:16 *** jervin has quit IRC
03:05:56 *** jervin has joined #gnucash
03:12:35 *** Aussie_matt has quit IRC
03:51:49 *** Mechtilde has joined #gnucash
03:52:39 *** fell has quit IRC
03:55:37 *** fell has joined #gnucash
03:55:37 *** ChanServ sets mode: +o fell
03:58:08 *** David has quit IRC
03:58:13 *** David has joined #gnucash
04:14:36 *** Aussie_matt has joined #gnucash
05:45:43 *** field^Mop has joined #gnucash
06:00:25 *** Aussie_matt_ has joined #gnucash
06:02:50 *** Aussie_matt_ has quit IRC
06:04:52 *** Aussie_matt_ has joined #gnucash
06:05:03 *** User_ has joined #gnucash
06:06:50 *** Aussie_matt_ has quit IRC
06:36:54 *** Aussie_matt has quit IRC
06:40:39 *** User_ has quit IRC
06:45:47 *** Aussie_matt has joined #gnucash
07:02:25 *** CDB-Man has quit IRC
07:04:09 *** CDB-Man has joined #gnucash
07:04:10 *** ChanServ sets mode: +v CDB-Man
07:22:43 *** field^Mop has quit IRC
07:55:57 *** gjanssens has joined #gnucash
07:55:57 *** ChanServ sets mode: +o gjanssens
07:57:39 *** mydogsnameisrudy has joined #gnucash
08:04:41 *** field^Mop has joined #gnucash
08:11:03 *** Aussie_matt has quit IRC
08:12:14 *** chris has joined #gnucash
08:12:14 *** ChanServ sets mode: +v chris
08:12:14 *** gncbot sets mode: +o chris
08:13:42 *** dklann has joined #gnucash
08:28:45 *** mydogsnameisrudy has quit IRC
08:49:04 *** Jimraehl1 has joined #gnucash
08:49:56 *** Jimraehl1 has quit IRC
09:04:49 *** storyjesse has joined #gnucash
09:13:14 *** sbluhm has quit IRC
09:33:17 *** Agfarmer18 has joined #gnucash
10:03:04 *** CDB-Man has quit IRC
10:04:44 *** CDB-Man has joined #gnucash
10:04:44 *** ChanServ sets mode: +v CDB-Man
10:17:32 *** Agfarmer18 has quit IRC
10:17:42 *** field^Mop has quit IRC
10:53:53 *** halipaul has joined #gnucash
11:03:11 <warlord> chris, LOL
11:14:29 *** guak has joined #gnucash
11:15:38 *** storyjesse has quit IRC
11:17:56 *** mikey has quit IRC
11:18:03 *** ArtGravity has joined #gnucash
11:18:03 *** ChanServ sets mode: +v ArtGravity
11:24:35 *** field^Mop has joined #gnucash
11:37:49 *** Mechtilde has quit IRC
12:12:11 *** jervin1 has joined #gnucash
12:12:22 *** jervin has quit IRC
12:12:22 *** jervin1 is now known as jervin
12:14:53 *** jervin1 has joined #gnucash
12:16:52 *** jervin has quit IRC
12:16:52 *** jervin1 is now known as jervin
12:32:35 *** field^Mop has quit IRC
12:42:24 *** Pegasus_RPG has joined #gnucash
12:43:49 <Pegasus_RPG> Hello. I'm interested in helping improve GnuCash's business use case through helping test and fix any issues with using a SQL back-end. What is the current status of this?
12:44:40 <Pegasus_RPG> I'm also willing to try to hack a way to read QuickBooks files. (My first thought would be to use an ODBC connection as QBW files are SQLAnywhere databases.)
12:49:46 <warlord> Is there a documented QBW format somewhere?
12:50:25 <Pegasus_RPG> I haven't seen one. But I did find this: https://razorsql.com/articles/quickbooks_odbc_sql.html
12:51:18 <Pegasus_RPG> And this: https://qodbc.com/
12:52:43 <warlord> Interesting.
12:52:59 <Pegasus_RPG> Specifically, https://qodbc.com/what-is-qodbc/
12:53:35 <warlord> An importer leveraging that as a plug-in would be... interesting.. But hard to do (most likely) due to GPL issues.
12:54:35 <Pegasus_RPG> How so? The importer would just require the user to purchase QODBC in order to be useful.
12:54:44 <Pegasus_RPG> So the importer itself could be GPL with no issue
12:55:27 <Pegasus_RPG> Otherwise, one would need to essentially write an ODBC driver from scratch using Intuit's QB dev kit like the QODBC people have
12:56:24 <Pegasus_RPG> (Assuming there aren't terms in Intuit's dev kit agreement that would cause problems.)
12:56:30 <warlord> Yeah, I was thinking that it would call into qodbc directly, but if the importer just pulls into ODBC then we're probably safe. The larger concern, I think, would be a moving-target schema
12:56:43 *** jralls_afk has joined #gnucash
12:56:43 *** ChanServ sets mode: +o jralls_afk
12:56:44 *** Mechtilde has joined #gnucash
12:57:39 <Pegasus_RPG> That's what the cost of QODBC covers. They are using Intuit's official development docs to keep it up to date.
12:58:20 <warlord> But how much of the schema would be importer need to know?
12:59:03 <Pegasus_RPG> Enough to import the essential business data to start: customers, vendors, chart of accounts.
12:59:14 *** jralls has quit IRC
13:12:30 * Pegasus_RPG is trying to find the docs for QODBC
13:15:44 <warlord> My concern would be the importer might need to track changes to properly import.
13:20:49 *** jervin has quit IRC
13:22:13 <Pegasus_RPG> Ah here we go: https://qodbc.com/data-layouts/
13:22:54 <Pegasus_RPG> https://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2368/0/how-to-get-the-table-schema-rules
13:23:01 <Pegasus_RPG> Specific to QODBC of course
13:23:32 <warlord> And looks like might be specific to region, too... And, I worry, might change over time.
13:24:26 *** angel has joined #gnucash
13:27:02 <Pegasus_RPG> Wouldn't that SP_COLUMNS procedure mentioned in the second link always work?
13:30:45 <warlord> I didn't follow that link, so I don't know.
13:30:52 *** jcarl43 has joined #gnucash
13:30:52 *** ChanServ sets mode: +v jcarl43
13:46:10 *** angel has quit IRC
13:47:48 *** sbluhm has joined #gnucash
13:47:48 *** ChanServ sets mode: +v sbluhm
13:48:02 *** jervin has joined #gnucash
13:53:39 *** jervin has quit IRC
14:21:36 *** halipaul has quit IRC
14:29:51 <Pegasus_RPG> "You can also use the stored procedure command SP_COLUMNS tablename in VB Demo to get the EXACT table schema rules for the QuickBooks Company file you have open. The last few columns have QUERYABLE, UPDATEABLE, INSERTABLE and will show you the related tables for each table in QODBC via column named RELATES_TO."
14:30:14 <Pegasus_RPG> Seems like that should always work, assuming QODBC is kept up to date of course.
14:31:02 <Pegasus_RPG> At that point, a GnuCash importer should be straightforward. (Then if anyone ever develops a FOSS equivalent for QODBC, all the better.)
14:32:27 <Pegasus_RPG> So about my second item: what is the current status of the SQL back-end to GnuCash? I'm interested in testing and helping fix it.
14:39:40 <Pegasus_RPG> Back on the QB import topic, it seems the QODBC is just translating the XML data the QB SDK offers, so perhaps an importer would do better just interfacing directly with the SDK. https://developer.intuit.com/app/developer/qbdesktop/docs/develop/exploring-the-quickbooks-desktop-sdk
14:52:04 <warlord> I think it is relatively stable. The main issue would be lack of good regression tests to ensure there isn't any inadvertent data loss.
14:59:48 *** mydogsnameisrudy has joined #gnucash
15:01:26 * Pegasus_RPG reads the Testing wiki page
15:03:29 *** mydogsnameisrudy has quit IRC
15:22:28 *** field^Mop has joined #gnucash
15:27:44 *** mikey has joined #gnucash
15:59:33 *** jw4 has quit IRC
16:00:00 *** jw4 has joined #gnucash
16:00:01 *** ChanServ sets mode: +v jw4
16:07:18 *** sbluhm has quit IRC
16:54:35 *** Aussie_matt has joined #gnucash
17:08:14 *** mydogsnameisrudy has joined #gnucash
17:08:57 *** bertbob has quit IRC
17:13:29 *** bertbob has joined #gnucash
17:13:29 *** ChanServ sets mode: +v bertbob
17:21:02 *** mydogsnameisrudy has quit IRC
17:29:06 *** KaiForce has quit IRC
17:29:13 *** KipITOne has joined #gnucash
17:29:13 *** ChanServ sets mode: +v KipITOne
17:33:26 *** KipITOne has quit IRC
17:49:46 *** dd has joined #gnucash
18:00:52 *** Mechtilde has quit IRC
18:08:25 *** mauritslamers has quit IRC
18:08:25 *** mauritslamers_ has joined #gnucash
18:08:25 *** ChanServ sets mode: +v mauritslamers_
18:09:28 *** bertbob has quit IRC
18:53:15 *** ArtGravity has quit IRC
19:04:13 *** bertbob has joined #gnucash
19:04:14 *** ChanServ sets mode: +v bertbob
19:06:09 *** David has quit IRC
19:06:20 *** David has joined #gnucash
19:07:46 *** dd has quit IRC
19:08:04 *** jervin has joined #gnucash
19:35:06 *** jcarl43 has quit IRC
19:43:34 *** storyjesse has joined #gnucash
19:49:54 *** guak has quit IRC
20:12:28 *** field^Mop has quit IRC
20:46:33 <chf> Pegasus_RPG, I'm very interested in a working Quickbooks import, because I'd like to use that for our small non-profit association.
20:48:07 <chf> We've got old data from 2 "ancient" versions (5.x/2000?). Do they essentially use the same database format?
21:44:18 *** guak has joined #gnucash
21:56:05 *** guak has quit IRC
22:43:13 *** FH_thecat has joined #gnucash
23:01:08 *** storyjesse has quit IRC
23:25:55 *** FH_thecat has quit IRC
23:29:30 *** FH_thecat has joined #gnucash