From very painful experience linking access to cache can be a very difficult proposition. In theory it's simple, an odbc link from access can read data fine from cache. However if you want to write anything back or perform updates of any kind it gets very finicky.

We ended up writing sql stored procedures in cache and calling them from access for any data modifications. So the linked odbc tables were only used for read only access.

Also be aware of large integer numbers, which need the bigint data type in access to display properly, which was only introduced in access 2019.

So currently I have iris installs with PWS as we all do, and I've configured IIS for https access to the management portal, but I'd like to see how the installer would setup IIS. Is the IIS configuration part of the setup agent going to be available to run outside the installer so that I could run it against a prior version of Iris and see how the IIS setup is configured? 

Additionally if I want to remove the PWS from an install after having configured IIS, is that supported for prior versions than 2023? Assuming the testing, upgrade release cycle internally is such that upgrading to 2023 isn't an option yet. 
Would that be answered in the future documentation mentioned here? 
"Once a customer has migrated off the private web server, they'll need to remove it manually.  (Add link to future documentation)"

Hi Robert

Thanks for the help and guidance. I've missed the window now as I've been away from the office, (a crazy idea I know). I'll take a look at the repo you've setup and see if I can figure out what I was doing wrong when I'm back online. 

Regards

My repo is linked above, but here it is again, although I'm way out of contention for any cool commmunity badges :) 
https://github.com/mcwebtree/WIT-AOC2022

and this is empty but green, (https://community.objectscriptquality.com/dashboard?id=intersystems_iris...), so I think this years CPD may be on encoding algorithms and how VS Code, GitHub and Docker work with objectscript... Might then have a better chance next year :D

Thanks for the motivation towards all the hair pulling, googling, screaming at monkeys, and don't get me started on the elephants...

Merry Christmas all and have a great New Year. 

I just changed one of my classes (Day1) from abstract to  Extends %RegisteredObject and committed to Git.
The action ran, the code change shows on the code view of Code Quality.  
The file shows a count of lines of code, yet the overall view still shows no code. 

So the $64,000,000 (or more like $6,000) question is, does the current state of the quality checker stand for our submissions or do we need to go back and change all the classes to get it to work and qualify :) 
A moot point for me in the back seats but more so for Kevin.

Yes, but if you look at the code tab it says there are 0 lines of code in the project... 

It's public.

https://github.com/mcwebtree/WIT-AOC2022

OK, so I tried that to see how it works and if I could figure it out... it didn't go so well. 
I mean I have a GitHub with actions running, code is loaded in as cls files, but apparently none of my code is code to the quality scanner and my other actions fail. Does anyone have the time to give me a few pointers as to where to look next please. 

OK thanks.

That sounds a bit more manageable. I'll take a look if I get time :)  I have the git hub account already so I'm 20% there...

If you're looking for a song with instructions you could try  Cha Cha Slide by DJ Casper.  Although I can't help you on how to do the charlie brown. 
https://g.co/kgs/JdWTca

[...]
Everybody clap your hands
Clap, clap, clap, clap your hands
Clap, clap, clap, clap your hands
Alright now, we're going to do the basic step

To the left
Take it back now, y'all
One hop this time
Right foot, let's stomp
Left foot, let's stomp
Cha cha real smooth
[...]

Hum, so now the question is how does the ObjectScript quality scanner work?
I don't have a login and the help docs don't (help)... 
Then I need a learn docker, 
Then I need to install Git. 
I get the impression that its easier just to not win ;) 

I answered my own question by a simple search, d'oh. but to save anyone else that 30 seconds of effort, here it is.
https://community.intersystems.com/post/setting-your-own-intersystems-ob...

Is there any way to have multiple registries enabled at the same time in ZPM, with a priority so that it looks at them in order to find packages. That way you can use public packages from the community repo without having to have them imported/duplicated into your local repo.  Or is the only way to keep switching between repos if you want to source from different places. 

I assume there is a way to install a private local ZPM repository if you want or need to keep your code internally.

That explains a lot. I had wondered if I was going mad or not. Glad I'm not, although I hadn't realised it wasn't a supported ability in the first place. 

Looks like I really need to put some time into VS Code now and start letting studio take a break :) 

Hey Kyle, 

You're a font of useful knowledge, another great nugget of info. I just wish there was a way to default the terminal colours so that I could see instantly which server I'm on, or even if its just production, testing or dev. 

I use a chrome plugin called URLColors that puts a colour wash over the page for my Management Portals so that I can see really clearly which server I'm operating on. If it has a red hue then I need to be careful, if it's green then I'm fine to play! 

Cheers for another great time and especially for sharing it, (although I've gone for 1,8,2 ;] )

I've read this post 4 times now and gone through my account settings and I'm damned if I can figure out what I can do to stop these email notifications coming thorough. Please can you advise which "technical reasons" mean that on the front page I have 2 categories 

http://prntscr.com/ec23ln

and in actual categories I have nothing, yet am still receiving many notifications

http://prntscr.com/ec248n

Thanks

Mark

(p.s. preview on this comment came up with a server error http://prntscr.com/ec255t)