News

CSV Improved 7.10.0

The end is coming near for 2018 and we want to leave this year with a parting gift. The final release of 2018 of CSV Improved with many new features. Although you think there are a lot of features in CSVI, more and more are requested and most of them make it into the release. To find out what we have in store this time, keep on reading.

Joomla Menus

Now you can export all menus in one export, no longer is it needed to export them menu by menu. Simply select All Menu Types and you can export all menus in your site.

HikaShop

HikaShop is back on the list as we added the Order Advanced export to HikaShop. An important staple in the VirtueMart exports, this is now also available for HikaShop. Allowing you to customize the export as you like. This makes it easy to export orders in a customized XML format. Check it out.

Combine rule arithmetic operations

The combine rule now has the option to perform arithmetic operations on 2 or more fields. This allows you to perform all kind of calculations as you run your import or export.

Joomla Content

The power of image processing in VirtueMart is now also available in the Joomla Content import. You can import external images for your content and have it stored on your server on the fly during import.

We also added the option to import associated articles for multi-language sites.

Unique ID

The multi-replace rule has the option to add a unique ID value to a field during import or export, this way you can create a unique identifier for any item you are importing or exporting.

Export orders based on ID

A while ago we added the option to export orders based on last run time, as it turns out, this is not always 100% foolproof as orders may come in as your export is running. Now we added the option to export orders based on last ID. So let's say your last export had the order ID 4552 as last ID exported, the next export will run and start from 4553. Now you should never miss an order again.

This option is available in the following exports:

  • VirtueMart Order export
  • VirtueMart Order Advanced export
  • HikaShop Order export
  • HikaShop Order Advaned export
  • J2Store Order export

Changes

Check the full list of changes in this release:

  • Fixed the search filter on the Rules page
  • Added option to verify SSL certificate on remote files
  • Added option to export all menu items
  • Fixed reading ODS file with extended characters
  • Fixed not able to export all shoppers in VirtueMart Users Info export
  • Fixed frontend export not using filename set as argument
  • Fixed broken tables due to change in Joomla 3.9.0
  • Added shipping method filter in VirtueMart Order Advanced export
  • Added show message if no valid usergroups are found in Joomla User import
  • Fixed warning with Custom Fields for All if site is using only one language in VirtueMart Product import
  • Added Order Advanced export in HikaShop
  • Added Category include/exclude filter in VirtueMart Product export
  • Added extra fields in VirtueMart Media Product import
  • Fixed notice in Joomla Categories import
  • Added arithmetic operations in Combine rule
  • Added support for remote image processing in Joomla Content import
  • Added associations fields to Joomla Content import
  • Added unique ID option to Multireplace rule
  • Added option to delete shoppergroups in VirtueMart Product import
  • Added option to export orders based on last exported order ID in VirtueMart Order export
  • Added option to export orders based on last exported order ID in VirtueMart Order Advanced export
  • Added option to export orders based on last exported order ID in HikaShop Order export
  • Added option to export orders based on last exported order ID in HikaShop Order Advanced export
  • Added option to export orders based on last exported order ID in J2Store Order export
  • Fixed export of product attributes in VirtueMart Order export
  • Fixed export of product attributes in VirtueMart Order Advanced export
  • Fixed export of product attributes in 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.

CSV Improved 7.9.0

We seem to be getting more regular releases lately. Last month we released CSV Improved 7.8.0 with some great new features, this time around we have some pretty neat features again. Read on, to find out.

Joomla Custom Fields

In Joomla it is possible to group a set of custom fields, however it was not possible in CSV Improved to export fields per group. We have added this filter to allow you to export your custom fields per group.

Joomla Users

In addition to the usergroup options we added in the previous release, we have taken this a step further. You can now import and export nested usergroups. For example you have the following structure:

  • Sales/Employees
  • Production/Employees

It was impossible to import this structure as you could only specify Employees, this would make CSV Improved always load the first entry it finds. Now you can specify the path in full and have full control over the usergroup structure. This can be used in both the Joomla Users import and export and the Joomla Usergroups import and export.

See our tutorial on Joomla Users import for specific details on how to use this new feature.

J2Store

The regular price is now added to the J2Store Price export as well, so you can get a clear overview of the regular prices and special prices linked to your products.

Template wizard

We have extended the template wizard with the field mapper. You can now map your fields directly when creating a new template, provided the option is set to not use the file for configuration.

Template Wizard Field Mapper

There are several options you have here:

  1. Go to Template fields to add them manually
  2. Type or paste the setup of your fields
  3. Upload a CSV file
  4. Drag and drop a CSV file

Once you have added your content, the fields will show up and you can map them.

Changes

