Changes so far in this version:

[FEATURE] Client/Server: Azure->Added SAS token support (VSPS-282)
[FEATURE] Client/Server: Excel Convert->Added Start/End row support (VC-1528)
[FEATURE] Client/Server: Excel Convert->Added Password support (VC-1575)
[FEATURE] Client/Server: Triggers->Added new "Folder Trigger" (VC-655)
[FEATURE] Server: Error handling->Now logging if communication port is being used (VC-2197)
[FEATURE] Server: HTTP REST Trigger->Added support for waiting with response for Job/Task to fininish first (VC-2255)
[FEATURE] Client: Font->Now users can select Font to use in Client->File->Client settings (VC-2125)
[FEATURE] Client/Server: Variables->Added various new Math Variables (VC-1869)
[FEATURE] Client/Server: Powershell->Added stack trace on error to output (VC-2271)
[FEATURE] Client: Log->Added Execution time column on Task row (VC-2277)
[BUGFIX] Server: SQL Task->Fixed better validation of input/output direction values (VC-2234)
[BUGFIX] Server: Cloud Sync->Fixed cast error from TElGoogleDocument to TElGoogleDriveFolder error (VSPS-290)
[BUGFIX] Client: SQL Trigger->Fixed duplicate stored procedure error (VC-2237)
[BUGFIX] Client/Server: Memory leak->Fixed memory leak on failing Client connections (VC-2215)
[BUGFIX] Client: Output window->Fixed InvalidOperationException (VC-2233)
[BUGFIX] Client: Output window->Fixed some positioning of text (VC-2225)
[BUGFIX] Client: Job report->Fixed issues with checkboxes in settings (VC-2227)
[BUGFIX] Server: Azure Gen 2->Added different listing routine for blobs (VSPS-292)
[BUGFIX] Client: SQL Trigger->Optimized loading of stored procedures (VC-2241)
[BUGFIX] Client: Azure->Adding missing dll to installing (Microsoft.Bcl.AsyncInterfaces.dll) (VC-2250)
[BUGFIX] Client: Performance->Various performance optimization work in Client (VC-2221)
[BUGFIX] Client/Server: Google Drive->Fixed auth issues (VSPS-294)
[BUGFIX] Client/Server: Web macro Task->Fixed issue with lingering sub process (VC-2257)
[BUGFIX] Client: HTML output->Fixed adding html tags if missing (VC-2127)
[BUGFIX] Client: Google auth->Fixed browser issue (VC-2244)
[BUGFIX] Client/Server: Exchange EWS->Fixed auth issue (VSPS-297,VC-1206)
[BUGFIX] Client: Web macro/browser->Fixed problem opening/hanging under limited user account (VC-2209,VC-2207)
[BUGFIX] Client/Server: .NET code Task->Fixed issue with temp file error while opening Task (VC-2260)
[BUGFIX] Client/Server: Amazon S3->Region changes and exception logging added (VSPS-279)
[BUGFIX] Client/Server: HTTP REST Trigger->Added regex alternative for url (VC-2255)
[BUGFIX] Client/Server: SQL Task/Trigger->Fixed bit data type validation issue for stored procedures (VSPS-302)
[BUGFIX] Client/Server: SQL Task->Fixed issue calling stored procedures in Oracle->ODBC (VC-2238)
[BUGFIX] Client: Fonts->Fixed issue with missing Roboto font and possibility to select own font (VC-2125)
[BUGFIX] WebClient: Next run->Fixed time zone issue (VC-2283)
[BUGFIX] Server: Crystal reports->Fixed ODBC crash when many Tasks ran at the same time (VC-2282)
[BUGFIX] Client: SQL Task->Handled possible duplicate stored procedure names (VC-2237)

https://drive.google.com...-U5I7BF/view?usp=sharing 

---

Hi

There is a bug in this version in the task that converts Excel to textfile.

This is the excel file I tested with:


I convert by selecting column 1-5:


It produces this:

Hi

There is a bug in the procedure task where it gets boolean (bit) flags wrong. To reproduce:

Create a procedure like this:



Call the proc with false as param:


Result:


If I change param to true, it still returns true. This is also a bug in 9.7.5

Hi

There is a bug in the procedure task where it gets boolean (bit) flags wrong. To reproduce:

Create a procedure like this:

CREATE PROC dbo.p_test (@input BIT)
AS
BEGIN
	SELECT @input
END;

Call the proc with false as param:


Result:


If I change param to true, it still returns true. This is also a bug in 9.7.5

Hi Thomas,

Thanks!

Please try our latest build and see if it works better for you with the SQL one (The excel hasn't been fixed yet)

---

Thanks Michael

I will test as soon as both have been fixed. We need both before we can consider upgrading

Hi

There is a bug in this version in the task that converts Excel to textfile.

This is the excel file I tested with:


I convert by selecting column 1-5:


It produces this:

Hi Thomas,

I am unable to reproduce this. Can you mail us your job and a sample excel file you used to reproduce this issue? support@visualcron.com

---

Hi Michael

I just tested again. When I upgrade from 9.7.0 to 9.8.0 it fails. However if I open the Convert task, change a setting (anything), save, and the reset those changes, it works. It seems the task needs to be refreshed. So if you want to reproduce, you will have to make the job in 9.7.0 and then upgrade to 9.8.0. If you run the job without making any changes it should fail.

I guess we can get around it by refreshing the few excel tasks we have, but it could affect others

Edit:

I exported the job xml before and after refresh. Here is a image of the difference between the jobs (before on the left side)

Hi Michael

I just tested again. When I upgrade from 9.7.0 to 9.8.0 it fails. However if I open the Convert task, change a setting (anything), save, and the reset those changes, it works. It seems the task needs to be refreshed. So if you want to reproduce, you will have to make the job in 9.7.0 and then upgrade to 9.8.0. If you run the job without making any changes it should fail.

I guess we can get around it by refreshing the few excel tasks we have, but it could affect others

Edit:

I exported the job xml before and after refresh. Here is a image of the difference between the jobs (before on the left side)

Thanks for the information, I could reproduce when doing it that way. It should be fixed in the official 9.8.0 release which we plan on releasing shortly, tomorrow or early next week most likely.

---