Resolved Not saving the mapping

Hello Davide,
Can you check if you see any error in Javascript console? You can use Firebug to analyse your problem and post the screenshot on what you see in firebug console.

Hi,

thank you for your prompt answer.

I'm attaching the screenshots.

Thanks,
Davide

Hello,
Can you also post a screenshot of how you are mapping your fields in field mapper? And also post the full screenshot of firebug console. It would also be of great help if you can post a sample file to check.

Sure, here's the files in attachment.

Hello,
I tested field mapper with your file with same settings here and it went fine, there is nothing wrong i could see from your file except that ; at the end of each record. If there is no more fields you can remove it from the end of each rows. Please try to create a new field mapper template after that and let me know how it goes.

Hello,

just tested, but I have the same problem, anything is saved...

I'm going crazy!

Hello,
Can you send a private message of your Joomla administrator login details? I will check in your site directly.

PM 4 you.

Thanks,
Davide

Hello Davide,
Thank you so much for sending the details. I checked your site for field mapper, there is actually no error in your field mapper and not even javascript error, the field mapper says its been saved. Can you go to your phpmyadmin>> select your database >> Look for table #__csvi_maps and #__csvi_mapheaders and see if you have rows in these tables?

Hi,
Just checked and they are present.

How can I see them in the control panel?


Thanks a lot,
Davide

Hello Davide,
If you see them in database then field mapper functionality has worked good. I am thinking if this could be something to do with your site cache. Can you try to clear the cache and check?

Just tested, but it's not a cache problem..

Hello,
Is this a problem only with field mapper page? how about other pages? Can you test the templates page by creating a new template and check if you see it in the templates list?

Hello,

Only for the field mapping.

Hello,
Can you send me mysql database dump of your field mapper tables? The tables are #__csvi_maps and #__csvi_mapheaders. Please post it as a private message or email it to tharuna@csvimproved.com.

Hi,

thank you much, email sent.

Waiting for you,
Davide

Hello,
Thank you so much for sending the mysql dump, it really helped. I could see that three fields in #__csvi_maps table are missing in the sql dump file you sent. Not sure how it has gone missing. Can you go to your phpmyadmin and delete the tables #__csvi_maps and #__csvi_mapheaders? Then run the below query by pasting it on SQL tab in your phpmyadmin so new tables are created. You can then try to do a fresh field mapping of fields and see if it works.

DROP TABLE IF EXISTS `sr16_csvi_mapheaders` ;

CREATE TABLE IF NOT EXISTS `sr16_csvi_mapheaders` (

	`id` INT(10) NOT NULL AUTO_INCREMENT,

	`map_id` INT(10) NOT NULL,

	`csvheader` VARCHAR(100) NOT NULL,

	`templateheader` VARCHAR(100) NOT NULL,

	PRIMARY KEY (`id`)

) CHARSET=utf8 COMMENT='Holds map field mapping';



DROP TABLE IF EXISTS `sr16_csvi_maps` ;

CREATE TABLE IF NOT EXISTS `sr16_csvi_maps` (

  `csvi_map_id` INT(10) NOT NULL AUTO_INCREMENT,

  `title` VARCHAR(100) NULL DEFAULT NULL,

  `mapfile` VARCHAR(100) NULL DEFAULT NULL,

  `action` VARCHAR(100) NULL DEFAULT NULL,

  `component` VARCHAR(100) NULL DEFAULT NULL,

  `operation` VARCHAR(100) NULL DEFAULT NULL,

  `auto_detect_delimiters` TINYINT(1) UNSIGNED NULL DEFAULT '1',

  `field_delimiter` VARCHAR(1) NULL DEFAULT ',',

  `text_enclosure` VARCHAR(1) NULL DEFAULT '"',

  `locked_by` INT(10) NULL DEFAULT NULL,

  `locked_on` DATETIME NULL DEFAULT NULL,

	PRIMARY KEY (`csvi_map_id`)

) CHARSET=utf8 COMMENT='Holds map configurations';

Thank you very much Tharuna, just did it and it works.

Last question
I need to update price and quantity, do I need to do 2 template and 2 jobs or there is any way to do more simply?


Thanks a lot for your support!
Davide

Hello,

I need to update price and quantity, do I need to do 2 template and 2 jobs or there is any way to do more simply?

Are you looking for updating price minimum and maximum quantity? In that case you can use price template to update both price and quantity, for quantity use fields price_quantity_start and price_quantity_end. You can have a look at import VirtueMart price documentation to know on this.

Yes, I know this, but my request is different.

I need to update the price and the quantity (availability of the product).

Do I need 2 templates or can I do it with only one?


Thanks,
Davide