CSV Improved
Author: Roland Dalmulder (contact@csvimproved.com)
Website: http://www.csvimproved.com/
Version: 0.9
Date: 19 October 2008
Status: $Id: changelog.txt 503 2008-10-19 06:16:03Z Roland $

Legenda:
+ Added
- Removed
* Fixed
/ Changed

Changelog
Version 0.9
Import
* Fixed the product type parameters not able to update

Export
+ Added removal of linebreaks for product export
* Fixed discount start and end date to export as regular dates
* Fixed product type exports were broken
* product_thumb_image was exported as product_full_image

Templates
/ Changed field adding and removing to no longer use AJAX
/ Updated layout to specify add field section

General
/ Changed DB layout check to ensure DB structure consistency

Version 0.9 RC 1
Import
* Fixed multiple prices import to reset shopper groups
* Fixed Fatal error: Class 'product_files' not found in product type parameters

Templates
* Fixed template not being saved
* Fixed manufacturer selection got lost

Version 0.9 beta 2
Import
* Fixed conversion option lost
+ Add price field check if entry is numeric
* Fixed preview losing convert choice
* Fixed cron throwing a GetObject() on a non-object error

Export
* Fixed order export to include non-existing users
* Fixed export not exporting first record

Templates
* Fixed settings getting lost

General
/ Updated installer script

Version 0.9 beta 1
Import
+ Added cron import via command line
+ Added support for passwords without salt
+ Added warning if more than 1 product <--> manufacturer link exists
* Fixed manufacturer name not being escaped for database insert
* Fixed generic manufacturers created when only importing manufacturer ID
+ Added category_id
+ Added custom database fields from the #__vm_product table
+ Added support for CSVI XML
* Improved the file upload handling
/ Changed the preview layout

Export
* Fix price_with_discount using wrong discount
+ Added category_id
/ Updated Google Base XML for category paths
* Fix picture URL path
/ Updated product description for Google Base to always be filled
+ Added custom database fields from the #__vm_product table
+ Added support for CSVI XML
+ Added export per manufacturer for products

Templates
+ Added export filename
+ Added system limit settings
- Removed standard delimiters
+ Added wizard for adding and editing templates
/ Redo Field management
* Fix error when publishing no selected fields
/ Moved renumber icon from toolbar to field list

Languages
+ Added French translation by Michel Loriaut and Xavier Lemoine
/ Updated Spanish translation by Juan Ferrari
/ Updated Polish translation by Keran from Quarkbit Software

Version 0.8 Stable
Import
* Fixed attribute_values not properly added
* Fixed duplicate product_tax_id

Languages
/ Updated German language file thanks kaltokri

Version 0.8 RC 3
Export
+ Add user_id and product_id fields to order export
* Updated XML export by adding CDATA tags
* Added UTF-8 encoding to the Froogle XML export
/ Changed mf_name to manufacturer_name for order export
+ Added username to order export
* Fixed duplication of products on export
* Fixed category details export
/ Changed export filename to use template name

Import
* Fixed fatal error Call to undefined method CsviSupportedFields::FieldsProductTypeXref()
* Fixed cannot access empty property in the rpc file
* Fixed Fatal error: Call to undefined method CsviRegistry::CloneObje()
+ Added Create manufacturer link if none exists
* Fixed undefined $debug
* Fixed a timeout bug where max_execution_time is set to 0
* Fixed incorrect manufacturer <---> product links
* Fixed possible double vendor_id in add product query

Maintenance
/ Changed layout of maintenance page

General
* Fixed VirtueMart check

Version 0.8 RC 2.1
Export
* Fix layout of discounted price
* Fix exports giving blank files

Version 0.8 RC 2
Import
* Fixed product_parent_sku deleted on import
* Fixed Fatal error: Class 'product_files' not found on multiple prices import
- Removed product type cross reference import
+ Product type names spaces converted to underscores

Export
+ Added Order export
* Fix attribute_values for downloadables
* Fix incorrect fieldname for order export
+ Added manufacturer name to order export
- Removed product type cross reference export
+ Added record limits to all exports

Templates
+ Added page navigation to template list
+ Added filter to field page
+ Added alternate row colors on template and field page

General
* Merged the product type cross reference into product type names import

Version 0.8 RC 1
Import
* Fixed invalid reference in mime type detection
* Fixed preview mode broken with imported file only 5 lines
* Fixed debug reporting being overridden
* Fixed template fields import
* Fixed product discount id not being used
+ Added more details for import preview errors
* Fixed product files import
* Fixed import not reading fields correctly
/ Changed loading of template details now uses AJAX

Export
* Fix hardcoded table prefixes
+ Add manufacturer export
* Fixed incorrect column header
/ Changed loading of template details now uses AJAX

Templates
/ Changed template fields page to Joomla style
+ Added button to add custom field
* Standard thumb width and height set to 90x90

