Aquileo | Recent changes to wiki

Aquileo | Main_Page modified by Larry Jordan

2024-03-01T17:27:50.040000Z

--- v65
+++ v66
@@ -10,11 +10,13 @@

 ## Requirements

-csv2odf requires [Python](http://www.python.org/) 2.6 or later. [OpenOffice.org](http://www.openoffice.org), [LibreOffice](http://www.libreoffice.org) or Microsoft Office are also needed to create templates and view output files. It can run on any operating system that Python and OpenOffice.org run on, including Linux, Mac, and Windows. 
+csv2odf requires [Python](http://www.python.org/) 3.5 or later. [OpenOffice.org](http://www.openoffice.org), [LibreOffice](http://www.libreoffice.org) or Microsoft Office are also needed to create templates and view output files. It can run on any operating system that Python and OpenOffice.org run on, including Linux, Mac, and Windows. 

-csv2odf has been tested on Linux with python 2.6, 2.7, 3.0-3.4; and with OpenOffice.org 2.4, 3.0, 3.1 and 3.2. It has been tested on Windows XP with Python 2.7 and 3.2-3.4. 
+csv2odf has been tested on Linux with python 3.11; and with OpenOffice.org 2.4, 3.0, 3.1 and 3.2. It has been tested on Windows XP with Python 3.2-3.4. 

 If you test with other versions of these programs, you can [send your results](http://sourceforge.net/sendmessage.php?touser=635673). 
+
+If wish to use with Python 2, try [csv2odf v2.09](https://sourceforge.net/projects/csv2odf/files/csv2odf-2.09/).

 ## Download

@@ -99,6 +101,7 @@

 | csv2odf Version | Release Date | Requires Python Version | Notes |
 |:----------------|:-------------|:------------------------|:------|
+|2.10 | 2024-02-24 | 3.5+  | Changes to make compatible with Python 3.11. Removed Python 2 support. |
 |2.09 | 2017-07-01 | 2.7-3.5+  | Added option to specify csv file encoding |
 |2.08 | 2017-02-14 | 2.7-3.4+  | Bugfixes: unicode regression, Fixed offset of filters when options are inside template. |
 |2.07 | 2017-02-05 | 2.7-3.4+  | Bugfix for memory error with xlsx and large csv files.  |

Aquileo | Main_Page modified by Larry Jordan

2017-07-02T23:45:07.525000Z

--- v64
+++ v65
@@ -99,11 +99,11 @@

 | csv2odf Version | Release Date | Requires Python Version | Notes |
 |:----------------|:-------------|:------------------------|:------|
-|2.09 | 2017-07-01 | 2.6-3.5+  | Added option to specify csv file encoding |
-|2.08 | 2017-02-14 | 2.6-3.4+  | Bugfixes: unicode regression, Fixed offset of filters when options are inside template. |
-|2.07 | 2017-02-05 | 2.6-3.4+  | Bugfix for memory error with xlsx and large csv files. |
-|2.06 |2016-12-12 | 2.6-3.4+  | Bugfix for error processing unicode. |
-|2.05 |2016-04-26 | 2.6-3.4+  | General improvements and bug fixes for handling unicode and xlsx. |
+|2.09 | 2017-07-01 | 2.7-3.5+  | Added option to specify csv file encoding |
+|2.08 | 2017-02-14 | 2.7-3.4+  | Bugfixes: unicode regression, Fixed offset of filters when options are inside template. |
+|2.07 | 2017-02-05 | 2.7-3.4+  | Bugfix for memory error with xlsx and large csv files.  |
+|2.06 |2016-12-12 | 2.7-3.4+  | Bugfix for error processing unicode. |
+|2.05 |2016-04-26 | 2.7-3.4+  | General improvements and bug fixes for handling unicode and xlsx. Testing is no longer performed on Python 2.6. |
 |2.04 |2015-05-12 | 2.6-3.4+  | Bugfix for loss of lines when list is long. |
 |2.03 |2015-04-20 | 2.6-3.4+  | Added -a option to append to existing data.  Fixed problem with large files on Windows. |
 |2.02 |2014-10-13 | 2.6-3.4+  |  Fixed the -o option so that cell not in the order are left unchanged. Added ability to add data to empty sheets in xlsx files. Fixed pipes in Windows when using python 2.7. |

Aquileo | Main_Page modified by Larry Jordan

2017-07-02T23:24:12.275000Z

--- v63
+++ v64
@@ -99,7 +99,7 @@

 | csv2odf Version | Release Date | Requires Python Version | Notes |
 |:----------------|:-------------|:------------------------|:------|
-|2.09 | 2017-07-02 | 2.6-3.5+  | Added option to specify csv file encoding |
+|2.09 | 2017-07-01 | 2.6-3.5+  | Added option to specify csv file encoding |
 |2.08 | 2017-02-14 | 2.6-3.4+  | Bugfixes: unicode regression, Fixed offset of filters when options are inside template. |
 |2.07 | 2017-02-05 | 2.6-3.4+  | Bugfix for memory error with xlsx and large csv files. |
 |2.06 |2016-12-12 | 2.6-3.4+  | Bugfix for error processing unicode. |

Aquileo | Main_Page modified by Larry Jordan

2017-07-02T23:22:24.281000Z

--- v62
+++ v63
@@ -99,6 +99,9 @@

 | csv2odf Version | Release Date | Requires Python Version | Notes |
 |:----------------|:-------------|:------------------------|:------|
+|2.09 | 2017-07-02 | 2.6-3.5+  | Added option to specify csv file encoding |
+|2.08 | 2017-02-14 | 2.6-3.4+  | Bugfixes: unicode regression, Fixed offset of filters when options are inside template. |
+|2.07 | 2017-02-05 | 2.6-3.4+  | Bugfix for memory error with xlsx and large csv files. |
 |2.06 |2016-12-12 | 2.6-3.4+  | Bugfix for error processing unicode. |
 |2.05 |2016-04-26 | 2.6-3.4+  | General improvements and bug fixes for handling unicode and xlsx. |
 |2.04 |2015-05-12 | 2.6-3.4+  | Bugfix for loss of lines when list is long. |

Aquileo | Main_Page modified by Larry Jordan

2016-12-13T00:37:02.480000Z

--- v61
+++ v62
@@ -99,6 +99,7 @@

 | csv2odf Version | Release Date | Requires Python Version | Notes |
 |:----------------|:-------------|:------------------------|:------|
+|2.06 |2016-12-12 | 2.6-3.4+  | Bugfix for error processing unicode. |
 |2.05 |2016-04-26 | 2.6-3.4+  | General improvements and bug fixes for handling unicode and xlsx. |
 |2.04 |2015-05-12 | 2.6-3.4+  | Bugfix for loss of lines when list is long. |
 |2.03 |2015-04-20 | 2.6-3.4+  | Added -a option to append to existing data.  Fixed problem with large files on Windows. |

Aquileo | Main_Page modified by Larry Jordan

2016-08-11T23:24:25.189000Z

Aquileo | Main_Page modified by Larry Jordan

2016-08-11T23:23:27.314000Z

--- v59
+++ v60
@@ -99,6 +99,8 @@

 | csv2odf Version | Release Date | Requires Python Version | Notes |
 |:----------------|:-------------|:------------------------|:------|
+|2.05 |2016-04-26 | 2.6-3.4+  | General improvements and bug fixes for handling unicode and xlsx. |
+|2.04 |2015-05-12 | 2.6-3.4+  | Bugfix for loss of lines when list is long. |
 |2.03 |2015-04-20 | 2.6-3.4+  | Added -a option to append to existing data.  Fixed problem with large files on Windows. |
 |2.02 |2014-10-13 | 2.6-3.4+  |  Fixed the -o option so that cell not in the order are left unchanged. Added ability to add data to empty sheets in xlsx files. Fixed pipes in Windows when using python 2.7. |
 |2.01 |2014-09-09 | 2.6-3.4+  | Additional decrease in memory. Fixed xml output crash in windows. |

Aquileo | Main_Page modified by Larry Jordan

2015-04-20T17:38:25.439000Z

--- v58
+++ v59
@@ -99,6 +99,7 @@

 | csv2odf Version | Release Date | Requires Python Version | Notes |
 |:----------------|:-------------|:------------------------|:------|
+|2.03 |2015-04-20 | 2.6-3.4+  | Added -a option to append to existing data.  Fixed problem with large files on Windows. |
 |2.02 |2014-10-13 | 2.6-3.4+  |  Fixed the -o option so that cell not in the order are left unchanged. Added ability to add data to empty sheets in xlsx files. Fixed pipes in Windows when using python 2.7. |
 |2.01 |2014-09-09 | 2.6-3.4+  | Additional decrease in memory. Fixed xml output crash in windows. |
 |2.00 |2014-07-31 | 2.6-3.4+  | Can now process large data file serially, using less memory.  The date tag changed to \[csv2odf-date\]. |

Aquileo | Manual modified by Larry Jordan

2014-10-21T22:54:40.261000Z

--- v13
+++ v14
@@ -20,7 +20,7 @@

 csv2odf is a command line tool that can convert a _comma seperated value_ (csv) file into an ods, odt, html, xlsx, or docx document. csv2odf is useful for creating reports from databases and other data sources that produce csv files. csv2odf can be combined with cron and shell scripts to automatically generate business reports. 

-The csv data is merged with a *template* file to produce the output file. The template is a document file as produced by OpenOffice.org or Word, or an html file. The template can be a spreadsheet file (ods or xlsx), a document file (odt or docx), or an html file. 
+The csv data is merged with a *template* file to produce the output file. The template can be a spreadsheet file (ods or xlsx) or a document file (odt or docx), as produced by OpenOffice.org, LibreOffice, or Word.  The template can also be an html file. 

 If a csv input file is not specified, input will be taken from standard input (stdin). If an output file is not specified, output will be directed to standard output (stdout). This allows the use of the command in pipes. 

@@ -39,18 +39,19 @@
 ## Options For Processing Csv Data File

 -c <*char*> : use *char* as delimiter instead of comma 
--o <*spec*> : specify column order: 2,1,3 = second csv column is first. Also use to leave the contents of a template column: 1,2,,3,4 = the 3rd template column is not overwritten. Useful if a column contains a formula. The formula cell references will be offset to the correct row. 
+-o <*spec*> : specify column order: 2,1,3 = second csv column is first. Also use to leave the contents of a template column unchanged: 1,2,,3,4 = the 3rd template column is not overwritten. Useful if a column contains a formula. The formula cell references will be offset to the correct row. 
 -s <*n*> : start reading at the nth row of the csv file 
 -e <*n*> : end reading at the nth row of the csv file 
--d <*fmt*> : date format within csv data is specified by *fmt* string, see -D for codes. Identified dates will be translated to the native spreadsheet date code. 
+-d <*fmt*> : date format within csv data is specified by *fmt* string, see -D for codes.  For columns identified as dates, the program will attempt to translate incoming data into the native date coding using the format  supplied with the -d option.  If the translation fails, the data will be inserted as text.  In ods files, the program knows which columns are dates by looking for date formatted cells in the template.  In xlsx files you must mark date cells with the text [csv2odf-date] (csv2odf-date inside square brackets).
+

 ## Options For Processing Template File

 -H : insert the first csv row into the header 
-\--comment= : replace [csv2odf-comment] within the document with  
+\--comment=<text> : replace [csv2odf-comment] within the document with <text> 
 -S <*n*> : skip the first n rows of the template file, the header will be the next row after those skipped 
 -t <*n*> : specify which tab or table to add data to, default first table 
-\--div : search for  tags instead of  (html files only). 
+\--div : search for <div> tags instead of <table> (html files only). 
 \--template-stdin-ods : The template will be passed to std-in and it's format will be ods 
 \--template-stdin-odt : The template will be passed to std-in and it's format will be odt 
 \--template-stdin-html : The template will be passed to std-in and it's format will be html 
@@ -64,7 +65,7 @@
 -D : show a list of date format codes 
 -q : suppress all warning messages 
 -x : create an xml output file instead of odf 
--n : do not merge the data into output, use with -x to extract test a long line template xml codes 
+-n : do not merge the data into output, use with -x to extract template xml codes 
 \--input=<*file*> : specify the csv data file location 
 \--template=<*file*> : specify the tempate file location 
 \--output=<*file*> : specify the output file location 
@@ -73,26 +74,26 @@

 ## Date Format Codes

-The date format codes are the same ones used by Python&rsquo;s _strftime_ function. 
+The date format codes are the same ones used by Python's _strftime_ function. 

-%a Locale&rsquo;s abbreviated weekday name.   
-%A Locale&rsquo;s full weekday name.   
-%b Locale&rsquo;s abbreviated month name.   
-%B Locale&rsquo;s full month name.   
-%c Locale&rsquo;s appropriate date and time representation.   
+%a Locale's abbreviated weekday name.   
+%A Locale's full weekday name.   
+%b Locale's abbreviated month name.   
+%B Locale's full month name.   
+%c Locale's appropriate date and time representation.   
 %d Day of the month as a decimal number [01-31].   
 %H Hour (24-hour clock) as a decimal number [00-23].   
 %I Hour (12-hour clock) as a decimal number [01-12].   
 %j Day of the year as a decimal number [001-366].   
 %m Month as a decimal number [01-12].   
 %M Minute as a decimal number [00-59].   
-%p Locale&rsquo;s equivalent of either AM or PM.   
+%p Locale's equivalent of either AM or PM.   
 %S Second as a decimal number [00-61].   
 %U Week number of the year (Sunday as the first day of the week) as a decimal number [00-53]. All days in a new year preceding the first Sunday are considered to be in week 0  
 %w Weekday as a decimal number [0(Sunday)-6].   
 %W Week number of the year (Monday as the first day of the week) as a decimal number [00-53]. All days in a new year preceding the first Monday are considered to be in week 0.  
-%x Locale&rsquo;s appropriate date representation.   
-%X Locale&rsquo;s appropriate time representation.   
+%x Locale's appropriate date representation.   
+%X Locale's appropriate time representation.   
 %y Year without century as a decimal number [00-99].   
 %Y Year with century as a decimal number.   
 %Z Time zone name (no characters if no time zone exists).   
@@ -124,7 +125,7 @@

 When the csv file has column names on the first row, -H will cause the column name to be put into the header of the output file. 

-The csv file has a header but we don&rsquo;t want to use it: 
+The csv file has a header but we don't want to use it: 

     csv2odf -s 2 data.csv template.ods output.ods

Aquileo | Main_Page modified by Larry Jordan

2014-10-15T01:02:41.372000Z

--- v57
+++ v58
@@ -99,6 +99,7 @@

 | csv2odf Version | Release Date | Requires Python Version | Notes |
 |:----------------|:-------------|:------------------------|:------|
+|2.02 |2014-10-13 | 2.6-3.4+  |  Fixed the -o option so that cell not in the order are left unchanged. Added ability to add data to empty sheets in xlsx files. Fixed pipes in Windows when using python 2.7. |
 |2.01 |2014-09-09 | 2.6-3.4+  | Additional decrease in memory. Fixed xml output crash in windows. |
 |2.00 |2014-07-31 | 2.6-3.4+  | Can now process large data file serially, using less memory.  The date tag changed to \[csv2odf-date\]. |
 |1.11 |2014-05-20 | 2.6-3.3+ | Bugfix to handle blank cells more cleanly. |