Search results for query: *

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...

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...

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...

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'...

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...

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...

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...

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...

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...

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 |...

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...

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...

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...

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...

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...

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'...

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...

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...

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...

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...