News

CSV Improved 7.6.0 - a small update

Only 3 weeks ago we release CSV Improved 7.5.0 and now there is already CSV Improved 7.6.0. While this could just be a bugfix release we did not want to postpone some of the new features we built for you. The new features in this release are small but absolutely worth mentioning.

Example templates

In the past few releases we have been adding more and more example templates to assist you to get started. One problem with the example templates was that it always installed all templates. So you either get a very large list of templates you never use and need to clean up or no example templates if you don't want to keep cleaning them. To help you out we now added the option that you can choose for which extension you want to install the example templates. Ensuring that you only get the example templates you want.

By default the debugging option is turned off because once you decide to take your template live you don't want it to fill up your hosting with all the debug logs. However when testing it can be useful to have the debug option enabled. So we now offer the option to enable debugging on the example templates before installing them. Just a minor change to make life easier.

Install CSV Improved example templates

Joomla! Content Export

The last feature we added is for the Joomla! Content Export to include all subcategories during export. So you no longer have to select all the categories for export, you can just select the parent and enable the option to also export the child categories and you are good to go.

Joomla! Content subcategory support

Database issues

We touched upon this topic last time and we have made further improvements to this to ensure older CSV Improved installations can be updated as well.

Changes

In addition to the new features, we have fixed a number of issues as well. Check the full list of changes in this release:

  • Fixed error on updating available fields
  • Fixed J2Store tasks not setup on installation
  • Lowered Form2Content available fields threshold
  • Fixed SFTP failing on cron job
  • Fixed missing default values for database fields
  • Added option to select for which component the example templates should be installed
  • Added option to enable debug logging on installation of example templates
  • Added option to include subcategories in Joomla! Content export
  • Fixed the back button throwing a fit after import when running in a subfolder
  • Fixed database index issues on installation
  • Make the Operation required during new template creation
  • Fixed ICEcat incorrect column count
  • Fixed AwoCoupon export not using new methodology
  • Fixed AwoCoupon import not using new methodology
  • Improved database integrity checks

This release is available for free to everyone with an active subscription from the Download section. If you do not have a subscription yet, you can subscribe here.

Moving on with CSV Improved 7.5.0

This is another feature release with some great additions to make CSV Improved more versatile. We have been expanding the J2Store support as the new kid on the block. In addition we have added a number of filters to the system.

J2Store

As mentioned before, J2Store is relatively new in CSV Improved and we have been working on improving supporting this extension. This release brings a product filter import and export that allows you to import and export product filters. The filters allow you to have more flexible products. We have also added an import and export for the geo zones option in J2Store. The geo zones allow you to manage all the geographical zones used in your shop.

The J2Store Order item export has an order state filter, allowing to only export order items for orders with a selected state.

VirtueMart

J2Store is not the only shop we have been working on. VirtueMart, our old-timer, is still being expanded as well. This time we added the option to unpublish categories before doing a VirtueMart Category import.

Custom Fields for All

This little gem is being used by quite a few people to add flexibility to their VirtueMart products. A few releases ago, it started to support multi-lingual websites, however it was not possible to import or export them with CSV Improved. This is now changed, we added full multi-language support for the Custom Fields for All plugin.

Price removal

In the maintenance section we have the option to remove prices for VirtueMart, Hikashop and J2Store. This has been enhanced with a manufacturer filter. You can now also delete prices that are linked to a selected manufacturer.

Database issues

The last few releases we have noticed an increase in issues that are related to database changes. Finally resulting in a list of errors shown on the About page since the Joomla 3.8.6 release while nothing had changed. This turned out to be a change in Joomla and was not related to any real database issues. This needs to change, so we wrote our own database sanity checker. Every time CSV Improved is installed, the database structure is checked and where needed fixed. In the case you do need to fix the database afterwards, we still have the Fix Database button on the About page. Let the database issues be gone and forgotten :)

Changes

