Lost password?    Lost username?    Create an account
OverviewDownloadsForumSupport
CSV Improved

CSV Improved

CSVI VirtueMart Changelog

Legenda:
+ Added
- Removed
* Fixed
/ Changed

Version 2.1.2
General
* Fixed installer not creating export price format column


Version 2.1.1
Import
* Fixed skipping first line issue (thanks Phil)
+ Added timer to check for possible script termination
* Fixed import hangs when image is corrupted

Export
+ Added select options for multiple price groups

Templates
+ Added check if website is chosen for XML export
+ Added option to set price format output
- Removed the Column Header field for import templates

General
* Fixed old logs not deleted (thanks Phil)
+ Added finer control over the replacement, is now set per field
+ Added field order when using Quick Add


Version 2.1
Import
* Fixed attribute_with_tax not handling prices in thousands correctly
* Fixed LOCAL_FILE_DOESNT_EXIST on import with preview
+ Added unlimited import
* Fixed product type names import not finding new product IDs
/ Check for valid image creation on generating thumbnails
* Fixed shipping rates import
* Fixed product type names import not importing on different case
+ Added cancel button to import process

Export
* Really fix the product_url
* Fixed user details export
+ Added order last modified date to selection criteria

Templates
+ Add input filter to template list

General
/ Keep configuration between new installations
/ Change installation to check if old CSV Improved tables exist
/ Updated log handling
+ Added clear cache to maintenance
+ Added number of preview lines in the settings
/ Updated Hungarian language
* Fixed calendars not working on order options


Version 2.0.2
Import
+ Added option to import zip files (only 1 file per zip for now)
* Cleanup after imported file is no longer needed
/ Expanded debug report
* Fixed Fatal error: Class 'CsvimprovedModelAvailablefields' not found on Product Type Parameters import
* Fixed product price not set correctly
/ Changed product_tax behavior to do nothing when field is empty
* Fixed numerous issues in the product type name import
+ Added support for image SEF urls

Export
/ Changed product type parameter names export, can now mix different parameter types
* Fixed front-end export not working in subdomain
* Fixed Column 'list_order' in field list is ambiguous on order export
/ Updated the replacement during export

General
+ Added Czech language thanks to Komanche
* Fixed Update available fields overwriting other product_type_x tables except last one
/ Clean up for PHP 5.3 compatibility


Version 2.0.1
Import
/ Fixed delimiters not always set correctly
/ Fixed category_path mistaken for category_id

Export
/ Fixed product_url missing domain name
/ Fixed picture_url missing forward slash

General
+ Added product_type_x fields to the list of available fields
+ Added search filter to available fields page
/ Fixed sorting on available fields page
/ Updated French language


Version 2.0
Import
/ Improved shopper group ID check
* Fixed product_files_url for downloadable products
+ Added category browse and flypage to new category creation
* Fixed product type names to lose HTML formatting
+ Added option to store remote images on the server
+ Added option to auto-generate imagenames based on SKU
+ Added option to unpublish products before import
* Fixed possible crash if template type not found on import
+ Added option to auto-detect CSV delimiter and enclosure characters
* Fixed several issues with product files import
+ Added category_delete field
+ Added field attribute_with_tax
* Fixed product_discount_id keeps previous value
+ Added userfields import
+ Added product reviews import
+ Added product_files_delete option
+ Added calculations to product_in_stock field
/ Improved product manufacturer relation check

Export
* Fixed attribute export causing undefined error
+ Added initialisation of big SQL selects
+ Added replacement feature
+ Added Google Base channel header
+ Added e-mail export option
* Fixed child products not being exported with category filter
* Fixed non-existing product discounts to export as 0.00
+ Added option to choose VirtueMart Item ID
* Fixed issues with sh404SEF
+ Added category_name to productexport
+ Added field attribute_with_tax
+ Added userfields export
+ Added product reviews export
+ Added cron command line generator
+ Added HTML export format
+ Added front-end export
/ Fixed multiple category id export

Templates
+ Added Quick Template Fields

General
* Fixed cron not using language file
* Fixed cron not using domain name
+ Added replacement table
+ Added maintenance option to cron support
+ Added settings screen
* Fixed tooltips on import/export screen
/ A lot of optimizations done to product import
+ Added option to not store logging
+ Added global category separator
+ Added sorting to Available Fields
+ Added sorting to Templates List
/ Moved sample templates to maintenance section
/ Updated German language


