Home Forums Discussions General Discussion Married and Amazing

OK, I would like to think I know this, but I don't want to miss anything. One of my staff recently got married and would like her name to reflect this in AC. Of course, user with the maiden name can't be deleted, but it can be turned off.

A new user under her name would be made, and she should be able to use that. Beside the fact that a lot of notes had her old name on them, would there be a problem.

Of course, there would be all the messages under the old name, but those could be dealt with.

Am I missing anything. One would think that this happens every once in a while.

Bert,
I just tried with an old user and changed the last name in Admin then edit users and it accepted it have you tried that yet?

So, are you saying I could just edit her user as it is now to reflect her new last name?

Yup, you can just update her info. I have done that once or twice I think, but don't remember why. Guess I must be an OG too!

Wendell - you have always been an OG in my book; and as said by the guy who said to me, I mean that with all the implied respect the title can confer.

As to the topic at hand - I suspect that the primary key is the userid or a synthetic, and not her name itself - always the better choice.

OK, at the risk of sounding STUPIDER than I normally do, what's an OG.

I also think that some both male and female couples (not getting into politics here) would like to turn their spouse off once in a while.

These are great answers. I just want to make sure I don't miss anything.

I assumed OG was 'Old Guy'.......

Ahhh, that would make sense if it pertained to Wendell and Indy, lol. Just kidding guys -- I am right there also.

I should also say, I don't want to lose data and lose all my incredible diagnoses.

When I read this on my phone, I started laughing so hard in a meeting I had to take a break and spell it out.

I had been brought in to work with a 'hipster' start-up in 'Cali', and this 20-something started asking about my background, and then when I started the run down he kind of cocked his head, paused, then blurted out "D@mn Man you a Legit OG!"

As soon as I got a break I went looking for one of the founders, told him of the interchange, and asked him to translate. He laughed and then told me that it was a back-handed compliment. In his mind I was a legit "Original Gangsta" - seriously cracked me up that was a compliment.

Yeah, but it was back-handed.

Damn, isn't this the best user board ever? Must be a reflection of the Admin.

The ID for a user in Amazing Charts is a SQL Server IDENTITY.

http://en.wikipedia.org/wiki/Identity_column

JamesNT

Amending my previous post:

The ProviderID for a user in Amazing Charts is a SQL Server IDENTITY. However, whether or not that is used to refer to the user depends on the table doing the referencing. Some tables reference the ProviderName column - which provides the contents of the username list on the logon screen - rather than the ProviderID column. Actually, I think most of them do. Others reference the FirstName column - this is often seen in the LastTouchedBy column of many tables.

All users are kept in a table called ProviderSecurity.

JamesNT

James,

I think everyone knows this. You have to come up with some more difficult stuff, lol.

Actually, the LastTouchedBy means more to me than you could imagine.

Then you'll also be happy to know many tables have a DateLastTouched column, also.

However, two columns such as those provide for a very weak audit trail as they cannot track multiple events - just the last one. Fortunately, Amazing Charts does what I consider to be a very good job of auditing changes to tables compared to many other softwares I've seen.

The AuditLog and AuditTrail tables are where the real fun is if you want to know who is doing what.

JamesNT

Wait. . . Bert might have got one past me with the whole touched thing. . .

JamesNT

Doubt it. Let's just say I know quite a bit about it. Not sure about all the tables, but in ListHMs, LastTouchedBy seems more important than RecordedBy, although both are populated initially by the user name.

It is time, though, to move to SQL Server 2012 Express, although it still only allows 1GB of RAM. With so many extra features in the stands, etc., you would think Microsoft could throw us a bone and give more than a GB. You know, keep up with the RAM technology since everyone is putting 20 to 48GB of RAM in their servers or computers, you would think just a tad more than 2% would be nice.

So, I just saw where Paul Ryan got two football players mixed up, and it made national news. Guess healthcare and the economy were just too boring to talk about.

Well, I guess I hijacked my own thread.

With everything else AC has going on:

* Version 7 with the PM module and all the feature requests/bug reports involved with that once it is released

* MU stage II

* the new "communications hub" to transfer data to third parties.

* hosted AC

I'm not sure where upgrading to SQL 2012 falls. AC has a great deal on its plate.

JamesNT

It's a big plate in seven years.

And, there simply can't be any bugs in the PM.

After that most of the crew started referring to me as 'The OG', and since most of them were unfamiliar with Indiana Jones, I rolled with it.

Old Geezer?

Greg

Ya know it is so nice to see some people are still so positive about the state of Modern 21st century Marriage. And yes it can be quite "Amazing"...

And while we're at it, since we should all be interested in reducing trauma and family break-ups, the only person in the "Last Touched By" data should Always be one's Spouse, Right?

But then again Bert is one very Eligable Bachelor...

Hey guys is it time to start another road of Primary Care, Peds Dial a Date or The Dating Game for old (O.G.) Bert??? I guess stating that makes me an O.G. too, ah?