Check the full list of changes in this release:

  • Users with enabled status set to yes are checked against blocked status in Joomla User export
  • Added export products with regular prices in J2Store price export
  • Added field mapping to template wizard
  • Fixed various issues in FastSeller for HikaShop export and import
  • Fixed maintenance options not used during cron run
  • Fixed Rule view cancel button compatible error
  • Added filter to filter on field groups in Joomla Custom fields export
  • Added support for nested usergroups in Joomla Users import
  • Added support for nested usergroups in Joomla Users export
  • Added support for nested usergroups in Joomla Usergroups import
  • Added support for nested usergroups in Joomla Usergroups export
  • Fixes to Custom Filters Pro import

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.

CSV Improved 7.8.0 - a feature release

Less than a month ago we released CSV Improved 7.7.0 with some great new features. In the meantime we have added some other extra nice features we don't want to keep to ourselves so we decided to do another smaller release.

Joomla Tags

We apologize for those looking for Tags support in 7.7.0, we forgot to include the package in the distribution. Although nobody asked us about it ;) This time it is included and you will see it in the list of extensions when creating a new template.

Joomla Users

We have added 2 options to the Joomla Users import that will now allow you to:

  • Append usergroups for existing users
  • Remove usergroups for existing users

See our tutorial on Joomla Users import for specific details on how to use this function.

HikaShop

The HikaShop Order export now is able to also export the characteristics of the products that have been ordered. So you can see the details of each product that a customer has ordered.

J2Store

For J2Store we have added some extra fields to make life a little easier. These fields help when you have to deal with variants. The fields are:

  • product_parent_alias
  • product_parent_title

Using these fields you can see clearer to which parent a variant is linked.

  • regular_price

The regular price allows you to update the Regular price field in addition to the quantity based prices.

Changes

Check the full list of changes in this release:

  • Added option to append usergroups on Joomla User import
  • Added option to remove usergroups on Joomla User import
  • PHP 7.2 compatibility fixes
  • Added support for product_parent_alias and product_parent_title fields for J2Store Variant import
  • Added support for product_parent_alias and product_parent_title fields for J2Store Variant export
  • Added lock on Rule fields being edited prevent other users from editing the same rule
  • Added regular_price to J2Store Price import
  • Added regular_price to J2Store Price export
  • Added characteristics on HikaShop Order 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.

CSV Improved 7.7.1 - a bugfix release

Last week we came out with CSV Improved 7.7.0 which was a big release with many new features. During the past week we found some issues that need to be addressed and we have addressed them. This release only contains bugfixes to further stabilize CSV Improved 7.

Changes

Check the full list of changes in this release:

  • Fixed not able to load the options in maintenance
  • Fixed Unknown column error with characteristic on HikaShop Product export
  • Fixed losing article content on J2Store Product import
  • Fixed not setting the has_options on variants import on J2Store Product import
  • Fixed missing update server for Form2Content addon

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.

CSV Improved 7.7.0 - a feature release

Summer is behind us and it is time to get to work, what a better way to do that with this new CSV Improved and some great new features.

The past few months we have been working hard on some great new additions including support for the most requested Joomla Tags import and export and J2Store Address import and export.

Joomla Tags

This release adds yet another Joomla component to the list of supported extensions. The Joomla Tags import and export allows you to import and export tags to be used throughout Joomla. We have documented on how to use these features in the Joomla Tags Tutorial. The tags can be imported with the Joomla Content and Joomla Categories using the tags field.

J2Store

This release contains some important additions to the J2Store support. We have added the option to import and export J2Store addresses, this allows you to manage your customer addresses as used in J2Store. How to manage the addresses is documented in the J2Store Address Tutorial.

We have also added more fields to the J2Store Product import so you can import more product details in a single import. We have added the following fields:

  • introtext
  • fulltext
  • language
  • featured
  • hits
  • access
  • version

Processes list

We have found out that the Running Processes list wasn't very accurate so we have spend some time optimizing this list to be more reliable. The list should give a better representation of the current running imports and exports. You are advised to delete all entries in the processes list and start clean.

Rules

The rules is a much used feature and for good reason, it gives you an enormous amount of flexibility. It was very hard to see which rules are linked to a template and to which templates. That has been changed now. The rule listing now has the option to filter on rules assigned to templates or not.

Rules Template filter

We have further enhanced this feature that when you edit a rule, you can click the Linked Templates button and you will get a list of templates linked to the rule. You can click the link to open the list of template fields for the linked template. The Linked Templates button will only show up if there are any linked templates.

linked templates button

linked templates list

HikaShop

This release contains yet again new features for HikaShop. A request we received multilpe times is to be able to export the file details in the Product export and import. So we listened and added these fields to the HikaShop import and export. The following fields have been added:

  • file_path
  • file_name
  • file_description
  • file_ordering

WIth these fields it will make it easier to manage the products with their images.

There is now also the option to recreate product aliases on import. This can be useful for when you want to clean up your aliases in bulk.

