Search found 10 matches

Search found 10 matches Page 1 of 1
by WallyD444
Wed Sep 02, 2015 6:51 pm
Forum: Community Forum
Topic: Increment Variable by Row
Replies: 1
Views: 6611

I have a project that will concantenate a few columns to form a url, I need a unique value for each row. Currently I'm using the modify column task, but I can't figure out how to create a counter for the unique value. e.g.: column 1 column 2 column 3 column 4 www .testing.com/ 0001 www.testing.com/0...
by WallyD444
Tue Jul 14, 2015 11:26 am
Forum: Community Forum
Topic: isnumber Function
Replies: 2
Views: 6777

Perfect, thank you!!
by WallyD444
Mon Jul 13, 2015 1:57 pm
Forum: Community Forum
Topic: isnumber Function
Replies: 2
Views: 6777

Is there a comparable function to isnumber in GAD? I'm trying to base an if statement on whether the variable returned is a number (0-9), I've tried this: ${decimal(fnameChar)==1 OR decimal(fnameChar)==2 OR decimal(fnameChar)==3 OR decimal(fnameChar)==4 OR decimal(fnameChar)==5 OR decimal(fnameChar)...
by WallyD444
Thu Jul 02, 2015 12:08 pm
Forum: Community Forum
Topic: Check if a variable exists
Replies: 12
Views: 25088

Thanks Rick, that worked perfectly!
by WallyD444
Wed Jul 01, 2015 7:50 am
Forum: Community Forum
Topic: Check if a variable exists
Replies: 12
Views: 25088

I'm trying the same thing, I have a variable 'fileList' that is a filelist and I'm receiving this error: [8099 - Create File List] An unexpected error occurred. Function 'IsEmpty': Parameter '1' must be a string value. Function definition: 'IsEmpty(text) returns boolean' here is my XML: <project nam...
by WallyD444
Thu Mar 26, 2015 9:39 am
Forum: Community Forum
Topic: Spreadsheet with two title lines...
Replies: 3
Views: 9010

It may be a helpful feature in a future release to allow multiple titles, that way we can pass variables through without having to use a template.
by WallyD444
Mon Nov 17, 2014 4:49 pm
Forum: Community Forum
Topic: SQL Server Stored Proc Execution
Replies: 4
Views: 9177

Hi, I have GA Director 4.1.1, and it's giving an "Invalid SQL statement" error trying to execute a stored procedure: <project name="Database Exec Test1" mainModule="Main" version="2.0" logLevel="normal" threadSafe="true"> <module name="Main"> <sql label="DBConnection" resourceId="WORK" autoCommit="t...
by WallyD444
Fri Oct 03, 2014 7:40 am
Forum: Community Forum
Topic: Cannot get a text value from a error cell
Replies: 3
Views: 6706

Thanks Rick, I've emailed the log and XML to [email protected]

-josh
by WallyD444
Thu Oct 02, 2014 8:45 am
Forum: Community Forum
Topic: Cannot get a text value from a error cell
Replies: 3
Views: 6706

I'm receiving the following error when converting a .xlsx file to .csv using the "Read Excel File" and "Write to CSV" tasks when the .xlsx file contains cells with value #N/A: "Cannot get a text value from a error cell" I've set "Skip Invalid Records" to "True", but that doesn' t help. Here is the p...
by WallyD444
Fri Sep 19, 2014 2:18 pm
Forum: Community Forum
Topic: Excel template fails
Replies: 1
Views: 4469

I have created a project that will select data from a table in an oracle DB and create an excel attachment and send it in an email. The job worked great, until I attempted to use a template. I had some data manipulation in the template, creating percentages from the gathered rows, however when I ran...
Search found 10 matches Page 1 of 1