Home
Forums
New posts
Search forums
What's new
New posts
Latest activity
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
UPS Subsidiaries
UPS Information Technology
Scripting assistance
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Deeohem" data-source="post: 620351" data-attributes="member: 5860"><p>These reports ARE a lot of work. The workload will drop once the win2k sunset is over (most of what I'm flagging are either new XP replacing 2K or the old 2K getting removed from use) But even then, with the churn in systems and keeping everything up to date, it's still gonna be measurable time each day and I'd rather have that time free for tasks that more directly benefit my internal and external customers. </p><p></p><p>It seems like I have three responses.</p><p></p><p><em>1) Don't do it, it's only be bug-ridden and IS will inherit it and be stuck trying to support it. </em></p><p>I understand this argument and sympathize. There is a need to maintain control of projects and IS too often gets stuck cleaning up the mess. This is why the CTSG Project Notebook had a section for Functional Applications, Those which were sorta rolled out, but that did not have the standard corporate support structure. Hoax, Random, It probably will have a bunch of bugs. I'm not trained to be a programmer and I'm not going to be 100% comfortable with the tools I'd need to use. But I will be hammering it until the bugs are either gone or less annoying than some of the time outs I get using I doubt IS will ever know it exists. This isn't SPARCS or any of the other func apps. It has a planned audience of 1 maybe 2 (if I ask the my partner to run it during vacation coverage) Management isn't asking me how I'm massaging the data only where it came from. I figure as the user, I'd be stuck supporting myself with it.</p><p></p><p><em>2) use Auto-It anyway and compile the exe</em></p><p>This is very tempting. Is there still a copy of the Auto-It V2 executable on the Windows build CDs? Honestly though, if I were to go that route, I'd use AutoHotkey. I'm more familiar with it's tricks and foibles. And yes, I'd have to violate company policy concerning 3rd party software in order to do it. but... If I'm using my personal computer at home via Remote.ups....</p><p></p><p><em>3) Use Data Warehouse or Infolib, that's what they're there for </em></p><p>This sounds like the best way to continue. Do either one of them contain information from EARS? I'm sure I could talk my manager into approving an ID request. Then I'd just need to revisit the code for comparisons, decide if I need to do it in VBA or SQL, I think I could remotely run the commands from Access on each record in the various queries, record results in temp tables and then combine in new queries and export as necessary. I think I could do this. </p><p></p><p>As part of my reports, I'm checking AD Tools and OSP's SIRF to check AD status on inventory. Does Infolib or Data Warehouse allow read access to AD? or would I still have to do that part manually?</p></blockquote><p></p>
[QUOTE="Deeohem, post: 620351, member: 5860"] These reports ARE a lot of work. The workload will drop once the win2k sunset is over (most of what I'm flagging are either new XP replacing 2K or the old 2K getting removed from use) But even then, with the churn in systems and keeping everything up to date, it's still gonna be measurable time each day and I'd rather have that time free for tasks that more directly benefit my internal and external customers. It seems like I have three responses. [I]1) Don't do it, it's only be bug-ridden and IS will inherit it and be stuck trying to support it. [/I] I understand this argument and sympathize. There is a need to maintain control of projects and IS too often gets stuck cleaning up the mess. This is why the CTSG Project Notebook had a section for Functional Applications, Those which were sorta rolled out, but that did not have the standard corporate support structure. Hoax, Random, It probably will have a bunch of bugs. I'm not trained to be a programmer and I'm not going to be 100% comfortable with the tools I'd need to use. But I will be hammering it until the bugs are either gone or less annoying than some of the time outs I get using I doubt IS will ever know it exists. This isn't SPARCS or any of the other func apps. It has a planned audience of 1 maybe 2 (if I ask the my partner to run it during vacation coverage) Management isn't asking me how I'm massaging the data only where it came from. I figure as the user, I'd be stuck supporting myself with it. [I]2) use Auto-It anyway and compile the exe[/I] This is very tempting. Is there still a copy of the Auto-It V2 executable on the Windows build CDs? Honestly though, if I were to go that route, I'd use AutoHotkey. I'm more familiar with it's tricks and foibles. And yes, I'd have to violate company policy concerning 3rd party software in order to do it. but... If I'm using my personal computer at home via Remote.ups.... [I]3) Use Data Warehouse or Infolib, that's what they're there for [/I] This sounds like the best way to continue. Do either one of them contain information from EARS? I'm sure I could talk my manager into approving an ID request. Then I'd just need to revisit the code for comparisons, decide if I need to do it in VBA or SQL, I think I could remotely run the commands from Access on each record in the various queries, record results in temp tables and then combine in new queries and export as necessary. I think I could do this. As part of my reports, I'm checking AD Tools and OSP's SIRF to check AD status on inventory. Does Infolib or Data Warehouse allow read access to AD? or would I still have to do that part manually? [/QUOTE]
Insert quotes…
Verification
Post reply
Home
Forums
UPS Subsidiaries
UPS Information Technology
Scripting assistance
Top