Given a shared Dropbox link to an Excel file, how can I easily open it in Google Sheets?

Scenario:

I get an email every two weeks with a vendor’s price list as a link to an Excel file in their Dropbox.

At this point, I have to:

  • open the link — This takes me to Dropbox, where the file is opened in a preview mode that is not compatible with cut and paste into a spreadsheet.
  • download the file to my computer — I have a choice to download to my computer or copy to my Dropbox.
  • upload the file to my Google Drive — To do this I go to any open Google app tab, click New, Upload, grovel through the file structure to find it.
  • from there I can open it with Google Sheets.
  • copy 6 columns of data out of the sheet, and
  • dispose of the file.

What I would like to do in Google Sheets is to open the file directly as a read-only file and save a bunch of steps.

My personal account is on Gmail. I use the web interface.

Is there a way to easily open this link directly as a sheet?

Why I can open reddit in chrome but not in firefox?

Instead I got this

enter image description here

Basically, Firefox complains that reddit have a certificate for firstmedia.com

firstmedia.com is my ISP. In Indonesia, ISP are required to block bad sites and reddit is one of the site blocked.

They do so by poisoning DNS or something. By changing the DNS I usually can access reddit.

However, for some reason, firefox still think that reddit uses firsmedia.com’s certificate.

Chrome doesn’t.

Why?

And what should I do to be able to open reddit in firefox.

Must click repeatedly in weka GUI to open dialogs, etc

In weka 3.8.3 GUI, Oracle’s Java 1.8. on 2 different windows 10 PC’s and a MacBook, single double and right clicks seem to frequently get lost. I have to repeat mouse actions till eventually the program responds. The program responds quickly in general. Don’t have issues with other programs on these devices, but haven’t tested other large jvm apps. Suggestions?

Open Engineer Mode and run other hidden codes on Moto G 3rd generation device?

I’m running LineageOS ROM on my Moto G 3rd generation smartphone and recently I wanted to run some hidden codes of Android like *#06# for IMEI and so on.
However, none of this ones works correctly on my phone:

  1. Phone information
    *#*#4636#*#*

  2. IMEI Info
    *#06#

  3. Calendar
    *#*#225#*#*

  4. Debug info for Google Play Service
    *#*#426#*#*

  5. Access Google Partner Setup
    *#*#759#*#*

  6. Engineering Mode
    *#*#2486#*#*

The IMEI closes the dealer/phone app, while the engineer/service mode codes (the one in which I’m more interested) don’t activate anything. Let’s say that the dealer interprets correctly the code but doesn’t run this tasks.

So knowing this, I would like to know if there is a way of looking if the relative services are on my phone? If it isn’t the case, how I can add them or run from PC with USB maybe? Are the secret codes dependent on the ROM like I imagine or not?

Notes:

I tried hidden codes of other manufacturers like Samsung, HTC, … too but no result obviously.

[ Etiquette ] Open Question : Poll, yes or no it is your responsibility as an adult to pay your bills on time?

Seems kind of common sense, but the longer I work with the public, the more I realize it isn’t so common sense to a lot of people. Right now I work in insurance and…yes…you do have to pay to insure your car, house, business, etc. It’s not free. We all know this. I have clients who have had their insurance for months, even years, that forget to make a payment but somehow make it OUR problem and throw a fit if their policy has a late fee, cancel notice, or worse completely cancels due to non-pay. They’ll use every excuse in the book. “I didn’t get my bill in the mail so I didn’t pay” is always my favorite You should still know about when your bills are due. I pay around a dozen bills a month, I know when they are due. And if I am late…guess what? That’s MY problem. Not the company’s problem. Even if I didn’t get a bill. Even if I thought I already paid and turns out I didn’t. So, am I nuts here in assuming as adults we alone are responsible for paying our bills on time? Yes? No? Why is this such a complicated concept to some? **Obviously this doesn’t count for people who have had a situation they absolutely cannot help. I.e. in the hospital or family member death or illness. We always do our best to accommodate for those situations. But interesting enough, those are the people who actually don’t get upset at us. Go figure. Also, for those of you who have been in this boat of grown *** adults getting mad at you or your company for penalties of being late, I am curious to hear your stories. 🙂 Actually, to the anonymous answer, you have a point. But I have been in that predicament. Especially with credit cards because they’re not as important as food, gas, rent, electric…BUT I do not get mad at the company for my negligence. At the end of the day if I am going to own a car insurance is part of the deal.

Unable to open jupyterlab on Google compute notebook instance

I am unable to access Jupyterlab for a couple of days now using the AI Platform > Notebook instances > Open Jupyterlab. I used the + New Instance option and launched a Tensorflow machine but when I click on the Open Jupyterlab button, it only gives me

504. That’s an error.  That’s all we know. 

I have tried downgrading the notebook version and restarting service as suggested here.

sudo pip3 install notebook==5.7.5 sudo service jupyter restart 

This brings me to the familiar Jupyterlab screen but then does not persist (I mean when I log back in to the instance, Jupyterlab still throws up the same error).

Is this a bug in Jupyterlab? Any solution?

Can open LUKS encyrpted partition but not scan volume groups

I am attempting to restore GRUB to my SSD after accidentally over-writing it by installing a Linux OS to another disk (not the same SSD). To attempt the grub repair, I’m using a Live version of the OS distribution from a USB stick.

