Automate

I have a v12 Winshuttle Composer form with multiple views.   On one view, for example, a drop down list of sales reps is populated from a sql-server table of about 40 entries and is filtered based on the division chosen previously.   This is done via the drop down choices menu -> Get Choices -> From Data Connection.   The data connection is a -> Database (Microsoft (SQL Server)) -> automatically retrieve data when form is opened, filter data on KNVW_SPART = Division(field on form).    

This works 75% of the time.   The sales admin fills the form, chooses the correct sales rep and other data and presses continue to route the form.   Then, when the master data team opens the form, the sales rep field is SOMETIMES in error with "invalid sales rep" and if you press the drop down list - NOTHING appears.   If they press REFRESH on the browers (sometimes once, sometimes 2-3 times) the error goes away, the choice is filled with the entry that the sales admin chose, and all the other entries are populated.     WEIRD!

This happens with TWO OTHER drop down fields populated by data connection, rather than hard coded.     I even rewrote the code with WS Query elements that load the entire table into a repeating table element and populate the drop downs from that.   That works 100% of the time for the dropdowns, but then the other fields in the form that use WS Query elements no longer work.   WEIRD!    Very glitchy.

Is it a memory issue?   The composer solution file is 8.4MB.   It glitches if i have one program open or 20.  and only happens about 25% of the time.   Is it a setting in foundation?    Please help or share similar experiences.   Thank you.      The same exact (relatively exact) code works fine in Winshuttle 10.6 with infopath.

------------------------------
Robert Zsedely | Business Architect
Seneca Foods Corporation | Marion, NY |
------------------------------

Hi Robert
If I have a data connection with data that is used in rules, I tend to preload it.  


------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 07-30-2020 08:36
From: Robert Zsedely
Subject: Winshuttle Composer Form - GLITCHES! - not preloading drop downs with external data

I have a v12 Winshuttle Composer form with multiple views.   On one view, for example, a drop down list of sales reps is populated from a sql-server table of about 40 entries and is filtered based on the division chosen previously.   This is done via the drop down choices menu -> Get Choices -> From Data Connection.   The data connection is a -> Database (Microsoft (SQL Server)) -> automatically retrieve data when form is opened, filter data on KNVW_SPART = Division(field on form).

This works 75% of the time.   The sales admin fills the form, chooses the correct sales rep and other data and presses continue to route the form.   Then, when the master data team opens the form, the sales rep field is SOMETIMES in error with "invalid sales rep" and if you press the drop down list - NOTHING appears.   If they press REFRESH on the browers (sometimes once, sometimes 2-3 times) the error goes away, the choice is filled with the entry that the sales admin chose, and all the other entries are populated.     WEIRD!

This happens with TWO OTHER drop down fields populated by data connection, rather than hard coded.     I even rewrote the code with WS Query elements that load the entire table into a repeating table element and populate the drop downs from that.   That works 100% of the time for the dropdowns, but then the other fields in the form that use WS Query elements no longer work.   WEIRD!    Very glitchy.

Is it a memory issue?   The composer solution file is 8.4MB.   It glitches if i have one program open or 20.  and only happens about 25% of the time.   Is it a setting in foundation?    Please help or share similar experiences.   Thank you.      The same exact (relatively exact) code works fine in Winshuttle 10.6 with infopath.

------------------------------
Robert Zsedely | Business Architect
Seneca Foods Corporation | Marion, NY |
------------------------------

Thanks for the tips.   Winshuttle engineering was on with me yesterday.   Since I had "automatically retrieve data on form load" checked, they believe that the asynchronous load of data was not happening prior to page load due to sql server being on a different location than the server for sharepoint.  I will recode that way and let you folks here know.

Joshua Whitener - Glad to hear from you.  You've helped me in the past thru Winshuttle support with 10.6.   Thanks!   I see you are with the oil company I spent 23 years with (chemical then downstream, SAP support).   What location are you at?

------------------------------
Robert Zsedely | Business Architect
Seneca Foods Corporation | Marion, NY |
------------------------------

Original Message:
Sent: 07-30-2020 17:47
From: Sigrid Kok
Subject: Winshuttle Composer Form - GLITCHES! - not preloading drop downs with external data

Hi Robert
If I have a data connection with data that is used in rules, I tend to preload it.

part of that will depend on how big the dataset is, of course, but perhaps you could try it?

HTH
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 07-30-2020 08:36
From: Robert Zsedely
Subject: Winshuttle Composer Form - GLITCHES! - not preloading drop downs with external data

I have a v12 Winshuttle Composer form with multiple views.   On one view, for example, a drop down list of sales reps is populated from a sql-server table of about 40 entries and is filtered based on the division chosen previously.   This is done via the drop down choices menu -> Get Choices -> From Data Connection.   The data connection is a -> Database (Microsoft (SQL Server)) -> automatically retrieve data when form is opened, filter data on KNVW_SPART = Division(field on form).

This works 75% of the time.   The sales admin fills the form, chooses the correct sales rep and other data and presses continue to route the form.   Then, when the master data team opens the form, the sales rep field is SOMETIMES in error with "invalid sales rep" and if you press the drop down list - NOTHING appears.   If they press REFRESH on the browers (sometimes once, sometimes 2-3 times) the error goes away, the choice is filled with the entry that the sales admin chose, and all the other entries are populated.     WEIRD!

This happens with TWO OTHER drop down fields populated by data connection, rather than hard coded.     I even rewrote the code with WS Query elements that load the entire table into a repeating table element and populate the drop downs from that.   That works 100% of the time for the dropdowns, but then the other fields in the form that use WS Query elements no longer work.   WEIRD!    Very glitchy.

