Issue
Issue No
Issue Name
Issue Description
Response
Submitted by ReAssign To
Date Submitted Priority
Expected Date New Status
Version In Version
Orig Assigned To Billable
Now Assigned To Customer
Priority Customer Status
Status Customer Product
Billable Next Action Date  
Customer Contact Information (When Applicable)
Customer Added
Name
Phone Number
Email Address

Issue Documents
Document Upload/Delete Documents List Attached To This Issue

 


(Select File To Delete From List)
26394_AddControlFlag_2264.txt
26394_CreateDispatchTables.txt
26394_CreateView_vw_DispatchBoard.txt
26394_CreateView_vw_DispatchBoardAssigned.txt
26394_Create_SP_GetDispatchWFCustomColumnsBoardDefaults.txt
26394_Create_SP_GetDispatchWorkflowBoardNewData.txt
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_0412.txt
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_06172024.txt
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_10252023.txt
26394_Insert_tbl_UsersAux.txt
26394_Insert_tbl_WFCustomDispatchBoardColumns_08172023.txt
26394_Insert_tbl_WFCustomDispatchBoardColumns_newcolumns_09122023.txt
26394_update_tbl_WFCustomDispatchBoardColumns_06172024.txt
CSADatatables_New.js
DispatchBoardDeleteColumn1.PNG
dispatchBoardWithNewcolumns1.PNG
DispatchDefaultsBoard1.PNG
DispatchDefaultsUserSetup1.PNG
DispatchIconSelectedAnd1Dispatched.PNG
DispatchWorkflow1.PNG
DispatchWorkflow2.PNG
DispatchWorkflowBoardDefaults1.PNG
DispatchWorkflowBoard_update1.PNG
DispatchWorkflowcheckBoxes1.PNG
DispatchWorkflowcheckBoxesAlignment.PNG
DispatchWorkflow_checkbox_alignement.PNG
DispatchWorkflow_newcolumns.PNG
DispatchWorkflow_select_addshipment.PNG
HAWB-403067_Search_1.PNG
HAWB-403067_Search_2.PNG
HAWB-403067_Search_3.PNG
Housebill_14347_ReturnToDispatch_NoTruncationNoClearing.PNG
Housebill_14347_search_1.PNG
Housebill_14347_updateshipment.PNG
jquery.dataTables.yadcf_New.js
OrderNo_52570_Dispatch_edit_DI.PNG
OrderNo_52570_Dispatch_edit_DLV.PNG
OrderNo_52570_Dispatch_edit_DR.PNG
OrderNo_52570_Dispatch_edit_PU.PNG
OrderNo_52570_Dispatch_edit_RE.PNG
OrderNo_52570_Dispatch_MultipleMoves1.PNG
OrderNo_55765_GoToCostBilling.PNG
OrderNo_Dispatch_3_checkboxes.PNG
OrderNo_ReturnTodispatchBoardandSelect1.PNG
ShipmentEdit_EquipmentType.PNG
Snap_dispatchCategory_CustomBoardSetting.PNG
UserPage_1.PNG
UserPage_2.PNG
UserPage_3.PNG
UserPage_4.PNG
UserPage_Maint1.PNG
UserPage_Maint2.PNG


Response History
ByDateCustomer
Can View
 Note Status?ResponseAssigned ToPriorityStatus 
Nick Schubert 6/18/2024 11:02:26 AM NO Looks good on 162. Per Ray, this change is already in 04/12. Waiting for Release High Waiting for Release
Ray Ciccone 6/18/2024 10:15:00 AM NO works as expected. Good for 162 Nick Schubert High Ready For Testing
Nathan Palmer 6/17/2024 6:35:56 PM NO Ray Ciccone High Ready For Testing
Ray Ciccone 6/17/2024 5:35:30 PM NO Changeset 73105

AirTrak/Main/Maintenance/WFCategory/GenerateDispatchWorkflowView.vb

fixes small bug on 162
Nathan Palmer High Merge to 79/162
Nick Schubert 6/17/2024 5:16:29 PM NO Ray - Something is still off on 162. Looks at the 'rayD1' board.

The columns are showing the wrong data. It seems like the BillNo column info isn't showing, and every other column's data is off by one row and shifted to the left.
Ray Ciccone High Questions
Ray Ciccone 6/17/2024 5:09:07 PM NO see attached:

26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_0412.txt

Got from SNAP
Nick Schubert High Ready For Install
Nick Schubert 6/17/2024 5:04:40 PM NO Tested on 162 and at 3 Way and everything looks good.

Added updated stored proc to the 04/12 PRS folder. I also updated 'Seq#' to 'ManifestSeq#'. Script attached and added to 04/12 PRS folder.

26394_update_tbl_WFCustomDispatchBoardColumns_06172024.txt
Waiting for Release High Waiting for Release
Nick Schubert 6/17/2024 4:45:34 PM NO Taking back. The 162 and 04/12 versions should be in sync. Nick Schubert High Ready For Testing
Nick Schubert 6/17/2024 2:58:02 PM NO Thanks Ray! Can you please grab the latest stored proc from Snap or Three Way and give me a 04/12 version of the script? Ray Ciccone High Questions
Ray Ciccone 6/17/2024 2:54:46 PM NO There was an error in store procedure: GetDispatchWorkflowBoard_GenerateView

See attached
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_06172024.txt

Works now on 162
Nick Schubert High Ready For Testing
Nick Schubert 6/17/2024 11:25:32 AM NO Ray - On 162 and in 04/12 when using Seq# (ManifestSeqNo) nothing is showing up on the workflow board.

Tested on 162 with 'rayD1'. Please review but do NOT bill your time.
Ray Ciccone High Questions
Nathan Palmer 3/19/2024 7:46:05 PM NO Merged to 4/12. Brian Cronin Highest Ready For Install
Nathan Palmer 3/19/2024 7:37:29 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 3/19/2024 3:02:34 PM NO Changeset 71995

AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 3/19/2024 1:02:06 PM NO Ray Ciccone Highest In progress
Nick Schubert 3/19/2024 12:46:40 PM NO FYI - I was able to duplicate this on Axis Test as well. We can test there once you have a fix.

Also, please do not bill any more time for this.
Ray Ciccone Highest Priority
Nick Schubert 3/19/2024 12:42:36 PM NO Ray - The issue from 11/27/2023 is happening again. I just forwarded you an email on how they made this happen in 04/12, but it's also not working in 162.


Go to any dispatch workflow board on 162.

-Check the complete dispatch box for one shipment.

-Then check the button under the complete dispatch button which selects all shipments on the page.

-Click the same button to uncheck all shipments on the page.

-Now check off a single shipment again and click the complete dispatch button. It will still mark all shipments on the page complete instead of just the single shipment. Please review and fix.
Ray Ciccone Highest Priority
Brian Cronin 11/28/2023 2:49:05 PM NO installed on shared server - STAGING - looks good. Asked the customer to try. Brian Cronin Highest Waiting on Feedback
Nathan Palmer 11/28/2023 2:29:11 PM NO Merged to test and 4/12. Brian Cronin Highest Ready For Install
Ray Ciccone 11/28/2023 11:14:20 AM NO Changeset 70746
AirTrak\Main\Operations\ShipmentBoard\DispatchWorkflowBoard_Cache.aspx

Notes:
Needed to add the resetDispatchcheckBoxes function when the 'Search' button is clicked as well as reset button. will need to clear browser cache to test.
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 11/27/2023 5:05:37 PM NO Ray Ciccone Highest In progress
Brian Cronin 11/27/2023 5:02:25 PM NO I sent you another email with an issue. Please review and knock this out ASAP.

"Problem: Checkboxes on the Dispatch Workflow board "stick" after making a selection, searching, and then making a new selection and attempting to dispatch, complete, or clear an order.

Steps to reproduce:

