EDS (weekly) -
|
1) Receive Email Attachment
- Save As [local file]
- Open IlliadPatronWorkspaceME.xsls
- Import into new worksheet
- Change format in ID col to TEXT
- Select & Copy up to header
- Paste into new dated (with today's date) worksheet
- Activate Macros: Ctrl+PUGS
2) Open IlliadPatronWorkspace.xsls (non-macro page)
- remove header from template
- Paste cols from ME-dated into non-ME sheet cols
- Paste header back in
- Select and Copy from bottom right, from inside yellow band on the right, up to the top
3) Paste into Notepad
- Find & Replace [tab] spaces with ###
- Fix top row to reflect ###
- Count bottom span of last name - should equal 18 #s
- Find & Replace double-spaces with single spaces until finished
- Save as "UserValidation.txt"
4) FTP to /illiad/import
|