How to use zsh in flatpak vscode

2022-04-07T08:30:55Z

I have Visual Studio Code installed in flatpak, I run it with:

flatpak run --command=sh com.visualstudio.code

I want to change the shell to zsh, but I can't find how to, I tried multiple thing in my settings.json:

...
"terminal.integrated.shell.linux": "/usr/bin/flatpak-spawn",
"terminal.integrated.shellArgs.linux": ["--host", "run", "env", "TERM=xterm-256color", "zsh"],
...

And

"terminal.integrated.profiles.linux": {
    "bash": {
        "path": "/usr/bin/flatpak-spawn",
        "args": ["--host", "--env=TERM=xterm-256color", "zsh"]
    }
}

None works.

How to modify Notion CSS on browser? I have the pieces, but need help putting them together

2022-04-07T08:23:47Z

I would like to modify Notion's CSS on Brave/Chrome browser so that it would show guidelines for indented text (and potentially more, if I can get that working).

Basically what I would want is similar to the image here, which also shows some CSS code to make it work: https://www.notion.so/Relationship-lines-for-bullet-points-a1040d8fa7d5439b8cf72358c83e9eba

I have also tried to follow this guide on how to modify the CSS on a site, by using the extension Stylus: https://www.reddit.com/r/Notion/comments/q0esqu/how_to_customise_notions_css/

I have tried copying that CSS from the first link into Stylus, but it doesn't seem to work. I don't know how to modify it to make it work though, unfortunately. Yet I think the ingredients should be all there if someone has enough expertise to piece them together. Can you help me make it work?

VMWare VM does not see a Shared Folder

2022-04-07T08:05:48Z

My OS Windows, I have VMWare and VM with Ubuntu 21.10 inside.

All works fine. But I'd like to have a Shared folder to exchange files. I have created in Windows the folder: SharedUFolder.

Then go to VM Settings->Options: Shared Folders: Enabled (Always) , then Add and added Windows SharedUFolder. Ok. How to access this Shared folder in Ubuntu? I do not find it.

Removing enterprise enrollment from chromebook [duplicate]

2022-04-07T07:32:28Z

I recently moved and my school said I would keep my Chromebook. The only problem is that they left the enterprise enrollment on. They told me to remove it, but I didn't manage. I have an Acer cb5 312t. I have already tried this. I have done it twice and I unplugged the battery connector and even the entire battery. It still wouldn't work. I even had it without the batter for over an hour. Is there some screw or something I am missing? Is there maybe a CMOS battery of sorts I have to remove or something? Please help me! I know I can replace the SSD, but I don't wanna invest SSD money into it. Another thing is that it has a take-home policy of sorts which allows it to unblock during non-school hours, but I have moved timezones so it doesn't work well. Any help would be apreciated!

Make sure your Chromebook is off.

Unscrew your Chromebook back cover.

Unscrew the battery and unplug the power cord connecting the battery and the motherboard.

Open your Chromebook and press the power button for 30 seconds. This should bypass the admin block.

Place the battery back in and connect the power cords. Put the back cover on.

Turn your Chromebook on and press esc + refresh + power It may take 9-15 minutes to boot based on your device. Do not follow this step until you reach the chrome screen.

When you reach the "Chrome Os is missing or damaged" screen press Ctrl + d.

How to upload a local map into PowerBI

2022-04-07T07:26:58Z

I am trying to load a custom map (svg) into Power BI and the local map button doesn't do anything. Is there a setting that enables this or is it blocked by some company policy?

threejs autocompletion on nvim

2022-04-07T07:26:39Z

i want autocompletions for three.js in nvim , kind of like the autocompletions we get if we open three.js file on a split window on vim [still not good], i searched in coc language plugins list, i cant find a plugin which satisfy my needs.
like,

image1

:spl path/to/three.js
^W ↓
i

image2

this is just recommending random words from the file on the other window,
but what i need is sord of like,

THREE.|
      [Scene]
      [PerspectiveCamera]
      [WebGLRenderer]
      [Mesh]

sorry for not putting the images, because i cant [im a new user on superuser]

