Enfocus Community

I've got an ODBC connection to the database now, if you're able to get something working that would be great! It's been added to v2 of the script here: https://github.com/open-automation/switch-sql-query Currently, it allows for 3 parameters. Just structure your SQL query with named placeholders pr...

Dominick, I'm actually using UPDATE's rather than SELECT's, is this still a viable option? Yep. But you'll need an ODBC connection to your database to use my script, so perhaps make sure that you can swing that before jumping ship on stored procedures. I've got an ODBC connection to the database no...

Freddy, that looks like it might be the safest way to go, I'll have a look to see whether or not it's viable in my (antiquated) database setup.

Dominick, I'm actually using UPDATE's rather than SELECT's, is this still a viable option?

Hello, I was planning on using the standard database connect flow element but concluded that it probably doesn't have any sort of SQL injection prevention built in...Does Switch JavaScript have any sort of SQL injection prevention or a way to sanitize database inputs? I've gone through the manual on...

What system produces files like that? Seems like having Switch parse through a file like this reliably would be very challenging and prone to error. Tell me about it. :lol: I've no idea what the system is, I believe it's something bespoke our client had built for them by a third party, but I've bee...

Hi guys, I have a windows formatted text file (\r\n) that I am reading into a switch script. Here is an example of the format: =======Section A======= Value 1: I need this value Value 2: I need this value Value 3: I need this value =======Section B======= Value 4: I need all of these values Value 5:...

I wish I knew what caused it. I thought that it was particularly high yield of files but sometimes that isn't the case.

Interestingly Pitstop Server also seems to stop processing files when it happens.

Do you have anything particularly clever setup in regards to stop processing, start processing etc. or are you just doing a standard system reboot? I don't know whether it's correct or not but it was instilled in me while learning Switch that you should always stop processing before restarting the s...

I've got a bit of weird one. It used to happen maybe once a year but over the past few weeks it seems to becoming a daily experience. For some reason Switch will just stop doing...anything! I don't get any error messages, but if I look at a flow there will be files in it not moving. The only way to ...

Very interesting! You know, I was just in the throes of writing my own timer based file injector, but the fact you've written one and have been gracious enough to let us use it will save me a lot of time! Can I ask, did you manage to get around timeFired always firing on flow activation regardless o...

Oh yeah, I misunderstood your question. My comments were assuming you were writing a script to process.execute and put new files in your flow. I really know nothing about the execute command configurator :/ Me neither apparently! Normally I would have done what you suggested and encapsulated the py...

Hey man, I'm not familiar with "Folder at Path" but I can tell you some of the ways I would consider doing it. Within the script, you have to use a sendTo function to route the job out of the script. You want to send the files out as Jobs. Ideally, you want to use the same job, so it keep...

Hi guys, I was wondering if anyone can give me any insight into working with the Execute Command configurator? I've written a Python script which is receiving a CSV list of files, logging into a website and looking for the files in the list. I then want it to output all of the files back into the fl...

Hello all, I've had a look around in the old threads but haven't seen anything posted recently to do with this. We'd like to have Switch send out emails on behalf of our customer services staff, but I can't find any way of setting this dynamically. The reply address property on Mail send does help t...

And there you have it, it's now outputting. In the original script, I had the line: var newFile = new File(s.createPathWithName("#" + orderID + "-#" + lineID + "(" + lineNum + ").dg")); I had assumed that this was sufficient enough to create the file, but appa...