Enfocus Community

Yeah nada:

[Metadata.Text:Path="//field-list/field[tag='PO#']/value",Dataset="FTP_XML",Model="XML"]

Doesn't work, I get the following error:
"There is no selected node. A location path is valid only when it indicates a single node"

I can't seem to make the method mentioned here work for me. I have this XML (just the top portion shown for brevity), dataset is named "FTP_XML", I want to use xpath so that I don't have to re-connect everything if I add a field in the middle of the XML. <?xml version="1.0" encod...

I need to provide a UUID in an XML file I'm thinking I'll be able to generate using "Make XML". But I'm not seeing anything about actually generating one within (and for use within) Switch.

Unless I'm missing something, I see only a 1:1 between files dropped onto a connector, and the job ticket provided for that file. I'm wondering about the Connector providing a single job ticket, listing all files dropped in a given session. Any other way to do this beyond ZIP-compressing and then in...

I'm pumped I built a working XSLT transform! Then I realized it is strictly a tool for processing a physical XML file. How could I output an XML file that contains both data that was picked up from an incoming (from a Connector) XML file *and* Switch system variables like Job.Name and the like? If I...

That was the ticket! Thank You so much!

I did indeed choose "Define Multi-Line...."

I have this defined as the body of an outgoing email in Switch v13 (and it works): ********************* File: [Job.Name] Pages: [Metadata.Text:Path="/pdfattrs/@pages",Dataset="Preflight",Model="XML"] Colors: [Metadata.Text:Path="/pdfattrs/colors/color[1]/@base&quo...

This worked:
SELECT Plan FROM Job WHERE Job_ID = (NUMVAL('[Email.Subject:After="#",Before=":"]'))

Not sure if it was switching to "=" and because it's numeric as I thought I understood that "LIKE" should work.

Trying to cross-reference a couple fields that are in Filemaker Server (hosted on a separate box - both are Windows Server), using database connect via ODBC, trying to do a SQL call. I have successfully made other SQL calls to Filemaker. But I'm stumped. I either get a syntax error or "an expre...

Perhaps most importantly, how to make the separator render as a carriage return once it hits a FileMaker text field via the SQL call.

I'm using Job.NestedName to get a file listing of a processed .ZIP file, it's a big blob of tab-delimited text, which I want to format into more of a list before pushing out through a SQL call, I figured I'd use the "separator" option, but I can't find anywhere a reference for what code eq...

This worked: INSERT INTO Transactions VALUES ( '[Job.Name]' , '[Metadata.Text:Path="/field-list/field[1]/value",Dataset="Submit",Model="XML",Before="@"]', '[Metadata.Text:Path="/field-list/field[1]/value",Dataset="Submit",Model="XML&qu...

Are they supposed to be single quotes (apostrophe's) or the acute character - same key as tilde?

I copied and pasted your statement, nada. "Incorrect syntax near the keyword `SET`" and "unclosed quotation mark after the character string "`" "

Switch 13u1, SQL 12.