Solved

Get attendance to the biometric machine directly in SQL through IP

Posted on 2013-01-17
6
5,096 Views
Last Modified: 2016-02-11
Dear Experts,
We are using  a attendance machine in our organisation for the employee daily attendance, which have lan facility and working on IP: 10.0.0.186

The vendor have us a patch which get data to the machine and generate text file of attendance. Sample attached. Which I called into SQL through following statement.

delete from Emp_DB.dbo.intermediary
Bulk Insert Emp_DB.dbo.intermediary  From '\\10.0.0.150\Att\txtfile.txt' With (FieldTerminator=',', FirstRow=1, rowterminator ='\n')


Is there any way may I get data directly into MS SQL-2005. Through any store procedure or something else. It would help us to avoid manual edit which generally did by the updating person before update.

Please help
txtfile.txt
0
Comment
Question by:Mehram
  • 3
  • 2
6 Comments
 
LVL 11

Assisted Solution

by:Deepak Lakkad
Deepak Lakkad earned 250 total points
ID: 38786349
You can create procedure and write same code in it.

If file name is changing every time, you can use parameter for file name.

You can execute this procedure from a program or from SSMS.

- Deepak Lakkad
0
 

Author Comment

by:Mehram
ID: 38786874
Sir, This code would work when we load data in database from txt file. but I need to update data into database direct from attendance machine which is on my given IP //10.0.0.186
0
 
LVL 5

Expert Comment

by:RehanYousaf
ID: 38786898
You can create a simple SSIS package which can pick up the file and load it to sql server

SSIS package can be scheduled as a job in SQL Server Agent
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:Mehram
ID: 38786902
in other words I want to say how to generate txt file to import data in database
0
 

Author Comment

by:Mehram
ID: 38786910
sir I haven't idea about SSIS package. please guide me in detail
0
 
LVL 5

Accepted Solution

by:
RehanYousaf earned 250 total points
ID: 38786916
You can try
http://www.codeproject.com/Articles/218914/Steps-to-Create-your-First-SSIS-Package

You will find lot of material if you search on google or bing
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now