Thursday, August 27, 2009

area cropped when skinning flv to swf

try using the noscale option and enlarging the dimensions exported ... you can use negative margins on the html output to make it look decent

Monday, August 17, 2009

notepad++ insert carriage return

In notepad++ you can easily find a carriage return by copying a section of texxt with a carriage return in it and doing ctrl+f or ctrl+h to replace, but you cannot copy that block and paste into the replace box. I found the answer for this here: http://bytes.com/topic/net/answers/767637-find-replace-insert-return-character

In the replace area, type

\1\r\n\2 -- \1 is the first group, \r\n is a carriage return and a new
line, \2 is the second group.

Friday, July 17, 2009

connecting to sde

Connecting to my new SDE was exceedingly difficult. I'm not sure if it's because it was built on postgres, but ... geez!

Here are a few items you should be aware of
  • contrary to ESRI's documentation, you need to do a very important piece of configuration on the client, namely add a reference to the service in the services file which is found (for most Windows users) at C:\WINDOWS\system32\drivers\etc\services. At the bottom add the following line (replacing servicename with the name of your sde service): service name serviceportnumber/tcp #ArcSDE for RDBMS
  • make sure your server is listed in the pg_hba.conf file (in your postgres data folder)
  • this entry must also be in the same file on the server, and also in C:\Program Files\ArcGIS\ArcSDE\pgexe\etc\services.sde, but that's usually less of a problem since the post-install takes care of it
  • if you add your port number in the server field in the "connection properties" from your client (in my case arccatalog), it will return an error
  • make sure your desktop software is the same major version as the sde (example: 9.3 to 9.3)
references:
  • http://forums.esri.com/Thread.asp?c=2&f=1717&t=142803
hint: was getting the following error: "Failed to connect to the
specified server. Entry for SDE instance not found in service file" ... note 1 above, particularly on the client side, fixed that

Wednesday, July 15, 2009

setting percent property as3

when setting percent height property in AS3 was getting the following erro"1084: Syntax error: expecting identifier before semicolon" ... was because I need to use percentHeight, percentWidth, etc. for percentage properties ... I believe this is similar to HTML DOM

Tuesday, June 23, 2009

Importing ESRI GRID to ENVI

I'm not sure if ENVI documentation is lousy or just not searchable, but I could not find any good information on how to import ESRI GRID to ENVI ... and the ENVI UI is so unintuitive (hint to ITTVIS, why not just streamline the whole "external file" thing into the same "open image" command used to import geotiffs and the like?) as to make a simple task need explaining!

THIS FUNCTIONALITY IS ONLY AVAILABLE IN THE WIN 32 VERSION!

1. File > Open External File > IP Formats > ESRI GRID
2. Navigate to the hdr.adf within the folder with the same name as the vector you are trying to open and open this

Monday, June 22, 2009

"select * into" in mysql

"select * into" is not allowed in mysql. Here is an example to get around this limitation:

CREATE TABLE newtable SELECT * FROM oldtable


originally found here

Monday, June 8, 2009

find/replace text mysql

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘find this string’, ‘replace found string with this string’);

from: http://www.mydigitallife.info/2007/04/23/how-to-find-and-replace-text-in-mysql-database-using-sql/