i posted this same question on stackoverflow with images

since, that is the place for development and programming language related questions and i believe this is a place for Linux and Linux commands/software related doubts and questions

Internet Explorer Mode in Microsoft Edge in Windows 11

2022-04-07T07:13:35Z

Some of our applications heavily depend on the ActiveX controls. As Microsoft discontinued support for Internet Explorer, we give a try for Microsoft Edge.

Solution 1 : Using Microsoft Edge -> Settings -> Default browser

This method works fine. But the added links will expire within 30 days. I have about 25 links, so every month I have to re-add ( the expiry can be adjusted to 90 days)

Solution 2 : Using Enterprise Site List configured in Group Policy

We have tried as in the below link but it is not working. We also tried in a standalone PC which is not connected to our domain.

https://docs.microsoft.com/en-us/deployedge/edge-ie-mode-policies

After trying Solution 2 and could not succeed we have reverted all the adjustment done. But now the solution 1 itself is not working. After adding the link to "Internet Explorer mode pages" and restarting the Edge browser, the link is cleared.

So what is the best option to use Internet Explorer in Microsoft Edge in Windows 11.

Why has my phone started charging slowly from my laptop's USB port?

2022-04-07T06:56:45Z

I understand that not all USB ports are created with power delivery in mind, and therefore some charge devices slower than others. What confuses me is the change in behavior. I swear around two years ago I could charge my phone at a reasonable speed from my laptop (around 3 hours maybe?). However, recently, it takes over five hours if I'm not using my phone at all simultaniously. Could there be some sort of USB driver that was updated and broke quicker charging?

Laptop: MSI GS63
Phone: Galaxy S8

Windows Search bar fills background with black color

2022-04-07T06:38:22Z

Today I launched my laptop, and when I hit the 3-finger gesture to open the search box, it blacked out the whole screen and then popped in the left part of my screen, taking more space than usual. It seemed weird to me, so I restarted. After restart, the problem seems to have gone, but not completely. Now I was able to capture a little bit of it. Once I again use a 3-finger gesture to pop up the search menu, it first fills up the space needed with black colour and then proceeds to animate. Here is a screenshot: Screenshot

As you can see here, gray background is filling up blank black space. Is there something wrong with my pc or just random bug of windows? My laptop is pretty fresh so I wouldn't like to allow any kind of virus or something into it.

EDIT

Oh okay, I got first case after restarting explorer first case screenshot

How to edit legends of a chart from cell range

2022-04-07T05:55:59Z

I have a list of legends and plot data in separate file. When I plot the data it creates legends as series1, series2, and so on. Now I want to replace the legends from cell list in other file. I can do that one by one from select data. But is there any way to replace all at once.

Chart from data Legend list

Please assist if possible for a file /folder issue

2022-04-07T05:54:45Z

I have a problem with a folder. I transferred it from a drive in order to zip it then archive it, How ever once I zipped the folder, and transferred the zipped contents back. I went to delete the unzipped counterpart of the folder. (I have attached a photo of the folder) but it says windows cannot locate the files/folder, there are no files left in the folder though, just remnants of the folder structure, but it simply wont go away, I really don't want to reformat the drive in order to get to it, because that would mean purchasing a drive to transfer the other data over. is there any way to get rid of this, I have tried numerous powershell, and cmd commands but its just persistent. I have scanned the folder but the comodo AV says it cannot locate the file/folders. I have tried a free file deleter but that didnt work (didnt think it would but you never know) I'm at a loss.

calling a flow from a function Twilio

2022-04-07T05:54:23Z

I have a simple flow that posts incoming sms messages to slack. I also have a function that allows me to send SMS messages and receive them. (I.E if the sms is from MY_NUMBER and the message starts with +12121212: then it will send the message to +12121212. If the message is not from MY_NUMBER it will forward the sms to MY_NUMBER)

I would like the function to trigger a flow instead of forwarding a message to MY_NUMBER

I would like to trigger my flow after the function has run:

e.g

