• Content Count

  • Joined

  • Last visited

About QP1

  • Rank
    Advanced Member

Recent Profile Visitors

890 profile views
  1. QP1


    My understanding of the entity issue was that some of the YOMI name fields (for Japanese phonetic spellings) were removed from the standard D365CE 'Appointment' entity, after which, whenever the App tried to access the entity via the CDS Current Environment connector, we got an error about missing fields. My suspicion is that the entity was changed but the definition of the connector was not, so the connector was trying to access fields that no longer exist, but I don't know much about the internals of the CDS connector so that is pure speculation on my part. My solution was to turn on 'Explicit Column Selection' (which I normally leave off now as it is marked experimental and I'd previously had issues where changes to the behaviour broke production Apps) so the App was no longer attempting to access those fields and our reads/writes started working again.
  2. QP1


    Common Data Service (CDS) is abysmal. Unless you are already in the D365 world (where you have no choice) avoid. Azure SQL is cheap for low volume (starts at $5 a month). Although CDS stores data in a 'relational' fashion, you can't do 'relational' querying - a join can only go one level deep, and not even that if data structure uses nonsense 'features' like polymorphic relationships, plus no real time aggregation). As such, CDS requires that you repeat data at many levels and use workflows (that may need to be asynchronous so as not to slow the system down too much) to try to keep all that repeated data in sync. Just take a look at the Common Data Model (a set of standard entities for common scenarios built on CDS) implementation of an Account entity and you'll see something like 100+ fields and limited normalization (e.g. Address1, Address2, Address3).
  3. I think that is a good analysis. I was deeply unimpressed with Ardern's response to the Mosque shootings. I think there was a bit of push back on the gun grab with many people just hanging on to their guns and I don't think the attempts to curb the internet got far. I did see a few women wearing head coverings 'in solidarity with their Muslim sisters'. Most of the people I talk politics with here in NZ are brits but I get the impression that significant numbers of Kiwis lean to the SJW side. Hopefully a silver lining of the CV crisis is that it helps open a few eyes to the downsides and risks of globalism, open borders and oppressive governments (CCP) and I think the longer lockdowns continue the more likely that will be the case, though I do fear the risk of governments gaining oppressive powers that they retain after the crisis is over (monitoring people's movements, enforced vaccinations and so on).
  4. I guess if this goes on for a while and people see/experience benefits of reduced/restricted international travel and immigration from 'less desirable' parts of the world, they may be reluctant to open up fully and 'go back to the way things were'. Interesting times.
  5. QP1


    SharePoint - it started out really terrible (I first started on SharePoint 2010), got a bit better, then went online and had a complete make-over so now it looks much better, but lots of functionality is in flux/incomplete. This week I wanted to duplicate the structure of a list so I could do some testing... used to be possible, no longer an option. The permissions model is going through a change (being simplified) but for some of our projects we need the older, more flexible model but it is a devil of job to reach it via the interface and who knows when it will be dropped completely. SharePoint is probably OK for some simple document management/sharing and intranet type knowledge sharing/comms as long as you are happy enough with what it looks like out of the box. Personally I don't much care, but you usually get 'input' from the comms people on what shade of puce they want and how many pixels thick the dividing lines should be, at which point it is a real pain to customize. I do some work with SharePoint lists (when I cannot possibly avoid it) and find the best way to use SharePoint is to link it to Access so you can see as many rows as you want and run queries to do bulk data modifications (albeit super slowly cos SharePoint performance is terrible). As a wise-man once said - if SharePoint is the answer, you are asking the wrong question.
  6. QP1


    I do a lot of work with PowerApps as a front-end to SQL, D365 and SharePoint and in years past did a lot of work with Access as a front end to SQL (a great way of getting front-ends onto locked down corporate PCs as a full Office install includes the Access run time license - meant we could create and distribute front-ends without going through IT). IMO PowerApps is going to quickly gain the negative reputation of Access, but in the case of PowerApps that negative reputation is far more deserved. I'm currently the voice of doom at work regarding PowerApps, recommending that we do not take on any more projects using the technology due to the following issues: Licensing: Initially you could use the PA license that comes with O365 to connect to on-prem and Azure SQL. Then MS screwed over the on-prem SQL folks by making the on-prem SQL connector premium (requiring a monthly license fee for every user), then when the on-prem folks move to Azure SQL, they pulled the same trick again and made Azure SQL Premium too, plus changed the licensing so it was no longer just per user, but per App per User. For us, one App went from a cost of $30 / month (for SQL Azure) to $1030 a month (for 100 users). To be fair, for existing Azure SQL based Apps the new licensing is deferred for a few years, but anything new will incur those charges so PowerApps is basically dead as a front-end to SQL. Do you really want to run critical systems on a licensing model that can change so dramatically and where you can't move what you have developed to another provider? Stability: PA runs on MS servers, not your own, so you have no control over when updates or changes are released. In the last few months I had a bunch of Production Apps break when MS decided, without warning, to change the behaviour of the Explicit Column Selection feature. Then a change to the App Checker locked up an App just prior to deployment and we had to wait a week for MS to fix/revert the behaviour. Then there was a change to Formula Level Error management which breaks how Nulls are handled, breaking some more of our Apps. Then MS removed some columns from a D365 entity but didn't update the connector, so every attempt to write data to the entity failed. Today I am trying to find a workaround because the Wave 1 2020 D365 release breaks our App but only on Mobile - cannot recreate in the design studio which makes it virtually impossible to bug-find / fix. MS are also starting to remove less-popular features from the platform (e.g. Rules), so if you used those features in your Apps you have to rework them or they will be broken. Maintainability: Internally PowerApps are ugly spaghetti logic - no encapsulation of logic into functions or re-use of code outside of a single screen. Picking up another developer's work is a nightmare and there aren't even proper search functions to trace logic through an App. Only one developer can work on a PowerApp at a time, so all the knowledge ends up in one developers head rather than shared in a team. MS release a new version of the runtime pretty much weekly. Every time you deploy (publish) an App it is on the latest runtime. I've had plenty of times where a new runtime introduces a new bug, so you have to be very careful to fully test an App after any change, no matter how minor, as screens you haven't touched may be affected by running on the new runtime. And guess what, PowerApps does not play well with automated testing tools so all the testing needs to be done by hand and needs to cover weird edge cases like check box empty yields result A, but if you check and then remove the check, does it still yield A? There are testing tools in Preview, but they are within the PowerApps platform, so I wouldn't trust those to give accurate results.
  7. Yes, if travel/immigration is divided between the CV and non-CV world that could be a seen as a good outcome given that the non-CV world is most likely to consist of less densely populated, technologically advanced nations (with populations more prone to following science than superstition) with stable/capable governments. One might say 'shit-hole' vs 'non-shit-hole' countries.
  8. I'm in NZ but as I'm obeying the lock-down (personally went into lock-down mode a couple of weeks before the country did) I can't comment much on what others are doing. We have a track/field stadium nearby and go for a walk around that pretty much everyday and sometimes a cycle. I see other people on bikes as well as dog walkers, joggers and families out for a stroll; all observing the 2 meters distancing. Haven't seen any sign of the Police or heard of any issues, but as I say, I'm in my own (very small) bubble. Reported cases very low (about 20 new cases a day at the moment I think) but deaths have ramped up recently (on about 20 total now I think) as it has got into some retirement homes. I'm hoping they keep the lockdown going another few weeks in an attempt to eradicate CV here completely. How/when air travel opens up and tourism begins again I don't know. If other countries eradicate it we could accept flights to/from those countries. Depends how many countries eradicate CV and how quickly. Could lead to a two tier world - those countries without CV allowing travel only between them, those with CV handling it as they see fit (banning travel in an attempt to join the CV free nations or just accepting it as endemic until/unless there is a vaccine).
  9. If/when there is an antibody test, you don't let in anyone who has does not have immunity (make this part of the visa requirement). Hopefully there will be a vaccine at some point and the vast majority will be immunized. Assuming this regularly mutates like cold/flu (so no immunity), you only allow international travelers from countries who have eradicated the virus or who have very very few cases and strong control measures in place (quarantines, contact-tracing). In terms of the movement of people, you end up with the world divided between functional governments/societies and dysfunctional ones - possibly a silver lining for those of us lucky enough to be on the functioning side. If it turns out you can pick it up from goods shipped into the country, all goods have to be irradiated, disinfected or held for a period of time upon arrival depending on the appropriate method to ensure no transition.
  10. Plus the elites who were never really exposed to 'enrichment' are not so isolated from corona virus, so may not be quite so ready to virtue signal on behalf of us plebs. As an aside, was there any truth to the story that the Italian super spreader was a migrant who refused to self isolate and carried on working in a restaurant and take-away delivery? Don't suppose we will ever really know...
  11. Yeah, would expect farming can carry on relatively unhindered - presumably overseas demand won't disappear completely and maybe 'COVID-Free' can become a new mark of distinction for foodstuffs? Expect we will be consuming a lot less cheap Chinese tat. Maybe we'll all become like Cuba trying to keep decades old cars and appliances running (good luck if they were made in China). Was looking to buy a home in 12 months - no doubt my savings pot will be eroded faster than any fall in house/asset prices... although quite a few of the oldsters here with nice houses are regular overseas travelers, so you never know
  12. New Zealand just announced the closing of schools (from Wednesday I think). All non-essential workers to work from home (or just not work if that isn't possible). All households to self-isolate for the next four weeks (at least). Households can go out for walks, etc but must stay away from other people. Currently 100 cases, no fatalities (haven't seen any figures for hospitalisations) but cases have been pretty much doubling per day the last four days. Until today all cases were recent overseas travelers but the latest cases include some that must be community transmission. As of last week, only citizens and residents can enter the country. I've been working from home for weeks now. Wife and I had just decided to pull the kids out of school when the announcement came through. Was on a conference call this morning with the rest of the team (who were told to work from home since early last week). Started off by going over what we'd done over the weekend - lots of folk had been to the beach (which was busy) out meeting friends for lunch, trips to the pub and so on. F*ckwits imo. Think (hope) NZ has a good chance to pull through this with a lot less pain than most other countries as long as people are sensible and, if/when it is eradicated in NZ, the flight restrictions are kept in place and only gradually relaxed with other countries who have managed to eradicate it. Interesting years to come. Expect the world to divide into those regions with coronavirus and those that have eradicated it/have it 'under control' (sparse, isolated cases with good quarantine and contact tracing in place), essentially a divide between 'shithole' and 'non-shithole' countries. Sorry SJWs but nature has destroyed your dreams of open borders.
  13. I tried a fairly high end Sony soundbar (that also had wireless rear speakers). It was crap. We actually had to switch back to the TV speakers to hear clearly what people were saying. Took it back and traded it in for some good stereo speakers, a surround sound amp and a subwoofer. OK, it cost twice as much but it sounds a million times better and if I ever feel the need (and financial well-being) I can add rear speakers and centre speaker to make it even better.
  14. I have a Nissan Leaf. Fantastic to drive and the acceleration is instant (though obviously not sustained for long). For every day driving a quick burst of acceleration is all you need and that is what you get even with a Leaf.