Welcome to the Casa de Pacopablo
This is the hideout of the crazy gringo, pacopablo.
Blog
T-SQL Tidy.com: Awesome!!
Digging through Dynamics: GP stored procedures is painful, to say the least.
When you pull the SQL out of the database via SQL Server Management Studio it is one LONG line. No formatting, nothing. Reading the TSQL as one line isn't really an option. Reformatting it by hand takes FOREVER.
Fortunately, there is a wonderful online formatter over at TSQLTidy. It can transform the GP stored procedures into something that can actually be parsed by a human brain. [http://www.t ...
Dynamics: GP 10 Manufacturing -- How Not To
Having recently upgraded from GP8 to GP10 and having switched from Horizons Manufacturing to GP: Manufacturing, I wanted to lay out a few do's and don'ts for anyone else considering a switch. Hopefully the below will save you some of the headache.
- Take The Defaults: As with pretty much all Microsoft products, accepting the defaults is prudent and nigh a necessity. If you simply take the defaults and use the software exactly as designed, you'll have an acceptable experience.
- ...
Dell Express Service Code Program
When you buy a Dell with Windows on it, you get a little program pre-installed that will tell you the service code of your machine. This is a handy little tool for tech support, especially if your machine is in a hard to reach location. Simply fire up the program and BAM! There is your service tag
Today I was cleaning up a PC today getting it ready to cycle it out of the company. In my hacking and slashing of data, I deleted the dell directory in which the Service Tag program resides. Not a huge d ...
Authenticate Trac Against phpBB
So, Chuck, over at Cobra wanted to get his trac site up and running and was wondering about using the exisiting accounts that people had in the phpBB3 forums. Trac being Python, and phpBB being, obviously, PHP, there was no stock way of accomplishing this.
First, Trac's authentication meme is basically: get someone else to do it. Generally speaking, this is the web server. That's all fine and dandy, but some people want a bit more. Thankfully, [htt ...
15 Character Limit
Let's establish some facts.
- MS SQL Server 2005 allows the sa password to be longer than 15 characters.
- MS Windows XP allows a password longer than 15 characters.
Given these two facts, one would assume that Microsoft has a policy of allowing arbitrary length password (or at least really long ones). However, if one were to assume this, one would be wrong.
Microsoft's Business Solutions - Great Plains 8 does NOT allow passwords longer than 15 characters. I'll admit that GP8 is a bit ...
!PyCon 2008 - Here I Come!
PyCon is March 14th through 16th with the 17th through 20th being open for sprints. PyCon was a blast last year, thanks to Financial Aid from the PSF. Thankfully, my employer is sending me this year. I'll be taking t ...
Populating ''Assign To'' Drop Down in Trac
When configuring a Trac environment, you can set the following option:
[ticket] restrict_owner = true
This will change the Assign To ticket filed into a select box that only contains existing users. However as it says on the TracTickets page, the user must have logged, in at least once, and set their email address.
If you run multiple Trac sites, and have a set of common users across all Trac ...
htpasswd with Python
As many Apache users know, the htpasswd1 is used to create a file with username/password pairs. The format for the file is simply a username, colon, encrypted password. For example:
foo:oNAU4bgeqQHt2
The username is foo and the password is bar encrypted with a salt of oN2
Now, there are good reason why an admin m ...
Enterprise Ready?
In today's IT scene, it is important to know which products are enterprise ready. Cliff Wells provides a useful evaluation of certain popular technologies. He also sets the baseline for what enterprise ready really means. Go see if your technology is Enterprise Ready.
The Mysterious Dell Express Service Code
Love or hate Dell, they do do a few things right. They provide a Service Tag on every PC with which you can get a host of information off their support site. Drivers, manuals, you name it. The service tag is generally on a little black tag someplace on the case. On the tag there is also an Express Service Code. If ever you call for tech support on your Dell computer, you will be asked to enter this number to route your call correctly. Now, you don't actually need ...
Thanks to coderanger, we will always know what day Easter is. :)
2009-04-12
As is evidenced by the lack of modification of the logo at the top of the page, this site is run on trac. It is a great piece of software that provides a wonderful plugin system. The "official" site for plugins and other modifications to trac is trac-hacks.org. Go check it out.
