Search found 76 matches

by rgpepper
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: 7812

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 drag someone ...
by rgpepper
Tue May 04, 2021 8:35 pm
Forum: Flows
Topic: HTTP POST as multipart-related?
Replies: 0
Views: 732

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 with that). The configurator ...
by rgpepper
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: 7812

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 request" configurator. Tri...
by rgpepper
Wed Aug 26, 2020 6:26 pm
Forum: Flows
Topic: Referencing PrivateData in an XSLT
Replies: 2
Views: 1372

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...
by rgpepper
Wed Aug 26, 2020 12:01 am
Forum: Flows
Topic: Referencing PrivateData in an XSLT
Replies: 2
Views: 1372

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']/value...
by rgpepper
Fri Aug 14, 2020 10:28 pm
Forum: Applications
Topic: SQL Query Incomplete Results
Replies: 1
Views: 1366

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.
by rgpepper
Fri Aug 14, 2020 8:46 pm
Forum: Applications
Topic: SQL Query Incomplete Results
Replies: 1
Views: 1366

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...
by rgpepper
Wed May 06, 2020 10:27 pm
Forum: Applications
Topic: SQL Syntax Doesn't Work in Switch
Replies: 1
Views: 1849

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.
by rgpepper
Wed May 06, 2020 9:22 pm
Forum: Applications
Topic: SQL Syntax Doesn't Work in Switch
Replies: 1
Views: 1849

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 ...
by rgpepper
Mon Apr 27, 2020 6:04 pm
Forum: Flows
Topic: HTTP Request Not Reliable
Replies: 11
Views: 5339

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 is that thi...
by rgpepper
Thu Jan 23, 2020 3:53 pm
Forum: LEGACY scripting
Topic: Writing a Text File via (Java) Scripting
Replies: 5
Views: 4052

Re: Writing a Text File via (Java) Scripting

I forget, what is the .sfixture file used for?
by rgpepper
Wed Jan 22, 2020 9:33 pm
Forum: LEGACY scripting
Topic: Writing a Text File via (Java) Scripting
Replies: 5
Views: 4052

Writing a Text File via (Java) Scripting

I searched the existing posts, didn't find an exact fit for what I want to be able to do. I'm simply looking for a code example showing the combining of perhaps a data field from the job, and perhaps some other static custom text, and writing it to a local file (on Windows), UTF-8. So: defining the ...
by rgpepper
Mon Nov 25, 2019 10:28 pm
Forum: LEGACY scripting
Topic: Using JS To Add Email Addresses
Replies: 6
Views: 4547

Re: Using JS To Add Email Addresses

Call me a hack, I'm new to JS (worse yet, within Switch), this worked for me - a blend of observations by Gabriel. I used a previous folder in the flow to attach the field I needed as the JobState like so: '[Metadata.TextIndexed:Path="/field-list/field[6]/value",Dataset="Submit",Model="XML"]' - it o...
by rgpepper
Mon Nov 25, 2019 5:43 pm
Forum: LEGACY scripting
Topic: Using JS To Add Email Addresses
Replies: 6
Views: 4547

Re: Using JS To Add Email Addresses

You are on the right track. The only thing you still have to do is to send the job to the output folder. In your case a single output connection will be enough, so in the properties of the script you define it as having just one output connection and the end of the jobArrived function you add: job....
by rgpepper
Tue Oct 29, 2019 6:49 pm
Forum: LEGACY scripting
Topic: Java "Includes" Not Working
Replies: 2
Views: 2491

Re: Java "Includes" Not Working

Thanks! Turns out I did have to use "IndexOf", and I'm golden!