Search found 83 matches
- Wed Dec 11, 2024 4:50 pm
- Forum: Connect ALL / SEND
- Topic: ConnectALL vs. Sonoma/Sequoia
- Replies: 0
- Views: 105178
ConnectALL vs. Sonoma/Sequoia
Yup, still needing to run the main dev app for ConnectALL in Sequoia... Will we be doomed to keeping a legacy Mac on hand for making new and/or changes to our fleet of connectors?
- Tue Jul 30, 2024 9:55 pm
- Forum: Flows
- Topic: Using [Last()] In XML/XPath Parsing SQL Results
- Replies: 2
- Views: 7890
Re: Using [Last()] In XML/XPath Parsing SQL Results
Thanks!
I let some Google searches that showed it as "Last" lead me astray.
I let some Google searches that showed it as "Last" lead me astray.
- Mon Jul 29, 2024 4:46 pm
- Forum: Flows
- Topic: Using [Last()] In XML/XPath Parsing SQL Results
- Replies: 2
- Views: 7890
Using [Last()] In XML/XPath Parsing SQL Results
Does Switch not support the use of "[Last()]" in specifying a Metadata field? Appears not. I have a SQL query returning multiple hits most of the time, and I just want the last one out of the results. i.e.: [Metadata.Text:Dataset="FMP_Data",Model="XML",Path="/Log/S...
- Thu Jan 11, 2024 11:33 pm
- Forum: Flows
- Topic: Using the current PDF page in variables?
- Replies: 9
- Views: 161101
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: 161101
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: 10957
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: 12424
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: 31825
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: 18120
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: 31825
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: 8531
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: 8531
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: 8913
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: 8913
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: 9268
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.