The above changes are just some highlights. We have made quite a few stability fixes as well to ensure CSV Improved keeps running smoothly. Check the full list of changes in this release:

  • Fixed an issue with downloading remote files
  • Fixed user import always skipping new users
  • Fixed custom field default value not exporting in VirtueMart Order Advanced export
  • Fixed shipping full name field throwing errors in VirtueMart Order export
  • Added manufacturer filter for Virtuemart Maintenance remove prices
  • Added brand select option to HikaShop Maintenance empty product prices
  • Added empty product prices for J2Store
  • Fixed Conditional rule plugin not reading 0 as a value
  • Fixed duplicate category error in VirtueMart category import
  • Fixed SFTP namespace casing
  • Fixed customer_note not exported in VirtueMart Order Advanced export
  • Changed do not update override and product_override_price when empty in VirtueMart Price import
  • Added clean CSVI cache on install of extension
  • Fixed Menu parameter missing when adding a new menu in Joomla Menu import
  • Changed updated the list of fields that need number formatting in VirtueMart Order export
  • Added product filter import for J2Store
  • Added product filter export for J2Store
  • Fixed new orders not created for guest users in VirtueMart Order import
  • Fixed update title with SKU only for new products in J2Store Product import
  • Added support for custom date format in Multireplace plugin
  • Added J2Store Geo zone rules import
  • Added J2Store Geo zone rules export
  • Fixed HikShop category filter does not include products with product_parent_id
  • Fixed field_combine variable undefined notice
  • Removed incorrect available field in J2Store Order export
  • Added the order state filter on the J2Store Order Item export
  • Added the customer name to J2Store Order Item export
  • Added Unpublish categories before import in VirtueMart Category import
  • Added Custom Fields for All multi-language support
  • Added new database sanity checker

This release is available for free to everyone with an active subscription from the Download section. If you do not have a subscription yet, you can subscribe here.

Kicking off with a new release

With the festive season behind us I want to start wishing everybody a joyful, exciting and amazing 2018. That this may be a year full of awesomeness. We are starting it with a new feature release, CSV Improved Pro 7.4.0. This release has been in the making for the past 3 months, so you can expect a lot of new goodies.

Joomla Modules

The Joomla Modules is one of the few parts of Joomla not yet supported by CSV Improved until now. This release brings you import and export features of Joomla Modules. This is a tricky one because each and every module has it's own settings so we cannot support all individual settings but we do support the basic ones. The other settings can still be imported and exported but this will be a field with lots of data in it. So you may have to sift through it if you are looking for a specific setting to change.

However for exporting and importing across multiple sites this makes life a lot easier as you can export and import the modules as-is. Assuming you have the module installed in the target system of course. This also allows you to roll out a module with settings across multiple sites if you need to.

We have the documentation ready and you can find out about it in the Joomla Modules Tutorial.

Custom Table import and export

The Custom Table import and export is undergoing major surgery and it keeps getting better and better. We have improved the performance and stability of the import mechanism and added some new features as well. The features we added this time are:

  • Option to empty the table before starting the import
    This allows you to import data into a clean table
  • Option to delete records on import using the record_delete field

SFTP

As the web is looking to become more and more secure we at CSV Improved would like to chip-in as well. This release adds the option to import from and export to SFTP servers instead of FTP. SFTP is the SSH File Transfer Protocol and should not be confused with FTPS which is something completely different. In case you are interested in the differences you can read the article Difference Between FTPS and SFTP. To use the SFTP option, you choose the FTP option and then enable the SFTP setting. Make sure you fill in all the correct details of course.

Remote images

Hosting images on another server is nothing new but what is new is that there is some movement going on in this area. HikaShop now allows you to use remote images so we also support that from this release onwards. In the K2 Item import we now added the option to download remote images and use them in K2. Finally, all the remote images downloads can be used with a username and password. This allows you to download remote images that are behind a login, making it even easier to manage your images directly.

Imagenames with spaces in them will now be replaced with underscores to make the files less prone to issues.

Changes

