Zach Fleming | 22 Oct 21:21 2014
Picon

Photo access through server

 Is there a way to make a folder of photos and put them on the server?  Can I access them based on certain criteria?

Example: I have a folder called "Weather Photos".   I also have a basic solution with a "Name" field, and a
"Container" field.

If I type "Cloudy" in the Name field, is there a way to make the "Container" field auto-display the "Cloudy"
photo, or if I type "Sunny" in the Name field, can the "Container" field auto-display the "Sunny" photo?

I've heard about externally storing container fields?  I wasn't sure if this was possible some way?  

I have FMPA13 and this will be a multi-user solution using mostly FMGO.

Thanks,
Zach

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

Brent Hedden | 22 Oct 19:47 2014

Reading memory dump files created from FM Server

Greetings all

After recovering from a system crash, I noticed that (Windows Server 2012) FM server created a log entry and
wrote a .DMP file, which is a memory dump file.  I don't have any experience is reading these types of file,
and wanted to see if anyone here has dealt with these before?  Something about getting the appropriate
debugging symbols, so maybe only FMI can read these??

Thanks for any info you can provide!

Brent Hedden | FileMaker Developer
P: 858.451.2383 x179
Brent.Hedden@... | www.nth.com

________________________________

This message (including any attachments) contains confidential information intended for a specific
individual and purpose, and is protected by law. If you are not the intended recipient, you should delete
this message. Any disclosure, copying, or distribution of this message, or the taking of any action based
on it, is strictly prohibited.
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

Brent Hedden | 22 Oct 18:27 2014

Reading windows dump files

Greetings all

After recovering from a system crash, I noticed that (Windows Server 2012) FM server created a log entry and
wrote a .DMP file, which is a memory dump file.  I don't have any experience is reading these types of file,
and wanted to see if anyone here has dealt with these before?  Something about getting the appropriate
debugging symbols, so maybe only FMI can read these??

Thanks for any info you can provide!

Brent Hedden | FileMaker Developer
P: 858.451.2383 x179
Brent.Hedden@... | www.nth.com

________________________________

This message (including any attachments) contains confidential information intended for a specific
individual and purpose, and is protected by law. If you are not the intended recipient, you should delete
this message. Any disclosure, copying, or distribution of this message, or the taking of any action based
on it, is strictly prohibited.
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

Bob Gossom | 22 Oct 17:27 2014

Real World Use of Mod Function

Hi,

I occasionally find myself trying to use the Mod function to deal with non-10 based numbering. Yesterday
for example I needed to get the fiscal year month, for a year that starts in July. (July = 1…June = 12).

The above example isn't hard to calc out without Mod, but I really like using clean, built-in calculations,
and enjoy extending my tool set.

My problem with using the mod function is that the last number in the sequence goes to 0. In the above example,
every month returns the expected value, except that June reports as "0", not 12. I've run into this every
time I've tried to use the function, and I've never found a workaround that wasn't at least as complicated
as a calculation not using Mod.

I understand the theory behind the function and why a mathematician wants that last number to be "0," but
I've never found it useful for solving a real world problem.

In the big scheme of things, this doesn't matter much, but it bugs me to have a function out there that I just
can't get to be useful. Is there something I'm not getting?

Bob Gossom
Absolute Advantage, Inc.

MOD CALC
Mod ( month(date_field) + 6, 12)
                 returns 1 - 11 for July - May, 0 for June. 

