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   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