Search found 31 matches

by apietrocini
Thu Feb 27, 2020 5:30 pm
Forum: LEGACY scripting
Topic: Database Module adding extra single quotes...???
Replies: 2
Views: 763

Re: Database Module adding extra single quotes...???

SQL statement being passed from database module...
Screen Shot 2020-02-27 at 11.15.10 AM.png
Screen Shot 2020-02-27 at 11.15.10 AM.png (135.44 KiB) Viewed 758 times
by apietrocini
Thu Feb 27, 2020 5:29 pm
Forum: LEGACY scripting
Topic: Database Module adding extra single quotes...???
Replies: 2
Views: 763

Re: Database Module adding extra single quotes...???

Private data before database module..
Screen Shot 2020-02-27 at 11.11.46 AM.png
Screen Shot 2020-02-27 at 11.11.46 AM.png (246.46 KiB) Viewed 758 times
by apietrocini
Thu Feb 27, 2020 5:10 pm
Forum: LEGACY scripting
Topic: Database Module adding extra single quotes...???
Replies: 2
Views: 763

Database Module adding extra single quotes...???

Hello all! I have a flow that receives csv files throughout the day... I need to take those files and add the information from them into a database table... I wrote a script that formats the csv in a way thats ready to be inserted into a sql insert statement and then save that to private data... Whe...
by apietrocini
Wed Nov 13, 2019 7:13 pm
Forum: LEGACY scripting
Topic: Filter Submit Point Dropdown
Replies: 0
Views: 1880

Filter Submit Point Dropdown

Hello All! I have a submit point where I'm pulling in job numbers from a database... The problem is that it returns a list that is IMO to long to scroll through... Has anyone ever scripted a filter function into the dropdown so that when the user types it begins to filter out unmatched entries...? T...
by apietrocini
Fri Oct 11, 2019 6:04 pm
Forum: LEGACY scripting
Topic: Javascript help
Replies: 1
Views: 908

Javascript help

Hello all! What I'm trying to do is take something I'm doing through an execute command in switch and convert it to a switch script. I keep getting a parse error and I'm not sure why... Script works fine when I execute it in node, but fails in the switch scripter...? Any help would be great! const a...
by apietrocini
Fri Sep 27, 2019 12:21 am
Forum: LEGACY scripting
Topic: Webhook Response
Replies: 2
Views: 1207

Re: Webhook Response

That did it! I was just using the webhook configurator and completely forgot about the ability to script it... :oops:

Thank you!
by apietrocini
Thu Sep 26, 2019 10:15 pm
Forum: LEGACY scripting
Topic: Webhook Response
Replies: 2
Views: 1207

Webhook Response

Hi All, I'm wondering if anyone else has had this problem... Is there a way to configure a/the response that is sent from Switch back to the webhook originator...? The particular case I'm using this in is with Twilio... I'm generating a text to someone through switch, and they then respond, and that...
by apietrocini
Wed Jul 03, 2019 10:07 pm
Forum: PDF Creation
Topic: Split Multiple Page PDF
Replies: 5
Views: 5411

Split Multiple Page PDF

Hello all,

I have a multiple page pdf that I need to split out dynamically. I know you can split by x amount of pages per file, but the problem I'm having is these are invoices and they can be any number of pages. Has anyone ever accomplished this.

Thanks,

Anthony
by apietrocini
Wed Jun 19, 2019 10:30 pm
Forum: Switch
Topic: SMB Protocol
Replies: 0
Views: 1750

SMB Protocol

Hello All, Has anyone experienced this...? I'm currently running Switch on an iMac Pro which is running High Sierra. I have normally connected to outside volumes using SMB Protocol 1, but our IT manager has informed me we need to go to SMB 3. When I mount a volume using the SMB 3 protocol, I can dra...
by apietrocini
Mon Apr 29, 2019 10:18 pm
Forum: LEGACY scripting
Topic: Multiple File/Folder Inject
Replies: 1
Views: 1239

Multiple File/Folder Inject

Hello All, I'm sure this is been addressed before, but can't seem to find a thread discussing a solution. What I'm trying to do is create a job archive process through switch. I can execute a db query to return all jobs that have been closed that day. The problem I'm running into is when I get a res...
by apietrocini
Fri Apr 05, 2019 7:01 pm
Forum: Applications
Topic: Using the Execute Command on a Mac
Replies: 2
Views: 1700

Re: Using the Execute Command on a Mac

I didn't... but just tried it and I'm still getting the extra folder...?
by apietrocini
Fri Apr 05, 2019 6:39 pm
Forum: Applications
Topic: Using the Execute Command on a Mac
Replies: 2
Views: 1700

Using the Execute Command on a Mac

Ok... I've been at this for about an hour and I think I'm close I just cant seem to close the deal... I'm trying to zip a file through the Execute Command tool because when I use the archive tool Mac will create a hidden folder that appears on a windows machine... Anyhow... I've attached screenshots...
by apietrocini
Fri Mar 22, 2019 11:27 pm
Forum: LEGACY scripting
Topic: Scripting the date
Replies: 1
Views: 1254

Scripting the date

Hello All, I know there are many threads on this, but I couldn't find an answer to my particular case... I have my script working and doing exacltly what I want it to, it's now a question of formatting... I'm using this to get a variable date and if that date falls on a Saturday or Sunday, I'm addin...
by apietrocini
Fri Mar 22, 2019 11:20 pm
Forum: LEGACY scripting
Topic: How to create a dataset
Replies: 8
Views: 8642

Re: How to create a dataset

Thank you!!! I got it to work!
by apietrocini
Wed Mar 13, 2019 9:31 pm
Forum: LEGACY scripting
Topic: How to create a dataset
Replies: 8
Views: 8642

Re: How to create a dataset

Ok... This may be a dumb question, but is there a way to attach a complete dataset to one private data key...?