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"
Search found 80 matches
- Mon Apr 23, 2018 10:29 pm
- Forum: Flows
- Topic: XML pickup tool
- Replies: 11
- Views: 17904
- Mon Apr 23, 2018 10:06 pm
- Forum: Flows
- Topic: XML pickup tool
- Replies: 11
- Views: 17904
Re: XML pickup tool
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...
- Fri Mar 23, 2018 10:28 pm
- Forum: Flows
- Topic: Generate a UUID For Use in XML?
- Replies: 2
- Views: 5029
Generate a UUID For Use in XML?
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.
- Mon Mar 19, 2018 10:11 pm
- Forum: Connect ALL / SEND
- Topic: Connector Provide a File "Manifest"?
- Replies: 2
- Views: 9233
Connector Provide a File "Manifest"?
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...
- Wed Mar 07, 2018 6:35 pm
- Forum: Flows
- Topic: Combining Data Into XSLT Question
- Replies: 1
- Views: 2782
Combining Data Into XSLT Question
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...
- Wed Feb 21, 2018 5:20 pm
- Forum: Flows
- Topic: Precision Parameter Not Working
- Replies: 4
- Views: 6596
Re: Precision Parameter Not Working
That was the ticket! Thank You so much!
- Tue Feb 20, 2018 8:00 pm
- Forum: Flows
- Topic: Precision Parameter Not Working
- Replies: 4
- Views: 6596
Re: Precision Parameter Not Working
I did indeed choose "Define Multi-Line...."
- Wed Feb 14, 2018 8:59 pm
- Forum: Flows
- Topic: Precision Parameter Not Working
- Replies: 4
- Views: 6596
Precision Parameter Not Working
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...
- Mon Feb 12, 2018 4:24 pm
- Forum: Flows
- Topic: SQL Call to Filemaker
- Replies: 2
- Views: 4586
Re: SQL Call to Filemaker
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.
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.
- Fri Feb 09, 2018 11:49 pm
- Forum: Flows
- Topic: SQL Call to Filemaker
- Replies: 2
- Views: 4586
SQL Call to Filemaker
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...
- Tue Aug 29, 2017 6:37 pm
- Forum: Flows
- Topic: Reference For "Separator" Characters
- Replies: 1
- Views: 3005
Re: Reference For "Separator" Characters
Perhaps most importantly, how to make the separator render as a carriage return once it hits a FileMaker text field via the SQL call.
- Tue Aug 29, 2017 5:55 pm
- Forum: Flows
- Topic: Reference For "Separator" Characters
- Replies: 1
- Views: 3005
Reference For "Separator" Characters
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...
- Fri Feb 10, 2017 8:41 pm
- Forum: Flows
- Topic: Basic SQL Commands
- Replies: 12
- Views: 48852
Re: Basic SQL Commands
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...
- Fri Feb 10, 2017 8:25 pm
- Forum: Flows
- Topic: Basic SQL Commands
- Replies: 12
- Views: 48852
Re: Basic SQL Commands
Are they supposed to be single quotes (apostrophe's) or the acute character - same key as tilde?
- Fri Feb 10, 2017 8:09 pm
- Forum: Flows
- Topic: Basic SQL Commands
- Replies: 12
- Views: 48852
Re: Basic SQL Commands
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.
Switch 13u1, SQL 12.