List of Contributions

Jane Dobbs

Contact Details

My Content

1 to 10 of 10 total

RE: Trigger Query from Power Automate

Posted By Jane Dobbs 05-27-2026 13:38
Found In Egroup: Automate \ view thread
RESULTS added the -alf"C:\Secure\SAPLogin.alf" with an without tms PS C:\Users\dob0024> & "C:\Program Files\Winshuttle\Studio\Winshuttle.Studio.Console.exe" ` -SapQuery ` -run"MARA SQL Import" ` -lib"Qxq lib" ` -tms"SPS" ` -alf"C:\Secure\SAPLogin.alf" PS C:\Users\dob0024> & "C:\Program File ...

RE: Trigger Query from Power Automate

Posted By Jane Dobbs 05-27-2026 10:50
Found In Egroup: Automate \ view thread
I am now trying a PowerShell script but it's not returning any records: This script is a Query that is a direct update to a SQL Table. $exe = "C:\Program Files\Winshuttle\Studio\Winshuttle.Studio.Console.exe" $args = @( "-SapQuery", "-run `"MARA SQL Import`"", "-lib `"Qxq lib`"", "-tms `"SPS`"" ...

Trigger Query from Power Automate

Posted By Jane Dobbs 05-26-2026 11:18
Found In Egroup: Automate \ view thread
I have Query that updates a SQL table that I would like to trigger using Power Automate. is this possible? ------------------------------ Jane Dobbs Canadian Pacific Railway ------------------------------

How to enable the Schedule and Chain Scripts in Admin to work with SQL Server

Posted By Jane Dobbs 03-20-2026 09:14
Found In Egroup: Automate \ view thread
I have a direct query to my SQL server tables and want to set both a schedule and chain scripts but don't know how to enable. The updates work, just want to set schedules etc. Scripts with Excel and Access DB are enabled. Jane ------------------------------ Jane Dobbs Specialist Supply ...

RE: Data Connections in Drop downs - Can you merge the values for a drop down?

Posted By Jane Dobbs 03-04-2026 08:47
Found In Egroup: Automate \ view thread
Hi Carmen, you can create a calculated column in the SQL table using concat() or & between the values you want to combine:. ------------------------------ Jane Dobbs Specialist Supply Chain Canadian Pacific Railway Calgary AB ------------------------------

RE: Date data type downloading to SQL Server

Posted By Jane Dobbs 02-26-2026 16:34
Found In Egroup: Automate \ view thread
Now have an issue with the (EKBE) "Time of Entry" I have it set to time(7) in SQL I have tried DateTime, TimeStamp and nothing works, get this error. the first issues were resolved by: The SQL Date column datatype has to be set to DateTime. ------------------------------ Jane Dobbs Specialist ...

Date data type downloading to SQL Server

Posted By Jane Dobbs 02-25-2026 10:31
Found In Egroup: Automate \ view thread
I am downloading EKKO directly to a SQL Server table with Created On and Document Date. I am getting this error: the SQL table is a basic import to table; the Winshuttle preview shows the dates when I look at my SQL import table the dates look like: any insight on what I need ...

RE: BAPI_CONTRACT_CREATE issues

Posted By Jane Dobbs 02-24-2026 10:46
Found In Egroup: Automate \ view thread
My goodness... saw the N and totally missed the upload portion, thank you... However, it was created but still getting an error message " PurchasingContract 6500000171 has been created. External reference: Start of validity period is in the past No message generated for output of purchasing document ...

BAPI_CONTRACT_CREATE issues

Posted By Jane Dobbs 02-23-2026 05:39
Found In Egroup: Automate \ view thread
I am getting this errors: " No instance of object type PurchasingContract has been created. External reference: # 1 Start of validity period is in the past Error transferring ExtensionIn data for enhancement CI_EKPODB Please enter material number or account assignment category Unit of measure not defined ...

BAPI_CONTRACT_CREATE issues

Posted By Jane Dobbs 02-20-2026 14:03
Found In Library: Automate