Wednesday, May 28, 2025

They made changes

They asked me about progress on a program I started last Sept, and last touched in Dec. I was totally clueless at that point as it is pulling data out of Jira, and then running a UCC ESLOC comparison between the current and last pull request in bitbucket, take that value and insert it into customfield_24954.

And if you read all that I bet you are just as clueless about it as I was 8 months ago... And still am. 

The code I wrote that was kinda working... They changed how the api works, so now I got nothing. And I don't know what else is broken as it doesn't get past step 1.

In other words, it is a typical day in the life of a coder

Thursday, May 22, 2025

Hired for our tech skills

 Mile long path to a folder. 

Cut & paste it into email... 

And because the very last folder has a space between the words, rather than a _, which is what the 10 other folders have, it fails to work, and I have to manually edit the link.

And we were all hired for our tech skills.

Wednesday, May 14, 2025

Trying to anticipate the end-user

 Trying to anticipate an end-user's needs. 

Do they want to keep old data or not? 

They want to keep the old file, but do they want to keep all of the old tabs, or can I delete everything other than Template, Cover Page, and the ones being updated?

I could make it so it takes a second argument (delete). If it is not there keep them, and if it is 'delete' then delete them. 

Sure I could just ask them, but where is the fun in that?

Tuesday, May 6, 2025

What are you doing today?

::: Scrum/dept meeting :::

Them: So what are you doing today? 

Me: Mostly screaming at my code. Just one word, over and over. And the word is "Why?". 


Sometimes the reason is me. 

Ok, most of the time.

Sunday, April 27, 2025

31 character limit

Making something for work, a nice simple situation of reading all xlsx files in a folder and moving the data to a tab in a single xlsx file. Easy peesy. 

30 mins later I run it the first time. It ran, but was giving me "Excel found errors, but can recover the data". Data all looked good, except every tab after the first was named "Recovered #". 

2hrs of work, with lots of long walks, and off the clock research, later, I discovered that the issue is the file names that I am trying to use for the tab names are longer than 31 characters, and the first 31 characters are the same.  OK, the first 39 characters are the same, and then there are 10 more at the end that match. These file names are insanely long. 

So I set up a simple replace to remove everything that is duplicate data in the names, and it all works! The issue was in excel, not my code. I went so far as to try writing the data to a csv, and then to the final excel file to see if there was some weird characters or formatting setting it off, before I wondered if there is a limit to the size of an Excel sheet name.

Monday, March 17, 2025

Error code

 "Oh, I know this error code! I just need to google it to remember how to fix it." 

Life of a coder.

Molly

Writing code that will search for a value.

Needed to call the searched for value something, so I named it 'molly'. 

Yep, I am looking for molly.

We can't do that here

I remember years ago looking over a book, Automate the Boring Stuff with Python, and thinking how this would be so useful at work. Half of m...