|
Malek posted:... in anticipation or direct reaction? E/N incoming but gently caress it. Nah, I'm just done with this. It was one thing when the station would poo poo all over my ideas, at least there I was able to think outside the box to craft a solution to whatever problem arose. Here, I'm given a board with square holes and then told we can't afford any pegs, so I work myself to death coming up with square peg alternatives that are cheap or free and I get publicly humiliated for not getting round pegs. I was just publicly shamed by my boss (as in, in front of an auditorium with every employee) because I have not yet had the security card system installed and operational, when the last thing we ever discussed about it was that we didn't have the money to pursue the project and not to worry about it. I'm just tired of all of it. They don't pay me a quarter of what I deserve to be making for doing this job. If you consider the cost of the therapy and medication I've begun taking to deal with the stress and anxiety this job has put on me, I'm I'm only making about $1000 a year more than I did at the television station. And even if I was making $200k a year, the fact that I'm having to seek mental and emotional therapy is just loving stupid. No job is worth this. On top of everything else I'm dealing with, the inventory manager got in a wreck over the weekend where her friend died, so now I have to do her job for the rest of the semester. I'm not heartless and it loving sucks for her, but shes coming back Friday. I asked what she would be doing the rest of the semester and the response was "healing and praying." I put forth an approval request to set up a sign-up portal for the emergency contact robo-caller so the parents could just go opt-in on the website and put their own info in and have the information purged automatically at the end of the year, completely automating the process and freeing up a ton of time for me to deal with other stuff. Director says no, that's one more things parents will have to deal with and they already deal with enough. You dumb motherfucker if you had to sit here and input 700 contacts every loving year you'd be all about this poo poo. I just ordered a bunch of Chromebooks for low-income students from a vendor who has been a huge help to me and managed to quote 4GB models for cheaper than every other vendor was quoting 2GB models. Turns out they aren't on state contract so I have to send them back and pay out the rear end in a top hat to our usual vendor I've been trying my hardest to get away from because they suck. It's just... none of this poo poo is worth it. I'd rather work two retail jobs than deal with this for another minute.
|
#
?
Sep 6, 2016 19:22
|
|
|
|
| # ? Jun 1, 2024 15:47 |
|
|
Renegret posted:I use Firefox at work because some of my tools only work on Firefox. Ugh.. similar situation.. Firefox for one internal management console that requires a stupid Java applet. Internet Explorer for one website in IE7 compatibility view mode. (Verifone's Payware Connect credit card processing console, yeah... a "secure" website handling credit cards requires IE7, and it doesn't even use any ActiveX..) Chrome for everything else.
|
|
#
?
Sep 6, 2016 19:26
|
|
|
Nice, working a data entry job and getting therapy for it! Totally worth it!
|
|
#
?
Sep 6, 2016 19:27
|
|
|
larchesdanrew posted:E/N incoming but gently caress it. That all sounds pretty normal for working at a school. It sucks but government work has odd rules about who they can buy from. It's a race to the top and your boss will always throw you under the bus rather than take the blame. You deserve better you really do. I worked in government / school and boss always making GBS threads on you ready to throw you under the bus is not fun, I'm sure there are places it doesn't happen in that sector. Find something, but if you don't stop taking work so personally. Let it slide, "oh well apparently it's my fault he can't get the budget together to fix the card reader, at least I know it's his fault". I don't think anyone in IT is immune to someone else playing the blame game, be it boss, co-worker, subordinate, or vendor. Someone is always going to try and not be the cause of a lack of technology.
|
|
#
?
Sep 6, 2016 19:30
|
|
|
Renegret posted:I use Firefox at work because some of my tools only work on Firefox. Exactly this, although its more for the loving dogs dinner of web interface incompatibilities. I've got everyone on Chrome since it's extremely manageable via group policy, when duty calls they get Firefox, Internet Explorer is anyone's game. I've also been poking around Hubspot for its functionality (person who was lumped with it left, its sorta on me to get it fit) since our sales team will be moving on it and found one important thing missing; you cannot make any fields required/mandatory of any kind. I even asked their support who basically confirmed this and recommended submitting a feature request... loving hell dude this is basic poo poo how does anyone justify giving these guys money. Go live is in two weeks 
|
|
#
?
Sep 6, 2016 19:32
|
|
|
larchesdanrew posted:if you had to sit here and input 700 contacts every loving year What form do these contacts come in? Is this an automatable task?
|
|
#
?
Sep 6, 2016 19:36
|
|
|
Dr. Arbitrary posted:What form do these contacts come in? Is this an automatable task? It sounds like voice, as in they call in and leave a message or call in he picks up and has to do it with them on the phone.
|
|
#
?
Sep 6, 2016 19:44
|
|
|
If someone at work asks me what I'm doing from here on in I will answer "healing and praying."
|
|
#
?
Sep 6, 2016 19:47
|
|
|
pixaal posted:It sounds like voice, as in they call in and leave a message or call in he picks up and has to do it with them on the phone. Jesus christ.
|
|
#
?
Sep 6, 2016 19:48
|
|
|
Dr. Arbitrary posted:What form do these contacts come in? Is this an automatable task? Not really. The data I pull from our student inventory system is so different than the accepted format of the robocaller import that I spend most of that time just doctoring the csv files.
|
|
#
?
Sep 6, 2016 19:48
|
|
|
larchesdanrew posted:Not really. The data I pull from our student inventory system is so different than the accepted format of the robocaller import that I spend most of that time just doctoring the csv files. Well, let's get it there. Can you post some dummy data in the powershell thread? Just let me know what your input looks like and what your output needs to look like and I'll treat it like a puzzle. INPUT --> POWERSHELL MAGIC --> OUTPUT
|
|
#
?
Sep 6, 2016 19:53
|
|
|
larchesdanrew posted:I was just publicly shamed by my boss (as in, in front of an auditorium with every employee) because I have not yet had the security card system installed and operational, when the last thing we ever discussed about it was that we didn't have the money to pursue the project and not to worry about it. "Does this mean you will finally approve the budget for this project, then?"
|
|
#
?
Sep 6, 2016 19:57
|
|
|
If it was me, I'd be tempted to send an email along these lines: TO: BOSS, ALL STAFF Subj: Re: Funding denied Body: Boss, I just wanted to follow up on this expense that you denied. It came up at the meeting yesterday as a high priority item, wanted to get this project rolling again. TO: BOSS, ALL STAFF Subj: Please Disregard Re: Funding Denied Body: Sorry all, please disregard the previous email. It was intended to be read by BOSS only. It concerns a private discussion between me and the Boss regarding funding for projects. Thanks.
|
|
#
?
Sep 6, 2016 20:04
|
|
|
Dr. Arbitrary posted:Well, let's get it there. When I first started learning Powershell at my previous job, everything started looking like a CSV-shaped nail.
|
|
#
?
Sep 6, 2016 20:04
|
|
|
The Fool posted:$30 is more like 10-15 minutes. Dr. Arbitrary posted:It's going to depend on the state and the lawyer. You might even get a freebie for the first 15-30 minutes. In actual lawyer dollars, yeah, but most county bar associations give 30 minutes either free or at very reduced rates. Depends on the county - I've dealt with two counties in northern NJ and once in Manhattan, and the Manhattan one was the only one to charge me anything, and that was just $30 for around 20 minutes. He was totally open to going on to the full 30, even asking if I had any non-field related questions (I forget the reason I'd reached out, but it was something job-related) that he might answer, and told me not to rush on paying him. I think it's just some kind of standing requirement for lawyers to be open to this kind of thing. It's a nice textbook fallback: "I am not a lawyer but here's a cheap/free way to talk to one if you need it" to any legal question.
|
|
#
?
Sep 6, 2016 20:13
|
|
|
Dr. Arbitrary posted:Well, let's get it there. Doing this. I'd like to see how one could use Powershell to intelligently standardized, say, phone numbers that are written in a wide variety of different ways.
|
|
#
?
Sep 6, 2016 20:14
|
|
|
larchesdanrew posted:Doing this. I'd like to see how one could use Powershell to intelligently standardized, say, phone numbers that are written in a wide variety of different ways. There's only so much you can do without validation at the time of input, but the easiest thing is to simply strip out any characters that are not numbers. That won't fix anything where they put in the wrong number of numbers, but it'll probably get you 80% of the way there. I guarantee you that you could find half a dozen posts about this very topic on stack exchange.
|
|
#
?
Sep 6, 2016 20:16
|
|
|
Dr. Arbitrary posted:If it was me, I'd be tempted to send an email along these lines: Do this, but don't include the all or the second message. It reminds them that they denied it and that you remembered. Doing it publicly is just going to get Larch fired and unhireable in his area which has limited jobs.
|
|
#
?
Sep 6, 2016 20:16
|
|
|
pixaal posted:Do this, but don't include the all or the second message. It reminds them that they denied it and that you remembered. Doing it publicly is just going to get Larch fired and unhireable in his area which has limited jobs. I've already filled out the requisition form and placed it in his hands. If it gets denied this time, he's got the vendor and price and can kick that project off anytime he drat well pleases. I've got Chromebooks to return.
|
|
#
?
Sep 6, 2016 20:19
|
|
|
pixaal posted:Do this, but don't include the all or the second message. It reminds them that they denied it and that you remembered. Doing it publicly is just going to get Larch fired and unhireable in his area which has limited jobs. Well, that's why I said "Tempted"
|
|
#
?
Sep 6, 2016 20:21
|
|
|
I can't fathom how many hours in my career I've spent massaging data, either pre or post export, always because there were no standards. A long time ago I worked at a place that had about 13,000 members in their terrible Frankenstein FileMaker database and I had an opportunity to bring order to chaos. There was no data validation. None. No proper serializing of records or usage of key fields. It was a horrid mess that made exporting data an exercise in madness. It took about three years to completely scrub the existing member data and then lock it down with validation. Doing this meant all data exports were now standardized and would never need scrubbing prior to use, either internally or with external vendors and entities. The staff members that were prone to creating their own abbreviations for states and countries were upset. After all using AS for Arkansas had worked fine in the years before I came on the scene! This was about 15 years ago and I still think of Canada as "Cananda" due to seeing it spelled that way so many times in that goddamn database.
|
|
#
?
Sep 6, 2016 20:21
|
|
|
Dick Trauma posted:I can't fathom how many hours in my career I've spent massaging data. I honestly don't mind this at all. I'm used to doing this kind of work and it's nice to zone out with some music and just mindlessly format or input data. If that was my only job. I don't know why they never trained previous IT guys how to deal with data exporting/importing.
|
|
#
?
Sep 6, 2016 20:37
|
|
|
A spam email came in (Fw: Spammer's pissed):quote:Hello user, spammer here. Got really irritated over the Holiday catching up on some emails. They were articles and e-blasts teaching search owners to "adjust to Millennials".
|
|
#
?
Sep 6, 2016 21:23
|
|
|
For phone numbers, it shouldn't be that hard to create a regular expression to find them, unless they've got an extension listed.
|
|
#
?
Sep 6, 2016 21:24
|
|
|
E.123, motherfuckers. Also, ISO 8601. If everyone just stuck to those two standards the world would be a much better place.
|
|
#
?
Sep 6, 2016 21:33
|
|
|
even with a country code and everything there can't be too many once you drop all non numerics.
|
|
#
?
Sep 6, 2016 21:34
|
|
|
Mr. Wookums posted:even with a country code and everything there can't be too many once you drop all non numerics. Have an expectation that if it bombs write line to IdiotsWhoCantWritePhoneNumbers.log and move on. Deal with them after. There were always be a few you need to do by hand, but at least get through the 80-95% you can automate.
|
|
#
?
Sep 6, 2016 21:37
|
|
|
pixaal posted:Have an expectation that if it bombs write line to IdiotsWhoCantWritePhoneNumbers.log and move on. Deal with them after. There were always be a few you need to do by hand, but at least get through the 80-95% you can automate. This is good advice. Just note somehow if a phone number doesn't fall within the regular parameters. A log file, or a separate column in the CSV, or something. I'd probably go with the separate column so I could easily report on it and filter and stuff.
|
|
#
?
Sep 6, 2016 21:55
|
|
|
Inspector_666 posted:When I first started learning Powershell at my previous job, everything started looking like a CSV-shaped nail. This happened to me too, but with awk.
|
|
#
?
Sep 6, 2016 22:25
|
|
|
Some people see posts, but I just see regular expressions.
|
|
#
?
Sep 6, 2016 22:33
|
|
|
pr0digal posted:I think we've all had CYA e-mails that consisted of "higher up and/or client said do this with my concerns outlined". In fact I have one sitting in my starred items right now.  Same. An email from March telling a higher-up that a critical system was at-risk and outlining what I needed to be able to start picking it apart to document, with a view to being able to ensure it was easily deployable and then actually doing the deployment onto non-failing hardware. I was denied that opportunity because it wasn't directly revenue generating activity (yeah seriously that is  to the extreme - the same logic would determine that repairing the roof of a warehouse filled with stock isn't revenue generating so is an unnecessary expense), and in the last few days it fell over. Welp. Got that CYA email.
|
|
#
?
Sep 6, 2016 22:58
|
|
|
larchesdanrew posted:
I have said it before and am repeating it now. You work in public education which means your workplace has a union. You need to join and get them to deal with what is workplace bullying from your superior. It will probably also stop them from loading that extra job on to you without appropriate compensation.
|
|
#
?
Sep 6, 2016 23:28
|
|
|
Varkk posted:I have said it before and am repeating it now. You work in public education which means your workplace has a union. You need to join and get them to deal with what is workplace bullying from your superior. It will probably also stop them from loading that extra job on to you without appropriate compensation. IT in public education is one of the few areas still lacking in union options. Hell, even the paraprofessionals in my district have representation, but there is nothing for the data or IT workers. Not being an educator, administrator, or laborer puts you in an odd position where you don't quite slot in to any of the existing union options unless they've specifically branched to cover you.
|
|
#
?
Sep 6, 2016 23:38
|
|
|
Varkk posted:I have said it before and am repeating it now. You work in public education which means your workplace has a union. You need to join and get them to deal with what is workplace bullying from your superior. It will probably also stop them from loading that extra job on to you without appropriate compensation. Yeah I'm not sure where in the US you live but I don't know of any IT unions.
|
|
#
?
Sep 7, 2016 00:13
|
|
|
We'll start our own union, with hookers and beer.
|
|
#
?
Sep 7, 2016 00:18
|
|
|
 Edit: I was referring to Arizona, and while we are ranked 51st in terms of Teacher Union protections, one does technically exist. Dr. Arbitrary fucked around with this message at 00:39 on Sep 7, 2016 |
|
#
?
Sep 7, 2016 00:32
|
|
|
Terminal posted:IT in public education is one of the few areas still lacking in union options. Hell, even the paraprofessionals in my district have representation, but there is nothing for the data or IT workers. Not being an educator, administrator, or laborer puts you in an odd position where you don't quite slot in to any of the existing union options unless they've specifically branched to cover you. IT Techs in my district are members of the IBEW. So : we get union representation along with a handful of building lead custodians. They don't give a gently caress about us, but it's... something.
|
|
#
?
Sep 7, 2016 00:45
|
|
|
Jeoh posted:Some people see posts, but I just see regular expressions. I need to frame this in my cube.
|
|
#
?
Sep 7, 2016 00:56
|
|
|
larchesdanrew posted:Not really. The data I pull from our student inventory system is so different than the accepted format of the robocaller import that I spend most of that time just doctoring the csv files. Then, after you get some experience doing that, you may get pulled out of helpdesk hell to developer heaven some day. Inspector_666 posted:When I first started learning Powershell at my previous job, everything started looking like a CSV-shaped nail. e: this site is also useful for learning http://rubyfiddle.com/ ee: for example, heres a regex that finds characters that AREN'T digits https://regex101.com/r/gQ3bY1/1 KoRMaK fucked around with this message at 01:23 on Sep 7, 2016 |
|
#
?
Sep 7, 2016 01:18
|
|
|
|
| # ? Jun 1, 2024 15:47 |
|
|
KoRMaK posted:I'm always surprised by the lack of automation I hear you guys talk about. Powershell is great. You should also learn ruby and/or python. You can get soo much done with those. Like for instance, call a bunch of people at once https://github.com/twilio/twilio-ruby If whatever you are doing manually has a pattern, even if the pattern only plays once, then you can automate it. Processing phone numbers should be dirt easy (after you learn the ropes). And regex's are a definate must. I use this site to prototype regexes, its super useful https://regex101.com/. Highly recommend Python for this (only because I never bothered to learn Ruby). I do all my automation in Python. I can rip out a lovely script that gets stuff done, and then spend time refining it before I hand it over to the ops guys. Using Anaconda I know that, except for a few edge cases, I can package up my programs to work on any platform we have (Win, Mac, UNIX/Linux). Most of my stuff is infrastructure related, so Powershell may be more use if you're touching the guts of Windows boxes. Anything else, I'd recommend Python. And yeah, CSV for lyfe.
|
|
#
?
Sep 7, 2016 01:27
|
|
