Just my opinion, most would probably disagree. If you want to import data from your previous application, you should distinguish between financial data and other data. You've probably already spent far more time trying to get GNU cash to work than it would have taken to build a simple cash accounting spreadsheet. You could probably teach him how to do the spreadsheet quicker than you could teach him how to get something else to boot up, not to mention use. I know you said in your original post that he did not want a spreadsheet, but it seems that would be the easiest way to get around most of the problems you are having, especially if it is simple cash accounting. Posted 08:11 (#6761278 - in reply to #6760004) Subject: RE: GnuCash, set up for a farm? Import DBF files. my assessment is that as a whole it is not nearly as "slick" as more popular commercial offerings and not everything is as intuitive as it could be, but I have generally gotten along pretty well with the program for my needs. I've found some good info there when I ran into snags. As I intend to regularly import CSV files to perform reconciliation, I would like to suggest an enhancement that reduces the amount of manual work required on each import. Search or post in their user forums if you haven't. Currently, the CSV import process for GNUCash is quite a manual process. I use GnuCash for my farm bookkeeping I started from scratch and set up the accounts based on a list given to me by my tax preparer but don't recall it being particularly tedious or complicated. How did you go about converting dbf to csv? I use Notepad++ for a lot of general text file editing or to verify what's coming out of another program (like if I converted something to csv using Excel and want to verify there isn't extraneous junk ). I have a backup plan which is that I will NOT do the multi-split import and will just select the Cash account for all rows in the Import Preview screen. Posted 13:16 (#6760045 - in reply to #6760004) Subject: RE: GnuCash, set up for a farm? Import DBF files. The GnuCash XML data file can be transformed to almost any other data format (e.g., QIF, CSV) quite easily if one is familiar with the Extensible. I started with the CSV importer because I figured it would be the easiest record layout to create but Im not against using a different format if what I want to accomplish can be done. But if it's one of those programs such as GIMP that work but you need to immerse yourself in it then I don't want to spend more time on it. If like so many programs, it's simple once you understand it then I could spend the time to help him with it. If anybody has had success importing a DBF file I'd greatly appreciate some help or if anybody is using it for farming what was your experience? I know it's free but it seems a long way from being usable for a novice. GnuCash looks in about 7 drives before it will let you look in the drive with the file you want. I did that but still didn't have it imported. It requires that you create a CSV file from the DBF file. I was going to just import a DBF file that has data and fields but GnuCash doesn't recognize a DBF file in the DBF format. A tedious process of name changes can make fields relevant, i.e. It comes with preconceived fields and they aren't related to agriculture. Posted 12:48 (#6760004) Subject: GnuCash, set up for a farm? Import DBF files.Īt a suggestion that I try to get a farmer setup in GnuCash I downloaded it and installed. GnuCash, set up for a farm? Import DBF files. To be clear, I don't want to preprocess the file before importing (I know how to do that, I want to know if there's a way to skip that step).You are logged in as a guest. ,Paycheck,MY EMPLOYER,1,000,000.00,credit,Paycheck,Checking, ,Mortgage,MY MORTGAGE COMPANY,1.95,debit,Credit Card Payment,OtherChecking, ,Student Loan Payment,MY STUDENT LOAN LENDER,40,debit,Student Loan,Checking, ,BART,BART-POWELL QPS 5104646979 CA 94102 US C_OTHERTRAVEL,20,debit,Public Transportation,CapitolOne Visa, Date,Description,Original Description,Amount,Transaction Type,Category,Account Name,Labels,Notes ![]() See columns 4 and 5 below in the (borrowed from elsewhere) sample data. Rather than hopping all over the web downloading transactions from every bank and credit card it would be great if I could just import one CSV file from Mint.įor the moment, the main problem is that Mint does not use separate Deposit,Withdrawal columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |