?
Solved

Get attendance to the biometric machine directly in SQL through IP

Posted on 2013-01-17
6
Medium Priority
?
6,209 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 11

Assisted Solution

by:Deepak Lakkad
Deepak Lakkad earned 1000 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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

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 1000 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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
A clone is a duplicate copy. Sheep have been cloned and maybe someday even people will be cloned, but disk cloning (performed by the hard drive cloning software) is a vital tool used to manage and protect data. Let’s look at what hard drive cloning …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

771 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