The above changes are just some highlights. We have made quite a few stability fixes as well to ensure CSV Improved keeps running smoothly. Check the full list of changes in this release:

  • Changed Threshold limit for AwoCoupon
  • Fixed Custom table import not adding new records
  • Setting value to Import based on field if its not a primary key field
  • Rework update mechanism for the Custom table import
  • Fixed skipping new records if set in template on Custom table import
  • Fixed fatal error and added logging to Custom table import
  • Added option to empty table before import in Custom table import
  • Added spaces will be replaced by underscores in image names on all imports
  • Added a new option to select required date field to be used in date range option in VirtueMart Order export
  • Added a new option to select required date field to be used in date range option in HikaShop Order export
  • Fixed do not use timezone when saving order date in VirtueMart Order export
  • Fixed do not use timezone when saving order date in HikaShop Order export
  • Fixed do not use timezone when saving order date in J2Store Order export
  • Added support for multiple product ordering in VirtueMart Product import
  • Added SFTP option for import and export
  • Added Multi replace rule to support replace of empty values
  • Fixed some minor issues with templates listing making it more robust
  • Added maintenance option to delete duplicate related categories and products for VirtueMart
  • Changed Take time offset into account when using last run date for HikaShop Order export
  • Fixed search filter on template fields not working
  • Added date field to multi-replacement plugin
  • Fixed ODS files import running forever
  • Changed Set a default extension in FastSeller producttype import
  • Added Image name to support accent characters
  • Fixed Front-end import for fromdatabase shows no file error
  • Fixed Missing image upload class in K2 2.8 version
  • Fixed Skip rule plugin to not skip the record
  • Fixed date format to read from first field instead of individual fields
  • Added username and password to be set to read images from remote resources that require login
  • Added support remote image download of K2 Item import
  • Fixed a number of undefined notices
  • Changed Make thumbnail processing more robust in VirtueMart Product import
  • Added import of remote HikaShop images to HikaShop Product import
  • Added I'm Mac to Field mapper
  • Added Joomla Modules import
  • Added Joomla Modules export
  • Fixed Joomla Article import not recognising required fields
  • Added support for zip files for restoring templates
  • Added Delete row using record_delete field in Custom Table import
  • Added Check if component is installed while restoring templates
  • Fixed custom_ordering field not exporting if it has a 0 value
  • Fixed Template fields view to be more robust
  • Fixed product thumb image in J2Store Product import
  • Added Validate regular expression set in Skip rule
  • Changed Keep Field name selected for Custom Table export template fields
  • Fixed Join field not selected by default in Custom Table export template
  • Fixed Stockable Custom Fields not updating parameters for children in VirtueMart Product import
  • Added order_number field to VirtueMart Order Item export

This release is available for free to everyone with an active subscription from the Download section. If you do not have a subscription yet, you can subscribe here.

CSVI Pro 7.3.0 released

09 October 2017
in News

New feature release CSVI Pro 7.3.0

All summer we have been working on this new incredible version of CSV Improved. Not only fixing bugs but also adding some great new features which we think you will enjoy. The biggest of them all is the support for yet another extension. We are now also supporting the import and export of J2Store data. Allowing you to choose yet another shopping cart system and keep on using CSV Improved.

J2Store

To keep supporting our customers we have added support for J2Store as this shopping cart is getting bigger and bigger by the day. Allowing users to create products from Joomla articles is a great way to maintain a store with an interface users are already used to. At this moment we have included the following imports and exports:

  1. Products
  2. Product files
  3. Product images
  4. Prices
  5. Orders
  6. Order items

As you can see quite a long list of things you can already import and export with J2Store. In combination with the Joomla Article import you can manage all your products with ease. We have documentation available as to how to run the imports and exports as well. Have a look for that at the J2Store tutorials documentation section. Please give it a try and let us know what you think. We are looking forward to your input and see how we can improve here.

VirtueMart

