2010-02-23 GnuCash IRC logs

02:06:16 *** Jimraehl has quit IRC
02:06:16 *** demitar has quit IRC
02:14:09 *** Gokee2 has quit IRC
02:14:25 *** Jimraehl has joined #gnucash
02:14:25 *** demitar has joined #gnucash
02:16:34 *** kling0n has joined #gnucash
02:28:21 *** kling0n has quit IRC
03:01:29 *** swaddo has quit IRC
03:01:54 *** ErKa has joined #gnucash
03:11:05 *** bentob0x has joined #gnucash
03:22:57 *** jpetersen has joined #gnucash
04:05:07 *** ErKa has quit IRC
04:41:27 *** feisar has joined #gnucash
05:27:43 *** swaddo has joined #gnucash
05:29:37 *** ErKa has joined #gnucash
06:33:54 *** swaddo has quit IRC
06:54:13 *** fDavid has joined #gnucash
07:38:49 *** bentob0x has quit IRC
07:43:36 *** Jimraehl has left #gnucash
07:59:52 *** Jimraehl has joined #gnucash
08:22:51 *** warlord-afk has quit IRC
08:59:29 *** warlord has joined #gnucash
08:59:29 *** gncbot sets mode: +o warlord
10:01:05 *** puck has quit IRC
10:04:00 *** puck has joined #gnucash
10:16:08 *** Wollie has joined #gnucash
10:16:27 <Wollie> good morning all!
10:16:42 <Wollie> first of all thanks for developing GNUcash :).
10:16:59 <Wollie> I'm having a question though that I cannot get answered and perhaps someone here can help me.
10:17:08 *** puck has quit IRC
10:17:48 <Wollie> We want to work with GNUcash in combination with a local bank. This bank will sent us updates about payments in a .txt file using it's own format.
10:18:23 <Wollie> We would like to import this file and match it with outstanding invoices of customers. When paid, GNUcash needs to be updated.
10:18:49 <Wollie> I can give all technical details about the .txt but am wondering first if someone can and is willing to help us with this. Thanks!
10:21:17 <warlord> Wollie: are you trying to write a new importer?
10:23:45 <Wollie> Warlord: yes, but not just plain import, GNUcash also needs to update existing records based on this .txt
10:24:17 <warlord> the importers can already do that.. E.g., marking existing txns as cleared.
10:24:20 <warlord> (if they are dups)
10:25:06 <Wollie> but this .txt is in a very typical format that only consists of numbers. Can I tell GNUcash that the first 4 numbers are X and the next 4 numbers are Y?
10:26:01 <warlord> If by "tell gnucash" you mean "write code to interpret the txt file", then yes.
10:26:21 <warlord> you wont be able to import it without getting your hands dirty in C
10:26:45 <ZeiP> Unless you write a script to transform it to a supported format
10:26:52 <Wollie> hmmm, and I gave 0 experience in C. Is there any consulting company that you know of that can assist in this matter?
10:28:11 <Wollie> Zeip: that can be an option indeed. The .txt file contains a lot of data we won't use, we basically only want the customer REF#, amount paid and date paid.
10:30:46 <Wollie> (I'm off to a meeting with a possible new client, will be back in around 1,5 hours)
10:41:26 <warlord> Wollie: you could try to convert it to QIF, but none of the current importers can actually "process payment"
10:43:29 <warlord> Basically, there's currently no importer that will properly affect biz objects/transactions
10:55:47 *** puck has joined #gnucash
10:59:50 *** jpetersen has quit IRC
11:13:36 *** bentob0x has joined #gnucash
11:39:32 *** blizgerg has quit IRC
11:40:07 *** ErKa has quit IRC
11:53:18 *** jpetersen has joined #gnucash
13:04:19 *** Zoolooc_ has joined #gnucash
13:26:31 *** ErKa has joined #gnucash
13:57:59 *** Gokee2 has joined #gnucash
14:04:14 *** andyt has joined #gnucash
14:32:00 <Wollie> re
14:34:01 <Wollie> hmmm, if there is no way to process a payment, what are the views of making this available?
14:34:15 <Wollie> and perhaps using a script and editing a MySQL database this could be done?
14:34:24 <Wollie> (which means I have to wait for the new GNUcash version)
14:35:46 *** feisar has quit IRC
14:40:37 <warlord> editing the database out from under gnucash is not supported or recommended.
14:41:49 <warlord> But right now there is no importer method to assign a transaction to a customer and treat it as a payment.
14:42:47 <warlord> There's gncOwnerApplyPayment()
14:45:33 *** Bornabe has joined #gnucash
14:45:37 <Bornabe> Hello there.
14:45:49 <Bornabe> Anyone around I can ask a few questions to?
14:46:37 <Bornabe> I am trying to help my parents recover old data from a previous company using One-Write Plus, they need to pull up the old data, and GnuCash is the best thing to use out there from my own experience.
14:46:51 <Bornabe> Are there any free ways to convert the OWP database on over to something GnuCash can use?
14:47:14 <jsled> I've never heard of that program in many years of being affiliated with gnucash
14:47:30 <Bornabe> It's an old account software, now owned by PeachTree.
14:49:32 <warlord> I've been involved since 1999 and I've never heard of OWP. I'm afraid I know of no way to import their data. Sorry. Can OWP export QIF?>
14:49:56 <Bornabe> I wasn't able to see that in it's options anywhere.
14:50:05 <Bornabe> I'm going to go back to their house tomorrow and double-check.
14:50:31 <Bornabe> OWP is now known as PeachTree Accounting, but is so old, that converting it may be a toughy, lol.
14:50:49 <Bornabe> I think it stopped production in or around 1998.
14:51:13 <Bornabe> PeachTree offers a service to convert it to their newer software, for an ugly amount of money.
14:51:29 <Bornabe> And since they're no longer in business, I don't see the point in spending hundreds to get this data back to usable.
14:53:26 <Bornabe> I'm going to keep researching. Thanks for the quick replies.
14:53:33 *** Bornabe has quit IRC
15:09:58 *** ecolitan has joined #gnucash
15:26:34 *** jpetersen_ has joined #gnucash
15:31:00 *** Zoolooc__ has joined #gnucash
15:35:11 *** jpetersen has quit IRC
15:39:26 *** Zoolooc_ has quit IRC
15:54:43 *** cort has joined #gnucash
15:57:16 *** raleightile has joined #gnucash
16:10:17 *** jpetersen_ has quit IRC
16:23:48 *** fDavid has quit IRC
16:31:00 *** obawin has joined #gnucash
16:35:32 *** raleightile has quit IRC
16:46:06 *** warlord has quit IRC
16:54:56 *** ecolitan has quit IRC
17:05:50 *** warlord has joined #gnucash
17:05:50 *** gncbot sets mode: +o warlord
17:21:39 *** ErKa has quit IRC
18:16:53 *** andyt has quit IRC
18:56:45 <warlord> Huh.. I appear to have lost my local logs for the last couple days. :(
19:14:55 *** Zoolooc__ has quit IRC
19:15:48 *** fDavid has joined #gnucash
19:25:18 *** obawin has quit IRC
19:45:23 *** cort has quit IRC
20:13:08 *** blizgerg has joined #gnucash
20:35:35 *** swaddo has joined #gnucash
20:55:10 *** bentob0x has quit IRC
21:18:13 *** fDavid has quit IRC
21:27:34 *** jimbo1 has joined #gnucash
21:29:07 <jimbo1> ?
21:30:27 <jimbo1> hi, anyone around tonight?
21:30:50 <warlord> define "around"?
21:31:00 * warlord notices there is no /topic
21:31:42 <jimbo1> just wondering if someone could help me, I screwed up my QFX imports
21:31:51 <warlord> screwed up how?
21:32:02 <warlord> (can't help if you don't ask your question)
21:32:07 <jimbo1> when you first import a QFX file it asks which account to use
21:32:15 <jimbo1> and i clicked the wrong one
21:32:21 <jimbo1> and don't know how to change it
21:32:26 <jimbo1> sorry slow typist
21:32:30 <warlord> Oh. oops. well, you have two ways:
21:32:39 <warlord> 1) hand-edit your data file and remove the binding
21:33:19 <warlord> 2) create a temp ofx file with a bogus acctid, assign that to the one you chose this time, then re-import the correct one and choose the correct account
21:33:41 <jimbo1> ofx is just ascii right?
21:33:49 <jimbo1> a glorified csv?
21:34:00 <warlord> SGML
21:35:07 <jimbo1> so ACCTID is what i'm looking for, eh?
21:35:43 <warlord> I think so...
21:36:09 <jimbo1> matches the visa # so that must be it.
21:36:16 <jimbo1> thanks for the prompt help
21:36:21 <warlord> you're welcome
21:46:30 <jimbo1> That did solve my problem tyvm
21:46:37 *** jimbo1 has left #gnucash
21:53:13 *** TommyT has joined #gnucash
22:06:03 *** TommyT has quit IRC
22:22:14 *** TommyT has joined #gnucash