Enfocus Community

True, thanks for that.

Next to the Value field in the "Add barcode" Action there is a "Variable" button that offers a set of internal variables and %Page Number% is one of them, so you specify "Page %Page Number%" as the value. There is a limitation: you cannot combine these variables with t...

Trying to do this calculation that involves 2 pieces of metadata, as part of a multi-line with variables, for an email body. I can't seem to find the right formatting. I either get nothing but "Shortage % %", or I get the entire formula exactly as it is below. How do I format those 2 piece...

I need to compare these two (dates). I need to compare in the format of; checking if one is equal to or less than the other (and neither is today or have any relationship to today) - basically, is this file "overdue": Is this date the same or *older* [Metadata.Text:Dataset="pdf",...

This ended up working: URL - http://172.##.##.##:55000 Header (this was the final piece to make it work) Content-Type: multipart/related; boundary="____MM-Part-Boundary____" The main reason I didn't want to use scripting is I haven't conquered that hill yet, and wasn't going to try and dra...

Sending a .jmf file using HTTP POST from the stock "HTTP request" configurator. Tried MIME encoding on/off, no joy. I need to do this without scripting. I need to provide the HTTP POST as "multipart-related" to the Muller-Martini "Connex" software (if anyone is familiar...

I have a similar question except for two things: I need to do this without scripting. I need to provide the HTTP POST as "multi-part/related" to the Muller-Martini "Connex" software (if anyone is familiar with that). Sending a .jmf file using HTTP POST from the stock "HTTP r...

Maybe it would be helpful to understand the problem I'm trying to solve with the use of PrivateData within this transform. Ultimately I'm trying to effectively over-write the value of a field in the job metadata. I'm using a field in a database that contains a name field (and a job number field) fro...

I'm using an XSLT to export a .csv file. One of the items in the CSV is pulled from PrivateData. I cannot find the appropriate quoting/escaping level to get it to appear in my output. And there are no errors thrown anywhere. Here's the relevant bit: ;<xsl:value-of select="//*[tag='Job Number']/...

It always helps to actually *be( hitting the database you *think* you're hitting... Dev vs. Live...
Never mind, sorry to take up bandwidth.

I have a query I run against a FileMaker Server using the Database connect module (Switch 2019 Fall). Recently it came to my attention that it wasn't returning complete results. Below is the query. If I use the query tool within Excel, it returns *all* of the results - and I just copy/pasted the bel...

Figured it out:
For these 2 lines:

INNER JOIN Title t ON t.ISBN = j.ISBN
JOIN Customer c ON c.CustID = j.CustID

I broke them apart to:

INNER JOIN Title t
ON t.ISBN = j.ISBN
JOIN Customer c
ON c.CustID = j.CustID

And it worked. But, again, the former version worked in Excel on Windows.

This syntax executes just fine in Excel against a FileMaker Pro 14 server, but from the Switch Database connect configurator, it hangs up FileMaker. I had to modify the query from a version that worked fine, the main difference here is the use of the JOIN command, never used it before. Again, Excel ...

Running 2018u1 on Windows Server 2012R2. I have a couple different flows that utilize the "HTTP request" configurator. Some of them hit external URLs, others hit internal URLs. But universally, randomly, the configurator has the red gear icon on it and is stalled out. One issue with this i...

I forget, what is the .sfixture file used for?