Author Archives: Aron

Online File Storage and Management

December 5, 2013 – 4:32 pm

I’ve been looking for some time trying to find a nice and easy file management server I could host that would give me the same abilities as a ‘Drop Box’ or ‘Google Drive’.  Finally stumbled on an open source server that does just that, it’s called Pydio and installs on a standard LAMP server and gives you that capability.  So far I’m really impressed, it has the drag and drop features that you’ve come to expect and does a heck of a job.

Permalink | Comments Off on Online File Storage and Management

Java classes

December 4, 2013 – 4:10 pm

public void addFriend(Person friend);

Public signifies that the class is going to be public and called.

Void means that it will not return a value but do something.

addFriend is the name.

Person and friend are the items passed when it’s void.

If the class is going to return something declare the variable type it will return:
public String getFriends();

Instance variables:

private [type] [name]

Permalink | Comments Off on Java classes

TCC – SUBSTRING Function

November 27, 2013 – 7:07 pm

Here is an example of how to do the substring function in TCC:

</pre>
<quer:projection alias="JobCode">
 <quer:substring>
 <quer:field path="JobCode"/>
 <quer:integer>0</quer:integer>
 <quer:integer>20</quer:integer>
 </quer:substring>
 </quer:projection>
<pre>
Permalink | Comments Off on TCC – SUBSTRING Function

TCC – Logical OR filtering

November 27, 2013 – 5:42 pm

Writing SQL is kind of hard if your filtering is limited to and under the where clause.  Here’s an example of how to filter using OR, in this case we had 14 items:)


<quer:filterings>
 <quer:filtering>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712187</quer:string>
 </quer:containsIgnoreCase>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712188</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712186</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712865</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712183</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712386</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712063</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712063</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712084</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712089</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712185</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712604</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712657</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 <quer:containsIgnoreCase>
 <quer:field path="JobCode"/>
 <quer:string>712839</quer:string>
 </quer:containsIgnoreCase>
 </quer:or>
 </quer:filtering>
</quer:filterings>
Permalink | Comments Off on TCC – Logical OR filtering

TCC – DECODE Function

November 17, 2013 – 11:44 am

This is one that I’m not 100% familiar with the Oracle counterpart of the Decode function.  In this particular instance it’s used to parse out and assign the gender component of the EEO questions.  This is very hard to extract from the system and is only done so after a hire is made so that the information can be passed to the HRIS for hiring and payroll purposes.

<quer:projection id="idGender" alias="Gender">
 <quer:query projectedClass="Candidate" alias="CandGenderNo">
 <quer:projections>
 <quer:projection alias="EEOGender_AnswerNo">
 <quer:decode>
 <quer:field path="QuestionAnswers,Answer"/>
 <quer:string>-11</quer:string>
 <quer:string>M</quer:string>
 <quer:string>-12</quer:string>
 <quer:string>F</quer:string>
 <quer:string>Not Specified</quer:string>
 </quer:decode>
 </quer:projection>
 </quer:projections>
 <quer:filterings>
 <quer:filtering>
 <quer:equal>
 <quer:field path="QuestionAnswers,Question"/>
 <quer:integer>-3</quer:integer>
 </quer:equal>
 </quer:filtering>
 <quer:filtering>
 <quer:equal>
 <quer:field path="Number"/>
 <quer:field ownerQuery="MainQuery" path="Candidate"/>
 </quer:equal>
 </quer:filtering>
 </quer:filterings>
 </quer:query>
</quer:projection>
Permalink | Comments Off on TCC – DECODE Function

TCC – TO_CHAR Function (datetime)

November 16, 2013 – 5:01 pm

This is an example of how to use the Oracle TO_CHAR function in TCC:


<quer:projection alias="DateOfBirth">
 <quer:customFunction name="TO_CHAR">
 <quer:field path="Candidate,Birthday"/>
 <quer:string>MM/dd/yyyy</quer:string>
 </quer:customFunction>
</quer:projection>
Permalink | Comments Off on TCC – TO_CHAR Function (datetime)

TCC – SUBSTR Function

November 16, 2013 – 4:51 pm

This is an example of how to use the Oracle SUBSTR function in TCC:

<quer:projection alias="work_state">
 <quer:customFunction name="SUBSTR">
 <quer:field path="Requisition,JobInformation,WorkmansCompCode,Code"/>
 <quer:integer>1</quer:integer>
 <quer:integer>2</quer:integer>
 </quer:customFunction>
</quer:projection>
Permalink | Comments Off on TCC – SUBSTR Function

Expense a steak

September 20, 2013 – 1:24 pm

I may be a computer geek but I have a sense of humor.  There is a site called expenseasteak.com that is run by a steak house in NY that helps you sneak a steak dinner onto your expense report by breaking it down into office stuff receipts, hysterical!!!

Permalink | Comments Off on Expense a steak

Shortcut to programs control panel Windows 8

September 5, 2013 – 6:40 am

Well we have to hand it to the monkeys in Washington, they stepped in the proverbial open can of paint with Windows 8.  So to help myself and others I’m putting together tidbits to try to ease the pain.

Start Button + r = run screen

appwiz.cpl takes you right to the Programs and Features window

Permalink | Comments Off on Shortcut to programs control panel Windows 8

The name game with Excel spreadsheets

August 15, 2013 – 5:08 pm

Basic take-away is:

=LEFT(A1,FIND(” “,A1,1)-1)

=RIGHT(A1,LEN(A1)-FIND(” “,A1,1)

Here is a really good article on it.

Permalink | Comments Off on The name game with Excel spreadsheets

« Previous Page — Next Page »

« Previous Page — Next Page »