There has been some changes to the VirtueMart integration as well. Most notably is that we removed the SnelStart export routine. The reason we removed the SnelStart routine is that it was pretty much doing the same thing as the Order export except it had a few more fields. So we moved support for these fields to the Order export routine to allow you to still export these fields. To continue using your template, you can just change the type from SnelStart to Order and the template will continue to function as before.

The VirtueMart Custom Fields import now allows you to also import custom fields that are grouped. This is useful when you have a number of custom fields that belong together.

Custom fields for products are used quite a lot we noticed and users would like to see this information as well when they run the Order export. That is now possible. The VirtueMart order export supports the custom fields that are assigned to products. All you need to do is make sure that the list of available fields is updated. One thing to be aware of, the values are taking from the product settings, they do not come out of the order table so any change you make to the custom field after someone ordered it, this will export the changed value and not the one it was at the time of ordering. That is because this information is not stored by VirtueMart.

Custom Table import and export

In the previous release we improved the export of the Custom Table export by allowing you to link any tables as you like. This time we looked at the import, here we added the option to use a compound key as unique identifier. In case the table uses multiple fields to identify a record, enter multiple keys separated by a comma. Setting this, you can update fields that are identified by more than just a primary key.

SEF URLs

Product exports usually require the product URL to be send to a comparison site like Google Shopping. Instead of having a long and not so friendly looking URL we use a SEF URL. CSV Improved supports SEF URLs but it didn't play nice on a multi-lingual site. This has now been fixed and SEF URLs are indexed based on language. Now you will always get the correct SEF URLs. Make sure to update the SEF URLs from the Maintenance section so your URLs are language aware.

Date formats

Until now the date format applied to all exported fields was set in the template. This meant you cannot get a different format for different fields. Now you can customize this by setting the date format field per field you export. Of course this will only be applied to fields that has a timestamp in them.

Changes

The above changes are just some highlights. We have made quite a few stability fixes as well to ensure CSV Improved keeps running smoothly. Check the full list of changes in this release:

  • Country separator for VirtueMart Shippingrate import is now |
  • Fixed Custom filters export
  • Added Field combine to allow empty values (Thank you Pavel)
  • Added support hyperlink fieldtype for Form2Content Article import
  • Added support for J2Store Product Images import/export
  • Set a default value for watermark margins
  • Fixed Remove folder after import using cron
  • Fixed username field is ambiguous on VirtueMart User Info export
  • Added support for J2Store Order Item import/export
  • Fixed unknown class error in CSVI override file
  • Fixed generating Joomla articles in cron mode in Form2Content Article import
  • Added support for category_path in Form2Content Article import
  • Added support for Options in HikaShop Product import
  • Added support for J2Store Order import/export
  • Added compound keys to CSVI Custom Table import
  • Changed setting log and tmp folder
  • Added message to show result of Database and Menu fix on About page
  • Removed Settings option from menu as it is obsolete
  • Fixed language not correctly read from template in VirtueMart product categories list
  • Store SEF URLs with language setting
  • Added allow multiple custom fields to be exported in Joomla Content export
  • Added check if CSVI stockable custom fields or CSVI custom fields for all is installed in VirtueMart Product import
  • Fixed ICEcat loading indexes
  • Added result message on screen when doing a frontend export
  • Fixed template fields throwing error when not set
  • Fixed FTP not loading correct filename
  • Added meta information fields for VirtueMart Manufacturer import
  • Fixed product_attribute field exporting empty in VirtueMart Orderadvanced export
  • Fixed category separator not using template settings in VirtueMart Google export
  • Added product custom fields support in VirtueMart Order export
  • Fixed Generate thumbnail image from main image in Form2Content import
  • Added a check to see if the appropiate add-ons are installed
  • Fixed export of multiple values for Custom Field type Image List
  • Added support for J2Store Product import/export
  • Added Joomla User custom fields in HikaShop Order export
  • Fixed product price filter of 0 in VirtuMart exports
  • Added option to specify date format for each template field
  • Added support for custom field groups in VirtueMart Custom Fields import
  • Merged SnelStart fields to VirtueMart Order export
  • SnelStart export removed from VirtueMart

