May 5, 2020 at 10:23 am
stupid question time. when you guys deal with X12 spec files, is there a reasonable argument *against* loading them into tables named for loops/segments/ref numbers?
I get that they are variable files, not all loops contain all things all the time, but that's what NULL would be for....is there some sort of referential integrity that PREVENTS such a method that I'm not thinking of?
I tire of not being able to find something or having to dig through the raw data because nobody thought we would need something
So this is the point where I embarrass myself by admitting I don't know what X12 files are. Never heard of them before this.
May 5, 2020 at 2:09 pm
EDI format files, 834 (Enrollment) , 820 (premiums) , 270/271 (verification files), 837 (claims remittance), etc.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 5, 2020 at 2:30 pm
Me neither, apparently EDI-files https://en.wikipedia.org/wiki/X12_Document_List
May 5, 2020 at 2:54 pm
stupid question time. when you guys deal with X12 spec files, is there a reasonable argument *against* loading them into tables named for loops/segments/ref numbers?
I get that they are variable files, not all loops contain all things all the time, but that's what NULL would be for....is there some sort of referential integrity that PREVENTS such a method that I'm not thinking of?
I tire of not being able to find something or having to dig through the raw data because nobody thought we would need something
If something needs to be searched or returned, then my feeling is the same as the one I have for XML, JSON, and a wealth of other database normalization sins... shred it, normalize it, store it as proper tables. Period.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2020 at 7:33 pm
jonathan.crawford wrote:stupid question time. when you guys deal with X12 spec files, is there a reasonable argument *against* loading them into tables named for loops/segments/ref numbers?
I get that they are variable files, not all loops contain all things all the time, but that's what NULL would be for....is there some sort of referential integrity that PREVENTS such a method that I'm not thinking of?
I tire of not being able to find something or having to dig through the raw data because nobody thought we would need something
If something needs to be searched or returned, then my feeling is the same as the one I have for XML, JSON, and a wealth of other database normalization sins... shred it, normalize it, store it as proper tables. Period.
I agree and it has been my approach for all of the EDI/ASN.1/XML/JSON/OOML and quite a few other formats, if handling the information in a relational database, then shred and normalize.
😎
May 10, 2020 at 1:13 pm
Well, I *know* this enforced isolation is starting to get to me...
I keep finding myself starting to "retail therapy" on stuff I don't really need (as of this morning, I was contemplating putting RGB lighting in my home PC... BLINKING LIGHTS for cryin' out loud that I'd probably leave off anyways!)
Been thinking about also getting a planer for the woodworking I do, although that's even a hard sell for myself as I don't do a lot of said woodworking. Plus I've heard they're ridiculously loud and it'd be in the basement...
Anyone else running into this?
May 10, 2020 at 2:19 pm
I hear you Jason.
The number of times I have nearly bought a wood lathe (for which I have no space) over the past few weeks is the 12th parameter for dbbc_timewarp when asking for the data to be undeleted. ??
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
May 10, 2020 at 2:20 pm
I hear you Jason.
The number of times I have nearly bought a wood lathe (for which I have no space) over the past few weeks is the 12th parameter for dbbc_timewarp when asking for the data to be undeleted.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
May 10, 2020 at 5:06 pm
I'd be buying radio gear, but Mrs. Scary has me cut off.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 10, 2020 at 5:23 pm
My problem is that I start forgetting what day it is. The only reason I know this is Sunday is that it is Mothers Day.
May 10, 2020 at 5:25 pm
Also, I have actually been working from home since October 2019.
May 10, 2020 at 7:02 pm
My problem is that I start forgetting what day it is. The only reason I know this is Sunday is that it is Mothers Day.
Been running into that problem too...
I'll wake up for work on Wednesday or Thursday and spend a couple minutes trying to remember which day of the week it is...
I think that's more because, working from home, your workplace never really changes, you don't get that 30-45-60+ minute drive in to work to get your brain really started...
May 11, 2020 at 1:36 pm
I can't remember most days which day it is. Mostly because I think it doesn't matter and then I don't pay attention. I check the display in my monitor (from Rainmeter) to see the day of week more than once most days.
Hard to complain about being shut in here on the ranch. We have lots of space, but the dull sameness is wearing. I've been slowly tackling things that need to get done, despite not having energy. I've been also trying to build a few things. I may actually add some LED lights to a frame for video calls. It's easier to buy a ring light, but the idea of trying to put something together actually generates a slight bit of enthusiasm.
https://www.youtube.com/watch?v=IQ3NxYPxRd4
If it works, might tackle this: https://flippedlearning.org/how_to/how-to-make-a-lightboard-for-less-than-100/
May 11, 2020 at 1:39 pm
Lynn Pettis wrote:My problem is that I start forgetting what day it is. The only reason I know this is Sunday is that it is Mothers Day.
Been running into that problem too...
I'll wake up for work on Wednesday or Thursday and spend a couple minutes trying to remember which day of the week it is...
I think that's more because, working from home, your workplace never really changes, you don't get that 30-45-60+ minute drive in to work to get your brain really started...
Yup - I have the same problem. I think a lot of people do for the exact reason you specify. I've been WFH almost exclusively since late last year and I find I'm far more productive. I've also become accustomed to knowing what day it is, but with the whole family home all the time now, the "what day is it again?" syndrome has returned. This too shall pass.
One thing I definitely DO NOT miss is that rotten commute. Yours was undoubtedly worse than mine, as I take Telegraph and I think you'd take I-696 :(. I get back over an hour a day without losing anything. I've also gotten 2 months out of a full tank of gas and haven't put on the miles that I usually do. The coffee's better at home, as is the food. 🙂
May 11, 2020 at 1:49 pm
I can't remember most days which day it is. Mostly because I think it doesn't matter and then I don't pay attention. I check the display in my monitor (from Rainmeter) to see the day of week more than once most days.
Hard to complain about being shut in here on the ranch. We have lots of space, but the dull sameness is wearing. I've been slowly tackling things that need to get done, despite not having energy. I've been also trying to build a few things. I may actually add some LED lights to a frame for video calls. It's easier to buy a ring light, but the idea of trying to put something together actually generates a slight bit of enthusiasm.
https://www.youtube.com/watch?v=IQ3NxYPxRd4
If it works, might tackle this: https://flippedlearning.org/how_to/how-to-make-a-lightboard-for-less-than-100/
You can mouse over the system tray to display the day, or look at your phone. 😉
We went to Home Depot over the weekend to try to get an order we placed 9 days ago. It was supposed to have a 1 to 2 day pickup notification, but it never arrived. When we went to pick it up, it took over 2 hours for them to "pick" 12 2x4s, only to come back and say they didn't have 15 1x6s we had ordered. They had 10 employees standing around talking and the line outside was 1/3 the way down the store. I guess "customer service" has taken on a whole new meaning nowadays. I hope this is local to the store and that other stores are better, but people remember stuff like this.
I stopped by Lowe's yesterday, on whim while on the way to buy food. I had no waiting in line, picked out the 1x6s we needed and checked out with no line. They were even cheaper than Home Depot. I guess I know where I'll be going next time.
Viewing 15 posts - 64,831 through 64,845 (of 66,816 total)
You must be logged in to reply to this topic. Login to reply