Kevin Frank | 26 Apr 02:39 2015

[FileMaker Hacks] FM 13 Anti-deduping, part 3

Hey Folks,

http://filemakerhacks.com/2015/04/25/fm-13-anti-deduping-part-3/

Mind expanding demos from Malcolm Fitzgerald and Ralph Learmont showing 
blazingly fast ways to get ! searches to work within found sets.

Enjoy,
Kevin

---------------------------------------------------
Kevin Frank & Associates
kfrank@...
www.kevinfrank.com
707-822-6414
---------------------------------------------------
FileMaker 7/8/9/10/11/12/13 Certified Developer
---------------------------------------------------
blog: www.filemakerhacks.com
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

Keith M. Rettig | 26 Apr 00:23 2015

Safe development strategies

Was working on our production database on FMS 13v9 yesterday.  Trying to clean up a layout to make it as fast
possible for web and FMPadv.  So I deleted a few fields from the layout.
Get a call today, “hey your search engine isn’t finding any locations near my zip code”.  Whoops!
Few minutes later with fields back on layout, search function works.

How am I suppose to do incremental development on a test copy and efficiently carry forth the final fixes to
the production server?
For our kiosks, I have a data file and an interface file and the data layer changes rarely and very little data
is stored at the kiosks.  But for the server, there is no need for an interface layer (I am the only one using it).
Regardless most of the changes are to the data layer itself and the server has millions of records (so I
can’t possible switch files and copy the records over).

Remembering every field change, calculation improvement, script fix, let alone new fields, scripts,
etc. and then repeating them on the production server just seems a horrific strategy.
And what if I work on it over a few days before I am happy?  I won’t possible remember what I did.

Just being careful works most of the time…
What’s the strategy I am supposed to be using?

Keith.
_______________________________________________
FMPexperts mailing list
FMPexperts <at> lists.ironclad.net.au
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
John P | 25 Apr 22:03 2015
Picon

Re: Forcing a user out of FMS 13

For what it’s worth to folks, obtained after running “fmsadmin help” from Terminal:

Description: 
    fmsadmin is the command line tool to administer the Database Server  component of FileMaker Server
installed on the local machine.

    You can script many tasks with fmsadmin by using a scripting language 
    that allows execution of shell or terminal commands.

    fmsadmin HELP COMMANDS
       Lists available commands

    fmsadmin HELP [COMMAND]
       Displays help on the specified COMMAND

    fmsadmin HELP OPTIONS
       Lists available options

Also see "Command line reference" in FileMaker Server Help:
    https://localhost:16000/help/en <https://localhost:16000/help/en>

obtained after running “fmsadmin help commands” from Terminal:

fmsadmin commands are:

    AUTORESTART     Get or set auto-restart for the Admin Server 
    BACKUP          Back up databases
    CLEARKEY        Removes saved database encryption passwords
    CLOSE           Close databases
    CERTIFICATE     Manage SSL certificates
(Continue reading)

Christopher Bailey | 25 Apr 20:04 2015

Forcing a user out of FMS 13

I've definitely seen "ghost" users, with no way to kick them out.  It
usually happens in conjunction with performance issues, i.e., someone got a
"spinning wheel of death" and force quit,  but the server still sees them
connected.  In at least some of the cases I've seen, it's ended up in an
overall freeze-crash of the server for all users.

Observing the action via the Client Stats sub-tab in the admin console has
sometimes proven useful.  In fact on heavy-usage servers/systems, I  leave
the "save client stats" checkbox on at all times during biz hours,  (at
night you can refresh the stats file since it builds up quickly), in case
you need to see what/who led to performance issues after they happen.

Chris
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

Bob Patin | 25 Apr 16:40 2015

Forcing a user out of FMS 13

FMS Server shows me logged on from one of my machines, where FMPA 13 isn't even running; numerous attempts to
disconnect myself have failed, and I need to close the database to put some data into a global.

Is my only option to restart FMS 13? I have a dozen or more users on there and can't do it...

Terminal command perhaps?

Bob Patin
Longterm Solutions
bob <at> longtermsolutions.com
615-333-6858
FileMaker 9, 10, 11, 12 & 13 Certified Developer
http://www.longtermsolutions.com
-
iChat: bobpatin <at> me.com
Twitter: bobpatin
—
FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

_______________________________________________
FMPexperts mailing list
FMPexperts <at> lists.ironclad.net.au
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Bob Patin | 25 Apr 15:32 2015

UUID string length

From what I can see in the database I'm developing, the string length of UUIDs generated using get ( UUID ) is
always 36 characters.

Is this true, or am I wrong to make that assumption?

Thanks,

Bob Patin
Longterm Solutions
bob <at> longtermsolutions.com
615-333-6858
FileMaker 9, 10, 11, 12 & 13 Certified Developer
http://www.longtermsolutions.com
-
iChat: bobpatin <at> me.com
Twitter: bobpatin
—
FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

