[grisbi-user-french] Export CSV
Nicolas
nvalette2004-divers at yahoo.fr
Ven 7 Sep 14:13:50 CEST 2012
Bonjour,
j'utilise Grisbi sur mon ordi et EasyMoney sur mon tel portable. EasyMoney
peut importer des fichier csv mais avec un format particulier (cf
ci-dessous). Est-ce que c'est possible de modifier l'export de Grisbi pour
avoir les bonnes colonnes ?
Merci par avance.
Bien cordialement.
Nicolas.
______________________________________________________________
EasyMoney's CSV File Format
The first line in the CSV file contains the column headers. You may choose
not to include this header when you export or import the CSV file but the
order of the columns must be maintained. Each CSV file can only contain
transaction data for a single account.
There are a total of 6 columns:
1)PAYEE_ITEM_DESC
2)CATEGORY
3)AMOUNT
4)STATUS
5)TRAN_DATE
6)REMARKS
Column 1: PAYEE/ITEM DESCRIPTION
This is the payee/item field. This is a mandatory text field.
Like all CSV text fields, if the data string contains the field delimiter
(eg. ',' (COMMAS)), it must be enclosed with '"' (DOUBLE QUOTES).
Additionally, if a '"' (DOUBLE QUOTES) appear within the data string, it
must be prefixed by another '"' (DOUBLE QUOTES).
Column 2: CATEGORY
This is a mandatory text field. If the category is not found in EasyMoney,
it will be created automatically with category type = 'Expense' if the
amount is negative and 'Income' otherwise.
Like all CSV text fields, if the data string contains the field delimiter
(eg. ',' (COMMAS)), it must be enclosed with '"' (DOUBLE QUOTES).
Additionally, if a '"' (DOUBLE QUOTES) appear within the data string, it
must be prefixed by another '"' (DOUBLE QUOTES).
Column 3: AMOUNT
The amount must be a valid number. For negative numbers, a -(MINUS) sign
must be placed in front of the number.
There should be no group separator and the only two acceptable decimal
separators are the '.'(PERIOD) and the ','(COMMA). If you use COMMA as the
decimal separator, you must enclose the amount field with '"' (DOUBLE
QUOTES).
Column 4: STATUS
The status must be exactly one of the following: 'Cleared', 'Uncleared',
'Reconciled' and 'Void'. Note that this field is case-sensitive.
Column 5: TRANSACTION DATE
The data in this field must be a valid date string.
Accepted date formats : "2 Dec 2009", "12/2/09"
Column 6: REMARKS
This is an optional text field. Like all CSV text fields, if the data
string contains the field delimiter (eg. ',' (COMMAS)), it must be
enclosed with '"' (DOUBLE QUOTES). Additionally, if a '"' (DOUBLE QUOTES)
appear within the data string, it must be prefixed by another '"' (DOUBLE
QUOTES).
Sample CSV File
PAYEE_ITEM_DESC,CATEGORY,AMOUNT,STATUS,TRAN_DATE,REMARKS
"Newspaper","Self Improvement",-0.90,"Uncleared","4 NOV 2009",""
"Cab","Transportation",-18.00,"Cleared","5 Dec 2009",""
"Drinks","Food",-60.00,"Cleared","15 Dec 2009","Beer, wine and spirits."
"Groceries","Groceries",-170.15,"Cleared","25 Dec 2009","Lots of food for
Joanne's birthday party"
"Lunch","Food",-9.20,"Uncleared","10/6/09",""
Plus d'informations sur la liste de diffusion user-french