X-Git-Url: https://git.dogcows.com/gitweb?p=chaz%2Fhomebank;a=blobdiff_plain;f=doc%2Fmisc-csvformat.html;h=ea1404e1c32e36e878bf706298802f2d51d6548a;hp=83f7859cffd3ac09f29b673d4491f3084e99b55f;hb=236cb5e47660876f46488ea8f76ecd5bebfa1fac;hpb=27f6e3b112df235c8e9afc9911b1f6bce208a001 diff --git a/doc/misc-csvformat.html b/doc/misc-csvformat.html index 83f7859..ea1404e 100644 --- a/doc/misc-csvformat.html +++ b/doc/misc-csvformat.html @@ -1,185 +1,128 @@ - - + - - + + CSV file format - + -
HomeBank User manual
-

CSV file format

- -

With HomeBank you can import/export some of the internal data's in - the most common file format that is CSV.

- -

Notice: meanwhile csv should uses comma as separator, HomeBank uses - semi-colon as separator (this is most common than comma)

- -

The format used for the different files is specific to HomeBank, so - don't expect to import files your bank should offers you directly, you - will need to arrange it a little in a spreadsheet like Gnumeric - before.

- -

Below is a description with example of the CSV format that HomeBank - uses.

- +

With HomeBank you can import/export some of the internal data's in the most common file format that is CSV.

+

Notice: meanwhile CSV should uses comma as separator, HomeBank uses semi-colon as separator (this is most common than comma)

+

The format used for the different files is specific to HomeBank, so don't expect to import files your bank should offers you directly, you will need to arrange it a little in a spreadsheet like Gnumeric before.

+

Below is a description with example of the CSV format that HomeBank uses.

-
-

Transaction

- - - +

Transaction

- - - - + - - - - + + - - - - - - - - - + - - - - + tag is mandatory since v4.5 -
dateformat should be DD-MM-YYthe date format can be: +
    +
  • y-m-d +
  • m-d-y +
  • d-m-y +
+

year can be 2 or 4 digits
+ separators can be / . or -
paymodefrom 0=none to 10=FI feepayment +  You cannot import transaction with payment type=5 (internal xfer)
+ from 0=none to 10=FI fee (in the same order of the list)
+
infoa string
payeea payee name
memoa string
amounta number with a '.' or ',' as decimal separator, ex: -24.12 or - 36,75a number with a '.' or ',' as decimal separator, ex: -24.12 or 36,75
categorya full category name (category, or category:subcategory)
tagstags separated by space
- tag is mandatory since v4.5
-

Example:

-15-02-04;0;;;Some cash;-40,00;Bill:Withdrawal of cash;tag1
-15-02-04;1;;;Internet DSL;-45,00;Inline service/Internet;tag2
+15-02-04;0;;;Some cash;-40,00;Bill:Withdrawal of cash;tag1 tag2
+15-02-04;1;;;Internet DSL;-45,00;Inline service/Internet;tag2 my-tag3
 ...
-

[top]

- -
- - - - - +

↑ Back to Top

+
-

Budget

- +

Budget

- - + - - - - - -
type* = monthly
blank = month value
categorythe category name
value(s)1 amount : if the type is monthly
12 amounts, separated by ';' : if type month value
-

Example:

-
+    
 *;Fuel;45.00
  ;Domestic animals;1.00;2.00;3.00;4.00;...
 *;Food;17.00
 ... 
 

-    
[top]

-
+    
↑ Back to Top
-
-

Category

- +

Category

- - + - - - - + - - - - + - - -
level1 = category
+ 		1 = category
2 = subcategory
type- = expense
+ 		- = expense
+ = income
category namethe category name
- +

Example:

 1;-;Food
@@ -188,31 +131,27 @@
 1;+;Wage
 ...
-

[top]

- +

↑ Back to Top

- -
-

Payee

- +
+

Payee

- - + - + + + +
payee namethe name of the payee
full category nameoptional: since 5.1.3
the full name of the category
-

Example:

-
-payee_name1
-payee_name2
+    
+payee_name1;cat1:subcat1
+payee_name2;
 ... 
 

-    
[top]

-
+    
↑ Back to Top
-