Hi,
I tried to contact you by email but sourceforge wouldn't let me do that,
I've been trying to get cvs2odf to work on a file, but it doesn't work. The file looks like this:
The template has a table with two columns. I've entered text and numbers as the sample for the second column but all it does is put the category text in the first column and nothing in the second column where the $ amounts should go.
Is this because of the structure of the file? Is there a way around this?
THanks
Keith
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Keith,
If your example is the csv file, the program assumes every row will have the same number of columns. It will look at the first row to determine how many columns there will be, so in your example, it only sees one column on the first row. One way to fix that is to add a comma after the title.
If possible, the title should be in the template. You can tell the program to skip some of the rows used for the title using the -S option.
Thanks,
Larry
Last edit: Larry Jordan 2014-06-06
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I tried to contact you by email but sourceforge wouldn't let me do that,
I've been trying to get cvs2odf to work on a file, but it doesn't work. The file looks like this:
Monthly Financial Report
01/05/2014 - 31/05/2014
Account,May 2014
INCOME,
,
Bookstall Sales,A$ 300.28
Compassion Support Income,A$ 230.00
The template has a table with two columns. I've entered text and numbers as the sample for the second column but all it does is put the category text in the first column and nothing in the second column where the $ amounts should go.
Is this because of the structure of the file? Is there a way around this?
THanks
Keith
Keith,
If your example is the csv file, the program assumes every row will have the same number of columns. It will look at the first row to determine how many columns there will be, so in your example, it only sees one column on the first row. One way to fix that is to add a comma after the title.
If possible, the title should be in the template. You can tell the program to skip some of the rows used for the title using the -S option.
Thanks,
Larry
Last edit: Larry Jordan 2014-06-06
Thank you Larry. Using the -s option to skip over the title rows fixed the problem. It works perfectly.
Keith