Navigate to dispatch workflow. Set your filters to All, and the customer to test.

Check all boxes in a column.

Select the Search Button

Select a single box, then select the dispatch cart.

Note how the orders are incorrectly dispatched."
Ray Ciccone Highest Priority
Brian Cronin 11/27/2023 11:47:02 AM NO they confirmed it is working for them too. So strange. Waiting for Release Highest Waiting for Release
Brian Cronin 11/27/2023 11:35:13 AM NO I cannot make it happen anymore. I will ask them to try again. Brian Cronin Highest Waiting on Feedback
Ray Ciccone 11/27/2023 11:29:50 AM NO I tested on shared server for Snap.
See screenshots:
HAWB-403067_Search_1.PNG (search on HAWB)
HAWB-403067_Search_2.PNG (go to cost page)
HAWB-403067_Search_3.PNG (after hit shipments tab again)

I've searched for each newer grid boards. It works as expected with no truncation. (May have to clear cache, since this is a JavaScript change).

Now if you search on 'File No', it still works, it's just that the search box is narrow and does not show the complete shipment number, but it's not truncated. you can place cursor and move over with arrow key; you will see complete number). If that's what they're seeing, we can expand the search box. I may have to add some JavaScript to page to make it bigger.
Brian Cronin Highest Questions
Ray Ciccone 11/27/2023 10:39:39 AM NO Ray Ciccone Highest In progress
Brian Cronin 11/22/2023 9:13:22 AM NO Ray - 04/12 release - Snap (on the shared server) - The issue with the HAWB# filter is back again. a few weeks back on this ticket, you stated the following:

"the truncate issue showed up on this ticket back on 9/30. I updated on 10/3."


See attached (2 files):
CSADatatables_New.js
jquery.dataTables.yadcf_New.js

Please fix.
Ray Ciccone Highest Priority
Brian Cronin 11/9/2023 10:24:37 AM NO Brian Cronin Highest Ready For Install
Ray Ciccone 11/9/2023 10:21:59 AM NO Changeset 70507 for 04/12 has the same code as Changeset 70506 (162). I separated them to separate any possible changes which would affect the grid data-icons. Brian Cronin Highest Ready For Testing
Ray Ciccone 11/9/2023 10:01:21 AM NO yes, I will test on 162 Brian Cronin Highest Questions
Brian Cronin 11/9/2023 9:19:22 AM NO Ray - I see that you fixed #1 for 162. Were 2 and 3 fixed as well? Ray Ciccone Highest Questions
Nathan Palmer 11/8/2023 7:54:31 PM NO Merged to 4/12. Brian Cronin Highest Ready For Install
Nathan Palmer 11/8/2023 6:57:38 PM NO Ray Ciccone Highest Ready For Testing
Nathan Palmer 11/8/2023 3:28:21 PM NO Nathan Palmer Highest Merge to 79/162
Ray Ciccone 11/8/2023 3:22:13 PM NO 2 changesets, for 162 and 04/12 versions

162:
Changeset 70506
AirTrak/Main/Operations/ShipmentBoard/DispatchBoard_New.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

04/12:
Changeset 70507
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb
Nathan Palmer Highest Needs to be Merged
Ray Ciccone 11/7/2023 3:47:56 PM NO Ray Ciccone Highest In progress
Brian Cronin 11/7/2023 2:59:26 PM NO Installed on Axis TEST on 11/07 - 04/12 release. Still have problem. Please review:

1. icons missing from new boards:

a. Dispatch - Edit and Delete icons not showing - 11/07 - BC - GOOD

Note: on 162, the costs/billing, documents, and M icons are missing. - - 11/07 - BC - STILL A PROBLEM

b. Workflow - Milestone, icon before Clone, and clone icons don't show. - 11/07 - BC - GOOD

c. DispatchWF - Delete icon not showing. - 11/07 - BC - GOOD

d. DefaultNEW - Good for now - 11/07 - BC - GOOD



2. Dispatch Workflow Board - if you click 'Reset' - it seems to run the logic twice - the board refreshes - GOOD, but then refreshes again. - 11/07 - BC - SAME ISSUE - PLEASE FIX.

Note: This also changes some of the regular 'top' filters to blank. Example: If I go to defaultnew or WF, the 'Status' filter is blank and is showing active and history shipments. It blanks out other filters at the top too. - 11/07 - BC - SAME ISSUE - PLEASE FIX.

3. Also - This is still an issue:

Shared Server - 04/12 Release - Snap
HAWB 402060

Trying to dispatch the DL move from the Dispatch Workflow Board only results in that PU move being dispatched.
Ray Ciccone Highest Priority
Nathan Palmer 11/6/2023 6:31:42 PM NO Brian Cronin Highest Ready For Install
Ray Ciccone 11/6/2023 5:11:53 PM NO For 04/12 version only

Changeset 70479
AirTrak/JS/datatables/CSADatatables_New.js
AirTrak/Main/Operations/ShipmentBoard/DispatchBoard_New.aspx
Nathan Palmer Highest Branch - 04/12
Nick Schubert 11/6/2023 4:43:45 PM NO Ray - everything you did on the SS Worldtrak Staging looks good so far. Please check in your changes when ready. Ray Ciccone Highest Ready For Testing
Ray Ciccone 11/6/2023 4:29:08 PM NO Performed these 3 updates:

1 - On SS WorldTrakStaging, I copied in the older, correct CSADatatables_New.js file.
2 - Made a small change to the edit button data-icon to the
DispatchBoard_New.aspx page
3 - regenerated views for DispatchWorkflow

I tested all the workflow and new boards (and the Dispatch board). The data-icons appear as expected. Of course, when testing please refresh cache on browser.

Working on item 2 and then 162 issues

thanks
Brian Cronin Highest Ready For Testing
Ray Ciccone 11/6/2023 11:33:33 AM NO Examining changes for last week for 26394. When I updated the CSADatatables_New.js, I had a 'bright' idea to get the latest version for 04/12 code base and then add the changes necessary and that was the changeset I submitted to Nate to merge for 04/12. I compared that latest version with the previous that was on SS and there were quite a few differences. Sure enough it has hardcoded code in there to change some of the data-icons (like the delete icon, etc). To fix this, I have a copy of those previous JavaScript files, so we can copy those with proper updates. Sometimes, 'the 'best laid plans ...'. I am very sorry to have done this, I made a bad assumption that this would get everything up to date, just in case. Otherwise, I tested on 162, workflow data-icons are as expected. The Dispatch WF is as expected (the delete icon, will disappear based logic I grabbed from the regular workflow. Criteria is Status=H, ShipmentOnConsol=Y, CostsOrChargesFinalized=Y, InvoicesPrinted=Y. I can remove these if wanted. Ray Ciccone Highest In progress
Ray Ciccone 11/6/2023 10:26:21 AM NO Ray Ciccone Highest In progress
Brian Cronin 11/4/2023 9:21:48 AM NO Ray - I did what we talked about, but there are still some issues with the icons.

1. icons missing from new boards:

a. Dispatch - Edit and Delete icons not showing

Note: on 162, the costs/billing, documents, and M icons are missing.

b. Workflow - Milestone, icon before Clone, and clone icons don't show.

c. DispatchWF - Delete icon not showing.

d. DefaultNEW - Good for now

Need to make sure we fix the release on Monday.


2. Dispatch Workflow Board - if you click 'Reset' - it seems to run the logic twice - the board refreshes - GOOD, but then refreshes again.

Note: This also changes some of the regular 'top' filters to blankl. Example: If I go to defaultnew or WF, the 'Status' filter is blank and is showing active and history shipments. It blanks out other filters at the top too.
Ray Ciccone Highest Priority
Brian Cronin 11/4/2023 7:59:57 AM NO Ray - I installed the latest 04/12 release on the shared server this morning. Please review:

1. Dispatch Workflow Board - The delete icon is not showing properly. If you hover over it, you can see the tooltip, but the icon is just an empty square.

2. REGULAR dispatch board - All of the icons are just the 'empty square'.

3. Dispatch Workflow Board - if you click 'Reset' - it seems to run the logic twice - the board refreshes - GOOD, but then refreshes again.

Note: This also changes some of the regular 'top' filters to blankl. Example: If I go to defaultnew or WF, the 'Status' filter is blank and is showing active and history shipments. It blanks out other filters at the top too.

4. DefaultNew - All the icons are missing from here too.
Ray Ciccone Highest Priority
Brian Cronin 11/2/2023 11:22:43 AM NO these all look good on Axis TEST now. Brian Cronin Highest Ready For Install
Nathan Palmer 10/31/2023 7:59:01 PM NO Brian Cronin Highest Ready For Install
Ray Ciccone 10/31/2023 4:34:43 PM NO For 04/12 only.

Changeset 70391
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
(one line change)

Changeset 70392
AirTrak/JS/datatables/CSADatatables_New.js
AirTrak/JS/datatables/jquery.dataTables.yadcf_New.js
Nathan Palmer Highest Branch - 04/12
Nick Schubert 10/31/2023 4:23:42 PM NO Ray - Please let Nate know what he has to merge. Ray Ciccone Highest Questions
Ray Ciccone 10/30/2023 6:00:20 PM NO see attached:
DispatchWorkflowBoard_update1.PNG
Make sure to clear/refresh browser cache.

For items below, I was able to logon to Axis test server and sneak these changes in. I will update this ticket for changeset updates for Nate.

#1
I updated the javascript files:
CSADatatables_New.js
jquery.dataTables.yadcf_New.js

#2
Had to change the 'data-icon' for the DispatchWorkflowBoard_Cache.aspx page

#3
Just added the column 'Move' to RayTestD1 view setup and regenerated.
Nick Schubert Highest Ready For Testing
Ray Ciccone 10/30/2023 5:59:20 PM NO see attached:
DispatchWorkflowBoard_update1.PNG

For items below, I was able to logon to Axis test server and sneak these changes in. I will update this ticket for changeset updates for Nate.

#1
I updated the javascript files:
CSADatatables_New.js
jquery.dataTables.yadcf_New.js

#2
Had to change the 'data-icon' for the DispatchWorkflowBoard_Cache.aspx page

#3
Just added the column 'Move' to RayTestD1 view setup and regenerated.
Nick Schubert Highest Ready For Testing
Ray Ciccone 10/30/2023 5:40:13 PM NO Looks like some merge issues Ray Ciccone Highest In progress
Ray Ciccone 10/30/2023 5:32:23 PM NO Ray Ciccone Highest In progress
Nick Schubert 10/30/2023 12:22:37 PM NO More on #1, the test you ran on 162 is not working in 04/12. My test was board to board, but the same thing happens if you go to the update shipment, cost/billing page, tracking page, etc and then go back to the Dispatch Workflow board. Ray Ciccone Highest Questions
Nick Schubert 10/30/2023 12:17:36 PM NO Ray - I'm seeing some issues in 04/12 on Axis Test that I'm not seeing on 162. Please review and let me know if you see any merge issues.

1. I searched for 723125120 in the HAWB column in Dispatch Workflow. When the leave Dispatch Workflow and go to any other board, then come back, the first and last # is still getting truncated.

2. I don't see the Edit Pencil in any Dispatch Workflow Board.

3. In raytestD1 and the test1 boards, why don't I see any records with the blue and green coloring? I created a new board (test2), and it looks fine. I did make sure to re-generate the view on raytestD1 and test1.
Ray Ciccone Highest Questions
Brian Cronin 10/27/2023 2:47:38 PM NO Great job Ray. Thanks! Brian Cronin Highest Ready For Install
Ray Ciccone 10/27/2023 10:38:13 AM NO For item 1 fix see screenshots:
OrderNo_52570_Dispatch_MultipleMoves1.PNG
OrderNo_52570_Dispatch_edit_DI.PNG
OrderNo_52570_Dispatch_edit_DLV.PNG
OrderNo_52570_Dispatch_edit_DR.PNG
OrderNo_52570_Dispatch_edit_PU.PNG
OrderNo_52570_Dispatch_edit_RE.PNG

For item 2 fix for dispatch checkboxes:
OrderNo_Dispatch_3_checkboxes.PNG
OrderNo_55765_GoToCostBilling.PNG
OrderNo_ReturnTodispatchBoardandSelect1.PNG
DispatchIconSelectedAnd1Dispatched.PNG

For item 3 after search and return - No truncation:
Housebill_14347_search_1.PNG
Housebill_14347_updateshipment.PNG
Housebill_14347_ReturnToDispatch_NoTruncationNoClearing.PNG
Brian Cronin Highest Ready For Testing
Ray Ciccone 10/27/2023 10:05:22 AM NO Ray Ciccone Highest In progress
Brian Cronin 10/27/2023 8:34:05 AM NO Ray - Please test on 162 and give me the examples you tested so I can review as well. Nate already merged this into the 04/12 release, but I can't install on the shared server yet.

No need to test the hazmat ticket. That looks good to me.

I just need an example test for each of the recent items you fixed.
Ray Ciccone Highest Priority
Nathan Palmer 10/26/2023 7:45:36 PM NO Merged to 4/12. Brian Cronin Highest Ready For Install
Nathan Palmer 10/26/2023 6:50:32 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 10/26/2023 5:36:26 PM NO Please add these 3 changesets:

Changeset 70297 (for ticket 26730 - Hazmat red flag)
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.designer.vb
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

Changeset 70317 (this fixes most items 1 and 2)
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.designer.vb
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

Changeset 70338(This changeset fixes another bug after further testing)
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

Script:
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_10252023.txt.

Note:
this script works for all changesets. the Changeset 70297 incorporates the hazmat column.

Lastly, see attached files (these fix truncation of search column values):
Please just copy these files to the 04/12 code versions, when deploying.
CSADatatables_New.js
jquery.dataTables.yadcf_New.js
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 10/25/2023 1:57:02 PM NO will do Ray Ciccone Highest In progress
Brian Cronin 10/25/2023 1:53:01 PM NO ok, thanks Ray. I need a way to communicate what Nate needs to do to the 04/12 release for that fix. When you update the ticket for the other fixes, can you please just describe what we need him to do in order to fix this issue? Ray Ciccone Highest Questions
Ray Ciccone 10/25/2023 1:48:37 PM NO the truncate issue showed up on this ticket back on 9/30. I updated on 10/3.


See attached (2 files):
CSADatatables_New.js
jquery.dataTables.yadcf_New.js
Brian Cronin Highest Questions
Brian Cronin 10/25/2023 1:28:52 PM NO Ray - 2 issues - working on 1 more too that might be an issue:

1. Ray - They found an issue. Please bill to the original mod. I sent you the email on it as well:

"Problem: When multiple moves exist in an order, dispatching from the Dispatch Workflow board does not work as expected. Specifically, using the "Edit Pencil" will not select the expected move.


Steps to reproduce:

Use test order 401454
On the costs & billing screen, add two moves, for example a PU move and a DL move, and submit a driver to them.
On the dispatch workflow board, set your filter to all and search for 401454
On the PU move, click the Edit pencil
*Note how it incorrectly pulls the edit record for the DL move

Now, dispatch the PU move, and filter to only dispatched orders. The behavior continues even when they are on separate views, which can result in major dispatching errors."

2. I forwarded you an email on this. Has to do with checkboxes. Please fix.

3. Please tell me the ticket that you fixed the HAWB# filter/truncate issue.
Ray Ciccone Highest In progress
Brian Cronin 10/25/2023 1:03:53 PM NO Ray - 2 issues - working on 1 more too that might be an issue:

1. Ray - They found an issue. Please bill to the original mod. I sent you the email on it as well:

"Problem: When multiple moves exist in an order, dispatching from the Dispatch Workflow board does not work as expected. Specifically, using the "Edit Pencil" will not select the expected move.


Steps to reproduce:

Use test order 401454
On the costs & billing screen, add two moves, for example a PU move and a DL move, and submit a driver to them.
On the dispatch workflow board, set your filter to all and search for 401454
On the PU move, click the Edit pencil
*Note how it incorrectly pulls the edit record for the DL move

Now, dispatch the PU move, and filter to only dispatched orders. The behavior continues even when they are on separate views, which can result in major dispatching errors."

2. I forwarded you an email on this. Has to do with checkboxes. Please fix.

3. will let you know if I need you to do anything.
Ray Ciccone Highest In progress
Ray Ciccone 10/24/2023 4:22:04 PM NO Ray Ciccone Highest In progress
Brian Cronin 10/24/2023 4:07:16 PM NO Ray - They found an issue. Please bill to the original mod. I sent you the email on it as well:

"Problem: When multiple moves exist in an order, dispatching from the Dispatch Workflow board does not work as expected. Specifically, using the "Edit Pencil" will not select the expected move.


Steps to reproduce:

Use test order 401454
On the costs & billing screen, add two moves, for example a PU move and a DL move, and submit a driver to them.
On the dispatch workflow board, set your filter to all and search for 401454
On the PU move, click the Edit pencil
*Note how it incorrectly pulls the edit record for the DL move

Now, dispatch the PU move, and filter to only dispatched orders. The behavior continues even when they are on separate views, which can result in major dispatching errors."
Ray Ciccone Highest Re-Work
Nathan Palmer 10/17/2023 7:23:15 PM NO Brian Cronin Highest Ready For Install
Brian Cronin 10/14/2023 10:35:23 AM NO Nathan Palmer Highest Branch - 04/12
Ray Ciccone 10/11/2023 11:29:05 AM NO This corrects invalid copied logic, see screenshots for expected results:

DispatchDefaultsUserSetup1.PNG
DispatchDefaultsBoard1.PNG
Brian Cronin Highest Ready For Testing
Nathan Palmer 10/10/2023 6:28:55 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 10/10/2023 3:28:25 PM NO Changeset 70116

AirTrak/Main/Maintenance/Users/DispatchWorkflowBoardDefaults.aspx.vb
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

This corrects invalid copied logic, see screenshots for expected results:

DispatchDefaultsUserSetup1.PNG
DispatchDefaultsBoard1.PNG
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 10/9/2023 5:40:31 PM NO Found bug for these values in DispatchWorkflowBoard_Cache page code. Fixing now Ray Ciccone Highest In progress
Ray Ciccone 10/9/2023 3:58:45 PM NO Ray Ciccone Highest In progress
Brian Cronin 10/9/2023 12:05:54 PM NO ok, thanks Ray. I can see the WorldTrak/Main/Maintenance/Users/DispatchWorkflowBoardDefaults.aspx page now and the times are off the date fields.

How do we get these fixes into the 04/12 build so other customers will get this fix when we install?
Ray Ciccone Highest Questions
Ray Ciccone 10/9/2023 11:06:33 AM NO see attached DispatchWorkflowBoardDefaults1.PNG.

Logged in as CSA. This checkbox 'Custom Dispatch Board Maint' allows anything related to maint, including 'WFDispatchcategoryBoard_mp.aspx' page.

If changing, then logout and then login, the tab should show up.

thanks
Brian Cronin Highest Ready For Testing
Ray Ciccone 10/3/2023 2:49:05 PM NO I'll look into the recent question. However, I finally fixed the previous issue:

Found root cause. It has to do with the exact match column setting and an old bug we fixed with the pilot version (ticket/issue 24069) is where it occurred first. It was a nasty bug then and it took me a while to find it.

It's in the:
jquery.dataTables.yadcf_New.js file for the new datagrid.

I fixed it and updated the shared server site.

NOTE: Users will need to clear history/cache and then refresh.

I also updated the axis test site as well. Yesterday, Dave Fisher found that the date column was showing the date and time (which should just show short date), I also updated the axis test site and the shared server as well. Both issues have been corrected via the JavaScript files.

In case this needs to be fixed, I attached the files to this ticket. since this code version of 04/12 is different.

CSADatatables_New.js
jquery.dataTables.yadcf_New.js
Brian Cronin Highest Ready For Testing
Brian Cronin 10/3/2023 2:44:38 PM NO Ray one more thing: I don't see this page in user security in the 04/12 release for them. Was this omitted?

WorldTrak/Main/Maintenance/Users/DispatchWorkflowBoardDefaults.aspx
Ray Ciccone Highest Questions
Ray Ciccone 10/2/2023 5:34:10 PM NO I'm troubleshooting. It appears the first and last characters are removed. Getting close Ray Ciccone Highest In progress
Ray Ciccone 10/2/2023 10:05:26 AM NO Ray Ciccone Highest In progress
Ray Ciccone 10/2/2023 10:05:03 AM NO Ray Ciccone Highest In progress
Brian Cronin 9/30/2023 7:38:43 AM NO Installed on SS on 09/30 - They found a new issue. Please review and fix:

"
I'd like to add to this ticket. There is an issue with the dispatch workflow board "eating" the housebill number.

Steps to reproduce:

Start on the Not Dispatched view.
Enter a valid housebill number into the Housebill search box. I have shipment 399792 prepared.
Hit Enter, you should see the full number you typed.
Go into the order by clicking on costs and billing.
Return to the dispatch workflow board by selecting Shipments
Check the Housebill box, it has "eaten" parts of the housebill we entered.

This behavior is also observed when changing the board view around, for example from Not Dispatched to Active. I believe this is the only field that this behavior occurs. This error causes some problems, and forces us to re-enter that housebill every time we are looking for a specific order. It is especially frustrating when dispatching a specific order from Not Dispatched, and then trying to find that order on the Dispatched screen. Could you please look into this?"
Ray Ciccone Highest Re-Work
Nathan Palmer 9/29/2023 8:13:23 PM NO Merged to 4/12. Brian Cronin Highest Ready For Install
Nathan Palmer 9/29/2023 7:21:41 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 9/28/2023 6:00:55 PM NO Changeset 69965

AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

Notes:
There was another CF214 that changed the condition, and I missed it. This update corrects item 1 below.
Nathan Palmer Highest Merge to 79/162
Brian Cronin 9/28/2023 2:50:44 PM NO Installed on Axis TEST and tested. Please review:

Ray - I tested everything. Please review:

1. If a user has at least 1 station assigned to them in their user profile, you cannot pull up the board. It hangs because it is appending an extra 'and' to the query. Please fix.
----------------------------------
09/16 - BC - Looks good.
09/28 - BC - Same error. Merge issue? 04/12

2. Dispatch WF Maint grid - Please add the button to generate all views.
----------------------------------
09/16 - BC - Looks good.
09/28 - BC - Looks good.


3. Dispatch WF Maint - Please always default 'custom board' as checked and hide the field.
----------------------------------
09/16 - BC - Looks good.
09/28 - BC - Looks good.


4. On the shipment board, the Dispatch and Dispatch Workflow options are showing twice in some cases. Why? Please fix.
----------------------------------
09/16 - BC - Looks good.
09/28 - BC - Looks good.


-------------------------------
Dangerous Goods checkbox from page 1 of a shipment (DangerousGoods from tbl_ShipmentHeader).

and these fields from tbl_Shipper and tbl_Consignee - you already get this info in reg workflow.

Shipper City

Shipper State

Consignee City

Consignee State
------------------
09/16 - BC - All new fields look good.
09/28 - BC - Had to add script and run. Looks good. Added to PRS folder as well.


----------------------
The delete icon doesn't appear to have the security wrapped around it like it does on the other boards.
--------------
09/16 - BC - I think it is ok, but did the delete icon always exist with the other icons? I thought it was always at the end of the row?

-----------------------------
"We did some more presenting and testing of the new board today, and one thing that popped up is that it always sets you back to the "Not Dispatched" filter. For example, I can change my view to Dispatched, go into an order, update it, and when I click back on the shipments tab, it sets it back to "Not Dispatched". The expected behavior is that it retains your filters - at least, this is how every other board works. Is this something you could look into please?"
---------------
09/16 - BC - Looks good.
09/28 - BC - Looks good.

---------------
09/28 - BC - NEW - had to run this script: 26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_09192023 - I put in the PRS folder as well.
Ray Ciccone Highest Re-Work
Nathan Palmer 9/26/2023 8:03:42 PM NO Brian Cronin Highest Ready For Install
Brian Cronin 9/26/2023 4:01:49 PM NO Nathan Palmer Highest Branch - 04/12
Ray Ciccone 9/22/2023 2:02:21 PM NO this was fixed in issue 26584.

this is ready for testing for the dispatch board anyway
Nick Schubert Highest Ready For Testing
Ray Ciccone 9/22/2023 10:28:08 AM NO This is caused by issue-26584-Omni - Worldtrak - To Do List Short Cut - DefaultNew/WorkFlow

fixing now
Ray Ciccone Highest In progress
Ray Ciccone 9/22/2023 9:15:43 AM NO Ray Ciccone Highest In progress
Brian Cronin 9/21/2023 3:37:09 PM NO Ray - The defaultnew board is messed up on 162 again. It isn't showing the HAWB# on the grid anymore. I think Nick noticed a few other things as well. Can you please review? Ray Ciccone Highest Priority
Ray Ciccone 9/20/2023 1:57:22 PM NO see attached: DispatchBoardDeleteColumn1.PNG

Note:
will need to re-generate views. This adds the columns:
ShipmentOnConsol,CostsOrChargesFinalized,InvoicesPrinted

Which will show or hide the delete icon based on these values (just like the other boards)
Brian Cronin Highest Ready For Testing
Nathan Palmer 9/19/2023 6:37:50 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 9/19/2023 3:11:48 PM NO Changeset 69806

AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.designer.vb
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

Script:
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_09192023.txt

Note:
will need to re-generate views. This adds the columns:
ShipmentOnConsol,CostsOrChargesFinalized,InvoicesPrinted

Which will show or hide the delete icon based on these values (just like the other boards)
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 9/19/2023 10:56:45 AM NO In testing, I found I need to add hidden columns to show/hide delete icon. Ray Ciccone Highest In progress
Nathan Palmer 9/18/2023 8:04:36 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 9/18/2023 5:05:23 PM NO Changeset 69791

AirTrak/Main/Maintenance/WFCategory/GenerateDispatchWorkflowView.vb
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.designer.vb

This adds the 'delete' icon will be at the end of row like the other boards.
Note:
Will need to re-generate the views.
Nathan Palmer Highest Merge to 79/162
Brian Cronin 9/16/2023 10:39:12 AM NO Ray - I tested everything. Please review:

1. If a user has at least 1 station assigned to them in their user profile, you cannot pull up the board. It hangs because it is appending an extra 'and' to the query. Please fix.
----------------------------------
09/16 - BC - Looks good.

2. Dispatch WF Maint grid - Please add the button to generate all views.
----------------------------------
09/16 - BC - Looks good.

3. Dispatch WF Maint - Please always default 'custom board' as checked and hide the field.
----------------------------------
09/16 - BC - Looks good.

4. On the shipment board, the Dispatch and Dispatch Workflow options are showing twice in some cases. Why? Please fix.
----------------------------------
09/16 - BC - Looks good.

-------------------------------
Dangerous Goods checkbox from page 1 of a shipment (DangerousGoods from tbl_ShipmentHeader).

and these fields from tbl_Shipper and tbl_Consignee - you already get this info in reg workflow.

Shipper City

Shipper State

Consignee City

Consignee State
------------------
09/16 - BC - All new fields look good.

----------------------
The delete icon doesn't appear to have the security wrapped around it like it does on the other boards.
--------------
09/16 - BC - I think it is ok, but did the delete icon always exist with the other icons? I thought it was always at the end of the row?

-----------------------------
"We did some more presenting and testing of the new board today, and one thing that popped up is that it always sets you back to the "Not Dispatched" filter. For example, I can change my view to Dispatched, go into an order, update it, and when I click back on the shipments tab, it sets it back to "Not Dispatched". The expected behavior is that it retains your filters - at least, this is how every other board works. Is this something you could look into please?"
---------------
09/16 - BC - Looks good.
Ray Ciccone Highest Ready For Testing
Nathan Palmer 9/15/2023 6:07:03 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 9/14/2023 5:28:26 PM NO Nate:
Can you please check this changeset:
Changeset 69664
For these 2 files to be updated?
AirTrak/Main/Maintenance/WFCategory/WFDispatchCategoryEdit.aspx
AirTrak/Main/Maintenance/WFCategory/WFDispatchCategoryEdit.aspx.vb

Thanks
Nathan Palmer Highest Merge to 79/162
Nathan Palmer 9/13/2023 6:11:55 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 9/13/2023 5:07:21 PM NO Changeset 69694

AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

AirTrak/JS/datatables/CSADatatables_New.js

Note:
This updates the retaining dropdown filter when returning to page

Also includes CSADatatables_New.js update from issue 26614
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 9/13/2023 11:38:35 AM NO Working on latest requests. Ray Ciccone Highest In progress
Nathan Palmer 9/12/2023 6:08:02 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 9/12/2023 2:52:31 PM NO Changeset 69664

AirTrak/Main/Maintenance/WFCategory/WFDispatchCategoryBoard_mp.aspx.vb
AirTrak/Main/Maintenance/WFCategory/WFDispatchCategoryEdit.aspx
AirTrak/Main/Maintenance/WFCategory/WFDispatchCategoryEdit.aspx.vb
AirTrak/Main/Operations/ShipmentBoard/DefaultBoard_New.aspx.vb
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb
AirTrak/Main/Operations/ShipmentEdit.aspx.vb

scripts:
26394_Insert_tbl_WFCustomDispatchBoardColumns_newcolumns_09122023.txt
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_09122023.txt

screenshots:
dispatchBoardWithNewcolumns1.PNG
Nathan Palmer Highest Merge to 79/162
Brian Cronin 9/12/2023 2:48:47 PM NO They just brought this to my attention as well. Can you please look into it and fix?:

"We did some more presenting and testing of the new board today, and one thing that popped up is that it always sets you back to the "Not Dispatched" filter. For example, I can change my view to Dispatched, go into an order, update it, and when I click back on the shipments tab, it sets it back to "Not Dispatched". The expected behavior is that it retains your filters - at least, this is how every other board works. Is this something you could look into please?"
Ray Ciccone Highest Questions
Ray Ciccone 9/11/2023 5:08:42 PM NO I was going to check in latest changeset. I will add these fixes as well. Thanks Ray Ciccone Highest In progress
Brian Cronin 9/11/2023 4:01:55 PM NO Ray - another issue:

The delete icon doesn't appear to have the security wrapped around it like it does on the other boards.
Ray Ciccone Highest In progress
Brian Cronin 9/11/2023 12:02:01 PM NO Ray - they have asked for some additional fields to be available to select. Please create a new script for these as opposed to attaching to the one already on this ticket.

Dangerous Goods checkbox from page 1 of a shipment (DangerousGoods from tbl_ShipmentHeader).

and these fields from tbl_Shipper and tbl_Consignee - you already get this info in reg workflow.

Shipper City

Shipper State

Consignee City

Consignee State

Bill your time to this ticket.
Ray Ciccone Highest In progress
Ray Ciccone 9/11/2023 10:42:32 AM NO Ray Ciccone Highest In progress
Brian Cronin 9/9/2023 6:57:13 AM NO Ray - a few things:

1. If a user has at least 1 station assigned to them in their user profile, you cannot pull up the board. It hangs because it is appending an extra 'and' to the query. Please fix.

2. Dispatch WF Maint grid - Please add the button to generate all views.

3. Dispatch WF Maint - Please always default 'custom board' as checked and hide the field.

4. On the shipment board, the Dispatch and Dispatch Workflow options are showing twice in some cases. Why? Please fix.
Ray Ciccone Highest Priority
Brian Cronin 9/8/2023 3:54:41 PM NO ok, thanks Ray! Brian Cronin Highest Ready For Testing
Ray Ciccone 9/8/2023 3:49:18 PM NO Found the root cause.
Examining the error, it is different from what I thought it was (which is similar but different)

When I designed the Dispatch Workflow, copied much of the existing Workflow code.
Anyway, there is code that queries the WFDispatchCategory table. However, that query requires it to be a 'Custom Board'. So, I checked that box:
see attached snapshot - Snap_dispatchCategory_CustomBoardSetting.PNG

when bringing up the DispatchWorkflowBoard, it should behave as expected.

Note:
We can remove that filter from the code (which is same as existing Workflow - I'm not sure why that's there for the original design, must have been a good reason, may not need to be applied for dispatch)
Brian Cronin Highest Ready For Testing
Brian Cronin 9/8/2023 1:53:53 PM NO Per our conversation: 04/12 release

https://www.ssworldtrak.com/WorldtrakStaging/
csa



Server Error in '/WorldTrakStaging' Application.
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index]
System.Collections.ArrayList.get_Item(Int32 index) +12711433
System.Web.UI.WebControls.ListItemCollection.get_Item(Int32 index) +15
AirTrak.DispatchWorkflowBoard_Cache.ResetWorkflowCategoryToDefault() +340
AirTrak.DispatchWorkflowBoard_Cache.SetupDispatchViewDDL() +1086
AirTrak.DispatchWorkflowBoard_Cache.BindDropDownList() +2043
AirTrak.DispatchWorkflowBoard_Cache.Page_Load(Object sender, EventArgs e) +1441
System.Web.UI.Control.OnLoad(EventArgs e) +97
System.Web.UI.Control.LoadRecursive() +61
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4330.0
Ray Ciccone Highest Priority
Nathan Palmer 9/7/2023 6:06:57 PM NO Merged to 4/12. Brian Cronin Highest Ready For Install
Nathan Palmer 9/7/2023 6:03:59 PM NO Merged to test. Not in 4/12 yet. Nathan Palmer Highest Branch - 04/12
Nathan Palmer 9/7/2023 5:39:07 PM NO Nathan Palmer Highest Merge to 79/162
Ray Ciccone 9/7/2023 4:14:21 PM NO different changesets for each version:

for 04/12"
Changeset 69580
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb
AirTrak/Main/Operations/ShipmentEdit.aspx.vb
Changeset 69581
AirTrak/Main/WorldTrakSetup.Master

Notes:
These 04/12 changesets updates the data-icons to match for the 04/12 version which is different than 162.
Fixes WFDispatchcategoryBoard.aspx to WFDispatchcategoryBoard_mp.aspx
also fixes update for the EquipmentCode for ShipmentEdit (different from 162)

For 162:
Changeset 69582
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb
AirTrak/Main/Operations/ShipmentBoard/WorkflowBoard_Cache.aspx.vb
AirTrak/Main/WorldTrakSetup.Master
Nathan Palmer Highest Needs to be Merged
Brian Cronin 9/6/2023 2:19:19 PM NO Ray - What Aaron said below is true, BUT, you can't even get to the maint program either. Not sure if it is a different error or not.

I was guessing the dispatch board was blowing up because no dispatch workflow categories have been created yet.
Ray Ciccone Highest In progress
Ray Ciccone 9/6/2023 1:24:49 PM NO Ray Ciccone Highest In progress
Aaron Biebuyck 9/6/2023 1:04:08 PM NO Ray

When trying to get to the dispatch board,
ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
its spitting back an error.

Axis test
4/12 build

9/6/2023 11:53:21 AM
Error in: http://204.93.248.43/worldtrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx. Error Message: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.Collections.ArrayList.get_Item(Int32 index)
at System.Web.UI.WebControls.ListItemCollection.get_Item(Int32 index)
at AirTrak.DispatchWorkflowBoard_Cache.ResetWorkflowCategoryToDefault()
at AirTrak.DispatchWorkflowBoard_Cache.SetupDispatchViewDDL()
at AirTrak.DispatchWorkflowBoard_Cache.BindDropDownList()
at AirTrak.DispatchWorkflowBoard_Cache.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
__________________________
Ray Ciccone Highest Priority
Ray Ciccone 9/6/2023 10:34:40 AM NO Testing looks good.

Note:
Scripts (updated for 'SP_GetDispatchWorkflowBoard_GenerateView'):
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_09052023.txt

Per Aaron, attached create view scripts (because these older scripts may not be there for 04/12 users):
26394_CreateView_vw_DispatchBoard.txt
26394_CreateView_vw_DispatchBoardAssigned.txt
Brian Cronin Highest Ready For Install
Nathan Palmer 9/5/2023 6:57:42 PM NO Merged to 4/12. Brian Cronin Highest Ready For Install
Nathan Palmer 9/5/2023 6:19:43 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 9/5/2023 4:59:01 PM NO 2 changesets
Changeset 69535
AirTrak/JS/datatables/CSADatatables_New.js
AirTrak/Main/Maintenance/WFCategory/GenerateDispatchWorkflowView.vb
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.designer.vb
AirTrak/Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

Changeset 69537
AirTrak/Main/Operations/ShipmentEdit.aspx
AirTrak/Main/Operations/ShipmentEdit.aspx.designer.vb
AirTrak/Main/Operations/ShipmentEdit.aspx.vb

Scripts (updated for 'SP_GetDispatchWorkflowBoard_GenerateView'):
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_09052023.txt

Per Aaron, attached create view scripts:
26394_CreateView_vw_DispatchBoard.txt
26394_CreateView_vw_DispatchBoardAssigned.txt
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 8/30/2023 11:21:52 AM NO Ray Ciccone Highest In progress
Nathan Palmer 8/29/2023 5:41:13 PM NO Merged everything so far to 4/12. Ray Ciccone Highest Priority
Brian Cronin 8/25/2023 6:18:10 AM NO Ray - Please review:

II. Custom Dispatch Board – Maint –

Equipment type - Add a new control flag for it - Call it: Enable Equipment Type on a Domestic Shipment? Y/N Require it too? R. Default needs to be 'N'.

If 'N', do what we do today.
If 'Y' or 'R', do the following:

We will need to surface the equipment type on page 1 like we show on the tledit1.aspx page. - or as close as you can. Be careful with the tabbing order.

If 'Y', just show it.
If 'R', require to be added.

You already made it an available field to choose from. That is working fine.
-------------------------
08/25 - BC - This all looks great - BUT - if it is set to an 'R', could you also show the red * next to the equipment type?
-------------------------

III. Dispatch Board – Shipment Entry

H. it works great, but could you put the checkbox under the icon instead of to the side of it? I don't want to eat up that horizontal space if we don't have to.

-------------------------
08/25 - BC - doesn't look like the checkbox moved at all.
-------------------------
Ray Ciccone Highest Priority
Nathan Palmer 8/24/2023 8:45:14 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 8/24/2023 2:22:19 PM NO Changeset 69338

