News

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.

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.

Page 1 of 4

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