Office(R)Tool Project

Discussion in 'Microsoft Office' started by Dark Dinosaur, Nov 6, 2021.

?

Change brand name or not ?

Poll closed Dec 26, 2021.
  1. No, keep it like that

    148 vote(s)
    75.1%
  2. Yes, officeRTool need fresh name

    49 vote(s)
    24.9%
  1. mahdimahatma

    mahdimahatma MDL Novice

    Aug 6, 2019
    4
    0
    0
    Okay. here is upload.ee

    upload.ee/files/15155890/Untitle1d.png.html
     
  2. mahdimahatma

    mahdimahatma MDL Novice

    Aug 6, 2019
    4
    0
    0
    nevermind sorry. My broken keyboard selected Retail version which as the help page link says doesnt support 8.1. now it goes office is installing in the backgrond whaetever percent
     
  3. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    Update version ... again ... v4.3

    Update error handling when using XML files
    some XML settings can cause a never-ending loop

    And add a new check in the PS1 script,
    to verify Path & Name location, if LOCAL install is chosen
    [$LOCATION + $NAME + 'Office\Data' --> verify full path]
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    #1605 Dark Dinosaur, Apr 22, 2023
    Last edited: Apr 22, 2023
    (OP)
    am I drunk? need spelling fixes ......
    next month hope to fix all of this ...

    upload_2023-4-22_22-2-36.png

    the new output will be.

    Code:
    ID         = 1
    action     = Download Mode
    Name       = Pro Plus 2021 English Full Package
    Location   = c:\Users\Administrator\Desktop
    version    = 16.0.14332.20493
    Language   = en-us,he-il
    System     = Auto
    
    ID         = 2
    action     = Local Install Mode
    Name       = Pro_Plus_2021_English_Full_Package
    Location   = C:\Users\Administrator\Desktop
    version    = Auto
    channel    = Auto
    Products   = ProPlus2021
    Exclude    = Access,Outlook,Publisher,Skype,OneNote
    Type       = Full
    Language   = Auto
    
    ID         = 3
    action     = Online Install Mode
    Name       = Pro Plus 2021 English Full Package
    Location   = Online
    version    = Auto
    channel    = PerpetualVL2021
    Products   = ProPlus2021
    Exclude    = Access,Outlook,Publisher,Skype,OneNote
    Type       = Full
    Language   = en-us,he-il
    Lang. Pack = en-us,he-il
    Proof Pack = en-us,he-il
    
    
    Choice [ID:] from the list, [X] to Exit:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    #1606 Dark Dinosaur, Apr 22, 2023
    Last edited: Apr 23, 2023
    (OP)
    Going to try a new format.
    get rid of the Profiles folder
    something like this. way better.
    one file -> Settings Node ->
    Nodes for each config ... etc etc
    if you want to improve it more, you can suggest better ideas
    this will be the next version ... no more 1000x files

    Plan to do something even better
    Multiple config files
    With different configuration in each file
    Let's check how it will go ..

    upload_2023-4-22_23-52-9.png

    Code:
    
    <Settings>
    
      <Download_PRO_PLUS_2021
        name       = "Pro Plus 2021 English Full Package"
        action     = "1"
        version    = "Auto"
        channel    = "PerpetualVL2021"
        Location   = "c:\Users\Administrator\Desktop"
        Language   = "en-us,he-il"
        System     = "Auto"
     
        ver_OPT_1  = "Auto"
        ver_OPT_2  = "16.0.14332.20493"
      />
     
      <LOCAL_INSTAL_PRO_PLUS_2021
        name       = "Pro_Plus_2021_English_Full_Package"
        action     = "2"
        version    = "Auto"
        channel    = "Auto"
        Products   = "ProPlus2021"
        Exclude    = "Access,Outlook,Publisher,Skype,OneNote"
        P_Type     = "Full"
        Location   = "C:\Users\Administrator\Desktop"
        Language   = "Auto"
     
        Lang_OPT_1 = "Auto"
        Lang_OPT_2 = "En-us,ru-ru"
      />
     
      <ONLINE_INSTAL_PRO_PLUS_2021
        name       = "Pro Plus 2021 English Full Package"
        action     = "3"
        version    = "Auto"
        channel    = "PerpetualVL2021"
        Products   = "ProPlus2021"
        Exclude    = "Access,Outlook,Publisher,Skype,OneNote"
        P_Type     = "Full"
        Location   = "Online"
        Language   = "en-us,he-il"
        lang_pack  = "en-us,he-il"
        proof_tool = "en-us,he-il"
      />
     
    </Settings>
    
    .....................

    worked....

    Upload test-pack v2
    with multi profiles selection ....

    upload_2023-4-23_11-4-32.png
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    new test version update --> attached
    will support multi xml files with multi Actions
    if only 1 file, will continue as usual ...

    upload_2023-4-23_15-43-58.png

    upload_2023-4-23_15-42-24.png

    upload_2023-4-23_15-42-43.png
     

    Attached Files:

    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. Alfredo Troncoso

    Alfredo Troncoso MDL Novice

    Sep 12, 2012
    22
    4
    0
    Hello!

    Version 4.3 download AGAIN (overwrites) the folder "en-US_Office_Current_x64_v16.0.16227.20280", even if this folder has already been downloaded.
    Older versions of your great program just "see" that it has already been downloaded and let it pass.

    Thank you again!
     
  9. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    #1609 Dark Dinosaur, Apr 23, 2023
    Last edited: Apr 23, 2023
    (OP)

    Attached Files:

    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  10. Alfredo Troncoso

    Alfredo Troncoso MDL Novice

    Sep 12, 2012
    22
    4
    0
    I mean it re-download again every file, but your quick fix version 4.4 is working OK now!!!

    Thank You very much!!!
     

    Attached Files:

  11. DuskGolem

    DuskGolem MDL Junior Member

    Jan 9, 2019
    97
    30
    0
    @Dark Dinosaur a suggestion. Please, after the next stable release, work on an UPDATED HOW-TO (usage guide) for the tool. With so many features being added regularly, it is a bit tough to understand. Also, you not being good at english is another problem :p (no offence intended). The profile xmls need to be made more clear, by which I mean, some variables like ver_OPT_1 and Lang_OPT_1 are not explained or clear (took some hair pulling for me to understand). Do you really need "Lang_OPT_1" when you can write multiples languages in the "Language" field? Need clear explainations please.


    P.S: Take a break from adding new features. Don't want you to get overwhelmed and leave the development of this tool. Cheers.
     
  12. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    You (not specific .. you) asked for one click solution..
    So I add one .. I did want add such in the past
    Opt1 .. opt2 .. can be ignored
    Settings * children * you own settings
    Child name can be what ever you want .. don't care
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  13. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    update version .....
    I don't want to wait until May...
    And yes ... you can change the files
    Open XML file for example,
    Copy The nodes, Remove the nodes, etc
    you can make dozens of files
    one for downloads only, one for local install
    the sky is the limit.

    Action -> 1-2-3 [Define the Type of action. Local / Online / Download]

    upload_2023-4-24_20-24-50.png

    Code:
     <Download_Example
        name       = "Pro Plus 2021 English Full Package"
        action     = "1"
        version    = "Auto"
        channel    = "PerpetualVL2021"
        Location   = "c:\Users\Administrator\Desktop"
        Language   = "en-us,he-il"
        System     = "Auto"
      />
     
      <Local_Install_Example
        name       = "Pro_Plus_2021_English_Full_Package"
        action     = "2"
        version    = "Auto"
        channel    = "Auto"
        Products   = "ProPlus2021"
        Exclude    = "Access,Outlook,Publisher,Skype,OneNote"
        P_Type     = "Full"
        Location   = "C:\Users\Administrator\Desktop"
        Language   = "Auto"
      />
     
      <Online_Install_Example
        name       = "Pro Plus 2021 English Full Package"
        action     = "3"
        version    = "Auto"
        channel    = "PerpetualVL2021"
        Products   = "ProPlus2021"
        Exclude    = "Access,Outlook,Publisher,Skype,OneNote"
        P_Type     = "Full"
        Location   = "Online"
        Language   = "en-us,he-il"
        lang_pack  = "en-us,he-il"
        proof_tool = "en-us,he-il"
      />
    
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  14. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    #1614 Dark Dinosaur, Apr 24, 2023
    Last edited: Apr 24, 2023
    (OP)
    Currently testing another option ...
    how is it possibly done? it will handle in PowerShell level
    trying to avoid using 1,2,3,4,5,6,7,8 ... | Foreach ... -Replace ...
    so trying to use regex ... hope it faster

    The test pack attached to this post contains:
    an updated xml_PARSER file, and new XML files

    `Location = "%USERPROFILE%\Desktop"`
    its mean `USER` -> Desktop

    Code:
      $pattern = "(%)(ALLUSERSPROFILE|APPDATA|CommonProgramFiles|CommonProgramFiles(x86)|CommonProgramW6432|HOMEDRIVE|USERPROFILE|"+
      "HOMEPATH|LOCALAPPDATA|TEMP|SystemDrive|SystemRoot|PUBLIC|ProgramData|ProgramFiles|ProgramFiles(x86)|ProgramW6432|UserName)(%)"
    
      $regex = [Regex]::Matches($location, $pattern,[Text.RegularExpressions.RegexOptions]::IgnoreCase)
      $regex| % { $location = [Regex]::Replace($location,$_.Value,[Environment]::GetEnvironmentVariable($_.Value.Split('%')[1])) }
    
    upload_2023-4-24_22-55-6.png
     

    Attached Files:

    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  15. SingelDigit

    SingelDigit MDL Novice

    Jun 5, 2017
    1
    0
    0
    Might be a good idea to update the included binaries? For example, 7zip, UnRAR, upx32, etc...
     
  16. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    maybe you're right ... will check it
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  17. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    #1618 Dark Dinosaur, Apr 30, 2023
    Last edited: Apr 30, 2023
    (OP)
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  18. amorshc

    amorshc MDL Novice

    Aug 22, 2015
    2
    0
    0
    It was a brand new install of Windows 10 (22H2, OS Build 19045.2846, Windows Feature Experience Pack 120.2212.4190.0).

    I'll try the recommended above :)

    Update: It worked great! I forgot I needed to run IE for it's first instance, so once that was completed it worked flawlessly. Since IE is officially retired, I assume there will be a different method that will not require IE to launch in the future?

    Thanks for the excellent support on this!
     
  19. Dark Dinosaur

    Dark Dinosaur X Æ A-12

    Feb 2, 2011
    4,169
    5,978
    150
    Run ie ? Weird. ( Interesting .. accept menu ? )
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...