Enfocus Community

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.

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 ...

And this is strictly using the Database connect module, and a SQL statement - no scripting? I'm not having any success.

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...

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...

v10 of the configurator.

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...

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 ...

I'm first trying your suggestion Freddy thanks, that's the kind of solution I was envisioning.

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 ...

There we go, I'll give that a try!

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)...

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.