Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Pink
Assigned To: Alan Williams
Created By: Cory Warden
Created Date/Time: 5/27/2020 1:30 pm
 
Action Status: Completed
Show On The Web: Yes - (public)
Priority: 0
Finished/Done: Yes - 10/12/2020 9:24 am
Finished/Done By: Cory Warden
Budgeted/Estimated Value: 2,000.00  
Actual/Real Value: 3,375.00   [donate]
Invoice/Quote Status: Blank (n/a)
General Amount: $0.00
 
Time Id: 1796
Template/Type: Community Funded Projects
Title/Caption: Payroll import tool
Start Date: 5/27/2020
End Date: Unknown... (open or blank)
Total Time: Unknown... (open or blank)
Target/Due Date: 5/27/2020
Main Status: Active

Sorry, no photos available for this element of time.


Notes:

5/27/2020: Client paying downpayment to get in queue. Wants it to work by 7/1/2020, but we are pretty far out in our queue.

1. We would need to know the exact format - columns, numbers, and layout.

>> 2. I've included a raw sample of what it looks like. If you look, you
>> will see that there are no column headings and tons of blank data (back to back commas) 3. A CSV (comma separated values) file has data separated by commas. For example: column 1,column 2, column

3,,,, - we would need to know what every possible column needs to be mapped to. In the example, we can see data in columns 1-3, however columns 4-7 are blank. We still need to know what would go there if there was data.
>>

4. Once we know the real format, we can then build a tool to pull in the data, parse it (break it apart into usable pieces), and then do bulk inserts into the database.