Processing old data into TimeLOG Web / Synergy Workforce

Processing old data if you've had to restore or a clock was not defined in the config file.

19 July 2019 16:58

1. Run Log Processor its in the sysserverdll folder.
2. Find the log file.
3. Search for Connection String not found
4. Open in excel
5. Sort A-Z
6. Data - Text to column delimited , select OTHER and use a - Delete columns either side
7. Sort A-Z Delete top and bottom lines without the IP address line
8. Select column Date -Text to Column Fixed (remove text and the final . )
9. Delete columns left & right
10. Select column Data - Remove Duplicates
11. Copy cells
12. Paste new cell Transposed (makes one row from a column)
13. Save file as CSV
14. Open in notepad
15. Copy this line and paste to the Filter by I box