Recent content by MkIIISupra

Hehehe, I found the problem! I was naming both destination files the same! DOH!!! One is supposed to be reads the other usages! Caught it and it works fine.... One by one the penguins return my sanity, as day by day Microsoft steals my sanity! OpenSuSE 10.0 kicks fanny!

Man that cleaned a lot up! Thanks! I am still learning Perl and have only been seriously working with it for about a week. Unfortunately I have been working with VBA for the last couple year, but now I have this killer job at UCSC, I am allowed a lot of freedom. As in I can choose my language...

#!/bin/bash/perl -w # This is a rename and move script. The goal is to rename files then move them to their # appropriate folders, and then e-mail (hopefully) the files to pre-defined people. use warnings; use strict; use diagnostics; use Time::Local; use File::Copy; my $date = `date`; # Load...

Oh, do I feel like a heel... Thank you! One by one the penguins return my sanity, as day by day Microsoft steals my sanity! OpenSuSE 10.0 kicks fanny!

Below is the error I get when I try to run a script I am slowly building. I am in the learning process with Perl and this is my 3 script that I have written. The first two were very simple and short. My goal with this script when I finish is to have a CRON job scan a predefined directory and...

Oh... man do I feel like a knuckle head... Thanks! One by one the penguins return my sanity, as day by day Microsoft steals my sanity! OpenSuSE 10.0 kicks fanny!

Here is some output to help... This is the actual output of the code in my first post: ID_CODE = E10301 Records = 9 HIGH USAGE = 1819 LOW USAGE = 1149 This is the output, what I have done is concated each instance of LOW USAGE writing. So what you are seeing are the LOW USAGE numbers in the...

I am doing a search for the high and low of a series of records, from there I will get the standard deviation and then compare a new read against that to see if it is within the realm of reasonable. If it isn't then I can research the problem and correct it before I update any tables. Here is...

I have a text box set up to receive errors found in a variety of records. Okay what does that mean? Simple, I have a set of pre-defined records that I read in every month from a handheld meter reader. During the import phase I run a series of checks against the data and anything that falls...

No, I can't seem to find any tools that fit the description. Looks like I am stuck. Only solution is to create a parallel DB in Access until I can resolve this. Thanks. One by one the penguins return my sanity, as day by day Microsoft steals my sanity! OpenSuSE 10.0 kicks fanny!

Okay one issue resolved a new one arises... When I try to add or modify a record in a linked Sybase table I get the following error: ODBC --insert on a linked table "DBA_Meterhst' failed. [Sybase][ODBC Driver]Unable to connect to database server: authentication violation (#-98) When I click...

Found the answer! When I was linking the Sybase tables I failed to ID the PK of 5 of the tables. So Access couldn't and wouldn't let me do anything but read the tables (data). Once I linked and ID'd the PK of each table I was allowed full access and so now I am on my way! Thanks for the...

Okay so I have been doing some digging around and here is what I have to deal with. Sybase iSQL 5.5.05 Build #2509. I found a good resource on Sybase <A href="http://manuals.sybase.com/onlinebooks/group-asarc/srg1100e/sqlref/@ebt-link;pt=66?target=%25N%13_577_START_RESTART_N%25">Here</A> but...

I have to keep the old tables up to date for a while. We are in a transitional period at the moment. Right now we are looking at a new databasing application to replace Faser. But until then I need to keep the Faser tables current. I am using Access as an interface due to the ability to create...

Ironically... it's now me! And I am not familiar with it either, I have a tool called iSql that comes with the Faser DB system. I am a bit rusty on setting table permissions and such via SQL... care to help? :) One by one the penguins return my sanity, as day by day Microsoft steals my sanity...