General
- Removed Help section
+ Added link to wiki (http://www.csvimproved.com/wiki/doku.php/)
+ Added AJAX support

Version 0.8 beta 6
Import
+ Added option to choose to convert encoding
+ Added check if iconv is available
+ Added BOM removal
+ Added check if memory_get_usage is available
* Fixed linenumbers not always showing
* Fixed the mdate/cdate import fields
+ Added default file location path to import template

Export
- Removed standard UTF-8 export, iconv might not be installed
* Fixed the export to file, not being able to write

General
- Removed PHP 4 support
+ Added check for PHP 5 installation

Version 0.8 beta 5
Import
+ Added filename to import results
+ Added button to return to import page on results page
+ Added manufacturer data import
/ Changed template list to only show import templates
+ Added table of site limits for import for user to check
+ Added check for maximum execution time
+ Added category details import
+ Added preview option for templates and template fields
+ Added character translation to UTF-8

Export
* Fixed missing delimiter on product price in CSV export
+ Added export limits
/ Changed template list to only show export templates
+ Added export per shopper group
+ Added export to local file
+ Added product url suffix
/ Changed product_url to force http
+ Added list of templates to export
/ Changed export to respect template fields
+ Added record limits to filename if used
+ Added category details export
/ Changed file encoding to be UTF-8
+ Added field to export discounted price
+ Added option to export published/unpublished/both products
- Removed full server path from imagename

Templates
+ Added tabs to clarify what options are meant for
+ Added thumbnail sizes for import
- Removed support for required field
+ Added option to clone templates
+ Added configurable file location for product files/product images
+ Added check if no more fields available to add
+ Added automatic field ordering
+ Added option to select state of products to export

Maintenance
* Fixed product type tables not being deleted
+ Added option to sort categories alphabetically

General
+ Added check if Virtuemart is installed
+ Added logging class
* Recoded import process
+ Added support for Virtuemart 1.1 display options
+ Added Italian translation by Crisalex
+ Added Joomla 1.5 support using legacy mode
+ Added CSVI standard templates

Version 0.8 beta 4.1
Import
* Fixed data not being processed
* Fixed txt file upload causing foreach error

Export
* Fixed &nbsp; not allowed in XML export

Version 0.8 beta 4
Import
* Fixed preview to show on all product imports
+ Added multiple prices import to also update prices
* Fixed not using default values
+ Added Excel support
* Fixed missing price_delete field
- Removed radiobutton selection
* Fixed field configuration not matching

Export
* Fixed bug with product discount that has too many delimiters
* Fixed default values not always used
* Fixed product_available_date not being exported correctly
* Fixed XML entities
/ Changed export filenames to be more descriptive
* Fixed invalid XML file header

General
* Cleaned up file import code to allow other filetypes to upload
+ Supported fields now being alphabetized

Version 0.8 beta 3
Import
+ Added tax value import
* Fixed import of category names with apostrophe
- Removed Empty Database option
- Removed the Price List Only Upload obsolete due to templates
/ Changed page layout
+ Added template import
+ Added template fields import

Export
* Fixed export not using CSVI configuration table
* Fixed product_available_date not adding field delimiter
/ Changed page layout
+ Added creation of product URL if there is none in the database
+ Added support for custom column names
+ Added template export
+ Added template fields export
+ Added picture url export
+ Added price with tax export
+ Added XML support for beslist.nl
+ Added XML support for froogle.com
* Fixed manufacturer_name and manufacturer_id

Templates
* Fixed fatal error on templates page
* Fixed bug available fields not selected on template ID
* Fixed bug where template fields were not deleted on template removal
* Fixed cancel returning to templates page showing no templates
/ Changed page layout
+ Added custom fields
+ Added a Froogle Export template

Maintenance
+ Added Empty Database option
+ Added Removal of orphaned fields
+ Added Optimization of the CSV Improved tables

General
+ Added Russian translation by Sbmart
+ Added Spanish translation by Joao
+ Added Polish translation by Jurek
+ Added German translation by Jingo
+ Added icons kindly supplied by Joao
/ Changed layout of program
+ Added maintenance page
/ Changed output totals to only show if count is greater than 0
* Choose language according to Joomla language setting
* Split the language file. Help texts are now separated from main texts

Version 0.8 beta 2.1
Import
* Fixed updating of discounts when field not used
* Fixed updating of prices when field not used
+ Added updating to product type names imports
* Fixed preview mode

Export
* Fixed product type export layout as it had an incorrect column header
* Fixed product type names export layout. Removed ^ at the end of the line

Version 0.8 beta 2
Import
* Fixed fatal error with manufacturer import

Export
/ Changed price export to drop trailing zeroes after second digit
* Order export on SKU
+ Added product type parameters export
+ Added product type names export

General
/ Changed tab system to use Joomla tabs
+ Added Joomla toolbar
- Removed deletion of tables on uninstall

Version 0.8 beta 1
Import
* Fixed product type details upload
* Fixed error where child products did not have a price set

Export
+ Added product type export
* Fixed export of customized ordering
+ Export now uses the template settings
/ Changed the types of export to match the types of import

Templates
/ Changed layout of templates
* Fixed " and ' as delimiter not showing
* Fixed skip first line not being updated

General
+ Converted CSV Improved into Joomla! component
* Added product_relations table to empty database list

Version 0.7.5
Import
* Fixed product adding error in certain cases
+ Added SQL Error reporting
/ Changed unsupported fields reporting
* Fixed bug with shopper group name if not specified
+ Added related products
+ Added multiple files
+ Added template system for import

General
+ Added attribute documentation
+ Created CSV Improved language file
+ Created CSV Improved CSS file
- Removed Dutch since the file is too old

Version 0.7.4
Import
* Fixed error "Missing argument 1 for product_details::ProcessDiscount()."
* Fixed first line of file not imported
* Fixed not adding or updating products
* Fixed category path not updated

Version 0.7.3
Import
- Removed product_discount_id
* Fixed child products upload
+ Added shopper group name to multiple prices upload
* Improved error handling on multiple prices upload
* Improved code for stabilizing import

Preview
* Removed Continue button when an error is encountered

General
* Updated language file
* Updated help texts

Version 0.7.2
Import
* Fixed error with field enclosure set to none
* Fixed error "Cannot break/continue ..."
* Fixed undefined variable

Configuration
* Fixed error with wrong datatype on saving the configuration

Version 0.7.1
Import
* Fixed product discount not being imported
* Fixed problem where download dialog pops up
* Fixed update of several fields not working
* Fixed price update if price is 0 or blank
* Re-added product_discount_id
* Fixed child products

Export
+ Added column headers to the Default ordering
* Export takes all fields as stated in configuration page

General
* Improved debug collection
* Fixed image not to display from front-end
* Fixed navigation bar in front-end after saving configuration
* Code rewrite export
- Removed required fields from configuration

Version 0.7
Import
+ Added field product_currency
+ Added option to import product types
+ Added option to import multiple prices per product
+ Added option to empty database
* Fixed skip first line with preview mode
* Fixed updating non-existing prices
* Fixed preview layout that is wider than the screen

Configuration
* Fixed Add Field button does not work
* Fixed problem with existing fields in csv table that are not supported

General
* Code rewrite
* Improved debug collection
* Updated Documentation tab
* Updated Available Fields tab

Translations
+ Added Dutch translation by giovi2002

Version 0.6.1
Import
* Fixed preview not working
* Fixed preview with Upload price list only
* Fixed preview with " or ' as enclosure character
* Fixed problem that uploaded file was always saved in cache folder

Version 0.6
Import
+ Added option to use column headers as configuration
+ Added option to preview import
+ Added option to collect debug information
* Improved support for child products
* Fixed bug with date import for product_available_date

Export
* Fixed broken export

General
* Replaced text input fields in configuration tab with dropdown menus for
  easier configuration
* Finalized changes Documentation page
+ Added the About page

Version 0.5.1
Import
* Fixed bug where Price List Upload only did not work because of not
  overwriting existing data

Version 0.5
Import
+ Added option to do a Upload price list only
* Only product_sku is mandatory now
* Fixed bug when using custom enclosure and/or delimeter
+ Added option to import manufacturers
* Fixed bug where product_publish was added twice to the SQL query
* Fixed bug where commas in product_price was not replaced with a period
* Fixed bug where all fields were imported

General
* Updated documentation

Version 0.4
Import
+ Added option to import product_available_date using a regular date format
+ Added option to import product_box
+ Added option to import product_packaging
+ Added option to import product discounts
* Fixed bug if product_publish is not used, items were not published
* Fixed bug if product_delete is not used, items were not added, import crashed

General
+ Added import statistics to the CSV upload result page
* Updated the message output on the CSV upload result page
* Updated localization
* Updated the descriptions on the Available Fields page

Version 0.3
Import
* Fixed if product_publish is empty, default is now set to Yes
* Fixed the vendor id. If no vendor is set, vendor id should be 1 instead of 0
+ Added a check for correct number of columns
+ Added option to choose not to overwrite existing data
+ Added option to skip the default value and not use the field in the update

Settings
/ Changed default field delimiter to ^ and text enclosure to ~

General
+ Added a link to the CSV import/export on the CSV upload result page
+ Added import flow description to readme.txt
* Updated the Available Fields page with the minimal required fields
* Updated the layout of the import/export tab

Version 0.2.1
Import
* Fixed a few undefined variables
* Fixed check for required fields

Version 0.2
Import
+ Allow empty fields
+ Made all fields from the product table optional except for product_id, 
  product_sku, vendor_id, cdate, mdate, product_name.
+ Possibility to delete products on import

General
+ Added a tab with the possible fields that can be used including documentation
/ Changed layout of the result page
/ Changed font size on the description page so it reads better in Firefox.

Version 0.1
Import
+ Numbers imported with a comma are changed to a period for correct database 
  insertion. This I found necessary since my locale uses comma as a seperator. 
  The only thing I do not know/understand is, how to get a comma on the webshop 
  frontend?
+ Imported data is sanitized for database insertion. This means that you can 
  use regular HTML code in your long description or apostrophe in your products 
  name for example.

Export
+ Removed backslashes from the export

Settings
+ Added the delimiter and field closure from Lauries Excel Generator
+ Added an inputbox for both the delimeter and field closure
+ Added an option to choose to add column headers

General
+ Renamed Field Required? to Field Included?
+ Made the system honor the choice to include or not include a field for export