MOD ALTERNATIVE
let(
m = Mod ( month(date_field) + 6, 12),
case( m = 0,12, m)
(Continue reading)

Jonathan Fletcher | 21 Oct 07:30 2014

GetFieldName ( self )

FileMaker Fellas and Females,

I could swear that this used to work for me. 

I cannot get GetFieldName ( Self ) to work in a calculated field.

I also tried: 
	Evaluate ( Quote ( GetFieldName ( Self ) ) ) 

and 
	Evaluate ( " GetFieldName ( Self ) " )

Those don't work either.

In all cases I get an error 1225 (via the Developer Assistant evaluate feature), and the calculation
returns either a question mark or nothing.

Didn't this use to work? What am I missing?

I am using FMPA 13.0v3 on OS X 10.8.5.

TIA!

--johnno

G. Pupita | 18 Oct 18:24 2014
Picon

small bug or known issue ?

Hello --
I don't remember this reported, so here it goes

FM 12 Adv or 13.01 Adv

Design functions do not work when using the Get(FileName) function and the file name contains a dot
In these cases you've to add the file suffix .fmp12

Example
file Invoices_2.1.fmp12

LayoutNames(Get(FileName)) -- does not work
LayoutNames(Get(FileName) & ".fmp12") -- works

file Invoices.fmp12

LayoutNames(Get(FileName)) -- works
LayoutNames(Get(FileName) & ".fmp12") -- works

Ciao
G. Pupita
Certified FileMaker Developer
FileMaker Business Alliance

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

(Continue reading)

Stefan Schutt | 17 Oct 09:11 2014
Picon

Instrument Manager (™) - anyone?

Hi all,

A customer of mine is considering purchasing a middleware solution for their veterinary lab called
Instrument Manager.

The producing company is called DataInnovations (www.datainnovations.com).

Has any of you possibly heard of this software and how it might communicate with FMP?

TIA,
__
Stefan Schutt, Mouse Up, Finland

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

Stephen Wonfor | 16 Oct 22:08 2014
Picon

Repeating Variables Redux - the Peril of Unpacking

Hi

Have read a bunch of FMX messages on repeats in variables ("When is a $var[N] not $var[N]" etc) and have an
observation to add.  (This may have been covered already but my weak filing system for eMails, coupled with
not using the right terms in Spotlight searches has not allowed me to find some posts I recall reading).

GetValue($RepeatingVariable;$Count) does not seem to work. 
GetValue($RepeatingVariable;3) does work.

A client had requested a category report from Invoice Details.  Then "oh while you're at it can we get that
broken down by type of invoice", "oh, while you're at it can we get that broken down by type of payment".  This
went on and on.  I ended up creating a reporting table with 130 data fields and 20 calculations as we were
mixing, into a single "dashboard" report info from Invoices, InvoiceDetails, Payments and TrainingCourses.
My stacking script works well.  As I might have had to define 130 variables I decided to stack the data into
repeating variables and reduce this number to a few dozen or so.  Works like a charm.

Set Variable[$CdnRecognized[4];$CdnRecognized[4] + INVOICESDETAILS::ExtendedPrice].  All the
repeats with values were visible in the DataViewer.

My unpacking was less than successful.

	Set Variable [ $Count; Value:1]
	Set Field [ InvoiceReporting::CDNRealizedRevenueExpenseDetails; $CDNRealized[$Count] ]
	Set Field [ InvoiceReporting::CDNRecognizedRevenueExpenseDetails; $CDNRecognized[$Count] ]
	Set Field [ InvoiceReporting::CDNDeferredRevenueExpenseDetails; $CDNDeferred[$Count] ]
	Set Field [ InvoiceReporting::CDNCancelledRevenueExpenseDetails; $CDNCancelled[$Count] ]
	Set Field [ InvoiceReporting::CDNGSTExpenseDetails; $CDNGST[$Count] ]
	Set Variable [ $Count; Value:1 + $Count
 ]
	Set Field [ InvoiceReporting::CDNRealizedRevenueLoyaltyDetails; $CDNRealized[$Count] ]
	Set Field [ InvoiceReporting::CDNRecognizedRevenueLoyaltyDetails; $CDNRecognized[$Count] ]
(Continue reading)

Zach Fleming | 16 Oct 15:47 2014
Picon

2 Print Questions

I've built a report and I'm not sure how to format or script it to print from my iPad.  The report prints great
from the desktop version, just not on the iPad.  

The report always has the same structure:

Page 1 - Report Data
Page 2 - Location Map
Page 3-? - Report Photos  (The report can have any number of photos)

Each of these three are seperate layouts. On the desktop version, the script goes to each layout and saves
the related records as PDF and appends to the final document.  However, on iPad this doesn't work.  

Question 1: How to make the FMGO soltuion print function work similar to the desktop version (when the user
hits print, the document displays in a multiple page format to print)?

Question 2: If we have multiple report records, is there a way to print all of the reports at once?  Example: If
I have 10 report records, hit print once, and have all records PDF together?

Any help would be appreciated

Thanks,
Zach

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

(Continue reading)

Patrick Neame | 16 Oct 15:03 2014

Get Active Object

Dear all

Sorry, tis me again,

FM13A

Let's say I have some buttons on a layout called Button 1, Button 2, and Button 3 that and they do essentially
the same thing. The only thing that distinguishes them is the object name. I've therefore tried a script
whose first line is Get(ActiveLayoutObjectName) with a view to passing that information into the rest of
the script steps so that I don't have to create eight scripts when one would do.

But, clicking on the object won't capture the object name, I seem to be compelled to start the script
GoToObject (Name) but then if I do that I may as well just create eight individual scripts anyway. I can't
see any other functions that might help save for capturing a field name. But then creating eight fields
adds to the overheads.

Grr, Is the situation just hopeless or is there a classy way that I haven't spotted.

Many thanks,

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

Stephen Wonfor | 15 Oct 18:15 2014
Picon

FMP access query

Hi

At a client office today and have noted that I am unable to make connections to any external dbs.  True for FMP
11 and 13 and also FMP 13 on another laptop.
Would the issue be that they have closed port 5003 outbound?

Stephen

---

"There are only two kinds of programming languages: those people always bitch about and those nobody
uses".   -- Bjarne Stroustrup

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


Gmane