Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RottPaws
  • Content: Threads
  • Order by date
  1. RottPaws

    SSIS -- ETL, then move Excel file

    I've got an SSIS package that is supposed to loop through the tabs of an xlsx file, extract data, and then move that file to an archive folder. It sounds simple enough, but I can't it to work. I have a Foreach Loop container that gets a collection from a network drive and gives the file name...
  2. RottPaws

    Save user data lookup field values

    I've inherited an OpenOffice template that has user data look-up fields for work phone number and fax number. There is a macro that does some manipulation of the document and then saves it as a .sxw file on a network drive to be imported by a document imaging system. oDocument = ThisComponent...
  3. RottPaws

    MSSQL 2005 Express reinstall sa password error

    MS SQL Server 2005 Express was installed on our SBS server as part of TimeClock Plus 4.2 that was not working. Both were having problems, so I removed them through the Control Panel Add/Remove Software tool. I'm trying to reinstall, but when the SQL Server 2005 Express installation gets to...
  4. RottPaws

    Regexp help -- matching filenames with different versions

    I'm trying to loop through a group of files for processing, but some files may have different versions in the batch and I only need to process the latest version of each one. I've got an array of filenames (reverse sort): @stl_files = [ 'STL-20120925.01.006_IPSP.CSV'...
  5. RottPaws

    Remote Desktop domain/certificate problem

    We've got SBS2011 Standard installed and we're having difficulty with the remote desktop feature. I've been tasked with figuring it out. I've either been on google or had my nose in a book for a few days, but haven't been able to find any info that has been helpful. From within the domain. I...
  6. RottPaws

    replace last REGEX match

    I have a string of comma delimited numbers and I want to replace the last comma with ' and '. I can write a regexp to find the last instance of ', ', but I haven't been able to figure out how to replace just that. It drops the last order number from the string $ord_list = '12345678, 23456789...
  7. RottPaws

    Automate web browsing

    I need to write a script to mine data from a web site. I could do it in Perl, but now I'm stuck on an environment that only has PHP and I'm a newbie in PHP. If anyone could point me to a tutorial or an example script for what I need, that would be great! Here's what I need the script to do...
  8. RottPaws

    Refresh/reload opener without retry pop-up

    I'm trying to refresh the parent window after a child window has finished some processing. Getting it to reload is simple enough. I've found thousands of threads with "opener.reload(true);" as the answer and it does work. But I'd like to make it work without the Retry/Cancel prompt on the...
  9. RottPaws

    How to open and pass info to another script

    What is the best/proper way to have one script run another and pass neede information to it? I have a cgi web page that can be used to request a report. Certain options can make it take a long time to generate the report and the web page will timeout and kill the script. So what I did is I...
  10. RottPaws

    Sorting keys in a nested hash

    I'm trying to sort the keys in a nested hash and it's not working right. My data is sort of like this %status_info -- group | member | snapshot | condition AAA | |- 1 | |- 1 = Good |- 2 = Good |- 3 = Bad |- 4 = Good |- 2 |...
  11. RottPaws

    Web automation with Perl

    I need to script interaction with a few web sites and I've tried WWW::Mechanize, but a couple of the sites have JavaScript on the submit buttons and another is written in Java. Does anybody know of any module(s) that will help with automating Javascript and/or Java web sites? Or does anybody...
  12. RottPaws

    Print nested hash with variable depth

    Does anyone have or know of a tutorial on printing/looping through a nested hash with a variable number of nests? I know how to do it when the depth of the nesting is fixed and known, but when it's variable, I don't know of an efficient way to code it. And I haven't figured out the correct...
  13. RottPaws

    procmail match and forward

    I have a procmail recipe that looks for a particular X-header and when it finds it, it extracts the email address behind it and forwards the email to that address. procmail recipe :0c BH * ^X-Sender: \/[^ ]+ ! $MATCH This works fine as long as the only thing behind the...
  14. RottPaws

    Date-Time conversion

    I'm trying to create a report of information in a scheduling database. The scheduling information is divided into 2 fields, one for the date and another for the time. The START_DATE field is a DATE datatype. The START_TIME is VARCHAR2 with times entered as 0, 30, 100, 130, ... 2330. To...
  15. RottPaws

    Memo field in append query to linked Oracle table

    I've been searching for hours and have found literally thousands of articles that mention the problem of Access Memo fields and Oracle, but none that offer any solution. I need to do some automation for someone based on some data they have in an Access 2002 Database. I have an Oracle 9i...
  16. RottPaws

    sendmail error kills script

    I'm using MIME::Lite in a Perl script to send am email with sendmail. $msg = MIME::Lite->new( From => $From, To => $To, Cc => $CC, Subject => $Sub, Bcc => $BCC, Type => 'multipart/mixed'); $msg->attach( Type => $BodyType, Data => $Body); $msg->send('sendmail'...
  17. RottPaws

    How do I get a sub-query to just take the first row

    I have a script that ranks order contacts. 99.99% of the time, this results in a single top contact that I use to update a table. But that one in 10k that has 2 contacts with the same ranking kills my script with the "single-row subquery returns more than one row" error . Here's my...
  18. RottPaws

    Get old value in onchange event function

    Is it possible to retrieve the old value for a text input control in a function that is run by an onchange or onblur event? I've got a series of records that are retrieved and when a field in one record is changed, I'd like to loop through the remaining form elements and update any other...
  19. RottPaws

    Link to Oracle DB that is not in TNSNAMES.ORA

    Is it possible to create a dns file and/or link to tables in an Oracle database that is not in the tnanames.ora file? I have all the TNS info to connect to the database in question, but have not been able to figure out how to connect to it. The obvious solution would be to add the database...
  20. RottPaws

    Accessing archived email in a .pst on CD/DVD

    I have a bunch of old email archived to a DVD in several .pst files. But I can't access them from the DVD because they are read-only and that property cannot be unchecked. Is there anyway to circumvent the read-only problem and access the emails from the DVD without having to first copy the...

Part and Inventory Search

Back
Top