Dramatically Shrink File Sizes for MS Word Manuals

If you are composing a technical document containing screenshots you will find the file size balloon very quickly. This makes it difficult to transmit via email and just wastes space on your hard drive.

There is a very simple way to compress the entire document without losing any of your details or pretty pictures, screenshots or diagrams.

Click on any one of the images in the document. Then click on the Red format button along the top ribbon.

Then click on the ‘Compress Pictures’ button (circled in red).

You will be prompted with the following menu.  Click OK.

This will compress the images and cut out any of the uncropped data that Word naturally stores. I just did this on a 30 page document and it cut the size from 2MB to 900KB which is much easier to use.

Hope this helps! Mike

Posted in Technology | Tagged | Leave a comment

Automatic BP Numbering in SAP Business One

Hello,

I have been honing this code for a while now and wanted to share it.  I ended up using it again today and I impressed myself.

This will automatically sequence up BP codes splitting vendor and customers (+leads).  It also has an optional prefix.

Save it as a query, then assign it to the Code field on the Business Partner Master Data, set it to auto refresh on Group Code.  I found it works the best.  Simply type the name of the BP you want to add and it will magically update.

Code__________________________________

--MJT/Forgestik - Auto sequential numbering for BPs.  Refresh on Group Code... trust me.  Remember to set PREFFIXES

DECLARE @CardType as NVARCHAR(1)
SET @CardType = $[OCRD.CardType.0]

IF (@CardType = 'C' OR @CardType = 'L')

  BEGIN

    SELECT 'C' + RIGHT('0000' + CONVERT(VARCHAR(4),(SELECT TOP 1 CAST(RIGHT(T0.[CardCode],4) as INT) +'1' FROM OCRD T0 WHERE 

(T0.[CardType] = 'C' OR T0.[CardType] = 'L') AND ISNUMERIC(CAST(RIGHT(T0.[CardCode],4) as INT)) = 1 AND 

LEN(T0.[CardCode]) = '5' ORDER BY T0.[CardCode] DESC)),4)

  END

ELSE IF (@CardType = 'S')

  BEGIN

    SELECT 'V' + RIGHT('0000' + CONVERT(VARCHAR(4),(SELECT TOP 1 CAST(RIGHT(T0.[CardCode],4) as INT) +'1' FROM OCRD T0 WHERE 

T0.[CardType] = 'S' AND ISNUMERIC(CAST(RIGHT(T0.[CardCode],4) as INT)) = 1 AND 

LEN(T0.[CardCode]) = '5' ORDER BY T0.[CardCode] DESC)),4)

  END
____________________________________________
I won't walk you through all of the steps here, but this will create an output something like C0010 and V0010.  But you can easily adjust it for almost any scenario.
You need to manually create the first customer/vendor or it won't work! (Or you can import through DTW first, but there needs to be at least one existing record for either cardtype).
Hope that helps!
Mike
Posted in SAP | Leave a comment

Rent Edmonton

If you are in Edmonton or considering moving there, rentedmonton.com is a great way to find places to rent.  It is the easiest and most straightforward way to get the best listings.  It divides up the regions logically and is useful for both renters and rentees alike.

First step is to select a region.  When you have selected a region you can filter by different types of properties, number of bedrooms and also rental price.

The listings are clear and include clear photos and occasionally video tours.  When you have found a property you like you can even quickly send the landlord an email through the form system.

Rentedmonton is the best way to find a rental property in Edmonton.  Use it today!!

Posted in Uncategorized | Leave a comment

Rent Calgary

If you are in Calgary or considering moving there, rentcalgary.com is a great way to find places to rent.  It is the easiest and most straightforward way to get the best listings.  It divides up the regions logically and is useful for both renters and rentees alike.

First step is to select a region.  When you have selected a region you can filter by different types of properties, number of bedrooms and also rental price.

The listings are clear and include clear photos and occasionally video tours.  When you have found a property you like you can even quickly send the landlord an email through the form system.

Rentcalgary.com is the best way to find a rental property in Calgary.  Use it today!!

Posted in Uncategorized | Leave a comment

Compliance. Best Friend of Process

I work closely with business processes in my career.  As I’m designing processes I need to keep in mind many things, accounting, operations, business analytics, etc.  BUT the one thing often left out is COMPLIANCE.  Not that I leave it out, just that I discovered the cool word for it.