This release is available for free to everyone with an active subscription from the Download section. If you do not have a subscription yet, you can subscribe here.

CSVI Pro 7.2.4 released

20 September 2017
in News

New stability release CSVI Pro 7.2.4

On Tuesday September 19th Joomla! released the Joomla! CMS 3.8 version and this has caused a break in CSV Improved as files have been moved around. This release only contains a fix to deal with sites that have been upgraded to Joomla 3.8.

Manual fix

For those who cannot update to CSVI Pro 7.2.4. a manual fix can be applied by following these steps:

  1. Open the file administrator/components/com_csvi/rantai/import/engine.php
  2. Go to line 162 where you will see:
    require_once JPATH_LIBRARIES . '/cms/version/version.php';
  3. Change this line with this code:
    require_once JPATH_LIBRARIES . '/src/Version.php';
  4. Save the file and the issue should be resolved.

Changes

The full list of changes in this release:

  • Fixed fatal error on version.php inclusion.

This release is available for free to everyone with an active subscription from the Download section. If you do not have a subscription yet, you can subscribe here.

New feature release CSVI Pro 7.2.0

Even before Joomla! 3.7.0 came out we were receiving requests if the new Custom Fields are supported in CSV Improved. At the time it wasn't because Joomla 3.7.0 was not even stable yet. Now that we have had a few new Joomla releases it is time for CSV Improved to come with a release as well. We proudly present the support of Custom Fields in CSVI Pro 7.2.0. So you can now import and export your custom fields for Articles, Users, and Contacts.

That is not the only new feature we have in CSVI Pro 7.2.0. We further improved the support for Form2Content import as we now also support the database lookup fields and after importing new Form2Content articles, they are immediately parsed as Joomla articles, so the article is immediately updated for your site visitors. VirtueMart recently came out with a new release as well which contains some new fields which are also supported now. These fields are payment_currency in the VirtueMart Order export and virtuemart_rating_vote_id in the VirtueMart Rating import. The categories in VirtueMart have been given a set of parameters by the developers, so we make those available as well for import and export.

Joomla! IDs

When you use CSV Improved to move over or synchronize data for your Joomla! data the IDs would always change as CSV Improved created a completely new item which then received a new ID. This is troublesome when you have links in your articles that link to other articles or menu items which link to articles or categories. So we recognized this problem and did something about it. Now it is possible to keep your existing IDs when you import:

  • Joomla! articles
  • Joomla! categories
  • Joomla! menus

Conditional rule

For some time the request has been to update field values based on conditions. Now it is possible to do this using the value comparison rule plugin or by writing your own rule plugin so it matches your exact needs, however writing a plugin is not something everybody can do. So we decided to build our own rule and include it for you. The value comparison rule would only allow for 1 rule at a time, the conditional rule you can not only add multiple conditions but also get values from other imported fields.

Conditional rule

As you can see with this conditional rule you can set all kinds of rules of how a field should be filled. The value comparison rule plugin is no longer being shipped with CSVI Pro but you can still continue to use the one installed on your site.

Custom table export on steroids

Custom table fields query

A long standing request but finally it has arrived, the ability to construct your own queries in CSV Improved. This is an example of exporting VirtueMart order data. You are in complete control of which tables are exported and how they are linked.

Support for Styleware Maps is back

In the past CSV Improved supprted Styleware Maps but somehow it was left behind. No longer and you can import data for Styleware maps into:

  • Joomla content
  • Joomla categories
  • K2 content

Other notable changes

We updated support for K2 version 2.7.1 so there is no problem anymore with a missing library. We implemented auto-loading for the addons, what this means is that it doesn't matter anymore in which order you install CSV Improved or the addon. You can now also import multiple files from an FTP folder. In VirtueMart it is possible to import and update orders for guest users.