_______________________________________________
FMPexperts mailing list
FMPexperts <at> lists.ironclad.net.au
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Daniel Weiss | 24 Apr 02:22 2015

XPOST: FileMaker IBM TAM Single Sign On Support


Anyone know if FileMaker can support IBM Tivoli Access Manager for single sign on ?

Daniel Weiss
Adatasol Custom Database Solutions
23810 East Baintree
Beachwood, OH 44122

Phone (440) 338-6874
Sales (800) 783-3346
www.adatasol.com <http://www.adatasol.com/>
AIM or SKYPE: adatasol

Interested In partnering with Adatasol?  Email us to schedule a free lunch now.

FileMaker Business Alliance Member

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

Bob Patin | 23 Apr 18:16 2015

NUMBER fields vs. TEXT fields

Am I correct in believing that a NUMBER field can have only 1 line in it?

Here’s why I’m asking: I have a client’s database where we have a NUMBER field that gets set by a
boolean checkbox—when you check it a 1 is put into the field; when you uncheck it, the 1 should disappear. 

I inadvertently had an auto-enter setting the field to 0 on record creation, so a new field had a zero; then if
they clicked the checkbox they’d have this:

0
1

 I thought that wasn’t possible in a NUMBER field (clearly not, Bob,  you’re seeing it…)?

Bob Patin
Longterm Solutions
bob <at> longtermsolutions.com
615-333-6858
FileMaker 9, 10, 11, 12 & 13 Certified Developer
http://www.longtermsolutions.com
-
iChat: bobpatin <at> me.com
Twitter: bobpatin
—
FileMaker Consulting 
FileMaker Hosting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

_______________________________________________
FMPexperts mailing list
FMPexperts <at> lists.ironclad.net.au
(Continue reading)

Fitzgerald, Theodore C | 22 Apr 22:05 2015
Picon

Custom Third Party SSL Certificate w/ FileMaker Server 13

Experts,

We are working through the steps to bring all of our FileMaker 13 servers to 13.0v9 but are running into a bit
of trouble with the custom SSL part.

A little background:

*         We have a process for requesting and obtaining SSL certificates through InCommon
(https://www.incommon.org/certificates).  This is our IT Security Office's preferred way to obtain
SSL certificates

*         Technically, Comodo issues the certs, but Comodo is nowhere to be found in the Certification Path of the
certs we get from InCommon (they are issued by InCommon RSA Server CA)

*         InCommon is not one of the vendors listed here http://help.filemaker.com/app/answers/detail/a_id/11413

Our IT Security Office and Windows Server Admins asked that we try the InCommon certificates to see if they
work.  I generated the certificate request using the "fmsadmin certificate create" command and gave the
CSR to our Windows server admins to request an SSL cert.  I am able to import one of the certs using the
"fmsadmin certificate import" command, however; after I do this no FileMaker clients are able to connect
to the server.  CWP and WebDirect are not able to connect to the databases.  When I use "Open Remote" to try and
view the databases on this server I am not able to see any databases.

The Admin console works fine and reports that all of the databases are "Normal".

I'm not seeing any errors in any of the logs.  I've restarted the servers, and have restarted the database
server /services several times with no change.

If I turn off SSL, or remove the serverCustom.pem file everything starts working again.

(Continue reading)

Stephen Wonfor | 22 Apr 02:39 2015
Picon

Filemaker and PyFilemaker

Hi

A client is using PyFilemaker (feels a bit unsupported of late) to wire their website into a Filemaker db. 
The server is FMS10Advanced.  They also have a server running FMS11.   The servers "chat" to each other - the
reason for the separation was IT insisting on separation and security.  So here we are.
We'd like to cut this down to a single server running FMS13.

What could go wrong?

Any notes from the field that could help us decide what to do?  Even though we all get along very well there is a
"code gap" - I can do all the Filemaker stuff while they speak in parseltongue as they do Python.  I find I am
not Harry Potter here.  The upgrade is inevitable - we just want to get a grip on the perils ahead.

Stephen

---

"It's like someone took a transcript of a couple arguing at IKEA and made random edits until it compiled
without errors." ~XKCD#1513

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

Tom Robinson | 21 Apr 22:47 2015
Picon

FileMaker 'in' function?

I really miss an 'in' function in FileMaker -- being able to test a variable/field for being equal to one of a
number of supplied values.

In SAS I can program elegant code like:

	Qtr in(0,1,2,3)

Which yields true if Qtr is 0, 1, 2, or 3; otherwise false.

In AppleScript:

	Qtr is in {0, 1, 2, 3}

In FileMaker it ends up this semi-opaque blob with implied numeric to character conversion:

	not IsEmpty(FilterValues(Qtr;"0¶1¶2¶3"))

Have I missed something?  How do others handle this?

(Note list of values aren't always sequential, and not appropriate to load into value list.)

Cheers

_______________________________________________
FMPexperts mailing list
FMPexperts <at> lists.ironclad.net.au
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

Gmane