Posts made by garak0410

More info: In some cases, after signing in to the service, users are then unable to access their OneDrive content. As the issue is intermittent in nature, users may be able to reload the page or make another attempt successfully.

Current status: We're analyzing system logs to determine the next troubleshooting steps.

Start time: Tuesday, March 21, 2017, at 5:15 PM UTC

Next update by: Tuesday, March 21, 2017, at 7:30 PM UTC

I verified...tried to open a document via OneDrive and Excel Mobile and said I didn't have permission...checked the XBOX Live Status and shows "limited."

garak0410

@wirestyle22 said in Gaming - What's everyone playing / hosting / looking to play:

@garak0410 said in Gaming - What's everyone playing / hosting / looking to play:

@scottalanmiller said in Gaming - What's everyone playing / hosting / looking to play:

@garak0410 said in Gaming - What's everyone playing / hosting / looking to play:

@scottalanmiller said in Gaming - What's everyone playing / hosting / looking to play:

@garak0410 said in Gaming - What's everyone playing / hosting / looking to play:

Gosh if I had the time to play games, I'd be back on Fallout 4. Last game I truly gave time to was ALIEN: Isolation...what an experience that was.

I got to watch several hours of Alien: Isolation when my SIL played it. Seemed really good.

If anyone is a fan of the original ALIEN, this game rocks...it was so effective that I've yet to replay it because it was so intense.

I love the original, always was a big fan of Ridley Scott's work.

Slightly off topic but I am both excited and nervous about the new ALIEN film that he is directing. Prometheus was both a good and bad movie. I hope this new Alien film isn't a gorefest and has a good story. The last trailer and the CGI Alien at the end has me nervous.

What are the complaints about Prometheus?

I feel the same. High points, and some weird stuff and didn't carry it completely. Good promise, though.

Couldn't have said it better myself about Prometheus. Loved how it started...David studying what it means to be human, Shaw's faith, the memories of her Dad, the holograms in the ship...but then just kind of falls apart when the two guys get lost in the ship and decide to touch the worm thing, reanimating that head, the incoherent results of the early mutations, Shaw running around after a C-Section, the Engineers being nothing more than bad guys at the end and then we get a "proto-facehugger" and the Deacon alien at the end. The writing suffered...I hope ALIEN: Covenant covers some of the good things about Prometheus.

garak0410

@scottalanmiller said in Gaming - What's everyone playing / hosting / looking to play:

@garak0410 said in Gaming - What's everyone playing / hosting / looking to play:

@scottalanmiller said in Gaming - What's everyone playing / hosting / looking to play:

@garak0410 said in Gaming - What's everyone playing / hosting / looking to play:

Gosh if I had the time to play games, I'd be back on Fallout 4. Last game I truly gave time to was ALIEN: Isolation...what an experience that was.

I got to watch several hours of Alien: Isolation when my SIL played it. Seemed really good.

If anyone is a fan of the original ALIEN, this game rocks...it was so effective that I've yet to replay it because it was so intense.

I love the original, always was a big fan of Ridley Scott's work.

Slightly off topic but I am both excited and nervous about the new ALIEN film that he is directing. Prometheus was both a good and bad movie. I hope this new Alien film isn't a gorefest and has a good story. The last trailer and the CGI Alien at the end has me nervous.

garak0410

@scottalanmiller said in Gaming - What's everyone playing / hosting / looking to play:

@garak0410 said in Gaming - What's everyone playing / hosting / looking to play:

Gosh if I had the time to play games, I'd be back on Fallout 4. Last game I truly gave time to was ALIEN: Isolation...what an experience that was.

I got to watch several hours of Alien: Isolation when my SIL played it. Seemed really good.

If anyone is a fan of the original ALIEN, this game rocks...it was so effective that I've yet to replay it because it was so intense.

garak0410

Gosh if I had the time to play games, I'd be back on Fallout 4. Last game I truly gave time to was ALIEN: Isolation...what an experience that was.

garak0410

@DustinB3403 said in What Are You Doing Right Now:

@garak0410 what is so.cl?

It is (soon to be WAS) an alternative social network...mostly for creative posts and such...It is similar to https://ello.co/ . I kind of liked its randomness.

garak0410

Trying to figure out how to save my way cool animated GIF's I uploaded to the soon to be defunct www.so.cl website. And also thinking if I may be the only ML user who actually used So.Cl.

garak0410

@JaredBusch said in Excel to SQL - Need Some Normalization Tips:

@garak0410 said in Excel to SQL - Need Some Normalization Tips:

