1. marekpipe
  2. RO CSVI
  3. Monday, 09 January 2017
  4.  Subscribe via email
Hi,

have a problem in 6.6.4 and now also with 7.0 on my joomla 3.6.5 Page :

When i use your Field mapper everything works until i choose the import file and the box on the right side is shown with the fieldmapping to choose. From this point i am not able to press Save oder save and exit , or save and new only exit button works...
As long as no file is loaded the button work ....
What could be the problem ?

PS : I found out that it must be something with the number of columns my csv has.... mine has about 120 columns .. all are displayed it the field mapper but save button does not work anymore. When i use the same template with about 40 columns everything is fine
Accepted Answer Pending Moderation
Hello,
You have not posted us your sample import file to see what is in your field columns. You can check your page on firebug console and see if you get any javascript error on save. There has been a known issue that save doesn't work when there is a "." in field names and it has been discussed in the thread here. If that is not the cause of your problem then post the screenshot of firebug console along with your file to check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi. Here is the file i used... i get no error message, only the buttons are not working...
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Your columns headers have a lot of spaces in them and characters too. There is an javascript error shown in firebug with your file. Try cleaning your column headers and then field mapper should work.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,

Attached is a patch file that you can load. After that the field mapper buttons will keep working, even with your file.
Attachments (1)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,

Attached is a patch file that you can load. After that the field mapper buttons will keep working, even with your file.


Still something wrong here ... When i use your file and save the field mapper (what works now) i press Create template ... that works ... when i try to run the import with this template i get an :

Unknown column 'f.source_field' in 'field list' SQL=SELECT `f`.`csvi_templatefield_id`,`f`.`field_name`,`f`.`source_field`,`f`.`xml_node`,`f`.`default_value`,`f`.`sort`,`f`.`ordering` FROM `#__csvi_templatefields` AS `f` WHERE `f`.`csvi_template_id` = 18 ORDER BY `f`.`ordering`

When i create an template by my own and start running an import i get :
An error has occured during the import. Below the information received from the server.
Status error: 403
Status message: Forbidden
Forbidden
You don't have permission to access /administrator/components/com_csvi/rantai/rantai.php on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
Unknown column 'f.source_field' in 'field list' SQL=SELECT `f`.`csvi_templatefield_id`,`f`.`field_name`,`f`.`source_field`,`f`.`xml_node`,`f`.`default_value`,`f`.`sort`,`f`.`ordering` FROM `#__csvi_templatefields` AS `f` WHERE `f`.`csvi_template_id` = 18 ORDER BY `f`.`ordering`

The field source_field is a new field which was introduced in CSVI 7 and that seems to be missing in your template fields table. I think something has gone wrong with your CSVI 7 update. If you know how to do then go to PHPMyAdmin, Select your database and then run the below query. Don't forget to replace #_ with your table prefix. See if the error goes after that.

ALTER TABLE `#__csvi_templatefields`
ADD COLUMN `source_field` VARCHAR(255) NOT NULL COMMENT 'Field name of the source table' AFTER `xml_node`;


When i create an template by my own and start running an import i get :
An error has occured during the import. Below the information received from the server.
Status error: 403
Status message: Forbidden
Forbidden
You don't have permission to access /administrator/components/com_csvi/rantai/rantai.php on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

Something is blocking CSVI, can be because of security plugins like Admin tools or may be your htaccess file. Please check these and give access to CSVI.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
Unknown column 'f.source_field' in 'field list' SQL=SELECT `f`.`csvi_templatefield_id`,`f`.`field_name`,`f`.`source_field`,`f`.`xml_node`,`f`.`default_value`,`f`.`sort`,`f`.`ordering` FROM `#__csvi_templatefields` AS `f` WHERE `f`.`csvi_template_id` = 18 ORDER BY `f`.`ordering`

The field source_field is a new field which was introduced in CSVI 7 and that seems to be missing in your template fields table. I think something has gone wrong with your CSVI 7 update. If you know how to do then go to PHPMyAdmin, Select your database and then run the below query. Don't forget to replace #_ with your table prefix. See if the error goes after that.

ALTER TABLE `#__csvi_templatefields`
ADD COLUMN `source_field` VARCHAR(255) NOT NULL COMMENT 'Field name of the source table' AFTER `xml_node`;


When i create an template by my own and start running an import i get :
An error has occured during the import. Below the information received from the server.
Status error: 403
Status message: Forbidden
Forbidden
You don't have permission to access /administrator/components/com_csvi/rantai/rantai.php on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

Something is blocking CSVI, can be because of security plugins like Admin tools or may be your htaccess file. Please check these and give access to CSVI.


Works ! THank you
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!