Search found 58 matches

by NickD
Tue Feb 13, 2018 6:48 pm
Forum: Technical / Scripting
Topic: Regex on Arrays
Replies: 6
Views: 4271

Re: Regex on Arrays

Looping through the array output by IEGetTagsByAttrib> works fine in my script, the problem occurs when I try to parse it with regex. I will pm you the script, probably a newbie mistake in there somewhere :roll:
by NickD
Tue Feb 13, 2018 6:05 pm
Forum: Technical / Scripting
Topic: Regex on Arrays
Replies: 6
Views: 4271

Re: Regex on Arrays

It's got me miffed too Marcus... When I loop through the array output by IEGetTags, ArrayVar_Count returns 30 for both titles and URLs. All the titles and URLs are unique, they are pulled from 30 different divs on the same page, each containing a different video. Could it be something to do with the...
by NickD
Tue Feb 13, 2018 5:55 pm
Forum: Technical / Scripting
Topic: Using ImageMagick CLI To Watermark Image Via Macro Scheduler
Replies: 3
Views: 2941

Using ImageMagick CLI To Watermark Image Via Macro Scheduler

Hi, I am trying to create a script that can watermark images in different places based on my dialog input I have installed Image Magick, and watermarking works fine if I open command prompt from the folder containing the images and use the command: magick composite -geometry +50+50 watermark.png ori...
by NickD
Fri Feb 09, 2018 3:55 pm
Forum: Technical / Scripting
Topic: Regex on Arrays
Replies: 6
Views: 4271

Regex on Arrays

I am struggling to figure out how to use regex on arrays, the following script only successfully parses the first title, and then returns empty variables after that. There are 30 lines in both of the GetTag arrays. If anybody could point me in the right direction it would be greatly appreciated. // ...
by NickD
Tue Aug 29, 2017 11:41 am
Forum: Technical / Scripting
Topic: MySQL Insert Into Row Selected from Array
Replies: 1
Views: 2120

Re: MySQL Insert Into Row Selected from Array

Cracked it! For anyone else searching for how to do this, try Let>SQLCmd=UPDATE %MySQLtable% SET Field1='Value1',Field2='Value2' WHERE id=%autoincrement_row_id% DBConnect>Driver{%ODBCDriver%};Server=%DBServerIP%;Port=%DBPort%;Database=%DBName%;User=%DBUser%;Password=%DBPass%;Option=3;,dbH DBExec>dbH...
by NickD
Tue Aug 29, 2017 10:24 am
Forum: Technical / Scripting
Topic: FTP connection doesn't works
Replies: 2
Views: 2404

Re: FTP connection doesn't works

FTPPutFile definitely works lechuga, I have used it very recently. I think the problem with your code is that you are using backslashes on the server filepath, try forward slashes. Let>ftpserver=ftp.domain.tld Let>ftpuser=admin@domain.tld Let>ftppassword=yourpassword Let>ftpport=21 Let>ftpuploadfold...
by NickD
Mon Aug 28, 2017 11:27 pm
Forum: Technical / Scripting
Topic: MySQL Insert Into Row Selected from Array
Replies: 1
Views: 2120

MySQL Insert Into Row Selected from Array

The script I am working on stores a MYSQL database in an array, then loops through the rows looking for rows that have a specific value in one field: // MySQL Database To Array Let>SQL=SELECT * FROM %MySQLtable% DBConnect>Driver={%ODBCDriver%};Server=%DBServerIP%;Port=%DBPort%;Database=%DBName%;User...
by NickD
Mon Aug 28, 2017 1:13 pm
Forum: Technical / Scripting
Topic: Struggling to Insert Data with DBConnect
Replies: 2
Views: 2445

Re: Struggling to Insert Data with DBConnect

Hi Djek,

It was the double quotes, working fine now thanks :)
by NickD
Sun Aug 27, 2017 10:57 am
Forum: Technical / Scripting
Topic: Struggling to Insert Data with DBConnect
Replies: 2
Views: 2445

Struggling to Insert Data with DBConnect

I am trying to use a MySQL database to store data created in a dialog macro I wrote. I can connect to the database, but when I try to INSERT, I get an error telling me that a parameter object in the DBExec line is improperly defined. Let>MySQLTable=PostContent Let>MySQLServer=xxx.xxx.xx.xx Let>MySQL...
by NickD
Tue Aug 22, 2017 11:39 am
Forum: Technical / Scripting
Topic: Possible to get file path from dialog file browse button?
Replies: 1
Views: 1768

Re: Possible to get file path from dialog file browse button

Never mind, found the path included in the file name var.
by NickD
Tue Aug 22, 2017 10:34 am
Forum: Technical / Scripting
Topic: Possible to get file path from dialog file browse button?
Replies: 1
Views: 1768

Possible to get file path from dialog file browse button?

Hi, just wondered if its possible to return the file path for the selected file with the File Browse dialog included in the sample scripts folder?
by NickD
Wed Aug 16, 2017 9:38 pm
Forum: Technical / Scripting
Topic: Struggling With Dialog In a Loop
Replies: 2
Views: 2888

Re: Struggling With Dialog In a Loop

Thanks JRL, that was driving me crazy lol.
Great support as always :D
by NickD
Wed Aug 16, 2017 8:40 pm
Forum: Technical / Scripting
Topic: Struggling With Dialog In a Loop
Replies: 2
Views: 2888

Struggling With Dialog In a Loop

I have a script which parses a row from a csv file containing a url for an image, then displays the image in a dialog with fields allowing me to tag the images color and write a description for the image, this info is saved to another csv file and them the script Loops and pulls the next row. The pr...
by NickD
Thu Jun 15, 2017 4:23 pm
Forum: Technical / Scripting
Topic: How To Strip @ Symbol From Var
Replies: 2
Views: 2421

Re: How To Strip @ Symbol From Var

Figured it out thanks to a post Marcus made:

Let>NewHandle=%OrigiVar%
Let>trimmatch=@
RegEx>trimmatch,NewHandle,0,matches,numMatches,1,,NewVar

MessageModal>%NewVar%
by NickD
Thu Jun 15, 2017 3:05 pm
Forum: Technical / Scripting
Topic: How To Strip @ Symbol From Var
Replies: 2
Views: 2421

How To Strip @ Symbol From Var

Hi Guys, I have a list of vars saved in a .ini, the vars all begin with "@": [Myvarlist] 1=@apples 2=@oranges 3=@banannas The script calls var 1, on loop one, var 2 on loop 2 ect, and they are already used in my script for one purpose, which requires the @ symbol, but I need to use them again later ...
Sign up to our newsletter for free automation tips, tricks & discounts