News

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.

CSVI Pro 7.1.0 released

20 February 2017
in News

New release CSVI Pro 7.1.0

This release marks the first feature release in the CSV Improved 7 series as we plough along. At first we thought to bring out another bugfix release but there were no urgent issues to fix so we decided to let it simmer a little longer and bring you some new goodies as well. Nothing really spectacular in this release but what deserves a little attentions is the generation of SEF URLs.

SEF URLs

Once CSVI 7 came out, exports become noticeably slower when exporting SEF URLs, the main reason behind this is because we adopted a new way of generating the SEF URLs. The forest of SEF extensions is dense and we tried to support the bigger ones as much as we could but as they keep changing, SEF URL generation kept breaking so we needed to find another way. So we did. Instead of generating the SEF URL ourselves we now ask Joomla to generate it for us by making a call to the front-end of your site mimicing to be a visitor. This works beautifully, were it not that it is considerably slower than before. Apart from the fact that with a lot of products the number of requests is not friendly either for your server. This has been fixed with this release. We now make it possible to cache the SEF URLs, so you only need to generate them once and can re-use them as much as you need for your export. This makes the exports really fast again. The caching of SEF URLs can be done while you run your first export or do it via a maintenance task. The maintenance task is recommended because it has a lot more optimized than a regular export. You can even schedule it as a cron job.

Changes

The changes this release are:

  • Fixed fatal error on emptying shopper groups on VirtueMart user info import
  • Fixed notice Trying to get a property of a non-object on VirtueMart Product import
  • Fixed retrieving wrong custom ID on Stockable Custom Fields import
  • Added Unpublish before import option for HikaShop
  • Added Category and Content Type selection on Form2Content Article export
  • Fixed database lookup field to list title instead of id
  • Added support for Display List and Image type fields for Form2Content article import
  • Added Do not show CDATA field if export file is not an XML file
  • Added Show XML layout tab only when export type is XML
  • Added User view access level import and export
  • Added a check to make sure the product_type is set on HikaShop product import
  • Changed loading the CSS file for HTML exports
  • Added Custom Fields for All support for product_attribute field on VirtueMart order export
  • Added option to use existing rules on template restore
  • Added option to cache SEF URLs on export where SEF URLs can be exported
  • Changed when restoring a template of the CSVI Custom Table type to index the available fields
  • Fixed error for JFolder when selecting component in edit template page
  • Added product_name as available field to VirtueMart Price export
  • Added product_name as available field to HikaShop Price export
  • Added category_path of parent is exported if child has none set
  • Added category filter for VirtueMart price export
  • Fixed JFile not found on import
  • Fixed language files are not copied when installing HikaShop CSVI Export plugin
  • Added maintenance task to load SEF URL cache
  • Fixed cron job to work when PHP runs in CGI mode
  • Fixed category translation not processing for parent categories in VirtueMart Category import
  • Added category filter in HikaShop Price export
  • Added extra price fields on the VirtueMart Price export
  • Added new field product_discontinued for VirtueMart Product import
  • Added NULL check for VirtueMart price checking
  • Added check if CSVI addon is the same version as CSV Improved itself
  • Fixed View not found error when opening dashboard
  • Fixed conflict when importing related_categories and related_products together in VirtueMart Product import
  • Fixed incorrect value for published field in Joomla! Menus import
  • Fixed HikaShop user not added when Joomla! user already existed
  • Fixed possible error on post processing related categories in VirtueMart Product import
  • Fixed product status default values applied to existing products in VirtueMart Product import
  • Added price_quantity_start and price_quantity_end to VirtueMart Product export
  • Fixed child products no longer inheriting prices in VirtueMart product 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.0.2 released

23 January 2017
in News

New release CSVI Pro 7.0.2

After the release of CSVI Pro 7 we are now at the second bugfix release. A few issues were discovered that we wanted to fix and release, mainly the cron import becoming slow. That has been fixed in this release and the cron import is back to it's normal self. There are no new features in this release, those will come in a future release.

The issues fixed in this release are:

  • Added missing language strings on HikaShop order export
  • Fixed cron import very slow
  • Fixed notices on VirtueMart Google export
  • Fixed Class 'JFolder' not found on import from server using folder
  • Fixed Target currency not used on VirtueMart Google Merchant export
  • Fixed wrong folder name in error message when using Load from server

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.0.1 released