exports.handler = function(context, event, callback) {
    const MY_NUMBER = '+0000000000000';
         
    let twiml = new Twilio.twiml.MessagingResponse();
    if (event.From === MY_NUMBER) {
        const separatorPosition = event.Body.indexOf(':');
        if (separatorPosition < 1) {
            twiml.message('You need to specify a recipient number and a ":" before the message.');
        } else {
            const recipientNumber = event.Body.substr(0, separatorPosition).trim();
            const messageBody = event.Body.substr(separatorPosition + 1).trim();
            twiml.message({ to: recipientNumber }, messageBody);
        }
    } else {  ***MY FLOW SHOULD BE TRIGGERED HERE***
      // the above line should replace  `twiml.message({ to: MY_NUMBER }, `${event.From}: ${event.Body}`);`    
    }
    callback(null, twiml);
};

Excel cell becomes input or output depending on another cell

2022-04-07T05:22:49Z

I have a situation where depending if cell C5 is BUY or SELL, cell D14 respectively shows the outcome of a formula or I have to input a number. How can simply achieve it hopefully with programming?

How do I convert an Excel calculation into a spilled dynamic array

2022-04-07T05:10:19Z

I'm not even sure how to ask what I'm looking for, without describing the full question.

if I have this table (CSV form at the bottom if anyone wants it):

      A             B         C              D             E             F            G            H            I          J
| Date Performed | Hours | Pay Date    | Pay Period  | Pay Type   | Verification | Period 1 | Pay Type     | Period 2 | Pay Type
| 1-Oct-2021     | 1.5   | 24-Sep-2022 | 1           | base pay   | 1-May-2022   | 4.0      | base pay     | 4.0      | base pay
| 29-Oct-2021    | 1.5   | 24-Sep-2022 | 1           | retirement | 2-May-2022   | 2.5      | base pay     |          |
| 29-Nov-2021    | 1.5   | 24-Sep-2022 | 2           | retirement | 19-May-2022  | 4.0      | base pay     | 4.0      | base pay
| 23-Dec-2021    | 1     | 24-Sep-2022 | 1           | retirement | 22-Sep-2022  |          |              | 2.5      | retirement
| 23-Dec-2021    | 2     | 24-Sep-2022 | 2           | retirement | 23-Sep-2022  | 4.0      | retirement   | 4.0      | retirement
| 27-Jan-2022    | 0.5   | 24-Sep-2022 | 2           | retirement | 24-Sep-2022  | 4.0      | inconsistent | 4.0      | retirement
| 2-Feb-2022     | 0.5   | 23-Sep-2022 | 1           | retirement | 25-Sep-2022  |          |              | 4.0      | retirement
| 22-Feb-2022    | 2     | 23-Sep-2022 | 1           | retirement
| 27-Feb-2022    | 2.5   | 23-Sep-2022 | 2           | retirement
| 28-Feb-2022    | 0.5   | 23-Sep-2022 | 2           | retirement
| 2-Mar-2022     | 0.5   | 23-Sep-2022 | 1           | retirement
| 3-Mar-2022     | 1     | 23-Sep-2022 | 1           | retirement
| 4-Mar-2022     | 0.5   | 25-Sep-2022 | 2           | retirement
| 6-Mar-2022     | 1     | 23-Sep-2022 | 2           | retirement
| 6-Mar-2022     | 2     | 1-May-2022  | 1           | base pay
| 7-Mar-2022     | 2     | 1-May-2022  | 1           | base pay
| 8-Mar-2022     | 0.5   | 2-May-2022  | 1           | base pay
| 8-Mar-2022     | 1.5   | 25-Sep-2022 | 2           | retirement
| 9-Mar-2022     | 1     | 22-Sep-2022 | 2           | retirement
| 10-Mar-2022    | 1     | 1-May-2022  | 2           | base pay
| 13-Mar-2022    | 1.5   | 1-May-2022  | 2           | base pay
| 14-Mar-2022    | 1.5   | 1-May-2022  | 2           | base pay
| 15-Mar-2022    | 1     | 2-May-2022  | 1           | base pay
| 17-Mar-2022    | 1     | 2-May-2022  | 1           | base pay
| 17-Mar-2022    | 2     | 25-Sep-2022 | 2           | retirement
| 18-Mar-2022    | 1     | 22-Sep-2022 | 2           | retirement
| 24-May-2022    | 0.5   | 22-Sep-2022 | 2           | retirement
| 19-May-2022    | 4     | 19-May-2022 | 1           | base pay
| 19-May-2022    | 4     | 19-May-2022 | 2           | base pay

