[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