11 January 2017
in News

New release CSVI Pro 7.0.1


Last week we released major version 7 of CSVI Pro. This was a great step forward with a lot of nifty features. Despite all our testing, bugs unfortunately emerged after release day. Over the past week we have been fixing these bugs and have now made available this bugfix release. There are no new features in this release, those will come in a future release.


The issues fixed in this release are:


  • Fixed generating image names on HikaShop product import
  • Fixed notice virtuemart_order_id on VirtueMart order export
  • Fixed price calculating on VirtueMart Google export
  • Fixed front-end export always deleting export file
  • Fixed stock levels applied on VirtueMart product export and HikaShop product export
  • Fixed language strings not available
  • Fixed Do not show update message when maintenance operation runs
  • Fixed cache folder not cleared on uninstall
  • Fixed display of XML output on front-end
  • Fixed export of output to download deleting file before save on server is called
  • Fixed missing filename extension when creating local filename
  • Fixed records not being shown due to Skip plugin in preview
  • Fixed wrong area name on optimize tables
  • Fixed fatal error when checking file path in source tab
  • Changed stock level filters on VirtueMart Google export
  • Fixed field mapper not always able to save due to invalid characters
  • Fixed CLI not able to open logdetails.php file
  • Fixed backup and restore of templates with multi-replace plugin
  • Fixed error on VirtueMart Google export when category published was set
  • Fixed notice when processing VirtueMart multi-variant fields

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 released

04 January 2017
in News

New release CSVI Pro 7

A new year, a new release. Over the course of the last 6 months we have been working hard to bring you a new release of CSVI with not only bugfixes but also a whole bunch of new features. This release is a first step towards a more independent CSVI Pro. The extra framework we used in the previous releases has been discontinued and CSVI is now completely Joomla! native code.

HikaShop support

As announced in the past, we continue to improve support for HikaShop. This release is no different, we added more support for HikaShop options in the import and export areas. The biggest change is most likely the order import which now makes it possible to import orders and order products into HikaShop.

Form2Content

A complete new extension that we support is Form2Content. Form2Content allows you to add content in a form based field where you control all the form elements and the look and feel. We have build 3 imports and 3 exports, this allows you to fully import and export all needed data to manage your Form2Content forms, fields and content. We have created tutorials for Form2Content as well for all these imports and exports.

Example templates

Example templates are now available for all supported extensions. You can install the example templates in CSVI from the Maintenance menu.

  1. Go to Maintenance
  2. Select CSVI Pro
  3. Select Example Templates
  4. Click on Continue

Multi-replace rule

As of PHP 7.0 it is no longer possible to use PHP functions in a regular expression. This is something many people make use of within the replace plugin. To make it possible to still have the same kind of actions available we developed the multi-replace plugin. This plugin can do what the old replace plugin did but more. What the multi-replace plugin can do is to chain operations, so you can say first do A then do B and finally do C. There is a list of operations available in the multi-replace plugin and if you want to have more operations added, let us know.

The old replace plugin will no longer shipped as of CSVI 7.0 however it will remain on existing installations and can still be used. This way you can setup any new rules using the new multi-replace and gradually move out the old replace plugin.

 

This release features a number of notable changes. These added features are:

  • Made CSS and JS files versioned
  • Removed FOF dependencies
  • Removed update of available fields during installation
  • Switch to HTTPS links for ICEcat XML files
  • Updated New SEF URL generation
  • Use Joomla database driver for export queries
  • Added a check if HikaShop image already exists or not
  • Added Awocoupon example templates
  • Added category separator option in HikaShop category import
  • Added category separator option to HikaShop product import
  • Added check if available fields need updating
  • Added check if folder or file exists for load from server option
  • Added CSS file exporttable.css to HTML output to allow styling
  • Added Custom Filters example templates
  • Added Fastseller example templates
  • Added Form2Content article import and export
  • Added Form2Content content type fields import and export
  • Added Form2Content content type import and export
  • Added HikaShop example templates
  • Added HikaShop order import
  • Added HikaShop order product import
  • Added Import based on field for Custom import
  • Added import from external database
  • Added Joomla Menu example templates
  • Added Joomla User example templates
  • Added make combining of XML nodes more flexible
  • Added make downloading of PDF files from ICEcat optional
  • Added media fields for VirtueMart category and manufacturer export
  • Added multiple shopper group name for VirtueMart user info import
  • Added multi-replacement plugin replaces the replace plugin
  • Added option to export to database
  • Added option to import data from text field
  • Added option to what to do with empty files on export
  • Added Product Builder example templates
  • Added retrieve parent manufacturer for child on VirtueMart Google export
  • Added RSForm! Pro example template
  • Added Show variants product category in HikaShop order export filter
  • Added Showing friendly message for duplicate SKUs in VirtueMart product import
  • Added Skip rule plugin
  • Added Stockable custom fields for using parent product as derived product
  • Added VirtueMart example templates
  • Added VirtueMart maintenance option to check for duplicate SKUs
  • Added zone fields to HikaShop order export

