Search found 80 matches
- Thu Jan 11, 2024 11:33 pm
- Forum: Flows
- Topic: Using the current PDF page in variables?
- Replies: 9
- Views: 153505
Re: Using the current PDF page in variables?
True, thanks for that.
- Thu Jan 04, 2024 9:43 pm
- Forum: Flows
- Topic: Using the current PDF page in variables?
- Replies: 9
- Views: 153505
Re: Using the current PDF page in variables?
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...
- Fri Jun 16, 2023 8:51 pm
- Forum: Flows
- Topic: Math Expressions With Metadata
- Replies: 2
- Views: 8228
Math Expressions With Metadata
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...
- Wed Nov 23, 2022 5:54 pm
- Forum: Flows
- Topic: Compare creation dates of two files
- Replies: 6
- Views: 7806
Re: Compare creation dates of two files
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",...
- Mon Jun 21, 2021 11:45 pm
- Forum: LEGACY scripting
- Topic: How to POST a file to an API (Content-Type: multipart/formdata)
- Replies: 9
- Views: 21859
Re: How to POST a file to an API (Content-Type: multipart/formdata)
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...
- Tue May 04, 2021 8:35 pm
- Forum: Flows
- Topic: HTTP POST as multipart-related?
- Replies: 0
- Views: 14325
HTTP POST as multipart-related?
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...
- Tue May 04, 2021 7:23 pm
- Forum: LEGACY scripting
- Topic: How to POST a file to an API (Content-Type: multipart/formdata)
- Replies: 9
- Views: 21859
Re: How to POST a file to an API (Content-Type: multipart/formdata)
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...
- Wed Aug 26, 2020 6:26 pm
- Forum: Flows
- Topic: Referencing PrivateData in an XSLT
- Replies: 2
- Views: 5890
Re: Referencing PrivateData in an XSLT
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...
- Wed Aug 26, 2020 12:01 am
- Forum: Flows
- Topic: Referencing PrivateData in an XSLT
- Replies: 2
- Views: 5890
Referencing PrivateData in an XSLT
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']/...
- Fri Aug 14, 2020 10:28 pm
- Forum: Applications
- Topic: SQL Query Incomplete Results
- Replies: 1
- Views: 5962
Re: SQL Query Incomplete Results
It always helps to actually *be( hitting the database you *think* you're hitting... Dev vs. Live...
Never mind, sorry to take up bandwidth.
Never mind, sorry to take up bandwidth.
- Fri Aug 14, 2020 8:46 pm
- Forum: Applications
- Topic: SQL Query Incomplete Results
- Replies: 1
- Views: 5962
SQL Query Incomplete Results
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...
- Wed May 06, 2020 10:27 pm
- Forum: Applications
- Topic: SQL Syntax Doesn't Work in Switch
- Replies: 1
- Views: 6506
Re: SQL Syntax Doesn't Work in Switch
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.
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.
- Wed May 06, 2020 9:22 pm
- Forum: Applications
- Topic: SQL Syntax Doesn't Work in Switch
- Replies: 1
- Views: 6506
SQL Syntax Doesn't Work in Switch
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 ...
- Mon Apr 27, 2020 6:04 pm
- Forum: Flows
- Topic: HTTP Request Not Reliable
- Replies: 11
- Views: 17050
HTTP Request Not Reliable
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...
- Thu Jan 23, 2020 3:53 pm
- Forum: LEGACY scripting
- Topic: Writing a Text File via (Java) Scripting
- Replies: 5
- Views: 11181
Re: Writing a Text File via (Java) Scripting
I forget, what is the .sfixture file used for?