Once inside the live distribution, I can see the disk where my OS installation and original GRUB reside:

Disk /dev/sda: 232.9 GiB, 250059350016 bytes, 488397168 sectors Units: sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disklabel type: gpt Disk identifier: 0A88BA3C-EF26-4291-AD41-EF9331042E6D  Device        Start       End   Sectors   Size Type /dev/sda1        40    409639    409600   200M EFI System /dev/sda2    409640  23845871  23436232  11.2G Apple HFS/HFS+ /dev/sda3  23846912  24319999    473088   231M Linux filesystem /dev/sda4  24320000 488396799 464076800 221.3G Linux filesystem 

/dev/sda1 is the EFI partition that contains EFI configuration for both MacOS and my linux distribution. /dev/sda2 is a MacOS installation and is of no relevance to the issue here. /dev/sda3 contains efi and grub information:

-rw-r--r-- 1 root root   186567 May  7  2018 config-4.9.0-6-amd64 drwxr-xr-x 2 root root     1024 Jun 16  2018 efi drwxr-xr-x 5 root root     1024 Apr 18 23:12 grub -rw-r--r-- 1 root root 28489619 Feb 23 15:59 initrd.img-4.9.0-6-amd64 drwx------ 2 root root    12288 Jun 16  2018 lost+found -rw-r--r-- 1 root root  3190138 May  7  2018 System.map-4.9.0-6-amd64 -rw-r--r-- 1 root root  4224800 May  7  2018 vmlinuz-4.9.0-6-amd64 

/dev/sda4 is the encrypted partition with user data.

I used the following guides as a reference:

https://ubuntuforums.org/showthread.php?t=2266650

https://stephentanner.com/restoring-grub-for-an-encrypted-lvm.html

https://blog.sleeplessbeastie.eu/2015/11/16/how-to-mount-encrypted-lvm-logical-volume/

I can open the encrypted partition:

$   cryptsetup luksOpen /dev/sda4 sda4_crypt Enter passphrase for /dev/sda4: $    

I enter the password and the encrypted drive is automatically mounted to /media/user/475cac44-f48a-4d17-8659-611a06e1f961.

However, when I attempt to scan for volume groups:

$   vgscan Reading all physical volumes. This may take a while… $    
$   vgdisplay $    

nothing is returned.

The same occurs when attempting to scan for logical volumes:

$   sudo lvscan $    

I can see the contents of the mounted, encrypted partition: $ ls -la /media/user/475cac44-f48a-4d17-8659-611a06e1f961/

total 112 drwxr-xr-x   22 root root  4096 Jul  4  2018 . drwxr-x---+   4 root root    80 Apr 18 08:57 .. drwxr-xr-x    2 root root  4096 Mar  9 17:16 bin drwxr-xr-x    2 root root  4096 Jun 16  2018 boot drwxr-xr-x    5 root root  4096 Feb 20 20:46 dev drwxr-xr-x  131 root root 12288 Apr 17 08:23 etc drwxr-xr-x    3 root root  4096 Jun 16  2018 home lrwxrwxrwx    1 root root    29 Jun 16  2018 initrd.img -> boot/initrd.img-4.9.0-6-amd64 lrwxrwxrwx    1 root root    29 Jun 16  2018 initrd.img.old -> boot/initrd.img-4.9.0-6-amd64 drwxr-xr-x   18 root root  4096 Apr 13 12:20 lib drwxr-xr-x    2 root root  4096 Jun 16  2018 lib64 drwx------    2 root root 16384 Jun 16  2018 lost+found drwxr-xr-x    4 root root  4096 Apr 17 08:23 media drwxr-xr-x    6 root root  4096 Nov 25 14:41 mnt drwxr-xr-x    4 root root  4096 Sep  8  2018 opt drwxr-xr-x    2 root root  4096 Feb 23  2018 proc drwx------   12 root root  4096 Apr 17 01:35 root drwxr-xr-x    3 root root  4096 Feb 20 20:46 run drwxr-xr-x    2 root root 12288 Apr 17 03:30 sbin drwxr-xr-x    2 root root  4096 Apr 28  2018 srv drwxr-xr-x    2 root root  4096 Feb 23  2018 sys drwxrwxrwt    8 root root  4096 Apr 17 08:23 tmp drwxr-xr-x   10 root root  4096 Jun 16  2018 usr drwxr-xr-x   11 root root  4096 Jun 16  2018 var lrwxrwxrwx    1 root root    26 Jun 16  2018 vmlinuz -> boot/vmlinuz-4.9.0-6-amd64 lrwxrwxrwx    1 root root    26 Jun 16  2018 vmlinuz.old -> boot/vmlinuz-4.9.0-6-amd64 

But without seeing/knowing the volume group, how can I mount the correct directories in order to repair grub?

Why does Chrome randomly open my Gmail on a new tab?

I have my Chrome set up to open on the New Tab page but whenever I open Chrome it also opens my Gmail on another tab. It also randomly opens it whenever I’m on.

It doesn’t do it when it’s closed, so that’s good but yeah. It’s kind of annoying.

I know that I’m signed in and connected to Google with my account. Does it have anything to do with syncing? If so, will turning off the sync stop it from opening my Gmail?