Has anyone had any experiance in crating an Joomla account with FileMaker via ESS, I have the conection to the Joomla Database. I just need to be able to create an account that will sent the client an email and their login details.
I've done it with wordpress before, the tricky part is usually encrypting the password in filemaker when writing to the ESS table.
This article loosely covers the process for Joomla user additions via MySQL:
You can use either ScriptMaster or SmartPill for filemaker to encrypt the passwords, there might be some web viewer methods as well to return an encrypted password.
Of course, you should consider how much this will be used before you get into this, it might just be easier to set up a joomla registration page in a webviewer from filemaker, then scrape the webviewer or pull the ESS into filemaker after the user registers.
Looked at link, it is a little help although I dont think I need to create an password as Joomla has the feature to auto create one and send details to user. I was more concerned with the ACL factor, I will build a development Joomla Site and play with it. If I get it working I will post sample file without datbase credentials.
Just an update on creating a Joomla account with FileMaker.
Joomla passwords are created by MD5+$salt which I have not been able to create with FileMaker, although I have found a site that can create Joomla passwords (http://www.w3studio.nl/md5/index_english.html). So I create several passwords which is randomly picked when I create account. I send email to user with login details and use a Joomla extension forcing a password change on first login
Not the most elegant solution but it works for the time being.
If you're familiar with Java at all, you can do salted hashing with ScriptMaster from 360works. They have a plug-in compiler so you could make your own hashing plug-in to deploy to your filemaker users.
I did this with a similar user-creation web app that was PHP/MySQL driven. I'm not sure the hashes were salted, but I DID use ScriptMaster.
PS - I would highly recommend Sterling Rouse at 360works if you have any budget for outside assistance, he knows his stuff, especially in/around Java/ScriptMaster.
Have been looking at ScriptMaster and still learning Java. My budget is very thin at the moment, but will have to consider outside assistance in near future.
Our BaseElements plugin can do MD5 hashing : https://github.com/nickorr/BaseElements-Plugin/wiki/Functions#wiki-BE_MessageDigest
Retrieving data ...