Resolved CSVI 6 vm 3 .csv field OK make template Wrong

Hello,

So when I remove the empty fields the list looks like the one I have created in the field mapper. But when I try again there are entry's missing.

Go to the Template fields page and make sure there are as many fields as you have columns in your CSV file and in the same order as the columns in your CSV file. If you run the import in that case, do you see all the columns in the preview?

Hi Roland,

When I look in the field mapper there were a few blank entrys. I have found out that in the headers (csv file) that when there is a space or '/' in the header -> the system does not read it well. Perhaps of the Text Enclosure.


When I go to the analyser -> the file is ok

When I upload a file -> preview -> there are still files missing for instance: article_number. I will try to make a new csv file.

In the meantime I also have a problem when export the product: with a 500 error
this is the server error:

Fatal error: Cannot use object of type stdClass as array in C:\wamp\www\dlw_fietsen\administrator\components\com_csvi\addon\com_virtuemart\model\export\product.php on line 441

[23-Sep-2015 15:22:04 Europe/Paris] PHP Stack trace:

[23-Sep-2015 15:22:04 Europe/Paris] PHP 1. {main}() C:\wamp\www\dlw_fietsen\administrator\index.php:0

[23-Sep-2015 15:22:04 Europe/Paris] PHP 2. JApplicationCms->execute() C:\wamp\www\dlw_fietsen\administrator\index.php:47

[23-Sep-2015 15:22:04 Europe/Paris] PHP 3. JApplicationAdministrator->doExecute() C:\wamp\www\dlw_fietsen\libraries\cms\application\cms.php:252

[23-Sep-2015 15:22:04 Europe/Paris] PHP 4. JApplicationAdministrator->dispatch() C:\wamp\www\dlw_fietsen\libraries\cms\application\administrator.php:152

[23-Sep-2015 15:22:04 Europe/Paris] PHP 5. JComponentHelper::renderComponent() C:\wamp\www\dlw_fietsen\libraries\cms\application\administrator.php:98

[23-Sep-2015 15:22:04 Europe/Paris] PHP 6. JComponentHelper::executeComponent() C:\wamp\www\dlw_fietsen\libraries\cms\component\helper.php:372

[23-Sep-2015 15:22:04 Europe/Paris] PHP 7. require_once() C:\wamp\www\dlw_fietsen\libraries\cms\component\helper.php:392

[23-Sep-2015 15:22:04 Europe/Paris] PHP 8. FOFDispatcher->dispatch() C:\wamp\www\dlw_fietsen\administrator\components\com_csvi\csvi.php:90

[23-Sep-2015 15:22:04 Europe/Paris] PHP 9. CsviControllerExport->execute() C:\wamp\www\dlw_fietsen\libraries\fof\dispatcher\dispatcher.php:326

[23-Sep-2015 15:22:04 Europe/Paris] PHP 10. CsviControllerDefault->execute() C:\wamp\www\dlw_fietsen\administrator\components\com_csvi\controllers\exports.php:41

[23-Sep-2015 15:22:04 Europe/Paris] PHP 11. FOFController->execute() C:\wamp\www\dlw_fietsen\administrator\components\com_csvi\controllers\default.php:50

[23-Sep-2015 15:22:04 Europe/Paris] PHP 12. CsviControllerExport->export() C:\wamp\www\dlw_fietsen\libraries\fof\controller\controller.php:960

[23-Sep-2015 15:22:04 Europe/Paris] PHP 13. CsviModelExports->runExport() C:\wamp\www\dlw_fietsen\administrator\components\com_csvi\controllers\exports.php:165

[23-Sep-2015 15:22:04 Europe/Paris] PHP 14. Com_VirtuemartModelExportProduct->exportBody() C:\wamp\www\dlw_fietsen\administrator\components\com_csvi\models\exports.php:316

Hello,

I have found out that in the headers (csv file) that when there is a space or '/' in the header -> the system does not read it well. Perhaps of the Text Enclosure.

It is always a good idea to use text enclosures, this way you are sure the headers can be read correctly.

When I go to the analyser -> the file is ok

The analyzer does not check for valid fieldnames, just checks if the file is readable.

When I upload a file -> preview -> there are still files missing for instance: article_number. I will try to make a new csv file.

The field article_number is not a CSVI known field, this would be product_sku I guess.

In the meantime I also have a problem when export the product: with a 500 error

Please make a new thread for this as it is a different issue. Include also your export settings.

Hi,

After a lot of testing I have found out that the error 500 has to do with delimiters. OK

I think I'm almost there: I have made a new csv file with " as enclosure. and ; als delimiter .. OK
Create a new fieldmapper with 15 fields for the test.
The analyser goes correct -> Also gave every field name a unique and underscored name OK
The field mapper has the process of value of virtuemart-> product OK

When I upload the template it shows me:

The These fields have been found but are not supported by CSVI:

EAN_UPC
fmamilie
Model
Primaire_basiskleur
Secundaire_basiskleur
Netto_gewicht
prijs
Korte_omschrijving
langeomschrijving

The other fields are imported correctly

I have double checked the virtuemart -> product in the template so it is not pointing to a wrong template file.

Please advise

Hello,

The These fields have been found but are not supported by CSVI:

That is to be expected as these are definitely not fields in a default installation. They are custom named fields, for example langeomschrijving would be product_desc to get it into the product description. Did you map those fields correctly? How did you map these fields?

Something is incorrect in your field setup unless these are all custom fields you created yourself in VirtueMart. In that case you will need to update the available fields in CSVI. So CSVI knows you have custom fields.