Search found 80 matches

by rgpepper
Fri Feb 10, 2017 7:08 pm
Forum: Flows
Topic: Basic SQL Commands
Replies: 12
Views: 47384

Re: Basic SQL Commands

Check on all of the above (well, the MS SQL server is external but I went through all the setup stuff and it configured just fine and I get a SQL error back as I mentioned in my original post), except I can't make the insert command work. Can someone please comment on my original query: INSERT INTO ...
by rgpepper
Fri Feb 10, 2017 6:22 pm
Forum: Flows
Topic: Basic SQL Commands
Replies: 12
Views: 47384

Re: Basic SQL Commands

And this is strictly using the Database connect module, and a SQL statement - no scripting? I'm not having any success.
by rgpepper
Thu Feb 09, 2017 11:55 pm
Forum: Flows
Topic: Basic SQL Commands
Replies: 12
Views: 47384

Basic SQL Commands

We have the Database connect module. I'm not finding any examples of using INSERT INTO to send data to a SQL database from Switch (including the reference manual). Can anyone give me an example statement of inserting say 5 fields into a table (named Transactions)? The database name is defined in the...
by rgpepper
Mon Jan 09, 2017 6:56 pm
Forum: Flows
Topic: Errors With HP Digital Front End JDF Control
Replies: 7
Views: 8311

Re: Errors With HP Digital Front End JDF Control

Switch v13 update 1. The configuration did behave strangely, when I selected "Single-line text with variables defined" from the "Due date method" menu, it gave me the dialog to set it up as expected, then it put "Single-line text with variables defined" in the "Due...
by rgpepper
Mon Jan 09, 2017 5:24 pm
Forum: Flows
Topic: Errors With HP Digital Front End JDF Control
Replies: 7
Views: 8311

Re: Errors With HP Digital Front End JDF Control

v10 of the configurator.
Screen Shot 2017-01-09 at 10.23.24 AM.png
Screen Shot 2017-01-09 at 10.23.24 AM.png (35.8 KiB) Viewed 8269 times
by rgpepper
Fri Jan 06, 2017 10:55 pm
Forum: Flows
Topic: Errors With HP Digital Front End JDF Control
Replies: 7
Views: 8311

Re: Errors With HP Digital Front End JDF Control

This is my due date expression: [Metadata.Text:Path="/field-list/field[3]/value",Dataset="Submit",Model="XML"]T[Metadata.Text:Path="/field-list/field[4]/value",Dataset="Submit",Model="XML"]:00.000 I hard-coded the 00.000 since that wasn't p...
by rgpepper
Fri Jan 06, 2017 1:37 am
Forum: Flows
Topic: Errors With HP Digital Front End JDF Control
Replies: 7
Views: 8311

Errors With HP Digital Front End JDF Control

Trying to use this configurator, getting these errors (for a single job), in this order: File extension ".xml" is not a supported file type. Fail method for job 'Generate JDF5January2017182441.xml' has been already invoked Job 'Generate JDF5January2017182441.xml' was already failed; can't ...
by rgpepper
Tue Nov 29, 2016 11:06 pm
Forum: Flows
Topic: Trailing Space When Using Mail Receive
Replies: 3
Views: 4270

Re: Trailing Space When Using Mail Receive

I'm first trying your suggestion Freddy thanks, that's the kind of solution I was envisioning.
by rgpepper
Mon Nov 28, 2016 6:29 pm
Forum: Flows
Topic: Trailing Space When Using Mail Receive
Replies: 3
Views: 4270

Trailing Space When Using Mail Receive

When using the Mail Receive configurator, a random email will come through with a trailing space in the subject, which results in a folder being created (using Switch on Windows) on a Windows server with a space at the end, which is a problem - it can only be deleted from the command prompt. So you ...
by rgpepper
Fri Oct 21, 2016 9:52 pm
Forum: Preflighting
Topic: Exporting a PDF report from Enfocus Switch
Replies: 9
Views: 16266

Re: Exporting a PDF report from Enfocus Switch

There we go, I'll give that a try!
by rgpepper
Wed Oct 19, 2016 11:06 pm
Forum: Preflighting
Topic: Exporting a PDF report from Enfocus Switch
Replies: 9
Views: 16266

Re: Exporting a PDF report from Enfocus Switch

I'm also trying to include the preflight report with the checkpoint via email, but unless I'm not understanding all the nuances of how checkpoints via email work, I don't see how you can: A) checkpoint's purpose is to get customer approval to move the *production* PDF to the next step in the flow B)...
by rgpepper
Mon Jul 18, 2016 7:26 pm
Forum: Applications
Topic: InDesign Config Can't See Images
Replies: 6
Views: 10978

Re: InDesign Config Can't See Images

They can't reproduce the error. I've tried one of their two suggested tests to isolate the cause, that didn't reveal anything new, working on the second one.
by rgpepper
Thu Jul 14, 2016 10:51 pm
Forum: Applications
Topic: InDesign Config Can't See Images
Replies: 6
Views: 10978

Re: InDesign Config Can't See Images

It shows them missing, but I can re-link to them (in the package folder on the Switch server) fine. So it's not a rights issue, it's like it doesn't know where it's supposed to look when told to re-link. Enfocus tried my flow (on a Mac) on their end and it works fine. Doesn't work for me, always say...
by rgpepper
Thu Jul 14, 2016 10:05 pm
Forum: Applications
Topic: InDesign Config Can't See Images
Replies: 6
Views: 10978

InDesign Config Can't See Images

Trying to process some InDesign files, I'm submitting package folders to my flow, but InDesign refuses to see the images, always errors if I check "Fail with unavailable images". And the error lists the name of every image in the document. But it's bogus, all the images are in the (InDesig...
by rgpepper
Mon Jul 11, 2016 11:43 pm
Forum: Flows
Topic: XSLT Need Help
Replies: 10
Views: 9918

Re: XSLT Need Help

Stackoverflow, good stuff. And I agree on XML and its' ilk.