I have scripts that compare an active employee list with an access list from various systems. For example AD. At the end of the day, I end up with two tables. One that shows people who have access to the system that are active employees and another one that shows accounts that don't belong to active employees. The two tables then get exported to Excel. The goal is to have nothing in the inactive employee listing.
The problem I have is when my script does the export to Excel, if the table is empty, it goes kablooie. I know I can do a resume and skip the export, but I need to have that excel file, or file of some sort that came out of Idea to prove that yes. There were no inactives.
I have worked with a secondary source file that has a single record that I can import in and append with my inactives which works. But for each application I script, I have to have a error file and do all of that import.
After all that, the question is this.
Is there a way to append a record via keyboard/script to a table?
Clear as mud?
Last seen: 2 years 1 month ago
Joined: 04/29/2015 - 16:56