Test Video,YouTube, Video making and editing, etc. coupled to excelfox (OBS)

[DocAElstein]

_... continued from last post

It would appear that a registered P2P account with Sannce, ( in our worked example the newly made account with the user name of cloudpoohpee ) , exists to hold information for, and to act as a form of authorisation to, access one or more DVRs remotely over the internet .
We have successfully Added this information to the account, after the first log in, ( https://i.postimg.cc/c432gY08/Fill-i...de-then-OK.jpg )
Necessarily this registered P2P account with Sannce also needs to be able to collect the necessary details of the DVR which are required to allow the P2P access. This does not appear to occur at the same time as the information is Added to the count. That is perhaps a bit strange and not as expected, but maybe there is some technical reason for that. Also, so far, I have not seen a “button” or any other way to evoke the “bringing in” , or “setting up with” or “using” of this information in such a way that things start working as we want them to , or as they need to in order to get the functioning P2P remote internet access.
This is a dilemma. My guess is that not just me, but the entire technical people at Sannce have been in this dilemma, and never consciously got out of it. I will further guess, that like me, anyone that ever got this functioning P2P remote internet access had spent many frustrating hours trying, and then at some point, a random combination of events resulted in it working.
However , we have done correctly and fully and successfully all we can and all we need to do get the remote cloud P2P way working
This is a dilemma. But I figured out that the necessary action which we are missing is referred to as something like “importing”. The software appears to have been written to carry out this importing when a valid account is logged in. Currently we are at the situation where the account with user name cloudpoohpee holds information for, and has authorisation to, access our DVR remotely over the internet. )
All we need to do is log in with the account. But we can’t, as we are already are logged in!
So, the final action needed is Log out , and then re log in

So , first we logout from the Device Management window, https://i.postimg.cc/yYQbJPSj/logout...ant-window.jpg
Because we have the Cloud P2P Device selected, we are returned to the large Sannce P2P cloud login window. We then check that we are in Germany , https://i.postimg.cc/66hSKwWD/Check-...n-re-Login.jpg , and then re Login https://i.postimg.cc/nccWc5MM/then-re-Login.jpg . ( Typically the last username used would be remembered and written in already)
Note that we are only interested in logging in, - the registration no longer concerns us, so we ignore the Register button, https://i.postimg.cc/QMdTPQMB/Log-in...-of-window.jpg .
After entering our current account name and password, and hitting the Login , some processing appears to be happening and if all goes well then a small black window pops up for a second to inform that “[FONT=Courier New]Importing succeeded![/FONT ]” https://i.postimg.cc/kG401ZVt/Import...ack-window.jpg
https://i.postimg.cc/7hXQn1tx/Importing-succeded.jpg

Now, in Device Management we see the same as we did just before logging out, https://i.postimg.cc/Ss6PJbWY/Device...gout-login.jpg


