CSV2. OFX Download.CSV2.OFX is a simple to use application that facilitates file conversion from CSV, TXT and XLS to OFX format Open Financial Exchange, thus enabling users to import transaction information into applications such as Microsoft Money.The tool comes packed with just a few intuitive options that can be figured out by all types of users, regardless of their skill level.Setting up the app takes little time and minimum effort.At startup you can point out the CSV file you want to open and, optionally map it e.Aside from this, you can view source details table and raw view, select the account type e.CSV data format.When it comes to the output, it is possible to open the OFX item immediately after conversion, enable compatibility with MS Money 9.Peachtree, as well as generate the reference from the date, amount and payee fields, among others.Colt 1911 Serial Number Markings On Capacitors .In addition, you can review mapping properties.In order to save the new file, you can specify the output name and location.The application carries out a conversion job quickly and without errors.It has a good response time and works well, without causing the OS to hang, crash or pop up error dialogs.We have not come across any issues in our tests.All in all, CSV2.OFX gets the job done.Thanks to the simplicity of options, it should please all users who are looking for a straightforward piece of s software to create OFX files from CSV, TXT and XLS.There is also a portable version available, if you want to bypass the installer and run the app from a USB flash disk.Csv2ofx Convert is a single step, easy to use converter to import data into any financial application that reads industry standard OFX format.A Python library and command line tool for converting csv to ofx and qif files.INTRODUCTIONcsv.Python library and command line interface program that converts CSV files to OFX and QIF files for importing into Gnu.Cash or similar financial accounting programs.Mac. Patch For Photoshop Cs6 2013 Oscar . OS X 1. 0. 9.CSV2OFX.jpg' alt='Csv2ofx' title='Csv2ofx' />Python 2.Requirementscsv.INSTALLATIONYou are using a virtualenv, rightsudo pip install csv.Usagecsv.Python or from the command line.Library Examplesnormal OFX usagefromfutureimport absoluteimport, printfunction.Iter.String. IO.JPG' alt='Csv2ofx' title='Csv2ofx' />OFXfrom csv.OFXmapping.Iter. String. IOcontent.QIF usagefromfutureimport absoluteimport, printfunction.Iter.String. IO.QIFfrom csv.QIFmapping. records readcsvpathtofile.Iter.String. IOcontent.CLI Examplesshow helpcsv.TYPE, account TYPE.CHECKINGfor OFX and Bankfor QIF.DATE, end DATE end date.LANGUAGE, language LANGUAGE.DATE, start DATE.MAPPING, mapping MAPPING.FIELDNAME, collapse FIELDNAME.S FIELDNAME, split FIELDNAME.C ROWS, chunksize ROWS.V, version show version and exit.QIF output instead of OFX.Downloadstransactions.CUSTOMIZATIONCode modification.If you would like to import csv files with field names different from the default, you can modify the mapping file or create your own.New mappings must be placed in the csv.The mapping object consists of a dictionary whose keys are OFXQIF attributes and whose values are functions which should return the corresponding value from a record csv row.The mapping function will take in a record, e.Account savings 2, Date 131.Amount 5,0.The most basic mapping function just returns a specific field or value, e.Better.Bank. account itemgetteraccountnum.But more complex parsing is also possible, e.Required field attributesattributedescriptiondefault fieldexampleaccounttransaction account.Account.Better. Bank Checkingdatetransaction date.Date.Amount3. 0. 5. 2Optional value attributesattributedescriptiondefault valuehasheaderdoes the csv file have a header row.Trueissplitdoes the csv file contain split double entry transactions.Falsecurrencythe currency ISO code.USDdelimiterthe csv field delimiter,Optional field attributesattributedescriptiondefault fielddefault valueexampledesctransaction description.Referencenashell stationpayeetransaction payee.Descriptionna.Shellnotestransaction notes.Notesnafor gaschecknumthe check or transaction number.Rowna.Numnabankthe bank namenaaccount.Bankaccountidtransaction account idnahash of accountbbcheckingtypetransaction account typenacheckingsavingsbalanceaccount balancenana2.Scriptscsv.Setuppip install r dev requirements.Examples.Run python linter and nose tests.Contributing.Please mimic the coding styleconventions used in this repo.If you add new classes or functions, please add the appropriate doc blocks with examples.Also, make sure the python linter and nose tests pass.Ready to contributeHeres how Fork and clone.Setup a new virtualenvmkvirtualenv no site packages csv.Create a branch for local developmentgit checkout b name of your bugfix or feature.Make your changes, run linter and tests, and submit a pull request through the Git.Hub website.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |