-
Type:
Enhancement
-
Status: In Development
-
Priority:
Medium
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Module:BenAdmin - Import
-
Reported by:Client
-
Item State:Development - On Hold
-
Issue Importance:Q2
-
Sprint:WT Sprint 38 - Enhancement, WT Sprint 40 - Enhancement
-
Severity:Simple
Please refer to WT-8848.
We support date formats - which appear to be redundant (see first two) and incomplete.
MM/DD/YYYY
MM-DD-YYYY
YYYY/MM/DD
YYYYMMDD
But not - which is one of the standard US date format.
MMDDYYYY
This date format picker needs to be rationalized to allow following regular expressions where * stands for any special character. In fact the list can be further pruned if the system could parse the string to remove special characters first and then we interpret it for only three options.
MM*DD*YYYY
MMDDYYYY
DD*MM*YYYY
DDMMYYYY
YYYY*MM*DD
YYYYMMDD
CC Nathaniel Cornejo-Walker Cindy Wibbing Nagini Indugula Bharti Satpute Amit Thorve
- relates to
-
WT-8848 City National Bank import failure
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Description |
Please refer to We support date formats - which appear to be redundant (see first two) and incomplete. MM/DD/YYYY MM-DD-YYYY YYYY/MM/DD YYYYMMDD But not - which is one of the standard US date format. MMDDYYYY *This date format picker needs to be rationalized to allow following regular expressions* where * stands for any special character. MM*DD*YYYY MMDDYYYY DD*MM*YYYY DDMMYYYY YYYY*MM*DD YYYYMMDD CC [~nwalker] [~Cindy.Wibbing] [~nagini.Indugula] [~bharti] |
Please refer to We support date formats - which appear to be redundant (see first two) and incomplete. MM/DD/YYYY MM-DD-YYYY YYYY/MM/DD YYYYMMDD But not - which is one of the standard US date format. MMDDYYYY *This date format picker needs to be rationalized to allow following regular expressions* where * stands for any special character. In fact the list can be further pruned if the system could parse the string to remove special characters first and then we interpret it for only three options. MM*DD*YYYY MMDDYYYY DD*MM*YYYY DDMMYYYY YYYY*MM*DD YYYYMMDD CC [~nwalker] [~Cindy.Wibbing] [~nagini.Indugula] [~bharti] |
| Description |
Please refer to We support date formats - which appear to be redundant (see first two) and incomplete. MM/DD/YYYY MM-DD-YYYY YYYY/MM/DD YYYYMMDD But not - which is one of the standard US date format. MMDDYYYY *This date format picker needs to be rationalized to allow following regular expressions* where * stands for any special character. In fact the list can be further pruned if the system could parse the string to remove special characters first and then we interpret it for only three options. MM*DD*YYYY MMDDYYYY DD*MM*YYYY DDMMYYYY YYYY*MM*DD YYYYMMDD CC [~nwalker] [~Cindy.Wibbing] [~nagini.Indugula] [~bharti] |
Please refer to We support date formats - which appear to be redundant (see first two) and incomplete. MM/DD/YYYY MM-DD-YYYY YYYY/MM/DD YYYYMMDD But not - which is one of the standard US date format. MMDDYYYY *This date format picker needs to be rationalized to allow following regular expressions* where * stands for any special character. In fact the list can be further pruned if the system could parse the string to remove special characters first and then we interpret it for only three options. MM*DD*YYYY MMDDYYYY DD*MM*YYYY DDMMYYYY YYYY*MM*DD YYYYMMDD CC [~nwalker] [~Cindy.Wibbing] [~nagini.Indugula] [~bharti] [~amitthorve] |
| Assignee | Vijay Siddha [ vijays ] | Suraj Sokasane [ suraj.sokasane ] |
| Issue Importance | Good To Have [ 11802 ] | Q2 [ 14901 ] |
We have not yet planned this. Adding a new Date format may not take much efforts. But here as we need rationalization for date format, high efforts are needed.
Currently we are running short of bandwidth. If possible we can add the MMDDYYYY format for now which is requirement and take rationalization which is betterment once enough bandwidth is available. Please let us know the priority.
| Assignee | Suraj Sokasane [ suraj.sokasane ] | Vishal Bajad [ vishal.bajad ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 37 - Enhancement [ 86 ] |
| Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
| Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
| Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
| Dev Due Date | 14/Sep/2017 | |
| Developer | Vishal Bajad [ vishal.bajad ] | |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | |
| QA | Jayshree Nagpure [ jayshree.nagpure ] |
-
- Time Spent:
- 2h
-
Analysis and understanding Business logic
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 2h [ 7200 ] | |
| Worklog Id | 78271 [ 78271 ] |
Hi Abhay Patil,
Today, I discussed this with Amit Thorve. We have concluded that it will create confusion with using *. We also have to fix and take as input the replacement of *. This may create confusion for end user, as there is already on field for null replacement character on template settings.
Amit Thorve has suggested that instead of doing this, provide below combinations on template settings,
MM/DD/YYYY
MM-DD-YYYY
MMDDYYYY
DD/MM/YYYY
DD-MM-YYYY
DDMMYYYY
YYYY/DD/MM
YYYY-DD-MM
YYYYDDMM
YYYY/MM/DD
YYYY-MM-DD
YYYYMMDD
Please let us know your thoughts on this.
| Assignee | Vishal Bajad [ vishal.bajad ] | Abhay Patil [ abhay.patil ] |
| Time Spent | 2h [ 7200 ] | 3h [ 10800 ] |
| Worklog Id | 78334 [ 78334 ] |
Hi Abhay Patil
Any update on this?
Gaurav Sodani (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: On Hold(10207) |
Gaurav Sodani (Inactive)
made changes -
| Dev Due Date | 14/Sep/2017 |
I believe that this has to be SIMPLE - and we can definitely make it NOT CONFUSING. Following is my suggestion. However I leave it to Nagini Indugula and Jennifer Reed to figure in consultation with you and Amit Thorve.
We can have only following four options.
MM/DD/YYYY
DD/MM/YYYY
YYYY/DD/MM
YYYY/MM/DD
Then each option should be liberally interpreted by code as one that can have any separator or no separator.
So for example, the option "MM/DD/YYYY" should admit and correctly interpret all of the following as July 25, 2017.
07/25/2017
07-25-2017
07252017
The way it could be coded is - whenever there is a data item of type "date", the system should first remove any special characters - leaving only numerals that take 8 spaces. Then it can be parsed using the sequence in the format.
Once again - I leave it to product management to make the call.
| Assignee | Abhay Patil [ abhay.patil ] | Jennifer Reed [ jennifer.reed ] |
Hi Jennifer Reed,
Could you please let us know the thoughts of the product team on this.
We need to update the status of the ticket
Regards
Gaurav
Gaurav Sodani (Inactive)
added a comment - Hi Jennifer Reed ,
Could you please let us know the thoughts of the product team on this.
We need to update the status of the ticket
Regards
Gaurav
Satya Abhay Patil Jaideep Vinchurkar - please go ahead with Amit's suggestion.
| Assignee | Jennifer Reed [ jennifer.reed ] | Jaideep Vinchurkar [ jaideep.vinchurkar ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 37 - Enhancement [ 86 ] |
| Assignee | Jaideep Vinchurkar [ jaideep.vinchurkar ] | snehal katkar [ snehal.katkar ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 38 - Enhancement [ 88 ] | |
| Original Estimate | 0h [ 0 ] |
| Dev Due Date | 05/Oct/2017 |
Gaurav Sodani (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
| Original Estimate | 0h [ 0 ] | 28h [ 100800 ] |
Snehal Katkar (Inactive)
made changes -
| Developer | Vishal Bajad [ vishal.bajad ] | snehal katkar [ snehal.katkar ] |
| Time Spent | 3h [ 10800 ] | 3.5h [ 12600 ] |
| Worklog Id | 82891 [ 82891 ] |
Snehal Katkar (Inactive)
logged work - 29/Sep/17 07:14 PM -
- Time Spent:
- 6h
-
Discussion with Jaideep and Vinayak, Analysis
Snehal Katkar (Inactive)
made changes -
| Time Spent | 3.5h [ 12600 ] | 9.5h [ 34200 ] |
| Worklog Id | 83835 [ 83835 ] |
Snehal Katkar (Inactive)
made changes -
| Time Spent | 9.5h [ 34200 ] | 11h [ 39600 ] |
| Worklog Id | 83842 [ 83842 ] |
Jayshree Nagpure (Inactive)
made changes -
| Attachment | Testcases.xls [ 64417 ] |
Jayshree Nagpure (Inactive)
logged work - 13/Oct/17 06:58 AM -
- Time Spent:
- 4.5h
-
Test case writting, Analysis
Discussion with Snehal
Hi Snehal Katkar,
Please refer attached test cases.
Please let me know if any additional scenario's are required. Testcases.xls
Also, while testing If found some additional scenario will update in test cases accordingly.
Thanks,
Jayshree
cc : Rakesh Roy Prasad Pise
Jayshree Nagpure (Inactive)
added a comment - Hi Snehal Katkar ,
Please refer attached test cases.
Please let me know if any additional scenario's are required. Testcases.xls
Also, while testing If found some additional scenario will update in test cases accordingly.
Thanks,
Jayshree
cc : Rakesh Roy Prasad Pise Jayshree Nagpure (Inactive)
made changes -
| Time Spent | 11h [ 39600 ] | 15.5h [ 55800 ] |
| Worklog Id | 84771 [ 84771 ] |
Snehal Katkar (Inactive)
made changes -
| Time Spent | 15.5h [ 55800 ] | 18.5h [ 66600 ] |
| Worklog Id | 85423 [ 85423 ] |
Snehal Katkar (Inactive)
made changes -
| Time Spent | 18.5h [ 66600 ] | 21.5h [ 77400 ] |
| Worklog Id | 85424 [ 85424 ] |
Snehal Katkar (Inactive)
made changes -
| Time Spent | 21.5h [ 77400 ] | 29.5h [ 106200 ] |
| Worklog Id | 85425 [ 85425 ] |
Snehal Katkar (Inactive)
made changes -
| Time Spent | 29.5h [ 106200 ] | 37.5h [ 135000 ] |
| Worklog Id | 85426 [ 85426 ] |
Snehal Katkar (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | 0.5h [ 1800 ] |
| Time Spent | 37.5h [ 135000 ] | 37h [ 133200 ] |
| Worklog Id | 85426 [ 85426 ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 38 - Enhancement [ 88 ] | WT Sprint 38 - Enhancement, WT Sprint 40 - Enhancement [ 88, 93 ] |
| Remaining Estimate | 0.5h [ 1800 ] | 0h [ 0 ] |
| Time Spent | 37h [ 133200 ] | 37.5h [ 135000 ] |
| Worklog Id | 85905 [ 85905 ] |
Gaurav Sodani (Inactive)
made changes -
| Dev Due Date | 05/Oct/2017 | 03/Nov/2017 |
Snehal Katkar (Inactive)
made changes -
| Time Spent | 37.5h [ 135000 ] | 45.5h [ 163800 ] |
| Worklog Id | 87482 [ 87482 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: On Hold(10207) |
Snehal Katkar (Inactive)
made changes -
| Assignee | Snehal Katkar [ snehal.katkar ] | Suraj Sokasane [ suraj.sokasane ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
180d 8h 56m | 1 |
|
42s | 1 |
|
5s | 1 |
Suraj Sokasane Do we have an update on the status of this ticket?