Monday, September 20, 2010

The US Customs Rules have not Kept Up with the Realities of Global Knowledge Work

As a global consultant, I travel from time to time to the United States.  When you go through customs, you are questioned to ensure that you are not “working” full-time in the United States without a green card or visa.   

The basic rules for "working" in the United States when you interact with airport customs seem to be as follows:

  • You are not allowed to be a "worker" without a visa or a green card
  • To get either a visa or green card you have to be employable in the US for an extended period of time, e.g. permanently in the case of the green card and at least a year in the case of a visa
  • Getting a NAFTA visa is based on a list of in demand occupations such as teacher, computer programmer or occupational therapist
  • If you do the work in another country they will let you visit your customer in the united states on occasion.  There is no specific rule that is spelled out but in my experience if you go down for a couple days in a month you are ok but if you are going down too often or stay too long the customs officer will start suspecting you are doing "work" in the United States.
  • You are allowed to go into the United States on business if you state that you are in “Sales”, e.g. to close a deal. 

So those are the basic rules, formulated decades ago before the Internet era.  The rules clearly show a very mid 20th century view of "work":

  • "Work" equals hours put in against a job requiring a very specific boxed in role.  The worst thing to tell a customs officer is that you are a "business analyst", "trainer", "strategist", or "consultant".   "Work" equals a job that an average customs officer had heard of, e.g. farmer or secretary.  Try explaining what you do as an "Information architect" and you will be met with suspicion.
  • "Goods" equals tangible imports like lumber, cars, etc.  What if your "good" is a company's online strategy that they just paid you 150k to develop?    What if your “good” is something that you can store on a USB key in your pocket? 
  • "Labor market" is based on the notion that you have to be in the country in order to work.  It misses the point that I can do millions of dollars of knowledge work without any concept of borders. 
  • “Work” means working on premises.  I can work just fine for a US company as long as I work for a Canadian company and ship goods into the United States.  However, if I want to spend 2 weeks deploying the “product” on site, then I’m going to get questioned.

If the goal is to prevent labor from competing with local “workers”, these types of restrictions don’t really provide much support in the digital global knowledge working realm.  Really, the rules basically are a restriction on face to face meetings but place no restriction on me being able to compete first hand with local resources from remote access points.  Instead, they just put a barrier to innovation and physical collaboration as a complement to existing means of digital collaboration.  It means that American companies with offices in other countries (Canada being a great example) need to obtain visas for employees who are jumping across the border for short term stays.

Surely, in the 21st century, we should update this approach and recognize that INCREASING global knowledge workers ability to collaborate across borders is essential to higher productivity, better solutions, and a better economy.   

Given that reality, I would propose a very easy to obtain, very low restriction visa that would enable short term deployments (say 2-4 weeks) across the border.   The governments on both sides could charge a fee and use a Nexus type approach to clearing consultants for the usual security risks.  Once they have the pass, they could go down at any time to deploy solutions, meet with customers, and collaborate with stakeholders with the assumption that 80% of the work would still be done outside the country but that at crucial times there is a requirement for global knowledge workers to collaborate together.  If the United States wants to be the centre of global innovation, it should enable these global workers to actively choose the US as their physical meeting hub for planning sessions, deployments to data centers, training, and collaboration sessions.  This would create a high degree of network effect that would put it at a significant advantage over more restrictive countries such as China, Russia, Middle Eastern countries, etc. 

Zachman Framework Certification No Longer Valid?!

Gartner is reporting that after almost 30 years of being the de facto Enterprise Architecture framework for government, aerospace, and other large scale enterprises the Zachman Framework has collapsed as John Zachman is retiring.

At first glance, it appears that John A Zachman is closing up shop and about to retire, having severed his business partnerships, and appearances are that his son, John P Zachman, will take over the IP trademarks and, as alleged by a former business partner Stan Locke, seek to place the Zachman IP within a COTS package.

A second, and more penetrating glance, into the actual lawsuit itself reveals alleged deceptive practices by the defendant, Stan Locke, and claims of serious and reprehensible actions that are alleged to damage the brand of Zachman.

The capitulation by the defendant in a surprising lawsuit, Stan Locke, will not resolve the concerns or Zachman brand ownership concerns as the damage has already occurred.  This, in turn, raises questions about how the Zachman brand will  regain control after relinquishing that control for so long.

What does this mean for Enterprise Architects that have spent their time, energy and significant financial resources getting certified and becoming practitioners in the EA field?  Based on the current state, it is not clear how this will be sorted out.

As of right now, certification programs have been suspended, John Zachman is exiting the business and the entire framework is now surrounded by legal troubles over who controls the brand, the IP, etc.

Wednesday, September 8, 2010

Copying Data from Project 2010 to Word is Actually Worse than 2007

In Project 2007, copying data from Project to Word was quite painful, resulting in some funky formatting that was hard coded to whatever colors, fonts, etc. you had in your project file.  In addition, when you copied dates, the default format was 9/8/2010 12:00pm which unless your plan is VERY time sensitive is not typically want you want to show in a word document.

So in Project 2010, the Microsoft team seems to have fixed some things but broken others in an effort to improve these problems in 2007.

So take this dummy project plan I created:

ScreenHunter_02 Sep. 08 08.57

I want to move this into Word so that I can include it in a Statement of Work, Project Charter, etc.  What I want is this data in a simple table – I don’t need GANTT charts or anything else…just a basic list of tasks and durations.

So now if I copy this into Word, this is what I get:

ScreenHunter_03 Sep. 08 08.58

Not a bad representation of the plan – certainly better than the output in Project 2007.    However, the biggest challenge here is the indenting – Task 1.1, 1.2, etc. are indented using 4 Spaces instead of a TAB, a proper Word paragraph indent, etc.  If you want to change the size of the indent in word, you’re now stuck with doing a search and replace for 4 spaces and either replacing them or converting them to TABs or Word paragraph indents.

In Excel, there is a further problem – date formatting.  In Excel, the same plan looks like this:

ScreenHunter_04 Sep. 08 09.02

Again, not bad and certainly an improvement over MS Project 2007.  However, let’s suppose that you want to change the date format to a simple date without the day in it, e.g. 8-Sept-10.    In order to convert the cell into a proper date, you have delete the "Wed " from the dates for each day of the week.  Then you can format your dates anyway you like in Excel.  In addition, you have the same problem with indents as Word – indents are handled with 4 Spaces instead of real indent marks, making them tough to remove.

So from my perspective, while the formatting is prettier when copying data from MS Project 2010, its actually less useful and harder to convert to something I can manually format and change in Word or Excel myself.  This is ultimately what is needed – if you are copying and pasting into another document, you will want to use the parent documents fonts, indenting, date formatting, etc. and not Project’s default settings.