Geekzone: technology news, blogs, forums
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.

Filter this topic showing only the reply marked as answer View this topic in a long page with up to 500 replies per page Create new topic
1 | 2 | 3 | 4 

Affiliate link: Online price comparison made easy.
1610 posts

Uber Geek

Nurse (R)
Lifetime subscriber

  #2565982 16-Sep-2020 14:02
Send private message quote this post










Love it - go Tuffy 🐈 You have trained your slave well 😀



iMac 27" (late 2013), Airport Time Capsule 5th gen + Airport Express 1st gen, iPhone7, iPad6, iPad Mini5


Panasonic Blu-ray PVR DMR-BWT835 + Panasonic Viera TH-L50E6Z, Chromecast Ultra, Yamaha AVR RX-V1085

The difficult we can do immediately. The impossible takes a bit longer. But Miracles you will have to wait for.

1045 posts

Uber Geek


  #2565983 16-Sep-2020 14:06
Send private message quote this post



Thanks Excel!



I'll take "What is both my silver bullet and waking nightmare?" for 500, Alex.



BDFL - Memuneh
68498 posts

Uber Geek

Lifetime subscriber

  #2566016 16-Sep-2020 15:00
Send private message quote this post

I extracted the data before removing the avatars then used Excel formulas to create the copy back command and the query to update the users with the avatar filename. Very good for that.



These links are referral codes


Geekzone broadband switch | Eletricity comparison and switch | Hatch investment (NZ$ 10 bonus if NZ$100 deposited within 30 days) | Sharesies | Mighty Ape | Backblaze | Amazon | My technology disclosure

12783 posts

Uber Geek

Lifetime subscriber

  #2566121 16-Sep-2020 18:21
Send private message quote this post

Any flame posts yet demanding to know what the #$%@#&$ happened to my avatar?



I don't think there is ever a bad time to talk about how absurd war is, how old men make decisions and young people die. - George Clooney


2899 posts

Uber Geek

Lifetime subscriber

  #2566368 17-Sep-2020 00:23
Send private message quote this post


Please upload JPG or PNG. Webp won't work in all browsers.



Or pretty much anything else but browsers. It's a totally stupid idea that saves Google a few bytes to serve up but is a major PITA for anyone else when images are presented in a format that nothing can use. For Firefox at least there's a conversion extension, but you have to do it manually, there's no way to have it automatically save webp images as jpeg.

255 posts

Ultimate Geek

Lifetime subscriber

  #2566639 17-Sep-2020 09:46
Send private message quote this post



All old avatars are now reloaded - the new avatar system is in place and no loss of content at the end.


Thanks Excel!



Plus 1 for Excel


I find Excel one of my most useful tools to manipulate data, to see what will change before I run a script.

1 | 2 | 3 | 4 
Filter this topic showing only the reply marked as answer View this topic in a long page with up to 500 replies per page Create new topic

News »

Amazon introduces new Echo devices
Posted 25-Sep-2020 11:56

Mad Catz introduces new S.T.R.I.K.E. 13 Mechanical Gaming Keyboard
Posted 25-Sep-2020 11:34

Vodafone NZ upgrades international submarine network
Posted 25-Sep-2020 09:09

Jabra announces wireless noise-cancelling airbuds, upgrade existing model
Posted 24-Sep-2020 14:43

Nokia 3.4 to be available in New Zealand
Posted 24-Sep-2020 14:34

HP announces new HP ENVY laptops aimed at content creators
Posted 24-Sep-2020 14:02

Logitech introduce MX Anywhere 3
Posted 21-Sep-2020 21:17

Countdown unveils contactless shopping with new Scan&Go tech
Posted 21-Sep-2020 09:48

HP unveils new innovations for businesses adapting to rapidly evolving workstyles and workforces
Posted 17-Sep-2020 15:36

GoPro launches new HERO9 Black camera
Posted 17-Sep-2020 09:45

Telecommunications industry launches new 5G Facts website
Posted 17-Sep-2020 07:56

New Zealand ranks 3rd in world in GSMA index
Posted 15-Sep-2020 10:13

Trend Micro Security Suite adds web monitoring to prevent identity theft
Posted 14-Sep-2020 15:37

NVIDIA to acquire Arm for US$ 40 billion
Posted 14-Sep-2020 12:27

Epson launches its next gen A3+ colour EcoTank multi-function printer
Posted 10-Sep-2020 16:08

Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.

Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.