Automate the UOAM map file for UOR houses

Discussion in 'Renaissance Discussion' started by Quick, Apr 2, 2018.

  1. Quick

    Quick Member
    UO:R Subscriber

    Joined:
    Jan 6, 2018
    Messages:
    16
    Likes Received:
    31
    I saw this thread and wanted to simplify the process so I didn't A) have to do anything manually and B) have to use a spreadsheet. No one has time for all that. Instead, I just created a simple Powershell script that will automate this whole process. What does it do?

    Download: https://github.com/markdwags/uorhousepositions

    The README includes instructions for how to run it manually and how to setup it up to automatically run every day do you don't have to do a single thing.

    If you have any issues or questions, feel free to post something here or send me a message on IRC.
    Fin, Rad, Melochabre and 6 others like this.
  2. Twister

    Twister Active Member
    UO:R Subscriber

    Joined:
    Nov 26, 2017
    Messages:
    324
    Likes Received:
    138
    Wow nice! Is this house.txt file updated automatically on the server? Do you know how frequently?
  3. Quick

    Quick Member
    UO:R Subscriber

    Joined:
    Jan 6, 2018
    Messages:
    16
    Likes Received:
    31
    The file is updated once a day, depending when the server was rebooted.
    Last edited: Apr 2, 2018
    Twister likes this.
  4. Ahirman

    Ahirman Well-Known Member
    UO:R Subscriber

    Joined:
    Mar 20, 2015
    Messages:
    813
    Likes Received:
    704
    Finally got it working and loaded in my task scheduler, Thanks!! :D
    Quick likes this.
  5. Quick

    Quick Member
    UO:R Subscriber

    Joined:
    Jan 6, 2018
    Messages:
    16
    Likes Received:
    31
    Cool, let me know if you had any issues that I could either fix in the script or update the README to help the next person.
  6. Erlkonig

    Erlkonig Well-Known Member
    UO:R Subscriber

    Joined:
    Jun 14, 2015
    Messages:
    1,076
    Likes Received:
    1,104
    First time running PS and it asked about execution polcies, I just said "no." Ended up having to change to unrestricted to get this to work.

    Set-ExecutionPolicy -ExecutionPolicy unrestricted
    Set-ExecutionPolicy unrestricted -Scope CurrentUser

    Also threw up a bunch of errors on compile but the result looks good.

    upload_2018-4-2_18-8-20.png

    I had the idea to do this when I created the original spreadsheet but never wanted to learn how. Looks simple enough.

    && For anyone wondering, script looks legit, nothing to worry about.
  7. Quick

    Quick Member
    UO:R Subscriber

    Joined:
    Jan 6, 2018
    Messages:
    16
    Likes Received:
    31
    @Erlkonig looks like when you copy/pasted the script (assuming you did..?), you may have missed the top <# at the top -- all those errors look like it was trying to execute the text header which of course won't run.
  8. Erlkonig

    Erlkonig Well-Known Member
    UO:R Subscriber

    Joined:
    Jun 14, 2015
    Messages:
    1,076
    Likes Received:
    1,104
    fixed, not sure how I deleted that bit, I downloaded it as package from the GitHub.... tyty
    Quick likes this.
  9. Ahirman

    Ahirman Well-Known Member
    UO:R Subscriber

    Joined:
    Mar 20, 2015
    Messages:
    813
    Likes Received:
    704
    I had to unblock it using Unblock-File cmdlet instead of changing my execution policy. After I did that everything worked great.
  10. RIN

    RIN Well-Known Member
    UO:R Donor

    Joined:
    Jan 4, 2017
    Messages:
    833
    Likes Received:
    731
    Is there a way to make this work with windows xp?
  11. Erlkonig

    Erlkonig Well-Known Member
    UO:R Subscriber

    Joined:
    Jun 14, 2015
    Messages:
    1,076
    Likes Received:
    1,104
  12. Quick

    Quick Member
    UO:R Subscriber

    Joined:
    Jan 6, 2018
    Messages:
    16
    Likes Received:
    31
    @RIN -- I would be surprised if this worked on Windows XP, since XP doesn't support the later versions of Powershell which this uses.

    I'll come up with an alternative solution (probably use AWS Lambda with S3 to host it) and let you know here.
  13. RIN

    RIN Well-Known Member
    UO:R Donor

    Joined:
    Jan 4, 2017
    Messages:
    833
    Likes Received:
    731
    Thanks Erl. Looked through that link and it seems this PowerShell 1.0 was designed for XP. The link from that page was dead but a quick search found this:

    https://support.microsoft.com/en-us...glish-language-installation-packages-for-wind

    When I get home from work I will look into it. It might actually work. I sure hope it does as I really would like to have all the houses in my UOAM.

    I appreciate the effort @Quick ! I will see if I can get the above 1.0 to work tonight and let you know what happens. Running XP in a virtual machine on my Windows 10 computer has made UO much more stable, but as we can see there are some drawbacks :)
  14. Ahirman

    Ahirman Well-Known Member
    UO:R Subscriber

    Joined:
    Mar 20, 2015
    Messages:
    813
    Likes Received:
    704
    Wow, I can't understand how that's possible. :confused:
  15. Quick

    Quick Member
    UO:R Subscriber

    Joined:
    Jan 6, 2018
    Messages:
    16
    Likes Received:
    31
    You'd be surprised how easy this is to do. If you have Windows 10 Pro, you can use the built-in virtualization. If you're on something else, you can download something like VirtualBox to do the same thing.

    Personally, I have no issues running UO on Windows 10.
    Ahirman likes this.
  16. RIN

    RIN Well-Known Member
    UO:R Donor

    Joined:
    Jan 4, 2017
    Messages:
    833
    Likes Received:
    731
    I use Oracle Virtualbox and it works quite well.

    I initially had UO running just fine on Windows 10 but was getting constant drops from the server. So I thought it was Windows 10. It ended up being my router and how it has both a 2.4G and 5G wifi. The 2.4G I was using ended up being kinda wonky and I think the combo modem/router from my ISP is slightly broken. But since switching to 5G and doing periodic restarts, I've eliminated my drops.
    Ahirman likes this.
  17. Ahirman

    Ahirman Well-Known Member
    UO:R Subscriber

    Joined:
    Mar 20, 2015
    Messages:
    813
    Likes Received:
    704
    I run mine on win 10 in compatibility mode winxp sp3 and I've never had any issues. Just seems like a VM is a lot more work. :D
    RIN likes this.
  18. Althorn

    Althorn Well-Known Member

    Joined:
    Mar 5, 2017
    Messages:
    825
    Likes Received:
    604
  19. Smash

    Smash Well-Known Member

    Joined:
    Jan 25, 2017
    Messages:
    1,088
    Likes Received:
    709
    thanks home slice

Share This Page