Tuesday, March 29, 2011

Split a PDF

From the developers website:

pdfsam basic:

A simple tool designed to split and merge pdf files. With it’s simple and intuitive interface you can:

  • split your pdf documents (into chapters, single pages, etc.).
  • merge many pdf documents or subsections of them.
  • extract sections of your document into a single pdf document.
  • mix alternate pages taken from two pdf documents in straight or reverse order into a single document.
  • rotate pages of the selected pdf documents.
  • visually reorder pages of a selected pdf document.
  • visually compose a document dragging pages from selected pdf documents.
  • save and load your environment to automatize your recurrent jobs.
  • manage pdfsam settings and set an environment to load at start up.

Find it here:
http://www.pdfsam.org/?page_id=32

Tuesday, March 22, 2011

Making an org chart from Exchange, part 2.5

Here's a link to one of the samples I'm using while building this:

http://vbaexpress.com/kb/getarticle.php?kb_id=222

In the author's words:
Dumping the Global Address List (GAL) to Excel provides an list in a form that can be easily searched or summarized. I recently had a phone call that was garbled and I caught only a fragment of his mobile phone number. I was able to quickly find this person's details by searching the Excel list. Can also be used to find multiple addresses in the GAL or to filter the GAL by location.


Here's another:
http://msdn.microsoft.com/en-us/library/Aa201300

And another:
http://www.outlookcode.com/article.aspx?ID=40

And from the OutlookCode.com, above, links here:
http://www.slovaktech.com/code_samples.htm#DLToWord

Tuesday, March 15, 2011

Making an org chart from Exchange, part 2

So what I want to do is, like I said before, is build a report that displays an org chart for my organization.

In order to do this, I'm think I'm going to need to
  • Figure out SSRS - I've done lots of Crystal Report writing in a previous life, so this should be more a matter of learning the UI
  • Find the data lurking somewhere inside of Outlook
  • Write a VBScript extraction routine inside of Outlook to push the data to a database source somewhere
  • Write the report, being cognizant of the org structure of my organization, and how the data is grouped

Tuesday, March 1, 2011

PowerShell math shortcut

So I'm using PowerShell as a calculator - I mean, why not, right? I've got the window open, and it's great for quick "What's the size of the LUN again?" sorts of questions. It's also really good at telling me the cost of things on a monthly basis.

For example, if you're spending $10/week on coffee, and you want to know how to figure that as a monthly cost, you'd multiply 10*4.3 in the PowerShell prompt for an answer of 43.

However, what if you want to find out how much it would be if you spent $12.50 a week? Rather than type in the full equation of 12.50*4.3, you might think you could use the last-tag-in command, or $$.

But instead, if you put $$*12.5 in the prompt, and hit enter, PowerShell returns that string 12.5 times, or
4.34.34.34.34.34.34.34.34.34.34.34.3

This appears because PowerShell is treating the last tag as typeless, with a default value of text.