- 40
- 320 850
AfhamnaExplains
United Arab Emirates
Приєднався 23 січ 2020
I simplify, automate stuffs, share product information.
Share Location on Whatsapp (wait for the 3rd method)
Share Location on Whatsapp (wait for the 3rd method)
Переглядів: 37
Відео
VTO2201F-P & VTH8621KMS-WP Configuration using PC | Dahua
Переглядів 963 місяці тому
Hello everyone, In this video, we'll show how to configure VTO2201F-P & VTH8621KMS-WP using PC / laptop. We will need a web browser and also Config Tool Config Tool Download Link: support.dahuasecurity.com/en/toolsDownloadDetails?id=590 Device Firmware Details: VTO2201F-P: V4.600.0000000.0.R VTH8621KMS-WP: V4.700.0000000.1.R Let me know in the comments if there's anything we can help you with.
SmartPSS-Lite & SQL Server Integration | Dahua
Переглядів 2483 місяці тому
Hello everyone, In this video, I have explained about SmartPSS-Lite and SQL Server Integration (mainly used for HRMS integration) The following script creates a database with a preset collation. (copy and execute both queries TOGETHER on Query Window). CREATE DATABASE attendancelogs COLLATE Chinese_PRC_CI_AS SmartPSS-Lite Version used in this video: V1.003.0000006.0 Build 2024-05-17 Download La...
iOS Shortcuts: Making use of the CLIPBOARD
Переглядів 6816 місяців тому
Hello everyone, In this video, I’ll be showing how to make use of clipboard feature in iOS shortcut to copy contents to clipboard and paste anywhere.
Split Video for posting on WhatsApp Status
Переглядів 2,3 тис.10 місяців тому
In this video, I have explained how to split video into multiple parts to post on WhatsApp status. FFMPEG Download: ffmpeg.org/download.html Command: ffmpeg -i input.mp4 -ss 0 -t 30 output1.mp4 ffmpeg -i input.mp4 -ss 30 -t 30 output2.mp4 Source: unix.stackexchange.com/a/1675
SmartPSS-Lite & MySQL Integration | Dahua
Переглядів 1,8 тис.Рік тому
In this video, We'll see about SmartPSS-Lite and MySQL Integration. Attendance logs will be pushed to MySQL database. SmartPSS-Lite Version: V1.003.0000004.3 (Date: 2023-10-13) MySQL Version: 8.0.31 SmartPSS Download Link: support.dahuasecurity.com/en/toolsDownloadDetails?id=589 Unix timestamp to readable date-time converter: www.epochconverter.com/
Set reminder for recurring events using ntfy & Cron
Переглядів 294Рік тому
In this video we’ll see how to set recurring reminders using ntfy and cron. Useful Links: ntfy console.cron-job.org/login nfty Web App: ntfy.sh/app Android: play.google.com/store/apps/details?id=io.heckel.ntfy&hl=en&gl=US&pli=1 iOS: apps.apple.com/us/app/ntfy/id1625396347
Download audio files from a webpage (Ver 2)
Переглядів 2,4 тис.Рік тому
Hello everyone, I made this video as a user had commented in one of my videos requesting to download all mp3 files from Oxford 3000 & 5000. Hope you find it useful.
iOS Shortcuts: Fuel Tracker
Переглядів 269Рік тому
In this video, I’ll be explaining about how to create a fuel tracker using iOS Shortcuts.
Convert table data to series of rows
Переглядів 3122 роки тому
In this video, we will see two ways to convert a tabular data (table) into a series of rows. Way 1: Using Power Query. Way 2: Converting to csv and using notepad
iOS Shortcuts: Notify if weather is “Sunny”
Переглядів 4,7 тис.2 роки тому
In this video we will see how to use iOS shortcut to check if it's sunny out there at current location and prompt a message saying "It's sunny"
Data Scraping using API
Переглядів 3,4 тис.2 роки тому
This video is about scraping data’s through API You can follow similar method to download data from websites. This is applicable for many websites. Hope you find it useful. Tools: 1. Browser (DevTools) 2. Postman 3. JSON to CSV converter: konklone.io/json/ Let me know in the comments section about your feedback. Thanks!
A day with installers @ Dahua Technology MENA
Переглядів 1122 роки тому
A day with installers @ Dahua Technology MENA
iOS Shortcuts: Automate WhatsApp message on yearly basis
Переглядів 14 тис.2 роки тому
Run iOS shortcut on yearly basis using if and current date. Using iOS Shortcut, whatsapp can send birthday greeting to a person on the mentioned date (using if condition) Hope you like the video. If you have any questions, let me know in the comments section.
iOS Shortcuts: Automate Whatsapp Message with sound notification
Переглядів 46 тис.3 роки тому
iOS Shortcuts: Automate Whatsapp Message with sound notification
IP Video Intercom (Villa) Configuration | Dahua
Переглядів 2,9 тис.3 роки тому
IP Video Intercom (Villa) Configuration | Dahua
Send bulk email using power automate desktop | Microsoft tools
Переглядів 6 тис.3 роки тому
Send bulk email using power automate desktop | Microsoft tools
Remote Configuration does NOT work in iVMS4200 | Hikvision
Переглядів 29 тис.3 роки тому
Remote Configuration does NOT work in iVMS4200 | Hikvision
iVMS4200 T&A Configuration - Alternate Weekly Off's | Hikvision
Переглядів 8343 роки тому
iVMS4200 T&A Configuration - Alternate Weekly Off's | Hikvision
Send Bulk emails with unique attachments
Переглядів 6 тис.3 роки тому
Send Bulk emails with unique attachments
iVMS4200 & MySQL Integration | Hikvision
Переглядів 29 тис.4 роки тому
iVMS4200 & MySQL Integration | Hikvision
Access Control Terminal & Video Intercom Integration | Hikvision
Переглядів 6 тис.4 роки тому
Access Control Terminal & Video Intercom Integration | Hikvision
Setup Hikvision Face Recognition Terminal with Intercom Indoor Unit for Visitor Access
Переглядів 14 тис.4 роки тому
Setup Hikvision Face Recognition Terminal with Intercom Indoor Unit for Visitor Access
Face Mask Detection in Hikvision Face Recognition Terminal
Переглядів 2,6 тис.4 роки тому
Face Mask Detection in Hikvision Face Recognition Terminal
HikCentral Pro Offline License Activation
Переглядів 10 тис.4 роки тому
HikCentral Pro Offline License Activation
Setting up QR access in face recognition terminal | Hikvision
Переглядів 9 тис.4 роки тому
Setting up QR access in face recognition terminal | Hikvision
Temperature Screening Monitoring Tablet | Hikvision
Переглядів 1,4 тис.4 роки тому
Temperature Screening Monitoring Tablet | Hikvision
Temperature Screening Access Control - Abnormal Temperature alarm pop-up | Hikvision
Переглядів 9804 роки тому
Temperature Screening Access Control - Abnormal Temperature alarm pop-up | Hikvision
IP Video Intercom Configuration - 1 Outdoor Unit & 2 Indoor Units | Hikvision
Переглядів 8 тис.4 роки тому
IP Video Intercom Configuration - 1 Outdoor Unit & 2 Indoor Units | Hikvision
very nice trick
Thank you
Wont work if the phone is locked. Lol
It works even if the phone is locked It does NOT work if your whatsapp is locked with Face ID.
Hello, I am trying to connect to the MySQL database but I get the error "Error connecting to the database. {Error code: SYS[16]}", checked the port, disabled the firewall but I can't. solve it.
Are MySQL and iVMS on the same computer? Double check the DLL file which you uploaded.
THANK YOUUUU!!!!!!!!!!!! THANK YOU SOOOOO MUCH INDIAN MANNNN!! I LOVEE YOUU SOOOO MUCHHH IVE BEEN TRYING SOO HARD TO FIND A WAY TO GET MP3 FILES FROM SITESSS I LOVE YOUUUUU THANK YOUUU
You are welcome!
hi, about the server IP address, can it put hosting mysql address as remote db instead of localhost db?
Theoretically it should work, you can give a try. Keep in mind that, IP address works and domain names don’t.
how to view terminal file?
Could you elaborate what exactly do you need? Thanks!
Very Good,, thank for share it !
Welcome!!
@AfhamnaExplains is there an official documentation about the Microsoft SQL Server version compatible with SmartPSSLite?
Nope, there is no such document.
Hi!, Thanks for the video. One question, how can I connect it to a mysql database on a web server? (I have a problem with the .dll
Hello there 1. What problem are you facing with DLL’s? 2. Is attendance software and MySQL on the same computer / server? Thanks!
hello and thank you for these clear explanations. But I have a problem, every time I try to connect ivms 4200 AC with my MYSQL database, I get the following error: third-party database connection failed. please check the database connection and click save. i'm using wampserver with mysql version 8.0 What could be the cause
Could be various reasons, 1. Make sure the iVMS4200 and WAMP server are using one of these: x86 or x64 2. Are iVMS4200 and MySQL on the same server? 3. Ensure that there is no firewall or any other blocking the access. Thanks!
if someties the internet is down ? is there any other way to ready data from device and dump it to MySql instead of real time transations ?
There in an option to manually download data from device onto iVMS, when you do that, the data will be synced to MySQL.
Thanks a lot. This is super useful and easy to use for anyone a little familiar with DOS commands and parameters. Their download page is very confusing. Would have preferred a link to download the latest EXE for Windows / Linux and MacOS upfront.
Glad it was helpful!
I don't know why it doesn't send anything, even though the contact was synced.
Face ID should be disabled for WhatsApp.
@@AfhamnaExplains I did it, but nothing happened. I wonder why it must be a phone number instead of their account to be chosen...
@@Levince36 Here are few things to check: 1. Could you confirm if you set the date format to dd-MM in shortcuts? 2. Make sure the contact exists on your phone. 3. Try entering the mobile number without spaces end enter ISD code also. Eg: 10250111991 I tried selecting contact directly on shortcuts instead of entering the phone number, SOMETIMES it did not work for me.
Why does the connection with SQL only work with COLLATE Chinese_PRC_CI_AS? If I use another one, it doesn't work.
Yes, currently we need to use collate. In the upcoming version of SmartPSS-lite, this issue will be resolved.
i can't find libmysql in xampp
big like to you bro
Thank you.
You are the best 🎉🎉🎉🎉
Thank you. 😊
Hi, thanks for the video. When I test the database connection it says successful. But when I enable the Database and press Save it gives the following: "Successfully saved database configuration" "Database connection failed" Then it unticks the enable database button. What is strange though, it creates the table in my database but does not write any data to it.
Are you using sa account [SQL Server]?
@@AfhamnaExplains Yes
@@AfhamnaExplains is there an official documentation about the Microsoft SQL Server version compatible with SmartPSSLite?
hello sir i have used lates SmartPSS-Lite Version but there is no any tripartite database config option can this option is avaliable for free version ? plz help i want to connect with MYSQL how we do any other process
Please download the latest version of SmartPSS-lite from dahuasecurity website: dub.sh/smartpssdownload
@@AfhamnaExplains thank you brother for your coordination but i have simple Question when we connect with DB My PPS lite connected with 4 device can it retrive data form all the devices in DB ?
@abubakarkhan7122 Hello Abu, Yes you can.
@@AfhamnaExplains thank brother project delivered with your help
I am getting the records in SQL only after a click on 'Get Event from Device' in IVMS Attendance report. Is there any way to get the record real time in SQL? or any trigger to 'Get Event from Device' every minute?
Usually the logs will get downloaded automatically provided iVMS4200 is open.
Hi, I need support from you on HikVision with MySQL or SQL intergration, please reply to this message with your mail or contact details , i will contact u..Thanks
i tried., but it failed to connect. I have used sql 2014, and IVMS 3.4.0.5
Hello there, What is the error message are you getting?
Hi, it says ‘third party database connection failed, please check the connection’. Saving failed.
Can u share ur contact in my mail?, i can pay for ur support.
You can reach me via kaashif@duck.com
Third-party connection failed error
Hello there Please check in SQL server if third party apps can have access to sql server.
Hi, I can't connect on Mysql. Hint Saved Failed. iVMS-4200 - V3.4.0.5 build20201102, mysql Ver 14.14 Distrib 5.7.24, for Win32 (AMD64), libmysql.dll - 5.7.24.0, Windows 10 Pro 64 bits. My database is localhost (127.0.0.1) port 3306. Firewall and antivirus down. Any suggestion?
Hello this video is interesting, I have tried to do it using Laragon but I have not been able to try wampserver
Hello there Were you able to integrate successfully?
@@AfhamnaExplains no, I can't integrate, I have Windows 11 and I have two computers in different locations, I've tried to use the API, which has allowed me to read the information of some workers but I haven't gotten the endpoint to bring the events, really what I require is to be able to get the inputs and outputs of the workers currently I use this model Hikvision DS-K1T320EFX which has a facial detector and fingerprint reader, however the IVMS does not meet my needs so I need to make an integration that allows me to do that, what do you suggest?
Hello, I have seen a old video in your channel which explains how to integrate hikvision ivms 4200 AC to ms sql server. Do you know if we can integrate sql server which is in different network in different location. Thank you
Hello there, I’ve NOT tried it. You can try port forwarding (1433) and use STATIC public IP address of the server where SQL server is installed, it may work!
Okay , Thank you
@shamshuddinali6942 you are welcome!
@@shamshuddinali6942 welcome!
It’s possible use two match for example cloud and rain? Thanks
Hello there You can use nested if statement.
Thanks your Sir. It is very helpful. While we maintain some information's in the Emailer list as a default but the particular data is not in the raw data, how it will ignore while sending an emails automatically as desktop power automate is stopped with the error as "attachment missing". Please help.
Did you enter the correct attachment path?
Thank you ❤
Most welcome!
Cool.. thanks for sharing this video
Glad it helped Welcome!
@@AfhamnaExplains yes, its really helping me sir :)
Hai bro I need to connect HikCentral Access control (Web client) in to mysql database. How to do that?
The process should be similar Did you try?
Hello , can you share the database script
You can check the description, thanks!
@@AfhamnaExplains Mine failed to connect
how we can get person name by employeeId?
Person name does not show up on sql table.
Thank you for this very helpful video. I tried this using iVMS-4200 v.3.11.1.7 with MySQL 8.0.31 - Community Server (Wampserver) but failed to connect. Any suggestion?
You can double check if the DLL file which you uploaded is correct. Or try 32-bit version of the dll file. Thanks!
Can this be done from a website that only allows 30 seconds of streaming ? Can you hear or download the entire song or just the 30 seconds ?
Hello there, It depends based on constrains which they have set on the backend.
@@AfhamnaExplains makes sense. Thanks.
You are welcome!
This didnt work for me🤕
Hello there, 1. Is it the same website? 2. If different website, do you need to login to download media files in it? Alternatively, you can watch my first video and see if that helps! Download audio files from a webpage ua-cam.com/video/J_5b6NY7tPw/v-deo.html Thanks!
@@AfhamnaExplainsHello there. I'm not sure whether you'll respond to this message, but it didn't work for me either. I was trying to download an audio file from Artlist. Could you help me?
I just bought used device Same model How can i reset the admin password?
You’ll have to check with your local distributor for assistance. Thanks!
Instead I'll write such information in 'Notes' and simply 'copy and paste' manually. easier than creating an automation and run every time and bla bla bla.
Thanks for your feedback.
Very useful and informative. Thanks for showing us how to create such workflows
Welcome! 👍
Good
Thank you for your feedback
Super resource!!!
Thank you!
@@AfhamnaExplains You're welcome...
💯 Thanks for the great video!! I was trying to run a daily weather announcement, just before I wake, however I was running into issues navigating my way through shortcuts. I drive for a living so local weather conditions and selecting the proper attire play crucial roles in my every day life. Plus knowing helps me discern if I need to warm my car up and if so then for how long (when it's freezing cold) and I like being mindful of my carbon footprint (not running my car for a long time). 🤔 Actually now that I think about it, I'm sure a video like that would help everyone, especially our beautiful planet 🌍 and with fuel costs it can help people not waste money 💰 Hopefully I can use your video as a means to get that to happen... but a video like that helps everyone is some way so if you were to create one it may go viral *hint hint* 😅 Either way, once again, thank youuu!! #subscribed
Hello there, Thank you for the sub. I am thinking of possible ways to help you with a solution for you. Perhaps, we may have to use weather API. Here are some questions for you: 1. Do you have a handful of places which you visit? Need number of places. 2. Do you travel across different cities? Thanks!
How many emails can l send using this?
Currently I have tested with 20 email address and it works fine. Probably more should work.
thanks a lot, good explanation without any fancy talking and pointing to their own shop
Glad it helped. Welcome!
page is not available for script
Pastbin link containing the script is available in the description, and link works.!
Bro i love YOU tanks ❤😂
Glad it helped.
I followed all steps it works , but my problem is , it does not triger every time for example if i punch 10 times it some time triger 6 times and some times triget 4 times . Please guide me
Are you getting logs on ivms4200? Is it real time or are you trying to download previous data? Try downloading the records again via ivms4200
how can I contact you?
You can contact me via this temporary email address. tbcu9v0f@duck.com
hey! i’m using mysql 5.7.26 on v3.11 of ivms and it shows the connection error when i try to save it - can i check what versions of ivms work w mysql?
i’ve also tried mysql version 5.7.44 and the latest 8.2, all of which don’t seem to work with the latest version of ivms
Did you try using latest version of iVMS? Have you uploaded the right dll file? What is the error message?
@@AfhamnaExplains i figured it out, apparently IVMS only works with x86 versions of mysql and not x64
Great. Thanks for the feedback
@@chloeho9655 Hi. Where you find the mysql installer for x86?
Can we connect this iVMS4200 with Remote MySQL Database.. not the localhost?
Haven’t tried it. However, if the required ports are forwarded on router, it should work.