PotzUK

Capita Financial Software, a leading financial services software company is looking for a FileMaker Developer to work from their headquarters in Bishop's Stortford, or from their new offices in the Fareham area. The successful candidate will have strong FileMaker development skills preferably gained in a commercial product development environment. Excellent analysis, database and GUI design skills are essential, as well as the ability to communicate and build relationships with our customers. Knowledge of financial services and/or IFA business processes would be a bonus but not essential. For more information about the position, please contact me via PM or by email at tony.pottrell [at] capita.co.uk Many thanks! Tony

Just thought I'd add to my post above, that I've found a free way to generate a GUID in Filemaker. You'll need Visual Studio Express edition (Or similar) for this. Download and install the DotNet2FM plugin from: http://www.dotnet2fm.com/ (A donation to the author would probably be appreciated). Follow the instructions/tutorials for the plugin to create a new class library function that returns (The code has been butchered a bit by me in Notepad to remove unrelated code, so apologies for the wrapping) : using System; using System.Collections.Generic; using System.Text; using System.IO; using System.Xml; using DotNet2FMInterface; using System.Net; namespace fmConnector { public class fm : IPlugin { public fm() { } public string PluginID { get { return "fmConnector"; } } public short MethodBase { get { return 10000; } } public bool CanIdle { get { return false; } } public bool CanPreferences { get { return false; } } public void Init(IEnvironment environment) { } public void Shutdown(IEnvironment environment) { } public void Idle(IEnvironment environment) { } public void Preferences() { } public enum Methods { GUID, MethodCount } public short MethodCount { get { return (short)Methods.MethodCount; } } public IMethodInfo GetMethodInfo(short nMethodIndex) { switch ((Methods)nMethodIndex) { case Methods.GUID: return new MethodInfo("GUID", "GUID()", 1, 1, MethodFlags.MayEvaluateOnServer | MethodFlags.DisplayInAllDialogs); } return null; } public bool InvokeMethod(short nMethodIndex, IEnvironment environment, IDataVector parms, IData result) { switch ((Methods)nMethodIndex) { case Methods.GUID: return Guid(parms[0], result); } return false; } // Guid Method private bool Guid(IData name, IData result) { result.AsText = System.Guid.NewGuid().ToString(); return true; } } } Compile the library and drop the DLL into the FilemakerDotNet2FM Plugins folder. You should now see the function available in Filemaker that will return a GUID :

Well it was a given that you close Filemaker, duplicate the strings file and rename the copy to .fp7, edit the fp7, close Filemaker and then swap the files around...

That's why I suggested he make a backup of it, in case it got chewed. As per http://fmforums.com/forum/showtopic.php?tid/192705/post/278957/hl/FMStrs.dls/fromsearch/1/#278957

Make a backup of the FMStrs.dls file in your ExtensionsEnglish folder and rename it FMStrs.fp7 The file is a list of all the strings/calculation names used in Filemaker... I'm sure one of them controls the text displayed on various dialog boxes.

Actually the OP said he was adding the password to the database table but also adding the user to the database accounts as well, and that in doing so he'd managed to lock himself out of the file.

The password is in the database FILE (as in within the file itself, not as a record in the database), obviously hashed/encrypted in some way. No system is completely hack/crack/foolproof, it stands to reason that the authors of the tool have been able to reverse engineer Filemaker's password storage system and reveal or otherwise overwrite the password. I suspect the former, as I've used the tool previously and confirmed that it does indeed retrieve the password I set.

Surely the password must be stored in the Filemaker database, where else could the password be? It stands to reason that the (Presumably Passware) tool is able to decrypt the password data in the fp7?

Tooltip

I think it's new, as the FM11 installer prompts to install the same package if it's not ready installed...

I had to disable the windows firewall and reboot to get mine to work...

The yellow blob (Think it's a magnifying glass) has something to do with the quick search I think

It is possible to do this... 1. Give the tabs a space character for a name then specify a tab width in the tab control editor 2. Create a calculated field that does what you want (e.g. If( Type = "House" ; "House" ; "Flat" ) ) 3. Add the field to the layout as a merge field, and align so that it sits roughly where the normal tab would. Then increase the height of the merge field so that it's top handles are outside of the tab control, this ensures it is visible from all tabs.

The KB is sound, however until they make the performance of RLA usable I doubt many people will actually use it, it's just too slow (particularly over relationships). Sure, it works great on small systems but typically owners of smaller systems aren't as worried about security. It's the larger companies who run larger systems that have written policies that tend to be the people that need RLA.

I've not tried it, but you could try creating a calc field using the GetAsCSS( [YOURFIELD] ) then using that field with the PHP API.