Member Avatar for adil.ghori

Hello !

I have a baylan Biometrics Finger Print Reader working at my work place for attendance, it imports data to spreadsheet and then let me edit and sort the attendance sheet, i want its automatic backup, is there any way to take its back-up automatically, whether through batch file or anything else.... using schdule task...

  • 5 Contributors
  • 7 Replies
  • 545 Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by rproffitt

Dani AI

Generated

Quick plan (three practical routes) that builds on responses already here: use the vendor SDK/CLI if available (ask the vendor as suggested), script a GUI export with AutoHotkey/AutoIt if there’s no CLI, or do file-level scheduled backups of the exported sheet (the file-copy ideas and mentioned are good starting points). Pick the route that matches what the Baylan software actually supports.

If Baylan offers a command‑line export or SDK: script the export and then open an Excel workbook that runs your cleaning macro on open. Put your processing in a Workbook_Open event so Task Scheduler can launch Excel unattended (note: Excel will block unsigned macros unless the file is in a Trusted Location or digitally signed).

' ThisWorkbook
Private Sub Workbook_Open()
    Application.DisplayAlerts = False
    Call ProcessAttendance   ' your macro that imports/cleans/saves
    ThisWorkbook.Save
    Application.Quit
End Sub

If there’s no CLI/SDK, GUI automation is the pragmatic fallback. AutoHotkey or AutoIt can launch the Baylan app, wait for the main window, trigger the download/export sequence and save to a known folder. Important caveats: GUI scripts are brittle (screen resolution, dialogs), require the user session to be unlocked, and the scheduled task must run “only when user is logged on” so the UI is available.

If the app already writes a spreadsheet file you can copy, schedule a small script to copy that file to a backup location and append a timestamp. A simple VBScript backup helper (run from a scheduled task) produces timestamped copies reliably on XP/7:

' backup.vbs  - usage: cscript backup.vbs "C:\path\attendance.xls" "\\backup\baylan"
Dim fso, src, dstFolder, dt, stamp, dst
Set fso = CreateObject("Scripting.FileSystemObject")
src = WScript.Arguments(0)
dstFolder = WScript.Arguments(1)
If Not fso.FileExists(src) Then WScript.Quit 1
dt = Now
stamp = Year(dt) & Right("0" & Month(dt),2) & Right("0" & Day(dt),2) & "_" & _
        Right("0" & Hour(dt),2) & Right("0" & Minute(dt),2) & Right("0" & Second(dt),2)
dst = fso.BuildPath(dstFolder, fso.GetBaseName(src) & "_" & stamp & "." & fso.GetExtensionName(src))
fso.CopyFile src, dst, True

Operational tips: use UNC paths (scheduled tasks often don’t have mapped drives), test runs manually, set retention/rotation for backups, and protect export files (attendance data is sensitive).

Recommended Answers

All 7 Replies

Member Avatar for rubberman

I assume you are using Windows of some sort? Linux has a tool called rsync which can periodically make backup copies of new or changed files, even across the network.

commented: I'm using windows xp and 7 for this purpose. +1
Member Avatar for adil.ghori

Ofcourse, I'm using windows xp and 7 also..

Member Avatar for rubberman

There is a Windows tool built on top of rsync for Windows - DeltaCopy. Here is a link: http://www.aboutmyip.com/AboutMyXApp/DeltaCopy.jsp

It is also open source, so you can modify it to suit if necessary. :-)

Edited by rubberman
Member Avatar for JorgeM

If what you are trying to backup is a simple flat file, then yes creating a scheduled task is a pretty easy solution. You could create a batch file, vbs script, etc.. Within a batch file, you could use copy, xcopy, robocopy, etc...

Which part do you need help with?

Member Avatar for adil.ghori

the attendace baylan device is on a reception computer with xp windows right now, when i goto take backup and after modifying and sorting it out, take print out during this, i click on baylan own software icon on desktop and then it runs the program of itself, then i download the new records and export it to spreadsheet and then modify it, i want to autorun the procedure of opening baylan software and downloading new records from device and exporting it to spreadsheet, and then also want to automate the spreadsheet work through macro feature of office 2010. is it possible?

Member Avatar for Muhammad_146

I want SDk of baylan where can i found it any website for download

Member Avatar for rproffitt

@M. I see has a lot of contacts to ask for that.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.