Main/Operations/ShipmentEdit.aspx
Main/Operations/ShipmentEdit.aspx.designer.vb
Main/Operations/ShipmentEdit.aspx.vb

Script:
26394_AddControlFlag_2264.txt

Screenshots:
ShipmentEdit_EquipmentType.PNG
DispatchWorkflow_checkbox_alignement.PNG
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 8/22/2023 11:57:45 AM NO Ray Ciccone Highest In progress
Brian Cronin 8/22/2023 11:12:11 AM NO Ray - Please review: Just need to finish:

II. Details below.
and
III. H. Details below

I. User Security
A. ok.
1. ok.
2. ok.
3. ok.
4. ok.
5. ok.
i. ok
6. ok.
7. ok.

II. Custom Dispatch Board – Maint –

Equipment type - Add a new control flag for it - Call it: Enable Equipment Type on a Domestic Shipment? Y/N Require it too? R. Default needs to be 'N'.

If 'N', do what we do today.
If 'Y' or 'R', do the following:

We will need to surface the equipment type on page 1 like we show on the tledit1.aspx page. - or as close as you can. Be careful with the tabbing order.

If 'Y', just show it.
If 'R', require to be added.

You already made it an available field to choose from. That is working fine.

III. Dispatch Board – Shipment Entry
A. ok.
B. ok.
C. ok.
D. ok.
E. ok.

F. ok.

G. ok.

H. it works great, but could you put the checbox under the icon instead of to the side of it? I don't want to eat up that horizontal space if we don't have to.
Ray Ciccone Highest Re-Work
Ray Ciccone 8/22/2023 10:00:28 AM NO see DispatchWorkflowcheckBoxes1.PNG


Scripts:
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_08212023.txt

Notes:
Includes checkbox for 'select All' and reset of checboxes as well.
Also added 'shipment InUse' feature as well.
Brian Cronin Highest Ready For Testing
Nathan Palmer 8/21/2023 7:34:30 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 8/21/2023 4:00:34 PM NO Changeset 69294

Main/Maintenance/WFCategory/GenerateDispatchWorkflowView.vb

Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.designer.vb
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

Scripts:
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_08212023.txt

Notes:
Includes checkbox for 'select All' and reset of checboxes as well
Also added 'shipment InUse' feature as well.
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 8/21/2023 10:18:45 AM NO Ray Ciccone Highest In progress
Brian Cronin 8/21/2023 10:00:24 AM NO ray - Please test what you have done did on Friday. Also, I forgot to add 1 more thing:

I'm adding a new item to III. I added it to the original write-up as well.

III. Dispatch Board – Shipment Entry

H. Need a 'Select All' checkbox under the dispatch, complete dispatch, and clear dispatch icons. If checked, check off all the rows on that line item.

Also - looks like you missed the tooltip for 'dispatch' on the dispatch icon. Please add that.
Ray Ciccone Highest Re-Work
Nathan Palmer 8/18/2023 4:25:07 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 8/18/2023 3:27:43 PM NO Changeset 69280

Main/Maintenance/Users/UserEdit.aspx

Scripts:
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_08182023.txt
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 8/18/2023 9:59:56 AM NO Ray Ciccone Highest In progress
Brian Cronin 8/17/2023 10:26:08 PM NO Ray - Please review:

I. User Security
A. ok.
1. ok.
2. ok.
3. ok.
4. ok.
5. ok.
i. ok
6. ok.
7. NEW - We need to allow the Dispatch Workflow Board to be a default in user security so that when the user logs in and goes to the shipment board that it goes directly to that board...much like we can do with Workflow or any of the other search by's.

I'm talking about the 'Domestic Defaults' 'Search by' section.

II. Custom Dispatch Board – Maint –

Equipment type - DO NOT DO ANYTHING UNTIL WE TALK. We will need to surface the equipment type on page 1 like we show on the tledit1.aspx page. We will need to add a control flag for this. Whereever that field is held will have to accessible on the dispatch wf board fields.

The SHORT Shipper/Consignee names - I don't know what you mean by your explanation below. Let's discuss. I see the fields and they seem fine for now.



III. Dispatch Board – Shipment Entry
A. ok.
B. ok.
C. ok.
D. ok.
E. ok.

F. Tok.

G. ok.
Ray Ciccone Highest Re-Work
Nathan Palmer 8/17/2023 7:29:03 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 8/17/2023 4:01:03 PM NO Changeset 69260

Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.designer.vb

scripts:
26394_Insert_tbl_WFCustomDispatchBoardColumns_08172023.txt
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_08172023.txt

Notes:
The changeset adds tthe Cost, Doc and Milestone image buttons.

In adding the 'Shipper (short)' and 'Consignee (short)' columns (I added them just like the regular workflow uses)
In contrast to the 'ShipperInfo' and 'ConsigneeInfo' columns, which come from the vw_DispatchBoard and has more complicated derivation in the view. It uses the CF1680 value and case statements. It may show different data than the 'short' columns. May want to contact Dave Fisher (I believe authored this view) if necessary to discuss.
Nathan Palmer Highest Merge to 79/162
Brian Cronin 8/17/2023 12:19:54 PM NO Ray - Please review:

I. User Security

Everything looks ok so far.

II. Custom Dispatch Board – Maint –

I don't see these fields I asked you to add:

Equipment type - That is not the correct field, but please HOLD until I get you the table/fieldname to pull.

The SHORT Shipper/Consignee names are still missing. We have done this in Workflow. You have the fields that are 50 characters long, but we need the ability for them to pick the 10 character customer id's as well.



III. Dispatch Board – Shipment Entry
A. ok.
B. ok.
C. ok.
D. ok.
E. This looks good so far.

F. This looks good so far.

G. Need the ability to select a shipment.

You can do that now - GOOD, but where are the other shortcuts for the costs/billing page - etc? Just needs to be like Workflow. They exist on the old Dispatch board, but you removed them on the new one.
Ray Ciccone Highest Priority
Ray Ciccone 8/16/2023 10:55:00 AM NO Notes:
Screenshots:
DispatchWorkflow_newcolumns.PNG
DispatchWorkflow_select_addshipment.PNG

I added a join with tbl_ShipmentApar to the 'SP_GetDispatchWorkflowBoard_GenerateView' to add EquipmentType (from what I see that is the best source?)

Also, there is CF2227-'Dispatch Board - Enable Assign to Dispatch Logic Y/N'

I saw that being used for the other dispatch new board. I handle it in the stored procedure 'SP_GetDispatchWorkflowBoard_GenerateView'.

Once changed, you need to regenerate the views.

when testing, I found when CF2227=Y, not much data is retrieved. If set Assigned and Dispatched dropdowns both to 'All' and refresh, it would retrieve 1 record.

On the positive side, the views generated from 'SP_GetDispatchWorkflowBoard_GenerateView' can be changed on the SQL side without recompiling the VB code.

Lastly, as before, all the columns are derived from the established views, 'vw_DispatchBoard' or 'vw_DispatchBoardAssigned' (based on CF2227, which when set to 'Y', it will use the 'vw_DispatchBoardAssigned' instead of the 'vw_DispatchBoard')
Brian Cronin Highest Ready For Testing
Nathan Palmer 8/15/2023 7:37:17 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 8/15/2023 5:03:07 PM NO Nathan Palmer Highest Merge to 79/162
Ray Ciccone 8/15/2023 5:02:49 PM NO Changeset 69236

Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.designer.vb
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

Sql scripts:
Insert_tbl_WFCustomDispatchBoardColumns_08152023.txt
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView_08152023.txt

Screenshots:
DispatchWorkflow_newcolumns.PNG
DispatchWorkflow_select_addshipment.PNG