F2: =SORT(UNIQUE(FILTER(C:C,ISNUMBER(C:C))))

G2: =LET(x,F2#,SUMIFS(B:B,C:C,x,D:D,1))

I2: =LET(x,F2#,SUMIFS(B:B,C:C,x,D:D,2))

One complete pay period is 4hr; there can be up to two pay periods in a day. But, if there are only a handful of hours used, they can be incrementally combined into another arbitrary day, and get paid-out when a pay period aggregates to 4hr.

I get get H2 to work as: =IF(--G2=0,"",LET(x,FILTER(E:E,(C:C=F2)*(D:D=1)),IF(AND(EXACT(x,@x)),@x,"inconsistent")))

Essentially it ensures that everything in a given pay date/pay period is funded from the same pool, either the base pay pool or the retirement pool.

I can copy/paste that just fine. But, is there a way H2 can be re-formulated to yield a dynamic spilled range the same length as F2# and G2#?

(In case anyone is curious, this is how US Military Reserve pay works, this is a tracker I'm using to make sure I'm being honest in what I'm claiming.)

CSV form of the above table:

Date Performed,Hours,Pay Date,Pay Period,Pay Type,,Verification,Period 1,Pay Type,Period 2,Pay Type
1-Oct-2021,1.5,24-Sep-2022,1,base pay,1-May-2022,4.0,base pay,4.0,base pay
29-Oct-2021,1.5,24-Sep-2022,1,retirement,2-May-2022,2.5,base pay,,
29-Nov-2021,1.5,24-Sep-2022,2,retirement,19-May-2022,4.0,base pay,4.0,base pay
23-Dec-2021,1,24-Sep-2022,1,retirement,22-Sep-2022,,,2.5,retirement
23-Dec-2021,2,24-Sep-2022,2,retirement,23-Sep-2022,4.0,retirement,4.0,retirement
27-Jan-2022,0.5,24-Sep-2022,2,retirement,24-Sep-2022,4.0,inconsistent,4.0,retirement
2-Feb-2022,0.5,23-Sep-2022,1,retirement,25-Sep-2022,,,4.0,retirement
22-Feb-2022,2,23-Sep-2022,1,retirement,,,,,
27-Feb-2022,2.5,23-Sep-2022,2,retirement,,,,,
28-Feb-2022,0.5,23-Sep-2022,2,retirement,,,,,
2-Mar-2022,0.5,23-Sep-2022,1,retirement,,,,,
3-Mar-2022,1,23-Sep-2022,1,retirement,,,,,
4-Mar-2022,0.5,25-Sep-2022,2,retirement,,,,,
6-Mar-2022,1,23-Sep-2022,2,retirement,,,,,
6-Mar-2022,2,1-May-2022,1,base pay,,,,,
7-Mar-2022,2,1-May-2022,1,base pay,,,,,
8-Mar-2022,0.5,2-May-2022,1,base pay,,,,,
8-Mar-2022,1.5,25-Sep-2022,2,retirement,,,,,
9-Mar-2022,1,22-Sep-2022,2,retirement,,,,,
10-Mar-2022,1,1-May-2022,2,base pay,,,,,
13-Mar-2022,1.5,1-May-2022,2,base pay,,,,,
14-Mar-2022,1.5,1-May-2022,2,base pay,,,,,
15-Mar-2022,1,2-May-2022,1,base pay,,,,,
17-Mar-2022,1,2-May-2022,1,base pay,,,,,
17-Mar-2022,2,25-Sep-2022,2,retirement,,,,,
18-Mar-2022,1,22-Sep-2022,2,retirement,,,,,
24-May-2022,0.5,22-Sep-2022,2,retirement,,,,,
19-May-2022,4,19-May-2022,1,base pay,,,,,
19-May-2022,4,19-May-2022,2,base pay,,,,,

Excel - Need formula help for project at work

2022-04-07T02:25:58Z

I am working on a project at work where I am pulling a report each week from one of our systems and pasting it into a "DATA" tab in a workbook.

There are then 6 other tabs that are specified by region - "Midwest", "Northeast", etc. The report I pull does not have the region located in the data, so I've contemplated creating another tab as a sort of look-up table, but I'm not sure how to connect all of this.

Basically, when I paste the report data into the DATA tab, I need formulas on the region tabs that will determine if the State is a member of that region and populates all of the rows and columns on the corresponding tab.

I'm posting a screenshot of what the DATA tab looks like (confidential information removed) and an example of what the region tab should like. Any help is greatly appreciated!

Example of DATA tab:

Example of what region tab should like:

Ffmpeg GPU encoding not speeding up processing

2022-04-06T18:39:29Z

ffmpeg -framerate 29.97 -hwaccel cuda -start_number 200000 -i %06d.tif -c:v libx264 -preset veryslow -tune film -profile:v high -pix_fmt yuv420p -level 4.1 -crf 17 -r 29.97 -threads 2 -frames:v 5000 ade-20000_202559_ArtemisHQ_tiff.mkv

I’m using the above command line to join together TIFF files that have been produced by a video enhance program, to produce a final video. I’m using a 2080ti GPU on Linux ver 20. Ffmpeg has been compiled using an online tutorial for Nvidia video encoding. My problem is that running the command with the -hwaccel cuda doesn’t increase the speed of processing much. I have used NVTOP to check that the GPU is being used. It shows 1% GPU and 200% CPU. Without the -hwaccel cuda NVTOP obviously doesn’t show any data.

Yes, it is to speed up the encoding. As the second answer says, maybe it can't be done because of the frequent read of files. I will still try the replacement with the nvenc command.

Thanks for all three prompt replies.

So I tried:

ffmpeg -framerate 29.97 -hwaccel cuda -start_number 200000 -i %06d.tif -c:v h264_nvenc -preset veryslow -tune film -profile:v high -pix_fmt yuv420p -level 4.1 -crf 17 -r 29.97 -threads 2 -frames:v 5000 ade-20000_202559_ArtemisHQ_tiff.mkv I got:

Codec AVOption crf (Select the quality for constant quality mode) specified for output file #0 (ade-20000_202559_ArtemisHQ_tiff.mkv) has not been used for any stream. The most likely reason is either wrong type (e.g. a video option with no video streams) or that it is a private option of some encoder which was not actually used for any stream. Codec AVOption tune (Tune the encoding to a specific scenario) specified for output file #0 (ade-20000_202559_ArtemisHQ_tiff.mkv) has not been used for any stream. The most likely reason is either wrong type (e.g. a video option with no video streams) or that it is a private option of some encoder which was not actually used for any stream. When the command ran I got:

[h264_nvenc @ 0x559577472b40] [Eval @ 0x7ffd3759cc40] Undefined constant or missing '(' in 'veryslow' [h264_nvenc @ 0x559577472b40] Unable to parse option value "veryslow" [h264_nvenc @ 0x559577472b40] Error setting option preset to value veryslow. Error initializing output stream 0:0 -- Error while opening encoder for output stream #0:0 - maybe incorrect parameters such as bit_rate, rate, width or height Conversion failed!

So I tried:

ffmpeg -framerate 29.97 -hwaccel cuda -start_number 200000 -i \%06d.tif  -c:v h264_nvenc -preset veryslow -tune film -profile:v high -pix_fmt yuv420p -level 4.1 -crf 17 -r 29.97 -threads 2 -frames:v 5000 ade-20000_202559_ArtemisHQ_tiff.mkv

I got:

Codec AVOption crf (Select the quality for constant quality mode) specified for output file #0 (ade-20000_202559_ArtemisHQ_tiff.mkv) has not been used for any stream. The most likely reason is either wrong type (e.g. a video option with no video streams) or that it is a private option of some encoder which was not actually used for any stream.
Codec AVOption tune (Tune the encoding to a specific scenario) specified for output file #0 (ade-20000_202559_ArtemisHQ_tiff.mkv) has not been used for any stream. The most likely reason is either wrong type (e.g. a video option with no video streams) or that it is a private option of some encoder which was not actually used for any stream.

When the command ran I got:

[h264_nvenc @ 0x559577472b40] [Eval @ 0x7ffd3759cc40] Undefined constant or missing '(' in 'veryslow'
[h264_nvenc @ 0x559577472b40] Unable to parse option value "veryslow"
[h264_nvenc @ 0x559577472b40] Error setting option preset to value veryslow.
Error initializing output stream 0:0 -- Error while opening encoder for output stream #0:0 - maybe incorrect parameters such as bit_rate, rate, width or height
Conversion failed!

Could this be where I've placed the command? You'll probably guess that I am not good at Linux or ffmpeg.

How to delete all files (or the entire content of all files) with less than 250 words with Regex?

2022-04-06T15:12:08Z

Is it possible to delete all files (or the entire content of all files) with less than 250 words?

I try this regex, but needs to be improved a little bit. Can anyone help me?

Find: (?s)(.*?(\w+\s?){1,250}).*$
Replace with: (EMPTY)

Can not delete read-only file on mac

2022-04-06T07:56:10Z

I have a problem with the deletion read-only file, i have disabled csrutil, but it still problem.

How i can delete /usr/bin/ruby file ?

Add a IP to another rule matching hex in iptables linux

2022-04-05T18:24:53Z

iptables -t raw -A PREROUTING -p udp --dport 4578 -m string --hex-string '|fefffffffffffffffff77f12|'

How can I whitelist the IP having the above hexx string automatically on Iptables.

I'll be dropping all incoming traffic on iptables and allowing only the packet with above hex string. Whenever we receive a packet with above hex string the I want to whitelist his IP on Iptables immediately. So that all traffic from that particular IP gets passed

Thanks in Advance

How to get a running sum - floating above the cell

2022-04-05T06:58:35Z

I have a column of natural numbers (1, 2, 3...) and I want to know the sum up until a certain point without opening a new column that would calculate the sum.

Basically, I want to have a floating label, that pops whenever I hover on a cell, with a formula in it - where the formula is sum(A1:A<current_index>)

Is that possible? (I'm also fine with the having that data pop on the column's header instead)

I'm working in google sheets, so some of MSExcel functions won't be available I guess

How to restrict mouse and graphics tablet to primary monitor?

2021-01-17T12:13:44Z

I have a MacBook connected to a monitor as an extended display. I am using a wacom graphics tablet. I want to restrict the wacom to the primary display only and not move onto the secondary display.

The graphics tablet is small so using it across two display is difficult.

Can the same be done with a mouse?

Transparent windows in Windows 10 Pro over videos & color shift while browsing

2020-11-29T12:16:20Z

I recently bought a new MSI laptop and after installing windows 10 pro I am facing some issues with the screen. First of all, it goes to night mode (shifts color tune) when I am browsing the internet or any light-colored pages like Microsoft Word, it keeps getting warmer and lighter so often when scrolling or changing the window size.

Second, I have a transparency issue whenever I play a video on youtube or on windows, all the windows over the video become transparent and I can't figure out how to solve these issues.

I appreciate all your help.

My device is: MSI GE75 Raider 10SGS-444XES
Intel Core i7-10875H/32GB/1TB SSD/
RTX 2080 SUPER/17.3"/ 240Hz/ intel UHD Graphics
Windows 10 Pro

color-shift & nightmode problem - YouTube video

How to connect wsl to a windows localhost?

2020-03-24T03:48:59Z

I'm trying to let WSL use a localhost proxy(actually its Fiddler) on my windows, but I can't see any connection like that, and downloads usually fail, how do I fix that?

I know that I can connect to Linux localhost from the windows one, but how can I reverse this?

WSL is Ubuntu 18.04

Heroku Error: ENOENT: no such file or directory, stat '/app/client/build/index.html'

2019-04-04T21:31:38Z

App repo: https://github.com/calebkish/DevConnector

To preface, my web app has been pushed to Heroku.

I'm trying to successfully build my MERN web application onto Heroku, but when I visit my app page (https://safe-fortress-83003.herokuapp.com/), it just returns the error "Not Found" from the root GET response. When I view the logs for my Heroku app, this error displays when a root request is sent:

Error: ENOENT: no such file or directory, stat '/app/client/build/index.html'

So, I went into my local CLI and ran heroku run bash, viewed the current files and directories, and found that /app/client/build/ didn't exist. This leads me to believe that it isn't being generated using my heroku-postbuild script defined in my package.json (no idea why it isn't running when I git push heroku master). Out of desperation, I ran npm install && npm run build inside my client folder (where my react app is located), and now the build folder containing index.html is on my heroku app. When I try to view the app however, I still get an error of "Not Found".

I've been trying to debug this for hours, no idea what is wrong. The static files (build folder) are being defined inside server.js if you'd like to take a look.

EDIT: I just removed build from .gitignore and pushed to heroku, and my app works now. So the main problem is that my heroku-postbuild script isn't running even though the name is clearly defined in this documentation: https://devcenter.heroku.com/articles/nodejs-support

Auto confirm eject usb device using powershell command

2018-05-18T05:05:48Z

I have to use this PowerShell command to eject USB drive

$driveEject = New-Object -comObject Shell.Application
$driveEject.Namespace(17).ParseName("E:").InvokeVerb("Eject")

Whenever I do Windows always ask me to confirm, How can I get it to force eject or auto confirm using this command? I have explored some suggestions like here but none seem to work with this particular command.

Find unique or duplicate values between two worksheets

2017-02-28T22:40:02Z

I have multiple worksheets with the results from various searches on a database. I'd like to compare them to find any unique hits (or duplicates if that's easier). Each worksheet has the same column headings but the data in the rows may or may not be different and may be in a different order. For example, if Search1 finds ROGER and ROGER is on row 27, and I compare that with the result of Search2, which finds ROGER but puts him on row 6, I'd like a method that would know that row 6 and 27 are the same data even though the position is different.

Are there motherboards that support dual PSUs connections?

2015-10-09T15:15:20Z

I was thinking about how I would build myself a server with redundant power supplies.

Now they sell redundant PSU units, but they are proprietary. If one PSU in the unit fails and you want to replace it you have to buy a replacement PSU that unit supports.

Do they make motherboards that have two PSU connections- the idea being you plug any two PSU into the motherboard and when one fails the mobo will intelligently switch over to the other.

I couldn't find any that do this which makes me think there is something inherently bad/unrealistic about this idea.

Setting up a transparent proxy on Mac OS X

2013-11-10T18:46:12Z

I have a proxy running that I can successfully use with both Firefox and Safari. However flash is less amiable and from what I read it will not use a system proxy unless if cannot connect directly. Is there a way on Mac OS X to force everything through a proxy. That is only allow the proxy access to the outside internet?

Edit:

Ran route this is what I got and then all internet stopped working even with the proxy running

Mac:~ user$ sudo route flush
Password:
default              xx.xx.xx.xx        done
route: write to routing socket: No such process
got only -1 for rlen
Mac:~ user$ sudo route add 127.0.0.1
route: writing to routing socket: Invalid argument
add host 127.0.0.1: Invalid argument

Then I launch TCPCatcher and run it on port 8200 with monitor SSL enabled and Transparent Proxy unchecked.

I then set my Proxy in System Preferences to 127.0.0.1:8200

After that I set firefox to use the System Proxy

I then attempt to connect to a website and it fails.

Arch Linux booting with read only filesystems

2012-09-10T18:00:51Z

I installed Arch today and when I logged in I noticed that my filesystem is read only.

How can I fix this?

Sharing Template emails in public folders

2010-01-27T22:51:52Z

I have a template email I've created and saved on my local templates folder. How do I share my template so anyone on my domain can use it?

Recent Questions - Super User