Mapping Data Sources - Quotes() issue?

Words of praise first.

Joomdle has been a lifesaver. It's the most completely developed solution for integrating Moodle with a CMS that I've run across. It's easy to use, feature rich, and it works (At least for me).

So thank you, Joomdle creators, contributors, and community for all your work.

Okay, that said, I'm running into a little problem with the data mapping utility. I'm running Moodle 2.x, Joomla 2.5, and Joomdle 0.81. I've also installed the ELIS add-ons for Moodle. In order for users to be added to the ELIS platform, their profiles are required to include a first and last name, a city, and a country. When I add users through Joomla, they are being created in Moodle, but the city and country fields are given quotation marks before going into the database. So when I create a user and go into Moodle to view their profile, the city and country fields look like this (for example):

City: "Houghton"
Country: "U

The first and last name are displaying correctly, but these two are getting quotes, and my two-letter country code is being cut off. So my users aren't automatically being added to the ELIS system.

If I could just get the two letter code to insert correctly, my users would be added to ELIS and I would be sailing smoothly. I was looking at the mappings.php file in the administrator/components/com_joomdle/helpers folder, and I think my problem lies in the Quotes() function. But I'm not sure.

Am I on the right track?

Thanks in advance for any advice.

*****************edit***********************
I just realized I posted this in the wrong section. Could this be moved to support please? Sorry 'bout that.

You don't say which moodle, joomdle and joomla you are running on.

I just double checked my moodle tables to ensure the country and country code details are coming across correctly without quotes and they are.

Also, we have never tried with the ELIS add-on. If you wish to send to development@joomdle.com we can quickly load up to see if there are any conflicts.

Hi!
Did you solve the quotes issue?
I'm having the same problem.
Joomla 2.5.6
Moodle 2.0.9
Joomdle 0.82

I tried to map different 1.6+ User profile fields (e.g. postal code, website) with Moodle's ID Number and other fields. All mapped values are put into quotation marks in Moodle.

Thank you very much in advance!

I don't know why you get this behaviour, as this is working fine for most people (I use J1.6 profiles in some sites, and they all work fine)
No idea what may be causing your problem...

Hi Chris

Did You find a solution, I'm having the exact same Issue, running:
Joomla 2.5.8
Moodle 2.4+
Joomdle 0.9

For me it seems to start when my hoster moved to Windows 2012 servers, but I'm not sure.
What I canfigure out is that:
Joomla stores the values (Address City aso) in the db with Quotes t.ex: "25 Wallstreet", but Moodle stores without quotes.
When updating userprofile in Joomla it seems that Joomdle stores the exact same values in the Moodle-db, so it comes in Moodle with quotes.

Usernames are stored in Joomla without the Quotes, hence no problem here.

By the way a very happy NewYear !!!

What extension are you using for the address, city details?

Hi the other Chris

I'm not sure what You mean with extension for Address, City ?

Please specify.

Thanks in Advance

The Joomla registration by default only collects name, username and email. Therefore when Joomdle creates the Moodle account it can only transfer / syncronise those three fields. Yet Moodle wants more. Thus the question must be asked where does the additional information come from? Most people will use a user profile extension such as CB, Jomsocial, VM, Hikashop, etc. or with Joomla 2.5, Joomla additional user fields. Only when you have 'something' can the user enter the information. Only when the data exists can Joomdle transfer if to Moodle. Only then will Moodle allow you to pass by that screen. End of the date, the data is required in Moodle, so you must enter it somewhere.

Sorry, I understand now.

Is entered in Joomla 2.5