Version 1.9
Import
+ Added support for ignoring empty lines thanks to doorknob
* More fixing of thumbnail creation
+ Added message on preview screen to click Import
* Fixed template fields import not importing duplicate fields
* Fixed category details import to not always look for category_id
* Fixed user info import to not handle user_info_id correctly
+ Added extra signature for JPG files
+ Added test check for delimiters on import failure

Export
* Fixed price_with_discount export
* Fixed price_with_tax export not to remove too many 0
* Fixed writing to file garbles UTF-8 text
* Fixed export results not being shown
* Fixed undefined property with custom fields on coupon export
* Fixed export with same field names to use only the last
+ Added condition field to Google Base sample as this is now a required field
* Fixed Unknown column 'jos_vm_order_user_info.first_name' in 'field list'
* Fixed product type names export to be empty when choosing Don't use

Templates
+ Added template name when editing template
+ Added option to specify different kind of paths
* Fixed field order ID to follow the highest order number

General
+ Added delete all option for log entries
+ Added support for multiple select boxes to cron
+ Added another jpeg signature
+ Added German translation thanks to crissxcross
/ Updated French translation
/ Updated Hungarian translation
/ Updated Brazilian-Portugese translation
/ Updated Slovenian translation


Version 1.8
Import
* Fixed external images not being resized
* Fixed shopper_group_id ignored on user info import
* Fixed shopper_group_name not foud on user info import
/ Changed product file import to use thumbnail sizes from template setting when not creating thumbnail
* Fixed thumbnail creation for subfolders. A resized folder MUST be specified now.
* Fixed file_url to be always the same for product files import
/ Changed import not to stop on error but only report it
* Fixed user info import not creating shopper vendor xref
* Fixed user info import not to create a name for Joomla user
* Fixed product files import causing index.php on file download
* Fixed shopper <--> vendor relation for user
* Fixed undefined errors on userinfoimport
* Fixed product_packaging being reset to 0
* Fixed double / in product_url
+ Added product stock import
* Fixed Not overwrite existing data always return product exists when disabled
* Fixed manufacturer details import not working without manufacturer_id
* Fixed template fields import not handling "not overwrite existing data" correctly
* Added check if category_name matches category_path
/ Updated memory usage check
* Fixed incorrect import when using category_path and category_id in upload file
* Fixed product files thumbnail not being put in resized/ folder
+ Added modal window to show template fields
* Fixed undefined error in case of incorrect attribute

Export
* Fixed undefined error for export filename
+ Added sh404SEF URLs for product URL export
* Fixed missing product_box field
+ Added modal window to show template fields

General
+ Added Russian translation thanks to progressor
/ Updated Slovenian translation
/ Updated French translation
/ Updated Hungarian translation


Version 1.7
Import
* Fixed bug where filename loses first character on the product files import
* Fixed fatal error when overwrite data is unchecked
* Fixed fatal error with ToPeriod function
* Fixed product_mdate and product_cdate not being processed
* Fixed category list order not being processed
+ Added Joomla user details to user info import
* Fixed XML import not using first entry
+ Added shipping rates import
* Improved product deletion
* Fixed manufacturer ID import
+ Added comma to period conversion on multiple prices import
+ Added detailed output on column mismatch
+ Added option to import selected columns
/ Changed filename handling for product files

Export
+ Added payment method to order export
* Fixed template export not showing template selection list
* Fixed template fields export not showing template selection list
* Fixed order export to fail on a number of fields
+ Remove slashes in vendor name on user info export
+ Added country name to order export
+ Added Joomla user details to user info export
* Fixed category details export
+ Added shipping rates export
+ Added currency conversion on export

Templates
+ Added option to add currency to price on export

Maintenance
+ Added product files table to emtpy database
+ Added option to remove empty categories

General
+ Added Portugese translation thanks to dadus
+ Added Brazilian Portugese translation thanks to Igaeta
+ Added French translation thanks to ahamel
+ Added Hungarian translation thanks to dkg11hu
* Fixed control panel images and links
+ Added template name to log view
+ Added Slovenian translation thanks to VidKo
+ Added Swedish translation thanks to cpthaddock
+ Added Dutch translation thanks to djors


Version 1.6
Import
+ Added coupon import
/ Updated thumbnail creation process to check for sensible thumb sizes
* Fixed product files import creating duplicate entries
* Fixed product type names import warning if product type does not exist
* Fixed vendor_id returning no result

Export
* Fixed product with discount has no tax
+ Added stock level values to product export
+ Added user-interactive user selector
+ Added user-interactive product selector
* Fixed Product Type Names not exporting column headers
/ Changed product type names export not to force lowercase
+ Added coupon export
* Fixed product files export
* Fixed manufacturer details export not working
+ Added product_files_download to product files export
+ Added product SKU filter for product export
+ Added product type name filter

