Menu
▾
▴
sql-ledger-users
|
From: Uri G. <ur...@be...> - 2006-10-27 21:30:09
|
i have data dumped from another ledger program (quickbooks) in csv files. it is typical stuff like product orders and customer/vendor info. is there any standard way to import these into sql-ledger? or are there any relate utility scripts or examples? i can hack the perl to suit my needs (parsing cvs, column name munging and such) or even do a full script if there is a schema and/or some dbi code i can use. any ideas are welcome. thanx, uri |
|
From: Stroller <lin...@my...> - 2006-10-28 00:33:04
|
On 27 Oct 2006, at 22:29, Uri Guttman wrote: > > i have data dumped from another ledger program (quickbooks) in csv > files. it is typical stuff like product orders and customer/vendor > info. is there any standard way to import these into sql-ledger? or > are > there any relate utility scripts or examples? They're here: <http://www.sql-ledger.org/cgi-bin/nav.pl?page=misc/conversions.html> Dieter: It took me some time to find these, and I was only able to because I knew they existed. Eventually I searched the email folder to which I filter this list for "import" and found the link straight away, but I was unable to search your site via Google. For instance, <http:// www.google.com/search?q=+import+site%3Asql-ledger.org> returns nothing, and it seems that in all only 3 pages of SQL-Ledger are indexed by Google <http://www.google.com/search?q=site%3Asql- ledger.org>. Is spiders.txt the problem? If this is something that could be easily resolved then it might be helpful. Stroller. |
|
From: Kevin B. <kb...@fr...> - 2006-10-29 14:11:22
|
Hi, When going through the reconcilliation there are times when this shows me that an error has occured. So sometime I have to delete a transaction. If this has not been reconciled can I presume that this will not have any effect. What happens if I accidentally delete a transaction which has been set as reconciled? Thanks, Kevin |
|
From: Danita Z. <da...@ca...> - 2006-10-29 14:34:06
|
> They're here: > <http://www.sql- ledger.org/cgi- bin/nav.pl?page=3Dmisc/conversions.html>= Okay - so now the next question is, just how flexible are these for a = non-expert, and can they be used on an ongoing basis. For example, both = our shopping cart and our credit card processor will export data in comma = delimited, tab delimited, Quicken or Quickbooks formats. Would it be easy = enough for me to "import" this information into my SQL-Ledger routinely? Thanks. Danita |
|
From: Danita Z. <da...@ca...> - 2006-10-29 16:54:35
|
>Okay - so now the next question is, just how flexible are these for a = non- expert, and can they be >used on an ongoing basis. =20 BTW - I see that these are all pretty much "static" info imports - like = customers, vendors, parts, etc. I'd be interested if anyone has every put = together an import tool for importing actual transactions I guess! Thanks. Danita |
|
From: Roy P <or...@sh...> - 2006-10-29 17:15:48
|
On Sunday 29 October 2006 8:33 am, Danita Zanre wrote: > > They're here: > > <http://www.sql- ledger.org/cgi- bin/nav.pl?page=misc/conversions.html> > > Okay - so now the next question is, just how flexible are these for a > non-expert, and can they be used on an ongoing basis. For example, both > our shopping cart and our credit card processor will export data in comma > delimited, tab delimited, Quicken or Quickbooks formats. Would it be easy > enough for me to "import" this information into my SQL-Ledger routinely? > > Thanks. > > Danita The scripts on that page only import parts, vendor info and customer info. They don't handle actual transactions. This could be done using Sql-ledger API. There has been a few posts on this list about developing script that will handle this. Maybe others on this list who already have scripts like this can give/sell them to you..... or can write some for you if needed. Of course having Dieter write them for you is an option too. Cheers |
|
From: david <da...@ke...> - 2006-10-30 04:20:15
|
On Sun, 2006-10-29 at 14:11 +0000, Kevin Bailey wrote: > Hi, > > When going through the reconcilliation there are times when this shows > me that an error has occured. > > So sometime I have to delete a transaction. > > If this has not been reconciled can I presume that this will not have > any effect. > > What happens if I accidentally delete a transaction which has been set > as reconciled? I finished my quarterly reconciliations about an hour ago, so it's all very fresh :-) If you alter or delete any transaction that's been previously reconciled, the reconciliation will need to be done again (pretty reasonable really). As a matter of good practice, I always check the old reconciliation before starting a new period. If you delete or alter any transaction from AFTER the period that has been reconciled, there is no effect at all. I believe an accountant would tell you that deleting/changing transactions after reconciliation is a BAD_IDEA (tm). I do it all the time, but then I'm not an accountant so it's OK. You can use audit control to lock transactions (somebody correct me if I'm wrong?), but that's for people who do the job properly. |
|
From: Wallace R. C. <wrc...@gm...> - 2006-10-30 20:24:00
|
On 10/29/06, david <da...@ke...> wrote: ... > I believe an accountant would tell you that deleting/changing > transactions after reconciliation is a BAD_IDEA (tm). Why not simply make an adjusting transaction instead of deleting one? -- Best Regards, Wallace |
|
From: David R. <le...@re...> - 2006-10-30 13:55:49
|
Quickbooks is pretty much a 'Hotel California' for transaction data. They go to great lengths to prevent you from getting transaction data. This of course helps the revenue stream because its easier to pay another $150 this year and upgrade than to do anything else. I have had a link in the past to a [non-free] package that can convert a QB database to Micro$oft Access and I used it once and was able to write a conversion for my specific needs. The problem was that on the next Quickbooks update, Intuit changed fhe format yet again, rendering the $100 converter useless. I just googled and this sounds like the program that I used: http://www.synergration.com/accessBooks/default.htm I seem to remember that the one I used had a free download that would show only the first 50 records in each table, so you could get an idea what your're getting into and if it will work with your data. Good luck, and as always -- "your mileage may vary", "Solutions are guaranteed to work unless they don't", etc. -- Dave Ratte Recreational Mobility On Sunday 29 October 2006 11:54, Danita Zanre wrote: > BTW - I see that these are all pretty much "static" info imports - like > customers, vendors, parts, etc. I'd be interested if anyone has every put > together an import tool for importing actual transactions I guess! |
|
From: Danita Z. <da...@ca...> - 2006-10-31 21:25:38
|
>Quickbooks is pretty much a 'Hotel California' for transaction data. They = go=20 >to great lengths to prevent you from getting transaction data. I know - that's why I don't use it any longer <g>. I'm not actually = looking to convert Quickbooks data. I'm looking to import data into = SQL-Ledger through ascii delimited files. For example, we moved to Paypal = Website Payments Pro for our online credit card processing company - we = can download transactions in various formats: comma delimited, tab = delimited, Quicken or Quickbooks. I'd be happy with an import tool that = could handle any of those really. Danita |
|
From: Remco v. V. - C. H. C. <r.v...@ch...> - 2006-11-01 08:46:26
|
Well maybe you should write something yourself, i've done so by writing a php script that's able to import our suppliers products by reading a comma delimited file. PHP is great language to use for such kinda things i think... Remco Danita Zanre schreef: >> Quickbooks is pretty much a 'Hotel California' for transaction data. They go >> to great lengths to prevent you from getting transaction data. >> > > I know - that's why I don't use it any longer <g>. I'm not actually looking to convert Quickbooks data. I'm looking to import data into SQL-Ledger through ascii delimited files. For example, we moved to Paypal Website Payments Pro for our online credit card processing company - we can download transactions in various formats: comma delimited, tab delimited, Quicken or Quickbooks. I'd be happy with an import tool that could handle any of those really. > > Danita > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > -- Met vriendelijke groet, Remco van Vugt - Chris Hectors Compuvision E: r.v...@ch... T: 0164-674935 |
|
From: Graeme B. <gb...@te...> - 2006-11-01 10:31:47
|
Hi all This may be slightly off the real topic, but I import clients from a csv sheet using the command line in psql every once in a while (new members to a sports club), but I can't find the field to select "Tax Included", so I have to manually go and select the radio button on each new client. Does anyone know how I can get around this? Graeme -----Original Message----- From: sql...@li... [mailto:sql...@li...]On Behalf Of Remco van Vugt - Chris Hectors Compuvision Sent: Wednesday, November 01, 2006 10:59 AM To: sql...@li... Subject: Re: [SL] importing csv files Well maybe you should write something yourself, i've done so by writing a php script that's able to import our suppliers products by reading a comma delimited file. PHP is great language to use for such kinda things i think... Remco Danita Zanre schreef: >> Quickbooks is pretty much a 'Hotel California' for transaction data. They go >> to great lengths to prevent you from getting transaction data. >> > > I know - that's why I don't use it any longer <g>. I'm not actually looking to convert Quickbooks data. I'm looking to import data into SQL-Ledger through ascii delimited files. For example, we moved to Paypal Website Payments Pro for our online credit card processing company - we can download transactions in various formats: comma delimited, tab delimited, Quicken or Quickbooks. I'd be happy with an import tool that could handle any of those really. > > Danita > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > -- Met vriendelijke groet, Remco van Vugt - Chris Hectors Compuvision E: r.v...@ch... T: 0164-674935 ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sql-ledger-users mailing list sql...@li... https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Dieter S. <dsi...@sq...> - 2006-11-01 11:28:09
|
On Wed, 1 Nov 2006, Graeme Bruton wrote: > Hi all > > This may be slightly off the real topic, but I import clients from a csv > sheet using the command line in psql every once in a while (new members to a > sports club), but I can't find the field to select "Tax Included", so I have > to manually go and select the radio button on each new client. Does anyone > know how I can get around this? You could purchase technical support which includes the ERD. -- Dieter Simader http://www.sql-ledger.com Tel: (408) 898-4421 DWS Systems Inc. Accounting Software Fax: (780) 478-5281 ============== On a clear disk you can seek forever ================ |
|
From: Nathan L. <nat...@ph...> - 2006-11-01 15:39:20
|
One option I have used is to write an app in Ruby on Rails that integrates with SL. With Rails ActiveRecord you just give the name of the table representing your object and you can then address fields as attributes. Ruby has built-in libraries for dealing with CSV, so getting data in from there is no problem. This is most effective for what I call "master" data (parts, customers, etc.), but be careful of the ID sequences that SL uses. I had trouble with those until I found out how to specify them within ActiveRecord. I won't bore the entire list with more details, but if you are interested contact me off list. Thanks, Nathan On Wed, 2006-11-01 at 04:27 -0700, Dieter Simader wrote: > On Wed, 1 Nov 2006, Graeme Bruton wrote: > > > Hi all > > > > This may be slightly off the real topic, but I import clients from a csv > > sheet using the command line in psql every once in a while (new members to a > > sports club), but I can't find the field to select "Tax Included", so I have > > to manually go and select the radio button on each new client. Does anyone > > know how I can get around this? > > You could purchase technical support which includes the ERD. > |
|
From: Ed W <li...@wi...> - 2006-11-03 17:59:20
|
Nathan Leach wrote: > One option I have used is to write an app in Ruby on Rails that > integrates with SL. With Rails ActiveRecord you just give the name of > the table representing your object and you can then address fields as > attributes. Ruby has built-in libraries for dealing with CSV, so > getting data in from there is no problem. > > This is most effective for what I call "master" data (parts, customers, > etc.), but be careful of the ID sequences that SL uses. I had trouble > with those until I found out how to specify them within ActiveRecord. > > I won't bore the entire list with more details, but if you are > interested contact me off list. > > Hi Nathan I'm getting into Rails right now and building some small apps for our business. I am actually working on a web facing frontend for SQLledger so that people can pay their bills directly. I would be curious to see what kind of things you have done with rails because you are obviously diving directly into the data rather than going via the http interface? I haven't really plugged through the tables - is there a quickstart guide that you can offer? I have to say that SQL-Ledger is rather a pain in the arse - it's a nice looking product, but there is minimal support and fairly slow development. The code is quite messy as well. (Having bought the manual I wrote to Dieter to request a feature and he sent me an estimate of $16,000 to implement it... Outside of my budget and not what I would call supportive - he keeps blocking my emails to the list it seems and I sent him at least one patch and didn't even get a reply that it was received...) I would love to have the time to write an alternative in Ruby - I think a rip off would be possible in just a few months, the trick is having a few months free to write it... Regards Ed Wildgoose |
|
From: Ed W <li...@wi...> - 2006-11-03 18:03:35
|
Oh darn. Was supposed to be mailed offlist. Guess I probably just seriously irritated Dieter now... (Will teach me to keep my opinions to myself...) Sorry folks Ed W |
|
From: Christopher M. <chr...@gm...> - 2006-11-03 18:26:05
|
On 11/3/06, Ed W <li...@wi...> wrote: > I'm getting into Rails right now and building some small apps for our > business. I am actually working on a web facing frontend for SQLledger > so that people can pay their bills directly. Hi Ed, We've currently got an XML/RESTful API in the planning stages for LSMB (a fork of SQL-Ledger), and we hope that it will also work with SQL-Ledger (any folks here intersted in that, please let me know - we could use some testing/coding help to ensure SL compatibility). If this sounds interesting to you, please email me off-list or join our -devel mailing list (info at http://ledgersmb.org/help/ - follow mailing list link). > I have to say that SQL-Ledger is rather a pain in the arse - it's a nice > looking product, but there is minimal support and fairly slow > development. The code is quite messy as well. While you might not like some of the style and structure of the code, SL does have a pretty decent feature set. BTW, we've done a major cleanup of the code (all of which Dieter is free to use or toss at his discretion of course - our changes are in a public svn repository) and are on the cusp of a new release which has a lot of changes and enhancements. We have 5 active developers and are moving at a fairly fast pace. SL users can benefit from our changes and still use SL if that's their preference. I hope that Dieter will take our changes (or at least the ones that he likes) and that it will save him work and benefit his users, but I don't want to pressure him either way. Cheers, Chris |
|
From: Danita Z. <da...@ca...> - 2006-11-01 16:18:32
|
r.v...@ch... wrote:=20 > Well maybe you should write something yourself, i've done so by = writing=20 > a php script that's able to import our suppliers products by reading = a=20 > comma delimited file. > PHP is great language to use for such kinda things i think... >=20 > Remco Well, maybe for someone who can actually WRITE PHP <g>. Danita |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X