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="bit" data-source="post: 670755" data-attributes="member: 10262"><p>Hoaxster is right <img src="/community/styles/default/xenforo/smilies/wink.png" class="smilie" loading="lazy" alt=";)" title="Wink ;)" data-shortname=";)" /> </p><p></p><p>However, if you want to become that random person, take a look on your computer, I'll bet perl is a ( very hidden) part of the standard image. You can do some AMAZING stuff with Perl/Python, the hard part was getting ppm to work with the proxy.... Infolib is easier to script against if you can manage to get an Oracle client installed and use sqlplus to spool results off, or use pass through queries on Infolib. Access is great when the data is small, but if you're dealing with large data sets, it's a pig. The other thing I don't like about Access is that any VBA you write for it is a moving target and you may have to port code to the new platform when you upgrade in 3 years.</p><p></p><p>My real piece of advice is to not screen scrape websites, and ask for access to the back end - or maybe ask them to create a tuned view that creates the data set you need. </p><p></p><p>I started where you were and now I'm a data architect ( albeit elsewhere, I was just dropping in on the boards to see how things were ) . It's a fun path and it's not for everyone and occasionally you'll want to rip your eyeballs out of the sockets, but that's the job <img src="/community/styles/default/xenforo/smilies/wink.png" class="smilie" loading="lazy" alt=";)" title="Wink ;)" data-shortname=";)" /></p></blockquote><p></p>
[QUOTE="bit, post: 670755, member: 10262"] Hoaxster is right ;) However, if you want to become that random person, take a look on your computer, I'll bet perl is a ( very hidden) part of the standard image. You can do some AMAZING stuff with Perl/Python, the hard part was getting ppm to work with the proxy.... Infolib is easier to script against if you can manage to get an Oracle client installed and use sqlplus to spool results off, or use pass through queries on Infolib. Access is great when the data is small, but if you're dealing with large data sets, it's a pig. The other thing I don't like about Access is that any VBA you write for it is a moving target and you may have to port code to the new platform when you upgrade in 3 years. My real piece of advice is to not screen scrape websites, and ask for access to the back end - or maybe ask them to create a tuned view that creates the data set you need. I started where you were and now I'm a data architect ( albeit elsewhere, I was just dropping in on the boards to see how things were ) . It's a fun path and it's not for everyone and occasionally you'll want to rip your eyeballs out of the sockets, but that's the job ;) [/QUOTE]
Insert quotes…
Verification
Post reply
Home
Forums
UPS Subsidiaries
UPS Information Technology
Scripting assistance
Top