Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Pink
Assigned To: Joshua Sagert
Created By: Cory Warden
Created Date/Time: 11/19/2019 12:28 pm
 
Action Status: Completed
Show On The Web: Yes - (public)
Priority: 11
Finished/Done: Yes - 1/21/2020 2:03 pm
Finished/Done By: Cory Warden
Budgeted/Estimated Value: 0.00  
Actual/Real Value: 0.00   [donate]
Invoice/Quote Status: Blank (n/a)
General Amount: $0.00
 
Time Id: 1554
Template/Type: Community Funded Projects
Title/Caption: CA drivers license field needs tweaking
Start Date: 11/19/2019
End Date: Unknown... (open or blank)
Total Time: Unknown... (open or blank)
Target/Due Date: 11/19/2019
Main Status: Active

Sorry, no photos available for this element of time.


Uploaded Media/Content & Other Files (1)
Media Name   File Type Date Description
CARD SWIPE.docx   Doc/Text 11/20/2019


Notes:

11/20/19: Steve sent a note with data- please see attached.

Cory emailed Steve Mitchell asking for more data to demonstrate what exactly is being pulled from the CA DL to determine what needs to be fixed/edited.

From Steve Mitchell: We are trying to swipe in new customer info at Euflora Long Beach and apparently everything is jumping into the first data field.

From Brandon: One of the main pages will be top_secret/custom/process_drivers_license.cfm - pretty heavy in script and string manipulation.


Additional Date/Times - Subs (3)
Title/Caption Start Date Start Time End Date End Time Age Notes
Progress Notes - 12/6/2019 11:39 am 12/6/2019 7:17 pm 7.63 Hours Done with first scan algorithm, working on second scan
Progress Notes - 12/4/2019 9:33 am 12/4/2019 1:35 pm 4.03 Hours Continue building algorithm
Progress Notes - 12/2/2019 10:17 am 12/2/2019 2:37 pm 4.33 Hours Analyzing string for manipulation, start building algorithm jcs

Total Time In Hours And Minutes: 16:00 :: Total Hours As A Decimal: 16.00

Additional Comments/Notes - Subs (1)
Title/Caption Date Time Done By Comment/Note
notes for algorithm 12/2/2019 2:28 pm Joshua Sagert

%CALONG BEACH^FORD$JARED$RYAN^3334 E BROADWAY 3^?;636014253585547=200819910821?

NAME:

the name is stored in between the first "^" and the second "^".   The first, middle, and last names are separated by the only two "$" symbols.   

last name:   the last name is stored between the first "^" symbol and the first "$" symbol.    

first name:  stored between the only two "$" symbols

middle name:  stored after the second "$" symbol and the second "^" symbol


DOB:

temp string to start from the end of the string, take the last 9 of the string.  the first 8 of that string is converted as follows:

first 4 of the string:   year of birth

next 2 of the string:   month of birth

next 2 of the string:  day of birth

ADDRESS:

in this case, we need to store a tempString with the entire address because we do not know how long the address is.   We need to catch everything in the string past the "%" up to the first "?" in the string.   


first 2 of the string:  state of address

we should be able to test the length of the string so that we can separate out the last part of the address.   the length of the preceding variables is fixed and it should be predictable which part of the string is which.

the city of the address is the string that starts before the first "^" in the string and after the state 2 characters.   this can be variable length.   the state code should always be a 2 character code and if we take out these first two characters it should give us the complete name of the city to store in a temp string

the actual street address is stored between the 2nd and 3rd "^" tags.    There is an extra 3 on the inside on the last part...  this might denote "st, dr, way, cir