Jump to content

g__day

Hero
  • Content Count

    654
  • Joined

  • Last visited

  • Days Won

    6

g__day last won the day on November 28 2017

g__day had the most liked content!

Community Reputation

65 Learner

About g__day

  • Rank
    Master
  • Birthday 09/12/1961
  1. So I tried a new approach with a lot more more success. I created a Execl file with two worksheets. In the first worksheet I wrote a normal Data -> web query that polls the website, successfully passes the credentials – grabs the inverter JSON results and simply writes it to a local file called inverters.json. Then in another worksheet write a power builder query to read this inverters.json file and extract the inverter data – scheduled to run every minute. This worked well! The only challenge I have now is storing the first procedure call and setting its properties to run every minute. Excel doesn't seem to want to store this call if Excel isn't trying to do something with the results. Any suggestion guys?
  2. g__day

    They have finally arrived. Maybe.

    And the surprising true answer - it was child porn on the janitor's computer! Read they tracked a dark web site to the observatory and scanned folks computers!
  3. g__day

    BASTARD CHILD Member Since 10 Sep 2008

    Sad news indeed - condolences to his family and friends. To think the forums and this community have been around so long we now have a left the planet list...
  4. g__day

    damn, it's been a while...

    Waves Notices 651 post - my arse!
  5. g__day

    money

    The Ascent of Money is a great TV series to watch if you want to see and understand the pivotal moments in the creation of money and economies. The textbook answer to what is money being the classic line money is what money does, or its a way to price and trade/transfer risk - often doesn't leave many the wiser; this series will! Plus the narrator does for money what top gear did for cars - they make it really interesting and the content really accessible.
  6. So some major progress - I now have 1) admin user id and password - and have been shown how to use Excel 2013 with PowerQuery add on - which reads javascript really well! I can now query the old or classic views of my device - with the admin user id, or the new views using PowerQuery and if the URL is not protected all is fine. My Dilemma If in Excel I simply select Data -> From Web and supply the URL User Id and Password – it works fine – but it returns javascript which Excel simply can't natively ingest. If in Excel I select Powerquery -> from Web, it asks basic or advanced. If I chose basic – it only asks for the url and this fails. If I chose Advanced – I don't know how to format the query to supply the user id and password. Which is annoying given Powerquery natively does support Javascript and easily converts it into readable tables! If in Powerquery I try and reach say http://envoy:011842@192.168.0.12/api/v1/production/inverters the call will fail and bring up web access – where I can choose API, Simple or web access – and for simple or advanced I can add user id and password – but the call simply hangs. Does anyone know how to use Excel 2013 with PowerQuery on a web access call to supply the user id and password? Many thanks, Matthew
  7. Interesting development last week - GITHub posted a 20.4MB 64 bit version of Deep Sky Stacker v4.1.0 and its much, much faster - I just stacked 20 images of M20 and all up it took about 3 minutes. https://github.com/LucCoiffier/DSS/releases/download/4.1.0-Release/DeepSkyStacker64Installer.zip Have to play with it some more - but it looks pretty much the same - just the stacking is a lot faster, not sure about the registering but stacking was wow the first time around!
  8. g__day

    Windows10 BSOD WHEA

    I think it more likely there may have been an under voltage at low usage issue (no idea why it took so long to manifest unless a Windows update automatically triggered it. An updated BIOS may have side stepped the issue by raising an auto / default voltage for the detected CPU. Still watching the stability but so far so good!
  9. g__day

    Windows10 BSOD WHEA

    Asked on Whirlppol forums - they are quite good. They ran thru my dump file - concurred it was hardware related bug, said the idle CPU voltages seem low - suggested I update my motherboard BIOS and see if a new BIOS better manages these new CPUs. Did so and no crashes for two weeks :)
  10. Fresh reinstall on a re-formatted disk - the nuclear option - sorted it. Total p.i.t.a.
  11. g__day

    Windows10 BSOD WHEA

    Scorptec said send it back and we will fix / replace whatever is wrong :) So will likely do that next week! From WhoCrashed: Just ran Whocrashed thanks for the suggestion. It could provide very little information - it just says it thinks it is an unspecified hardware fail: On Sat 17/03/2018 2:04:55 AM your computer crashed or a problem was reported crash dump file: C:\Windows\MEMORY.DMP This was probably caused by the following module: hal.dll (hal!HalBugCheckSystem+0xCF) Bugcheck code: 0x124 (0x0, 0xFFFFAD0960174028, 0xB2000000, 0x70005) Error: WHEA_UNCORRECTABLE_ERROR file path: C:\Windows\system32\hal.dll product: Microsoft® Windows® Operating System company: Microsoft Corporation description: Hardware Abstraction Layer DLL Bug check description: This bug check indicates that a fatal hardware error has occurred. This bug check uses the error data that is provided by the Windows Hardware Error Architecture (WHEA). This is likely to be caused by a hardware problem. The crash took place in the Windows kernel. Possibly this problem is caused by another driver that cannot be identified at this time. -------------------------------------------------------------------------------- Conclusion -------------------------------------------------------------------------------- 2 crash dumps have been found and analyzed. No offending third party drivers have been found. Connsider using WhoCrashed Professional which offers more detailed analysis using symbol resolution. Also configuring your system to produce a full memory dump may help you.
  12. g__day

    Windows10 BSOD WHEA

    One surprising thing - never seems to crash in playing a game for hours - but surf the net or watch youtube for 5 mins... So maybe some h/w isn't playing nice at low utilisation? A voltage is too low somewhere. Scorptec have been good - saying just drop it in to use (1km away) and its under warranty - we will replace whatever maybe broken - first guy wondered memory or CPU - not cheap fixes. I did run System restore - memtest - Chkdsk - all fine. Will try options suggested above - given PC is stable enough. Thanks all!
  13. g__day

    Windows10 BSOD WHEA

    Will do mate. BTW - just played Serious Sam 3 for an hour or two - rock solid - which makes me wonder if its a registry error if its crashing in a browser or excel? The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {6B3B8D23-FA8D-40B9-8DBD-B950333E2C52} and APPID {4839DDB7-58C2-48F5-8283-E1D1807D0D7D} to the user NT AUTHORITY\LOCAL SERVICE SID (S-1-5-19) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool. The above error happen many times in the last 24 hours. The other error was: The computer has rebooted from a bugcheck. The bugcheck was: 0x00000124 (0x0000000000000000, 0xffff830d0cd75028, 0x00000000b2000000, 0x0000000000070005). A dump was saved in: C:\Windows\MEMORY.DMP. Report Id: 86634aa3-7259-4e7a-87ce-5e06da5d2039..
  14. Hi folks On my new big rig the PC now just randonly crashes - usually within 5-10 mins of booting with a WHEA unrecoverable error. I haven't been overclocking or using it hard - nor any changes put thru. ANy ideas how to fix this very persistent and annoying issue - system restore hasn't helped! Thanks, Matthew
  15. About 20 times faster than before - it was definitely CPU bound before :)
×