So, what I am looking for is the proper way to store these notes in a database and have it tie back to the matching customer. I've imported this into SQL and while it worked, I still have the problem of how to display the data from the columns. Management stills wants one large field that displays the notes, most likely with a vertical scroll bar to through through them.

Do not worry about how to store the data.
Start with what you need to end up with and how it will be entered.
Those are two different things.
But those two will form the basis for what your data will have to be.

So supposing you have these entry fields.

ID

Customer (multiple fields for info, name, account #, etc.)

Note 1

Note 2

Note 3

You were posting about making multiple tables and getting close to 3rd normal form.

Works great, and is good design of course, but you also need to think about the purpose of this application.

But do you need to get that complicated? Any relational database can take all that in a single table with as many columns as needed.

The purpose is to see what special requirements there are for certain customers. We currently have 145 regular customers who have special needs when we design a building for them. We want to be able to display the customers in a cleaner format and also make it easy for a designated person to update as needed.

And I am, for now, going to use Access because I need something quick and within my current skill level. And yes, when my skills expand, I do plan on redesigning this. The main problem I am having is displaying the notes. Each single note per customer is it's own field. For example, look at this wizard:

In creating a form,. it's wants me to select each note field and ends up looking like this:

This isn't want management wants and it will also cause problems for customers who need more than 16 "notes." They want to see the customer name, address, contact number and all notes associated with it. It would be nice to see all notes in a scrollable window. Not sure how easy that would be with Access but I'm thinking it would be. This is where I may be confused if I need normalization or not.

garak0410

@JaredBusch said in Excel to SQL - Need Some Normalization Tips:

@garak0410 said in Excel to SQL - Need Some Normalization Tips:

Yeah, the number one goal for management/end users is just something that is NOT EXCEL. Web-Based is what they want but it is limited on my (current) dev knowledge. Access would work for now for sure but not what I would choose. I used to really like LightSwitch but it is on the route of depreciation.

I think I am on the right track as far as forming the database but need something that will store and display these notes in correct database normalization.

normalizing the notes into a separate table means they will look like this

ID

CustID (foreign key to Customer tbale)

NoteNo (ie note 1, 2, 3, 4)

NoteText

I am visualizing that now...thanks...

garak0410

Yeah, the number one goal for management/end users is just something that is NOT EXCEL. Web-Based is what they want but it is limited on my (current) dev knowledge. Access would work for now for sure but not what I would choose. I used to really like LightSwitch but it is on the route of depreciation.

I think I am on the right track as far as forming the database but need something that will store and display these notes in correct database normalization.

garak0410

@scottalanmiller said in Excel to SQL - Need Some Normalization Tips:

I'd recommend MariaDB or PostgreSQL. Only two relational database servers I would choose without very specific needs to the contrary.

Definitely not SQL Server unless absolutely no choice for obvious long term licensing reasons.

Checking them out now.

garak0410

I've been tasked with converting a very ugly spreadsheet into a database application. I've yet to decide on an interface but I do want to throw it into MySQL or SQL Server and then go from there.

The spreadsheet has a front end that reads and then displays data from a second worksheet called customer data. That data is stored a customer per row, including all of the notes up to 17 columns. So for example, a customer can have notes in Column G though Column V. If a customer has notes that go beyond column V, they would then go to Column W.

So what I've done in my early tests (testing with Access but not going to necessarily end up using Access) is to split the data from that single worksheet into two work sheets, one containing the customers, one containing the "Notes". I also inserted a column for ID on both sheets so that it would match the "Notes." I then imported into Access and set the relationship between the Customers and The notes via the ID. Sounds fine...

But the problem I am having is that each NOTE shows up in it's own field (Note 1, Note 2, Note 3, etc.) and it is kind of a messy way to enter the data going forward. The current spreadsheet allows a user to choose a customer at the top left and then all the notes from those columns are displayed in one huge white form and it is ugly. So you can see why we want to update this...

So, what I am looking for is the proper way to store these notes in a database and have it tie back to the matching customer. I've imported this into SQL and while it worked, I still have the problem of how to display the data from the columns. Management stills wants one large field that displays the notes, most likely with a vertical scroll bar to through through them.

Any hints?

garak0410

I think I'm going to watch THE FINAL SACRIFICE tonight.

garak0410

@scottalanmiller said in Access Web Application With SharePoint Online - Set Relationships:

I feel like, and of course I am guessing, that you are caught in a world of "get it down now, screw doing it right" which is causing every project to take more work than it should and more effort to support long term making it increasingly impossible to get on top of things to do it right to start fixing the problems.

Sort of...on this latest project that is taking "too much time", they now just want to create 146 separate Word documents with the needed data rather than give me a little more time to come up with something on my own.