Is it a memory issue?   The composer solution file is 8.4MB.   It glitches if i have one program open or 20.  and only happens about 25% of the time.   Is it a setting in foundation?    Please help or share similar experiences.   Thank you.      The same exact (relatively exact) code works fine in Winshuttle 10.6 with infopath.

------------------------------
Robert Zsedely | Business Architect
Seneca Foods Corporation | Marion, NY |
------------------------------

Wow, that's quite the stint. I'm at Hughes Landing.

Interesting, we have our reference databases on the same server as SharePoint databases, but given that the data connection is agnostic to the location that's odd it affects the return. We have reference tables with hundreds of thousands of rows feeding drop downs with almost instant return, however I did have to add indentity columns and a primary key to optimize performance from SQL, otherwise it was orders of magnitude slower.

------------------------------
Joshua Whitener | Technical Advisor
Exxon Mobil Corporation | 8326258441
------------------------------

Original Message:
Sent: 07-31-2020 08:39
From: Robert Zsedely
Subject: Winshuttle Composer Form - GLITCHES! - not preloading drop downs with external data

Thanks for the tips.   Winshuttle engineering was on with me yesterday.   Since I had "automatically retrieve data on form load" checked, they believe that the asynchronous load of data was not happening prior to page load due to sql server being on a different location than the server for sharepoint.  I will recode that way and let you folks here know.

Joshua Whitener - Glad to hear from you.  You've helped me in the past thru Winshuttle support with 10.6.   Thanks!   I see you are with the oil company I spent 23 years with (chemical then downstream, SAP support).   What location are you at?

------------------------------
Robert Zsedely | Business Architect
Seneca Foods Corporation | Marion, NY |

Original Message:
Sent: 07-30-2020 17:47
From: Sigrid Kok
Subject: Winshuttle Composer Form - GLITCHES! - not preloading drop downs with external data

Hi Robert
If I have a data connection with data that is used in rules, I tend to preload it.

part of that will depend on how big the dataset is, of course, but perhaps you could try it?

HTH
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Original Message:
Sent: 07-30-2020 08:36
From: Robert Zsedely
Subject: Winshuttle Composer Form - GLITCHES! - not preloading drop downs with external data

I have a v12 Winshuttle Composer form with multiple views.   On one view, for example, a drop down list of sales reps is populated from a sql-server table of about 40 entries and is filtered based on the division chosen previously.   This is done via the drop down choices menu -> Get Choices -> From Data Connection.   The data connection is a -> Database (Microsoft (SQL Server)) -> automatically retrieve data when form is opened, filter data on KNVW_SPART = Division(field on form).

This works 75% of the time.   The sales admin fills the form, chooses the correct sales rep and other data and presses continue to route the form.   Then, when the master data team opens the form, the sales rep field is SOMETIMES in error with "invalid sales rep" and if you press the drop down list - NOTHING appears.   If they press REFRESH on the browers (sometimes once, sometimes 2-3 times) the error goes away, the choice is filled with the entry that the sales admin chose, and all the other entries are populated.     WEIRD!

This happens with TWO OTHER drop down fields populated by data connection, rather than hard coded.     I even rewrote the code with WS Query elements that load the entire table into a repeating table element and populate the drop downs from that.   That works 100% of the time for the dropdowns, but then the other fields in the form that use WS Query elements no longer work.   WEIRD!    Very glitchy.

Is it a memory issue?   The composer solution file is 8.4MB.   It glitches if i have one program open or 20.  and only happens about 25% of the time.   Is it a setting in foundation?    Please help or share similar experiences.   Thank you.      The same exact (relatively exact) code works fine in Winshuttle 10.6 with infopath.

------------------------------
Robert Zsedely | Business Architect
Seneca Foods Corporation | Marion, NY |
------------------------------

Try placing a reload drop down rule on the view. It sounds like options for the drop down aren't saving or something in the engine is clearing them. It's generally not a memory or size issue, 8 MB for a Composer soltuion is tame, even for older machines with low memory.

------------------------------
Joshua Whitener | Technical Advisor
Exxon Mobil Corporation | 8326258441
------------------------------

Original Message:
Sent: 07-30-2020 08:36
From: Robert Zsedely
Subject: Winshuttle Composer Form - GLITCHES! - not preloading drop downs with external data

I have a v12 Winshuttle Composer form with multiple views.   On one view, for example, a drop down list of sales reps is populated from a sql-server table of about 40 entries and is filtered based on the division chosen previously.   This is done via the drop down choices menu -> Get Choices -> From Data Connection.   The data connection is a -> Database (Microsoft (SQL Server)) -> automatically retrieve data when form is opened, filter data on KNVW_SPART = Division(field on form).

This works 75% of the time.   The sales admin fills the form, chooses the correct sales rep and other data and presses continue to route the form.   Then, when the master data team opens the form, the sales rep field is SOMETIMES in error with "invalid sales rep" and if you press the drop down list - NOTHING appears.   If they press REFRESH on the browers (sometimes once, sometimes 2-3 times) the error goes away, the choice is filled with the entry that the sales admin chose, and all the other entries are populated.     WEIRD!

This happens with TWO OTHER drop down fields populated by data connection, rather than hard coded.     I even rewrote the code with WS Query elements that load the entire table into a repeating table element and populate the drop downs from that.   That works 100% of the time for the dropdowns, but then the other fields in the form that use WS Query elements no longer work.   WEIRD!    Very glitchy.

Is it a memory issue?   The composer solution file is 8.4MB.   It glitches if i have one program open or 20.  and only happens about 25% of the time.   Is it a setting in foundation?    Please help or share similar experiences.   Thank you.      The same exact (relatively exact) code works fine in Winshuttle 10.6 with infopath.

------------------------------
Robert Zsedely | Business Architect
Seneca Foods Corporation | Marion, NY |
------------------------------