Compliance is the bridge between the processes and what people will ACTUALLY do.  So if you design the absolute best process you can and nobody bothers to use it because it’s too complex or unreasonable then your process will fail.

I’ll add more later.

Posted in SAP | Leave a comment

Use your phone as a Wifi Hotspot

Just a quick tutorial. The driver for my laptop suddenly crashed whether due to some sort of hack attack or just general Microsoftery. I thought that tethering my iPhone using WiFi might kick it back on since my laptop recognized wireless networks but just didn’t display them to be connected. I discovered something interesting and I thought I would share it.

All you really have to do is have a newer iOS version (my example uses 4.3.2), an iPhone cable (technically you can wirelessly connect to your phone as well but as mentioned my phone had no wireless at the time) and just switch on the setting.

This technique can be used to harness your 3G network to get internet as well as using WiFi through your phone as I did.

Step 1

Get to your network settings. Settings app button >> General >> Network (see image below). Click Personal Hotspot.


Step 2

Turn on the USB hotspot settings. (See image below)


Step 3

Plug your iPhone into your laptop

Posted in Technology | Leave a comment

Agorism

I personally am sick of the government bullshit, the lies, the money passed between politicians and corporations. I’m sick of hearing about stories months after they occur and not being able to do anything about it. Government has grown out of control (particularly in the US, not as much so in Canada) and needs to be held accountable. In this age of technology there has to be a better way to handle all of the crap the government has to do.

Having said that, there is a strong group forming around the likes of Lulzsec and Anonymous who are trying to bring down the government through “hacktivism.” Hacktivism includes shutting down websites, DDOS (Distributed Denial of Service) attacks, hacking sites to put information up, hacking sites to retrieve information, using alternative methods to get into government files, etc. This is all aimed at destabilizing the power of the government through transparency (shining a light on the BS).

These hackers are all around the world and don’t have a specific leader or organizing party, they operate similar to Al Qaeda in that they are a distributed network. Like a starfish they don’t have a brain which can be killed, chopping off (ie, arresting, shutting down, blocking) one part off will not lead to the demise of the entire organism. Their activities are loosely coordinated through anonymous forums and other methods where users are working towards a common goal, but without explicit tactics or strategy.

The ultimate goal seems to be to shake things up and demonstrate that people are not happy and that gov’ts can’t hide and don’t have 100% control.

This can be extended to the Agorism movement (see Agorist Radio for info) which seems to be driven by the principles of ‘privacy’ and the notion that the gov’t has too much say and control over their daily lives. I personally don’t care about privacy if it helps to eliminate any crime at all or prevent theft or fraud. I have absolutely nothing to hide.

The tone of the agorist movement seems to be exploratory and I’m very interested in the various sides (Bitcoin, free markets, etc.) but the focus is always back to privacy. Circumventing the system to create privacy, untraceable transactions. Who gives a shit about traceability? Isn’t it easier if there is an audit trail? If the system is going to come down then there would be a need for a BTC type currency which would still allow a transaction of value between individuals for goods and services, but it’s already turning into the system we have today (stock markets, etc.).

There also seems to be a bit of a technology superiority vibe meaning that these hackers have a level of knowledge of computers beyond the normal person and even the government so they will use that to express their power that way. I think that this is great for the few, but if they want it to be widely adopted, or enough so that normal citizens can use it they need to make it easier to follow and by the time you know it, the system is basically a mirror of the current one.

And if any real progress is made, the same sharks from the original system will figure out the new system and dominate it. Leaving the original hackers with their meager change and a set of dominant players taking control. These hackers want to level the playing field, but they fail to understand that successful people figure out systems. There might be a lag, but human nature will take over and the original people will regain control.

I keep following this movement closely but fail to see a realistic end game. I would like to see governments tighten their belts and become accountable to their citizens, I would like to see the real story in real-time with a method for us to give feedback. The current system doesn’t work anymore and it’s become too top heavy with useless moronic leeches. I don’t know if we can burn the establishment, but there needs to be some changes.

Posted in Opinion, Technology | Leave a comment

Second Realm and Bitcoin Summary

I have been digging into The Second Realm movement in the past few weeks compiling my notes on the various things I have found. Here are my impressions.