But the first thing we notice new in Main View is that we now have a + appearing to the left of the folder corresponding to the P2P account name , cloudpoohpee and either immediately or after a few seconds we get a working picture.
( Sometimes the receiver may “ hang” during a camera cycling process – We can “wake up” the receiver by either hitting the small restart/refresh symbol, https://i.postimg.cc/L5mbPQTC/A-refr...times-help.jpg , or alternatively, select the + to expand the drop down camera list, then double click on the first camera, https://i.postimg.cc/dVgN6V6T/click-...rst-camera.jpg

For a single camera, viewing in 1-Screen view, https://i.postimg.cc/52Xk8CBV/1-Screen-view.jpg , may give slightly more stable results, but it seems that in the Cloud P2P viewing, a click on the recycle/refresh symbol is still needed occasionally to “wake up” the DVR, https://i.postimg.cc/LXK798ZM/1-Scre...often-good.jpg . There may be some settings to influence recycling and updating, as there are certainly many more features to be tried with the Guarding Vision Software , but for now, that concludes the main purpose of this Blog.


Attachment 3774

[DocAElstein]

__________________________________

[DocAElstein]

________________________

[DocAElstein]

__________________________

[DocAElstein]

__________________________________

[DocAElstein]

____________________________________

[DocAElstein]

hkjahhdahdhdh

[DocAElstein]

Using this File:
“UpdatesOnVistaAspire4810TZG25thMarch.txt” : https://app.box.com/s/z90o8yj7iz0188yci34mu7gahe2tfhce
That file is downloaded into the same Folder as the file containing the code from the last Post.
This code line needs to have that text file reference in it such:
Let ActiviEL = ThisWorkbook.Path & "\UpdatesOnVistaAspire4810TZG25thMarch.txt"
Run code entering these search values when prompted
2553154 2726958 2965291 2920813 3054873 974554

Here the output string

You looked for
2553154
2726958
2965291
2920813
3054873
974554

Finded was

_.______________________________________________


Using this File:
“UpdatesAcerMartinWin7Pro64Bit26thMarch.txt” : https://app.box.com/s/8m96l0e7yh1wcb15y06eaaz6a7vtjzgd
That file is downloaded into the same Folder as the file containing the code from the last Post.
This code line needs to have that text file reference in it such:
Let ActiviEL = ThisWorkbook.Path & "\“UpdatesAcerMartinWin7Pro64Bit26thMarch.txt"
Run code entering these search values when prompted
2553154 2726958 2965291 2920813 3054873 974554

Here the output string

You looked for
2553154
2726958
2965291
2920813
3054873
974554

Finded was

[DocAElstein]

Appendix notes in support of these Threads:
http://www.excelfox.com/forum/showth...en-insert-them
http://www.excelfox.com/forum/showth...ommand-Buttons

Trying to find .exd files and delete them.
The results of most of what I have read or results of asking people suggests that they are usually findable if you look for a temp or temp somewhere in a file path

These appear a bit difficult to find sometimes . You can try:

_ manually navigating

_ a windows explorer search for *.exd
StarDotexeExplorerSearch.JPG : https://imgur.com/hfbC93Z
Attachment 2037

_ a search in a small bar using %temp% or %Temp%
You can get the small bar from either hitting WindowsKey+r or by selecting the Windows symbol
PerCenttempPerCentsearch.JPG : https://imgur.com/LypHLGY
Attachment 2038
PerCenttempPerCentsearch2.jpg : https://imgur.com/DZvycco
Attachment 2039

It seems a bit inconsistent which search finds what, but usually it is said that you find important places looking something like these:
C:\Users\username\AppData\Local\Temp\Excel8.0
C:\Users\username\AppData\Local\Temp\VBE

I found sometimes .exd files here also
C:\Users\username\Application Data\Microsoft\Forms

Some other typical places I found
C:\Dokumente und Einstellungen\Administrator\Application Data\Microsoft\Forms
C:\Dokumente und Einstellungen\Administrator\AppData\LocalLow

_.____._____________________

This is one of my typical attempts to get a ActiveX control button to_... either
_ insert into worksheet
or , if already three
_ work
_... by deleting .exd files

What I typically tried:
I looked here C:\Users\Elston\AppData\Local\Temp\Excel8.0
I found this:
C Users Elston AppData Local Temp Excel8.0.jpg https://imgur.com/doXstmr
Attachment 2040

I deleted that MSForms.exd File ( Excel had to be closed to do that ) : It had no effect. ( By the way, MSForms.exd gets made again every time I hit the button, or it appears to get made as soon as I open any file that either has or has ever had a control embedded in a worksheet)


In C:\Users\Elston\AppData\Local\Temp\VBE I found these:
C Users Elston AppData Local Temp VBE.jpg https://imgur.com/wjaZpXp
Attachment 2041

So…for these files I did:…
MSComctlLib.exd : I deleted this , - no effect
MSForms.exd : This could not be deleted with Excel 2003 open, it can when it is closed. But that had no effect
RefEdit.exd : This could not be deleted with Excel 2003 open, it can when it is closed. But no that had effect
( By the way, MSForms.exd and RefEdit.exd get made again every time I hit the button, or it appears to get made as soon as I open any file that either has, or has ever had, a control embedded in a worksheet )


In C:\Users\Elston\Application Data\Microsoft\Forms
I found these:
( https://imgur.com/Lv2kyhk )

So……for these files I did:…
RefEdit.exd This could not be deleted with Excel 2003 open, it can when it is closed. But that had no effect
mscomctllib.exd I deleted this: That had no effect
SHDocVw.exd I deleted this: That had no effect
( By the way, MSForms.exd gets made again every time I hit the button, or it appears to get made as soon as I open any file that either has or has ever had a control embedded in a worksheet)

_.._______________-

So for me none of that helped to get me a working ActiveX control Button in a worksheet.

[DocAElstein]

Screenshots and extra notes in support of this Thread:
http://www.excelfox.com/forum/showth...0595#post10595



Distributed Files for the day for "Raghu.xlsx"
From Raghu
Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member
2	1	ABC01	$ 55.00	22	$ 1,210.00	15. Mrz 18								Raghu
3	5	ABC05	$ 7.22	62	$ 447.64	15. Mrz 18								Raghu
4	9	ABC09	$ 741.99	101	$ 74,940.99	15. Mrz 18								Raghu
5	13	ABC13	$ 8.51	12	$ 102.12	15. Mrz 18								Raghu
6	17	ABC17	$ 11.99	1	$ 11.99	15. Mrz 18								Raghu
7	21	ABC21	$ 12.99	5	$ 64.95	15. Mrz 18								Raghu
8	25	ABC25	$ 333.45	99	$ 33,011.55	15. Mrz 18								Raghu
9	29	ABC29	$ 13.66	7	$ 95.62	15. Mrz 18								Raghu
10	33	ABC33	$ 3.99	35	$ 139.65	15. Mrz 18								Raghu
11	37	ABC37	$ 55.00	22	$ 1,210.00	15. Mrz 18								Raghu
12	41	ABC41	$ 7.22	62	$ 447.64	15. Mrz 18								Raghu
13	45	ABC45	$ 741.99	101	$ 74,940.99	15. Mrz 18								Raghu

Worksheet: FromRaghu



Or if distributed today, 2nd April
Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member
2	1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
3	5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
4	9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu
5	13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018								Raghu
6	17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018								Raghu
7	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018								Raghu
8	25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018								Raghu
9	29	ABC29	$ 13.66	7	$ 95.62	02.Apr.2018								Raghu
10	33	ABC33	$ 3.99	35	$ 139.65	02.Apr.2018								Raghu
11	37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
12	41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
13	45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu

Worksheet: Tabelle1

_.________________________

In next Post could be a typical returned worksheet from a team member : ( based on similar files in the Zip Folder "WorkDistributedAndConsolidated 16MAR18.zip" )