Maintenance
+ Added confirmation message to database delete
+ Added option to resize product name field

General
+ Added jQuery for improved GUI
+ Added Croation language thanks to tatamata



Version 1.5.2.1
Export
* Fixed category export being ignored
+ Added multiple category selection

 


Version 1.5.2
Import
* Fixed error when only importing manufacturer ID
* Fixed incorrect preview
/ Changed processing of related SKU's to be more efficient

Export
* Fixed product export when manufacturer is set
* Fixed fatal error when mysqli is set as database handler
* Fixed vendor_id not exporting
* Fixed delimiters not duplicated if they occur in the text
/ Made group by checkbox checked by default
+ Added order export option to export shipping address in case it exists
+ Added category selection to product export

Templates
+ Added filter for import/export templates

General
* Fixed license check
/ Updated folder layout

 



Version 1.5.1
Import
* Fixed manufacturer not assigned to first product if manufacturer doesn't exist
/ Changed handling of auto creating thumbnails
+ Added auto creating thumbnails for category details import
+ Added some performance tweaks
/ Changed import routine to stop immediately when timeout has been reached
/ Changed product type names import to only update the parameters specified in uploaded file

Export
* Fixed incorrect flypage as VirtueMart config is ignored
* Fixed group by not ignoring a few custom fields
+ Added option to set date format on export templates

General
* Fixed cron not logging out user
/ Changed informational messages to be no longer classified as success
* Fixed some undefined errors in the logging
* Fixed version number not always showing on about page

 



Version 1.5 Stable
Import
/ Updated product type parameters
/ Changed applying system limits only if value is greater than 0
* Fixed template import
* Fixed template fields import
+ Added template_name field to template fields import
- Removed converting HTML entities to real characters on product description
/ Update thumbnail creation check
* Fixed undefined errors when database structure is bad

Export
+ Added tab delimiter
* Fixed missing price_with_discount field
* Fixed template export not showing all templates
* Fixed template export in XML format no CDATA tag on cusom field value
+ Added template_name field to template fields import
+ Added disable Export button if no templates with fields are found
/ Fixed handling of templates with 0 fields in case the export gets called
/ Fixed file export to disk not UTF-8
/ Fixed Beslist.nl XML export to not include linebreaks for elements
/ Fixed errors showing up when no records are found to export
* Fixed undefined errors when database structure is bad

General
/ Updated license check
/ Updated installer to check if database can be read
/ Updated images

 



Version 1.5 RC 2
Import
+ Added default currency read from VirtueMart on Multiple Prices import
/ Fixed shopper groups ignored on Multiple Prices import
+ Added attributes tag to Product Import
+ Added product_sku tag to Multiple Prices import
+ Added shopper_group_name tag to Multiple Prices import
* Fixed products per row not working on category details import
- Removed UTF-8 conversion as it does more bad than good
+ Added first manufacturer is assigned to product when importing new products without manufacturer

Export
* Fixed filtering on address did not work for order and user info export
/ Changed loading of usernames to not load if there are more than 5000 users
+ Added disable export templates without fields
+ Added attributes tag to Product Export
+ Added product_sku tag to Multiple Prices export
+ Added shopper_group_name tag to Multiple Prices export
/ Fixed cron ignoring filepath set in general settings
* Fixed product type names export

Templates
+ Added missing text for non-existing images

General
* Fixed unclosed quotes in installation script
* Moved requirements checks to beginning of script
+ Added memory limits to sample templates
+ Added removal of images folder on un-installation as Joomla doesn't clean up
/ Updated install XML DTD
/ Changed license check
- Removed CURL requirement
/ Replaced license check on external server with license key


 

Version 1.5 RC 1

Import
* Fixed tax not associated with product
+ Added preview column to import selection screen
+ Added shopper details to user info import
* Fixed undefined errors in cron
* Fixed undefined errors on result page
* Fixed a bug in thumbnail creation where file is not found

Export
* Fixed undefined error on export result screen
/ Moved record grouping from order export to general settings
+ Added user address filter to user info export
+ Added user vendor filter to user info export
+ Added user permission filter to user info export
+ Added custom field to user info export
+ Added full_name field to user info export (combines first, middle and last name)
+ Added full_name field to order export (combines first, middle and last name)
+ Added discount_percentage field to order export (order_discount/order_total)
+ Added product_price_total field to order export (product_price*product_quantity)
+ Added total_order_items field to order export (counts number of items per order)
+ Added shopper details to user info export
* Fixed undefined errors in cron
* Fixed undefined errors on result page

