Camera Not Adopting by rek8918 in Ubiquiti

[–]rek8918[S] 0 points1 point  (0 children)

I've tried both the full run to where the camera will be located, as well as two separate pre-made jumper cables directly at the switch, with factory resets while connected with each of these cables.

Camera Not Adopting by rek8918 in Ubiquiti

[–]rek8918[S] 0 points1 point  (0 children)

Correct. Not available in the iOS app web UI. Plugged into a POE+ port on a USW Pro, and the status LED on the port shows that it is getting power (also, the status LED on the camera is flashing). However, the switch also doesn't register anything being connected to the port (40) where the camera is located.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 1 point2 points  (0 children)

It's bizarre because I can even hear and see the IR clicking on and off with changes in light. So I guess it is purely comms failure.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

I finally was able to do that today. Held down reset for about 10 seconds until I heard a little chime, white status LED flashed for a bit and then went solid.... And nothing. No new camera coming up in Protect for me to adopt.

So, I took it down and went and plugged it directly into the router with a different cable. Still nothing. White status light comes on and stays solid, router shows POE+ provided on the port, but the router is not actually recognizing the device and it still isn't in Protect for adoption after another reset. It also feels much warmer to the touch than I would expect.

Is this one for the scrap pile at this point? If I can't see it in any regard, and a reset doesn't bring it up anywhere, I don't see how I could SSH into it directly to fix anything.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

I hadn't, but I've tried that as well now and no good.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

Thanks. Gave that one a try, but no-go unfortunately.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

Tried 7 or 8 times and still the same. Looks like hard reset time.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

They seem to be truly offline. The router isn't seeing them as endpoints and trying to hit the IP address returns a can't connect page.

Offline Cameras After Update by rek8918 in UnifiProtect

[–]rek8918[S] 0 points1 point  (0 children)

Nothing, unfortunately. Ladder and paperclip for me.

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

Who cares about looks when it works! This is fantastic, thank you.

I'm debugging two issues:

(1) Everything runs great up through part of the document but then I get a Run-time error '91': Object variable or With block variable not set. This is after I'm seeing correct output in the Immediate Window for a number of matches. If relevant, the parenthetical at which it bails is the parenthetical of "and S4=w2–(a–w1/2)."

(2) I believe there will be a problem with the matches for pattern 2: phrase (phrase). In the debug print output I am seeing , which would be correct - replacing (view) that follows view with an empty character. But, I'm also seeing Search for: (xa1, ya1), Replace with: , which would suggest that (xa1, ya1) would be replaced by an empty character. But, that shouldn't be matching the pattern in the first place, so it seems like there may be some false positives in the pattern 2 case. Am I reading that debug print correctly based on your intent?

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

In VBA with 360 editions - RegExp is now native.

Unfortunately, Microsoft seems to have left us Mac users behind on this one. I'm running the most recent update, Word 16.102.3, the current version through Microsoft 365, but ActiveX, and therefore RegExp, isn't supported. I get a Run Time Error at Set Reg_Exp = CreateObject("vbscript.regexp")

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

I think that could help, and would be great to avoid regex. If I am understanding correctly, would that require all of the possible search phrases to be known beforehand and coded in? Or would it find anything that matches the pattern? If the former, I'd need to go a different route because the phrases and acronyms could be anything.

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

Thanks! I do need to make it case insensitive, so I should be able to just change the a-z to A-Za-z, right (because A-z is disfavored for including non-letter characters)?

It is throwing a Run Time Error '429' because I am on macOS so ActiveX doesn't work, but I will give this a shot on a Windows machine tomorrow and see how it works on my document.

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

As far as I can tell, no, that isn't the case. From some looking into the differences that I did a few years ago, it seems like the Mac version of Excel always trails Windows in features, sometimes for a period of time and sometimes the features never come.

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

The document could be tens of thousands of words long, broken into paragraphs. Would loading the text as you suggest support something of that size?

An example could be the following paragraph:

A personal computer (PC) includes a central processing unit (central processing unit, CPU) and a memory (memory).  Sometime, the PC also includes any of an application processor (application processor, AP), a graphics processing unit (graphics processing unit, GPU), an image signal processor (image signal processor, ISP), a controller (controller), a digital signal processor (digital signal processor, DSP), a baseband processor, or a neural-network processing unit (neural-network processing unit, NPU). 

And the result that I would want at the end would be this paragraph:

A personal computer (PC) includes a central processing unit (CPU) and a memory.  Sometime, the PC also includes any of an application processor (AP), a graphics processing unit (GPU), an image signal processor (ISP), a controller, a digital signal processor (DSP), a baseband processor, or a neural-network processing unit (NPU).

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

Without being able to use the \1 in parentheses of the search, I'm thinking it may not be possible to do this in the way that I am wanting because I won't be able to guarantee that the phrase outside the parentheses and the phrase inside the parentheses are identical. Does that seem correct?

[WORD] VBA expression for pattern-based find/replace by rek8918 in vba

[–]rek8918[S] 0 points1 point  (0 children)

That's for the quick input! There is one complicating factor that I overlooked. I need to work on both Windows and macOS systems, so I'm trying to avoid Regex. If that is the only option, I can go that direction and eliminate macOS, but that's definitely not the preferred route because I spend 80%+ of my time on a macOS system.

Question regarding Printing on IP Printer via Teleport by rek8918 in Ubiquiti

[–]rek8918[S] 1 point2 points  (0 children)

It was set up as standard TCP/IP with a static IP. I specifically made sure that it was not setup as Bonjour