“The Second Realm” is a term used to describe a permanent autonomous zone that certain groups of Crypto-Anarchists, Anarcho-Capitalists, Agorists, hackers, etc. are trying to create. A place where full economic freedom can be achieved with no interaction with “The First Realm” (our current economy, government, corporations, etc.). They claim the reason is to circumvent the governments control over their everyday lives, to live and trade anonymously and build a better world free from the control of “The Man.”

One of the primary ways of doing this is with a totally open source and anonymous currency known as Bitcoin (view market cap and real time value here). Bitcoin (BTC) is what they call a “non-political” currency that is free from borders and direct government control, and is 100% anonymous. There isn’t even a central server, the servers are spread across the world using extra GPU time on machines that volunteer to help the cause. This currency has been gaining much momentum and has recently been brought to attention of the authorities due to a Second Realm site called SilkRoad where you can use Bitcoins to anonymous but things (including drugs, etc.) More Info Here.

SilkRoad is a site that exists in a Dark Net zone known as Tor inaccessible from the normal web and designed to be accessed mainly by computer savvy individuals but not altogether hidden. The purpose of a Dark Net is to create an entirely separate zone from the regular www that is anonymous, secure and hidden.

Generally these activities are experiments by hackers, but if you look at the market cap for Bitcoin you will see that the market is worth $35M USD which isn’t just some small amount of users. It also has a small but growing stock market and new players are entering the scene daily.

Currently, users are using Bitcoin for paying for goods and services the same way you would use cash. Websites can accept them, they can be passed on USB sticks as cash and one Bitcoin miner actually had $500,000 worth of BTC stolen from him. But ironically they can’t trace the transaction because it’s anonymous. I laugh whenever I hear this story.

Personally I’m fascinated, but this is just scratching the surface of the subversion movement that is growing. My next article will focus on the Agorist movement and how it relates to BTC.

Posted in Opinion, Technology, Theories | Leave a comment

I ♥ Deviantart.com



If you are into art at all, this is the site for you. It is amazing how many spectacular artists are on this site. You can start from the homepage and view random popular works, but my favourite is to look at the daily deviations or search for a topic, find the one I like the best, look up the artist, then look at their favourites. If you do this, generally the favourites of an artist that you really like the style of will be packed with amazing similar pieces. This way you can find an artist or photographer that you really like and if you are lucky they have several hundred of their favourites for you to browse.

You have to avoid the nudes and anime, but when you find some artists you like you can even +watch them if you have an account, so you can login from time to time and check out new pieces from your favourites. You can even contribute yourself, look for feedback, earn llamas, etc.

Give it a try! There is everything from amazing photography, digital art, hobbies even poetry.

Click Here to Visit DeviantArt

If you ask me nicely, I might share all of my favourites.

Posted in I ♥ | Leave a comment

The Stupid Man

Why are men drawn to doing dumb (reckless, wild, crazy) things? And why are these primitive bahaviours attractive to females?

It relates back to the early days of man when we still had to do daring and adventurous things. Hunting with a spear or knife is incredibly dangerous, takes amazing amounts of stamina and athletic ability, intelligence and aggression. This example also works for warfare and fighting. Ever thought of walking onto a field and hitting another person with a sword who is also trying to hit you??

These weird behaviours were required for survival, if you didn’t have the aggression and skill to kill you would not be around for long. So I think this is what draws in mates as a trait that will help pass on genetics (providing for children and protection). The problem happens when these tendencies go too far or are not in line with social construct behaviours. IE, when a man hits a woman or does things so dumb that he needlessly puts his life or the life of others in danger.

The bottom line is that men that do dangerous or challenging things are rewarded with more mating opportunities (professional fighters, motorcycle racers, military men, etc., etc.). Females are subconsciously drawn to men who can bend the rules or push the envelope in doing activities which get things done (kill an animal, protect a tribe, etc.).

The dichotomy occurs when a these men are expected to be both nice and savage. The perfect balance between bad boy and family man. A man that is nice to women and family but will violently defend them. The problem is the hunters who go too far also end up hurting their tribes and while a certain amount of digression is understood, you are always walking the line. When a woman says, “he’s always nice to me” but then goes on to get thrown in jail. He clearly has not balanced the equation.

Therefore I propose the requirement to be daring and adventurous needs to be tempered with love and caution and that as men move from their early days of being a child, through being a warrior (teens, early twenties), on to being a chief (thirties – forties, fifties) and through an elder they would be wise to be as bold as they are caring.

Posted in Theories | Leave a comment