Templates
+ Added auto increment value when adding template fields
/ Changed field size of column headers to give more space

Maintenance
* Fixed not deleting product type names tables > 9

General
+ Added links to the available fields online help pages
* Fixed pagination on available fields page
+ Added server address to About page
/ Updated license check for working locally


Version 1.5 beta 5
Import
/ Updated available fields for product import
+ Added changing product_weight commas to periods
+ Added changing product_length commas to periods
+ Added changing product_width commas to periods
+ Added changing product_height commas to periods
- Removed category details from product import

Export
/ Updated available fields for product export
* Fixed filename incorrect when downloading file
+ Added product type export
+ Added product type parameters export
+ Added product type names export
+ Added currency filter to order export
/ Changed some order export options to multiple select
- Removed category details from product export

Templates
* Fixed file location having mixed path separators


Version 1.5 beta 4
Import
* Fixed category_id not processed

Export
* Fixed file location not used when exporting to local file based on template
+ Added log entry when SQL query is incorrect
* Fixed product_parent_sku missing
* Fixed local file not saving in the correct folder
+ Added option to group records together on order export
+ Added option to select address type on order export
* Fixed missing product_sku, product_name on order export

Templates
* Fixed error message if no templates are created

General
* Fix icons not showing if installed in subfolder


Version 1.5 beta 3.0.1
General
/ Updated license check
* Fixed license expire date incorrectly shown

Version 1.5 beta 3
Import
* Fixed categories not added correctly
+ Added product_list

Export
* Fixed product_name export
/ Changed product_url to be enclosed in CDATA tags for XML exports
* Fixed custom field not handled in product export

Templates
* Fixed typo in Google Base template
* Fixed template list not always showing

General
/ Completely revised language file

 


Version 1.5 beta 2.2
Import
* Fixed manufacturer_name not being imported
* Fixed tax rate not being imported

Export
* Fixed category_name Category Details export
* Fixed category_path misssing from Category Details export

Templates
+ Added default system values for System Limits

General
* Fixed error messages when no logs exist


Version 1.5 beta 2.1
Import
+ Added check and warning if no templates exist
+ Added a default selected template

Export
+ Added check and warning if no templates exist
+ Added a default selected template
* Fixed missing category_path on product export
* Fixed missing number of fields

General
+ Added Romanian thanks to Danny


Version 1.5 beta 2
Import
+ Added option to append categories
/ Fixed bug where multiple categories per product were not imported

Export
+ Added order export by sold product

Templates
/ Fixed wrong save button


Version 1.5 beta 1.3
General
/ Moved the creation of the log object to the parts that use it


Version 1.5 beta 1.2
General
/ Updated license check
/ Update database table definition to prevent possible key length error


Version 1.5 beta 1.1
General
/ Updated license check


Version 1.5 beta 1
Import
+ Added price calculations for both regular and multiple prices import
+ Added price_with_tax
+ Added option to ignore non-existing products
+ Added manufacturer category ID
+ Added downloadable files option to Multiple Files import (product_files_download)
+ Added product_type_parameter_delete option
+ Added manufacturer_category_details import
- Removed 100 character limitation on import preview
+ Added support for ODS files (OpenOffice Spreadsheet)
+ Added check if cache folder is writable
* Fixed cron support
+ Added default values from template to preview
+ Added option to set default thumbnail format
+ Added user info import

Export
+ Added order export by order number
+ Added order export by date range
+ Added order export by order status
+ Added order export by price
+ Added order export by customer name
+ Added removal of linebreaks on export
+ Added export results to log table
* Fixed dates exporting as Unix timestamps
* Fixed cron support
+ Added XML support for Oodle.com
+ Added user info export
/ Drastically reduced memory usage on export

General
/ Converted to Joomla 1.5 codebase
+ Added logging storage
+ Added browseable list of available fields


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

TESTIMONIAL

An absolute MUST HAVE for Virtuemart.
5 stars
2013-03-15
Honestly, it can be a bit of a pain to get setup properly at the start, depending on how well you understand spreadsheets, but once you configure CSVI properly for your needs, it works like a friggin' dream.

So save yourself the startup headaches and just get the Pro version, and the awesome support that comes with it. It's worth every penny.

I'll never even think about building another Virtuemart store without CSVI Pro. An absolutely MUST HAVE extension for any serious Virtuemart user.

STAY INFORMED


Stay informed with the CSVI newsletter.