tag:blogger.com,1999:blog-57168932024-02-28T05:12:48.249-06:00John Croson's Blog HomeJust where I place my rants and raves...John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.comBlogger119125tag:blogger.com,1999:blog-5716893.post-71662029225113592522018-06-04T08:49:00.002-05:002021-08-22T09:36:28.624-05:00Simple GitHub Issue Export using PythonWe needed a way to export GitHub issues and comments to import into Jira.
This Python example easily exports these via the Rest api, and is quite simple to customize to suit your needs.
Create a Personal Access Token and use this in place of the one in line 10 (after the word "token" of course).
You'll need to pick through the GitHub Api if you want more things like attachments.
I'm also a John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com1tag:blogger.com,1999:blog-5716893.post-51157852559390437112018-06-04T08:33:00.001-05:002021-08-22T09:37:54.631-05:00ETL - Using Python to push data to Salesforce Analytics The problem: develop a method to automate the process of pushing data from our Netezza reporting warehouse to Salesforce Analytics for consolidated reporting.
In my quest to solve this problem, I created the Python script below.
The commented yum & pip installs at the top of the script are required bits to make it work.
Sharing the data is outside the scope of this script, but it is easily John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com2tag:blogger.com,1999:blog-5716893.post-89843286096044988532013-10-25T16:30:00.000-05:002013-10-25T16:30:02.471-05:00Creating SCSM tickets using SMLets and ASP.NET
English: This is a photo of a room full of computers all showing the same windows error message at the Nanyang Technological University in Singapore (Photo credit: Wikipedia)
I was trying to figure out how we could leverage ASP.Net to create more functional forms for end user ticket creation in SCSM.
Many would agree that the self service portal is a bit restricted and we needed a method John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-51857604503674558142013-04-25T16:56:00.002-05:002021-08-22T09:42:00.438-05:00Crystal Reports, Advanced SQL Commands and Parameters
Crystal Reports Pic 4 - Select Data Tables (Photo credit: wmharshana)
I've not written a Crystal Report that required a more advanced query in quite a while, and had a need to union two selects and pass in a parameter to both queries.
I initially just wrote the Union query and attempted to place my {?CustomerName} in both places using the "=" comparison operator, which worked.
When I wanted John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com1tag:blogger.com,1999:blog-5716893.post-8674738367217713722013-04-05T09:02:00.009-05:002021-08-22T09:48:48.709-05:00Find GridView Cell Values on RowCommand with Paging EnabledThis was confounding me this morning until I found this post on the ASP.NET forums.
I was setting up a GridView and needed to check the values of a couple of cells before I let users click a button in an ItemTemplate.
I initially used the Container.DateItemIndex method to determine which row they clicked but quickly found out that this only works without Paging Enabled as noted on the MSDNJohn Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-25848797563046459602012-12-25T20:28:00.001-06:002012-12-25T20:28:38.054-06:00Mexicali Chili1 lb lean ground beef
1 medium onion, diced
1 14oz can chili beans
1 16oz jar corn salsa
3 large Idaho potatoes, diced
3 cups water
2 cups cold milk
2 tbl corn starch
Brown beef, season with 1/2 tsp cumin, 1/2 tsp salt, 1/2 tsp chili powder if desired.
Sweat onion in 1 tbl butter separately.
Mix beef, onion, beans, salsa, potatoes and water in large pot. Bring to a boil, then cover and simmer John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-41753420586824596832012-11-09T15:25:00.000-06:002012-11-09T15:25:51.734-06:00Crystal Reports Server 2008, WACS and AD Auth on 2008 Domain
Image via CrunchBase
This was kicking my butt the past couple of days. Up to this point, I'd simply been using the server to schedule and email reports out to people. What I wanted was to allow users to log in with their AD credentials, browse InfoView and run their own reports. Simple, right?
This is how I did it.
Create a service account in AD. This account doesn't need elevated&John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com2tag:blogger.com,1999:blog-5716893.post-63378095342340709592012-10-20T08:25:00.001-05:002012-10-20T08:26:38.114-05:00New Sourcegforge Project
English: jQuery Mobile logo. (Photo credit: Wikipedia)
I just posted a new project on Sourceforge, called Anonymous Compliance Reporting.
Anonymous Compliance Reporting aims to be a solution for small organizations that desire to adhere to the corporate practice of providing a means for employees to report issues anonymously.
This project originated to provide a mechanism for my John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-27898005649857282432012-07-26T16:00:00.000-05:002012-07-26T16:00:05.279-05:00ADFS and AD User Name ChangesOne of our users was recently married, and had her name changed.
Two days later she opened a helpdesk ticket indicating one of our claims aware applications denied her access to it's resources.
After enabling ADFS debug logging, I discovered that the server was still referencing her old user name.
After a few minutes of Googling, I found this article that points to a MS KB article outlining John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com2tag:blogger.com,1999:blog-5716893.post-37148200999816244722012-07-05T14:40:00.001-05:002012-07-05T14:40:27.684-05:00Easy CSV import into Oracle
English: The logo of Oracle Corporation de:Bild:Oracle-Logo.svg he:תמונה:Oracle Logo.jpg (Photo credit: Wikipedia)
The easiest way I've found to import text data sources into Oracle have been using the Microsoft SQL Server Import and Export Wizard that comes with Standard, Enterprise or Developer editions of MS SQL Server.
Assuming you've got the Oracle database drivers installed, just rightJohn Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-33020235862185225802012-06-04T14:53:00.002-05:002013-05-16T11:00:29.589-05:00ADFS AutoCertificateRollover
BITE (show) (Photo credit: Wikipedia)
Leaving your ADFS 2.0 installation in AutoCertificateRollover mode will most certainly bite you in the ass at some point.
This is the default mode when you install ADFS, and when your certificate expires, you'll get something that looks like this:
The key to your answer is in the first line:
ID4175: The issuer of the security token was not recognized by John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com4tag:blogger.com,1999:blog-5716893.post-44062146375835152422012-04-03T16:36:00.001-05:002012-04-03T16:36:42.306-05:00OpenAir ETL Project
Image via CrunchBase
Reporting in OpenAir has presented our company with some challenges. As such, I was asked to take a look at how we might be able to create an ETL of this data, create our reports and automatically distribute them to our project managers.
This is how I did it.
First we needed to purchase OpenAir's Automated Backup service. This service will export data in text format or John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com1tag:blogger.com,1999:blog-5716893.post-68890410334975456302011-11-30T20:24:00.001-06:002011-11-30T20:28:37.569-06:00Mobile posingDoes anyone actually do this? Well, here are my wife and I waiting for our son after school on Monday. He loves to unwind on the playground, so we gave him about 30 minutes to burn more of the day off.John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0Wauwatosa Wauwatosa43.063728 -87.994642tag:blogger.com,1999:blog-5716893.post-45730989497410113422011-09-29T15:27:00.003-05:002011-09-29T15:33:44.778-05:00System.ArgumentException: Keyword not supported: 'unicode'.Image via Wikipedia
This error was giving me fits today. Thought I had my Oracle connection string all setup correctly, since I'd already used it for a GridView control. Thinking I could just copy/paste a SqlDataSource command down for another couple of controls, it should have been a snap...
But I kept getting these System.ArgumentException errors pointing me to my web.config!!!! WTH???
Turns John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-48711777784508652242011-08-29T09:34:00.005-05:002011-08-29T11:29:28.934-05:00Adding Animation to the AutoCompleteExtenderImage via WikipediaAfter reading numerous articles relating to the AutoCompleteExtender, I was able to use CSS to set the overflow property of the ul that comprises the drop-down selector to get the browser to render a vertical scroll bar, making it easier to look through a long list.
My struggle was to get the list to shrink backup up after the item was selected and not sit on top of other John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-49132416067161672262011-08-16T07:59:00.004-05:002011-08-16T08:04:51.369-05:00My Sister ElizabethMy sister Elizabeth Croson was diagnosed with PPMS (Primary Progressive Multiple Sclerosis) several years ago. Before the disease robbed her of most of the things we take for granted, she enjoyed writing among other things. Here is one of a few stories I'll be posting.
YOU KNEW THIS WHEN YOU MARRIED ME Four years ago on November 4th I met, who is now my husband Curtis. It was a cold and rainy John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-20589831790338597512011-08-16T07:47:00.007-05:002011-08-16T07:56:40.228-05:00My Sister ElizabethMy sister Elizabeth Croson was diagnosed with PPMS (Primary Progressive Multiple Sclerosis) several years ago. Before the disease robbed her of most of the things we take for granted, she enjoyed writing among other things. Here is one of a few stories I'll be posting.
Mistaken Identidream
June and George were married on a beautiful day in June 1956. They dated for roughly 6 months before John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-52499139821281266972011-05-01T08:44:00.009-05:002011-05-01T10:02:46.065-05:00An Old Linux ProjectBack in 2005 when I started work at a Milwaukee area technology consulting company I was asked to develop a kiosk system that could automatically copy images from a digital storage card to a CD.
Image via WikipediaThe business idea from our customers perspective was to provide an iMac G4 with a handfull of cheap waterproof digital cameras to a water park free. The water park would then provide aJohn Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-43573568641834392692010-10-01T11:16:00.004-05:002010-10-01T13:38:35.203-05:00Ditch your backup tapes, use disks!Image via CrunchBaseWe've been backing up to LTO2 tapes for years using a Dell PowerVault 132T with an internal IBM Ultra drive. Differential backups from our SAN don't take too long, but full backups take nearly an entire day. The backup set has grown as the business has, and it's rapidly approaching 1tb, spanning 3-4 tapes.
About 10 days ago the internal drive finally croaked. Swallowed a tapeJohn Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-6206033966540962462010-09-08T10:31:00.003-05:002010-09-08T10:49:00.613-05:00Subsystem for Unix-based Applications and Windows Batch scriptsImage via WikipediaSome time ago, I installed the SUA package with the thought I might use it for scripting and other tasks that I find easier to accomplish using GNU-like tools rather than Windows.
Recently I needed to run a batch script that programatically checks for the evidence of some data files and injects them into MS Sql via DTS. This script worked fine on another server for years with John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-65380718001918737442010-09-07T11:54:00.004-05:002010-09-07T12:14:42.517-05:00Milwaukee PC Non-Customer ServiceLast week Friday, a tape got stuck in our Dell PowerVault 132T Library. Luckily, I was able to remove the tape and resume order to our backups...or so I thought.
After checking in Saturday it was clear that we were going to be without backups, something that makes my skin crawl.Image by artescienza via Flickr
So promptly after our return to work after a nice long Labor Day weekend, I rushed outJohn Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com1tag:blogger.com,1999:blog-5716893.post-70245012981322357492010-08-22T19:38:00.005-05:002010-08-23T06:51:54.814-05:00
Today during errands, we stopped by Goodwill and picked up this excellent enameled cast iron stew pot for $10. It inspired me to cook up an Indian stew for the family.
My wife liked it so much she suggested I blog what I did, since it was all spur of the moment, like so much of my cooking is.
The ingredients are as follows, in what I remember to be the approximate quantities...
1/2 John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-25173494468702223892010-06-09T08:08:00.009-05:002010-08-16T07:36:51.395-05:00Ubuntu AMR CodecWhat a PITA. I have a cool smart phone that takes video, and can't get audio to work in Ubuntu, since Intrepid and Jaunty don't appear to come with AMR codecs compiled in ffmpeg, or gstreamer.Now, you can try to compile your codecs from source, and I've certainly done this sort of thing before; I can build my own kernel (In the days BEFORE xconfig), run Slackware/Gentoo, etc. This just didn't John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-38993063708353313742010-06-09T07:17:00.004-05:002010-06-09T07:52:01.113-05:00Windows 2003 MigrationI haven't had to do a migration for some time, since the days of consulting have been over for 3 years now.Image by mooing brontosaurus via Flickr
Even then, I'd only done a couple of 2000 to 2003, and one SBS 2000 to SBS 2003 migrations.
This project involved moving from SBS 2003 to a Standard 2003 environment. I was a bit intimidated, and purchased the excellent Swing It! SBS Migration kit John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com0tag:blogger.com,1999:blog-5716893.post-79968335922986500552010-05-26T09:09:00.001-05:002010-05-26T09:09:45.816-05:00LastPass EnterpriseThe EnvironmentImage by justonlysteve via FlickrI work in an industry that deals with Protected Health Information (PHI). According to the Health Insurance Portability and Accountability Act (HIPAA) we need to apply certain measures to protect this information, and continue to improve those measures.
Over time our company has increasingly found itself turning to the Internet to retrieve John Crosonhttp://www.blogger.com/profile/01927740573342195129noreply@blogger.com1