Changes

The full list of changes in this release:

  • Check if there is a product currency in VirtueMart Google export
  • Checking if old parameters exist change to prevent error Unknown column 'csvi_setting_id'
  • Fixed VirtueMart Sort categories maintenance option Call to undefined function
  • Fixed ICEcat indexing
  • Added translation of titles in the product_attribute of VirtueMart order export
  • Fixed Inserting images in Form2Content Article import now contains all settings
  • Added support for database lookup fields in F2C Article import
  • Added decimal separator for product_discountedPriceWithoutTax and product_priceWithoutTax in VirtueMart order export
  • Added Show friendly message on rules page there are unpublished plugins
  • Fixed duplicate slug error in VirtueMart category import
  • Added option to use existing ID in Joomla! content import
  • Category thumbnail image to take resize folder only when user wants it in VirtueMart category import
  • Added Implemented autoloading of supported extensions
  • Products table field name is ambigous in VirtueMart order export
  • Fixed Custom Fields for All ordering field in VirtueMart product import
  • Added Generate alias from title field for Form2Content articles
  • Fixed failure to load the correct template instance in certain circumstances
  • Increased length of sefurl field to 512 characters
  • Added support for new field payment_currency in VirtueMart order export and import
  • Changed user check to make sure user exists in VirtueMart order import
  • Added support for new field virtuemart_rating_vote_id in VirtueMart rating import
  • Fixed wrong table name in VirtueMart shipping rate export
  • Added support for the category parameters in VirtueMart category import
  • Fixed product parameters not getting updated in VirtueMart product import
  • Added option to use existing ID in Joomla! menu import
  • Fixed missing show_on_pdetails and shipment_cost fields for VirtueMart shipping rate export
  • Update for K2 2.7.1 support
  • Fixed returning SEF URL when cache is turned off
  • Added option to use existing ID in Joomla! category import
  • Check for existing shipping name with either slug or shipment name on VirtueMart shipping rates import
  • Added Multiple table selection for CSVI custom table export
  • Added conditional rule plugin
  • Margin rule to convert decimal to points for calculation
  • Fixed Form2Content article not updating because of empty alias on Form2Content article import
  • Added to parse template after import in Form2Content article import
  • Fixed file not deleted from it's original location when importing from server
  • Added cron/frontend setting to templates list
  • Fixed cron export to show up double in logs
  • Fixed environment settings for JUri
  • Fixed template backup to fail due to special characters in rule
  • Fixed to select only Stockable Custom Field plugin row on import
  • Added support country and state names for HikaShop order export
  • Added support for Joomla! custom fields
  • Added Support for custom_disabler field for Stockable Custom fields on VirtueMart Product import
  • Added import multiple files from FTP folder
  • Fixed error on deleting product when language table doesn't exist in VirtueMart Product import
  • Fixed Column header showing in default value field
  • Joomla! Menus import now also supports backend menus
  • Added support for Joomla! Contacts
  • Fixed Form2Content Article import failing on displayList field not containing multiple entries
  • Added Product override price to convert to target currency price in VirtueMart Product export
  • Fixed bug of empty custom value in stockablecustomfields and customfieldsforall value in VirtueMart Product import
  • Added Allow updating orders of guest users in VirtueMart Order import
  • Fixed Refresh SEF URLs to deal with redirects
  • Updated file_url_thumb to be generated on the fly on export in VirtueMart Product export
  • Override field does not get updated when it is 0 in VirtueMart Product import
  • Removed Value Comparison rule plugin in favour of new Conditional rule plugin

This release is available for free to everyone with an active subscription from the Download section. If you do not have a subscription yet, you can subscribe here.

Page 1 of 4

My Member Software

My Member Software

My Member Software is the downloadable open source member administration program with which Associations, Clubs, Foundations and even companies can administrate their members and is integrated in the Joomla CMS.

You can use CSV Improved to easily import your user data into My Member Software.

Read all about My Member Software.