If your HikaShop is using product variants it is not possible to set a variant as default but that is history now. CSV Improved now supports setting a product variant as default product. Not only that but CSV Improved can also create variants on the fly on import. We have documented this in the HikaShop Variants Tutorial.

For those using FastSeller with HikaShop, we support this now as well for HikaShop.

Notable changes

There are a few changes we do want to highlight as they can be quite useful:

  • Joomla Content export now has date filters allowing you to export a selection of items based on date ranges
  • Option to delete prices before import in VirtueMart Product and Price import
  • Debug log entries can now be limited to what is recorded. Large imports can cause huge debug logs, we have now made it configurable and it defaults to only logging the first 20 products.
  • CSV Improved now supports multi-language support for Custom Fields for All in stockable custom fields in VirtueMart Product import
  • The skip rule plugin now has the option to skip empty records

Changes

Check the full list of changes in this release:

  • Fixed multi variant import shows invalid argument error when no values in import file in VirtueMart Product import
  • Fixed duplicate language error with VirtueMart
  • Added insert Variants on HikaShop Product import
  • Added allow import of Joomla content without text, informs user if so
  • Fixed change active language code in VirtueMart to standard language code
  • Fixed backup template does not save file in user defined location
  • Added allow importing 0 and empty values for custom fields
  • Changed Custom field check to be more precise for VirtueMart custom fields
  • Added FastSeller support for HikaShop
  • Added add default variant to HikaShop product import
  • Added Encode URL as a option in template settings for importing from remote sources
  • Fixed Missed Keep id condition with adding module menus
  • Fixed Use image base path from Form2Content configuration
  • Fixed HikaShop custom fields to be table specific in field list prevent ambiguous error
  • Added Joomla categories export Group and Sort By fields
  • Added throw an error when a component is not set in a template
  • Added Joomla Tags import
  • Added Joomla Tags export
  • Fixed Hikashop showing 0 variants for products with no children in HikaShop Product import
  • Added use image name from import file if provided in HikaShop Product import
  • Changed improved handling images from remote servers
  • Fixed HikaShop variants with a change in Characteristic name not updated
  • Added custom table export to support field alias using column headers
  • Added skip record when value is empty
  • Added decimal option to Margin plugin
  • Added option Recreate alias in HikaShop Product import
  • Fixed HikaShop product access on product import and export
  • Fixed the product access level and price site ID in HikaShop Product import
  • Fixed all value is exported on product_access in HikaShop Product export
  • Added multi-language support for Custom Fields for All in stockable custom fields in VirtueMart Product import
  • Added debug log limit number of lines entry
  • Added option to delete price before inserting new ones in VirtueMart Product and Price import
  • Fixed duplicate entry error on HikaShop customer import
  • Fixed custom table empties table on every step
  • Added installation of example templates to be language aware
  • Added filter date range options to Joomla Content export
  • Changed improve user message when file does exist on FTP server
  • Changed delete Product image relation to work when Process image is set to yes in HikaShop Product import
  • Fixed Hide the credentials if processing is set to No in HikaShop Product import
  • Added support export of image fields in HikaShop Product import
  • Added list the templates where rule has been used
  • Added J2Store Address import
  • Added J2Store Address export
  • Fixed removes image values in Joomla Content import
  • Changed synchronise product image handling between HikaShop, VirtueMart and J2Store
  • Fixed importing override value in VirtueMart Product and Price import
  • Fixed overwriting existing data on J2Store Product import
  • Added extra content fields in J2Store Product import
  • Fixed running processes listing finished processes
  • Added notification in cron where export file is saved

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.

CSV Improved 7.6.2 - a stability release

A couple of weeks ago CSV Improved 7.6.0 was released and in the meantime we have been busy fixing bugs that were noticed. This makes 7.6.2 a true stability release as there are no new features in this release.

Some interesting fact about many of these bugs is that they have been present in CSV Improved for quite some time and went unnoticed for so long. Thank you for reporting them and we will fix them as soon as we find them.

Changes

Check the full list of changes in this release:

  • Fixed error with product_params field on VirtueMart Product import
  • Fixed default values not used on product_params in VirtueMart Product import
  • Fixed corrupt lines stopping ICEcat index loading
  • Fixed import of multiple multi variant fields in VirtueMart Product import
  • Fixed fatal error on VirtueMart Order Advanced export when export type is changed
  • Fixed parsing date in Multi-replace plugin
  • Fixed default value on VARCHAR fields in database check
  • Fixed ambiguous delivery_date field on VirtueMart Order Advanced export
  • Fixed the time on log dates
  • Fixed the front-end export redirect
  • Fixed unable to import new orders in J2Store Order import
  • Fixed SFTP class not found on front-end export
  • Fixed not all categories shown in HikaShop templates
  • Fixed obsolete fields in Form2Content 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 5

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.