Note:
I added a join to tbl_ShipmentApar to the 'SP_GetDispatchWorkflowBoard_GenerateView' to add EquipmentType (from what I see that is the best source?)
Ray Ciccone Highest Merge to 79/162
Ray Ciccone 8/15/2023 10:39:21 AM NO Ray Ciccone Highest In progress
Brian Cronin 8/15/2023 8:31:44 AM NO Ray - Please review:

I. User Security

Everything looks ok so far.

II. Custom Dispatch Board – Maint –

I don't see these fields I asked you to add: Equipment type, Short Shipper/Consignee names.

Please add them as available fields and program accordingly.

Everything else looked ok.

III. Dispatch Board – Shipment Entry
A. ok.
B. ok.
C. ok.
D. ok.
E. If you access a shipment from this board, when you leave the shipment, it needs to come back to this board.

You did NOT do this. See G. I can't test this until G is done.

F. Need the ability to add a shipment/consolidation from this board

You did NOT do this. Please add.

G. Need the ability to select a shipment.

You did NOT do this. Please add the same shortcuts as we have on DefaultNew/Workflowfor getting into a shipment.
Ray Ciccone Highest Priority
Ray Ciccone 8/4/2023 10:17:59 AM NO Please see screenshots for security setup:
UserPage_1.PNG
UserPage_2.PNG
UserPage_3.PNG
UserPage_4.PNG
UserPage_Maint1.PNG
UserPage_Maint2.PNG

Note, by setting UserPage_1.PNG, user will be able to see UserPage_Maint1.PNG, UserPage_Maint2.PNG

DispatchWorkflow1.PNG
DispatchWorkflow2.PNG
Brian Cronin Highest Ready For Testing
Nathan Palmer 8/3/2023 7:45:11 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 8/3/2023 11:01:11 AM NO Changeset 69082
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb

Fixed some smaller issues.
Nathan Palmer Highest Merge to 79/162
Nathan Palmer 8/2/2023 6:57:12 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 8/2/2023 3:18:51 PM NO 2 changesets:

Changeset 69066
------------------These updates are for the 'SearchBy' drop downs
Main/Operations/ShipmentBoard/ConsolidationBoard.aspx.vb
Main/Operations/ShipmentBoard/DefaultBoard_New.aspx.vb
Main/Operations/ShipmentBoard/DispatchBoard_New.aspx
Main/Operations/ShipmentBoard/DispatchBoard_New.aspx.vb
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb
Main/Operations/ShipmentBoard/FinalizeBoard.aspx.vb
Main/Operations/ShipmentBoard/ManualAttachBoard.aspx.vb
Main/Operations/ShipmentBoard/PriorityTrackingNoteBoard.aspx.vb
Main/Operations/ShipmentBoard/SpecialAuthBoard.aspx.vb
Main/Operations/ShipmentBoard/TradeshowBoard_New.aspx.vb
Main/Operations/ShipmentBoard/WorkflowBoard_New.aspx.vb
Main/Operations/DomesticLanding.aspx.vb
Main/Operations/FastTruckLoadBoard.aspx.vb
Main/Operations/ShipmentBoard.aspx.vb


Changeset 69071
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb
Nathan Palmer Highest Merge to 79/162
Ray Ciccone 8/2/2023 11:23:43 AM NO Changeset 69066

Main/Operations/ShipmentBoard/ConsolidationBoard.aspx.vb
Main/Operations/ShipmentBoard/DefaultBoard_New.aspx.vb
Main/Operations/ShipmentBoard/DispatchBoard_New.aspx
Main/Operations/ShipmentBoard/DispatchBoard_New.aspx.vb
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb
Main/Operations/ShipmentBoard/FinalizeBoard.aspx.vb
Main/Operations/ShipmentBoard/ManualAttachBoard.aspx.vb
Main/Operations/ShipmentBoard/PriorityTrackingNoteBoard.aspx.vb
Main/Operations/ShipmentBoard/SpecialAuthBoard.aspx.vb
Main/Operations/ShipmentBoard/TradeshowBoard_New.aspx.vb
Main/Operations/ShipmentBoard/WorkflowBoard_New.aspx.vb
Main/Operations/DomesticLanding.aspx.vb
Main/Operations/FastTruckLoadBoard.aspx.vb
Main/Operations/ShipmentBoard.aspx.vb

These updates are for the 'SearchBy' drop downs
Nathan Palmer Highest Merge to 79/162
Nathan Palmer 8/1/2023 8:01:59 PM NO Ray Ciccone Highest Ready For Testing
Ray Ciccone 8/1/2023 6:01:24 PM NO Changeset 69061
(total of 32 files)

Main/Maintenance/Users/UserEdit.aspx
Main/Maintenance/Users/UserEdit.aspx.designer.vb
Main/Maintenance/Users/UserEdit.aspx.vb
Main/Maintenance/WFCategory/WFCategoryBoard_mp.aspx
Main/Operations/ShipmentBoard/DefaultBoard_New.aspx.vb
Main/Operations/ShipmentBoard/WorkflowBoard_Cache.aspx
Main/Operations/ShipmentBoard/WorkflowBoard_Cache.aspx.vb
Main/Operations/DomesticLanding.aspx.vb
Main/SPDataTablesWS.asmx.vb
Main/WorldTrakSetup.Master
Main/WorldTrakSetup.Master.designer.vb
Main/WorldTrakSetup.Master.vb
AirTrakDataAccess/DataAccess.vb

PLEASE add these new files to project:::::::::::::::::::::::::::::::::::::::::::::

Main/Maintenance/Users/DispatchWorkflowBoardDefaults.aspx
Main/Maintenance/Users/DispatchWorkflowBoardDefaults.aspx.designer.vb
Main/Maintenance/Users/DispatchWorkflowBoardDefaults.aspx.vb
Main/Maintenance/Users/DispatchWorkflowBoardDefaults.aspx.resx

Main/Maintenance/WFCategory/GenerateDispatchWorkflowView.vb

Main/Maintenance/WFCategory/WFDispatchCategoryBoard_mp.aspx
Main/Maintenance/WFCategory/WFDispatchCategoryBoard_mp.aspx.designer.vb
Main/Maintenance/WFCategory/WFDispatchCategoryBoard_mp.aspx.vb

Main/Maintenance/WFCategory/WFDispatchCategoryEdit.aspx
Main/Maintenance/WFCategory/WFDispatchCategoryEdit.aspx.designer.vb
Main/Maintenance/WFCategory/WFDispatchCategoryEdit.aspx.vb

Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.designer.vb
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.vb
Main/Operations/ShipmentBoard/DispatchWorkflowBoard_Cache.aspx.resx

Main/Search/WFDispatchCategories.aspx
Main/Search/WFDispatchCategories.aspx.designer.vb
Main/Search/WFDispatchCategories.aspx.vb
Main/Search/WFDispatchCategories.aspx.resx

SCRIPTS::::::::::::::::::::::::::::::::::::::::::::

26394_CreateDispatchTables.txt
26394_Create_SP_GetDispatchWFCustomColumnsBoardDefaults.txt
26394_Create_SP_GetDispatchWorkflowBoardNewData.txt
26394_Create_SP_GetDispatchWorkflowBoard_GenerateView.txt
26394_Insert_tbl_UsersAux.txt
Insert_tbl_WFCustomDispatchBoardColumns.txt

SCREENSHOTS:

UserPage_1.PNG
UserPage_2.PNG
UserPage_3.PNG
UserPage_Maint1.PNG
UserPage_Maint2.PNG
Nathan Palmer Highest Merge to 79/162
Brian Cronin 7/14/2023 1:15:57 PM NO Ray - Just updating the ticket from some of the responses I received from Dave F. The control flag is 390 = '4'. Then I updated II with the table/view names you need in order to get some of the dispatch board data. Ray Ciccone Highest In progress
Ray Ciccone 7/13/2023 10:36:06 AM NO Ray Ciccone Highest In progress