The issues fixed in this release are:

  • Fixed auto-generating product images on VirtueMart product import
  • Fixed CDATA setting for manufacturer and product url on Google export
  • Fixed Custom override and disabler fields not updating in VirtueMart product import
  • Fixed exported URL missing slash in case of non-SEF URL
  • Fixed exports not using UTC timestamp for comparing dates
  • Fixed Fix Menu method missing
  • Fixed full_name empty if shipping address is empty on VirtueMart order export
  • Fixed get products with 0 stock using stock filter option on VirtueMart product export
  • Fixed getting category ID for Joomla! content
  • Fixed HikaShop importing empty categories
  • Fixed image path duplicate check in VirtueMart manufacturer import
  • Fixed Import available fields are shown on export
  • Fixed incorrect error message when virtuemart_product_id and order_item_sku are both used in VirtueMart order item import
  • Fixed invalid arguments error on update available fields
  • Fixed invalid SQL query on HikaShop order export
  • Fixed Joomla! category import wrong structure
  • Fixed Joomla! content import duplicating records
  • Fixed logger not available on cron export
  • Fixed Make the temporary folder name more unique
  • Fixed Manufacturer category id not assigned to manufacturer in VirtueMart manufacturer import
  • Fixed missing fields in VirtueMart order import
  • Fixed Moved name field from userinfos to user table on VirtueMart userinfo export
  • Fixed notice error fixes for lastrun when there are no templates
  • Fixed override file for available fields
  • Fixed override routine in front-end export and cli
  • Fixed path to thumb images for manufacturer takes wrong path on VirtueMart manufacturer import
  • Fixed possible notice on price styling in VirtueMart Advanced order export
  • Fixed product currency not being used on HikaShop product import
  • Fixed sale_start and sale_end dates on HikaShop product import
  • Fixed the Enter key not being able to use
  • Fixed the onAfterImport is not being triggered in cron mode
  • Fixed translate media id to file_url on export
  • Fixed undefined notice for missing shipmentmethod ID in VirtueMart Advanced order export
  • Fixed undefined notice when source is not set
  • Fixed Virtuemart category filter not exporting child products
  • Fixed VirtueMart not processing HTML in product name in VirtueMart product import
  • Fixed VirtueMart product categories not showing if no languages are set in VirtueMart
  • Fixed wait time between imports not working
  • Fixed Yandex export issues

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 release CSVI Pro 6.6.4

Continuing on the path of further stabilizing CSVI, we have released version 6.6.4 which fixes a few more issues that have been found.

The issues fixed in this release are:

  • Fine-tune VirtueMart Google Merchant export
  • Fixed VirtueMart Product import not setting thumbnail in some cases
  • Fixed thumbnail not being set in VirtueMart Product import
  • Fixed category name and path not matching error in VirtueMart Category import
  • Fixed Product override price getting updated when its empty in VirtueMart Product import
  • Fixed multi-variants warnings on VirtueMart Product export
  • Fixed VirtueMart Order export not exporting product_attribute values
  • Fixed FTP trying to login twice
  • Fixed SEF URLs containing helper/ in the URL
  • Fixed timestamp in logs not showing local date and time
  • Fixed storing of end timestamp being the same as start timestamp

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 3

More products by RolandD

RolandD Cyber Produksi

RCP User helps you to maintain a clean userlist by automatically deleting stale user accounts. Never logged-in user accounts are deleted automatically, old user accounts are deleted after a give time, bounce handling, white-listing user accounts you never want deleted. Customize reminder emails that are send out to users. Connected to other extensions to not delete accounts that have a forum post or order placed on your site. RCP User runs automatically via cron-job.

Go to RCP User