Windows services keep monitor (thread timer) specific folder (“c:\upload”) if it contain log files it read it line by line and import it into SQL-server table DeviceLocation
After finish delete the file
Sample file
1554481381,Ahmed,2816AD358847,[login to view URL],SYSTEM,29.3751988333333,47.9861126666667
1554481383,Ahmed,2816AD358847,[login to view URL],SYSTEM,29.3751988333333,47.9861126666667
1554481414,Ahmed,2816AD358847,[login to view URL],SYSTEM,29.37528725,47.986311
1554481447,Ahmed,2816AD358847,[login to view URL],SYSTEM,29.3754354536452,47.986539241034
1554481477,Ahmed,2816AD358847,[login to view URL],SYSTEM,29.3753713791688,47.9864261559491
The table description as: flowing
USE [GPSDB]
GO
/****** Object: Table [dbo].[DeviceLocation] Script Date: 4/5/2019 4:20:42 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DeviceLocation](
[sTime] [int] NOT NULL,
[AuthSerID] [nvarchar](50) NOT NULL,
[Latitude] [numeric](18, 6) NOT NULL CONSTRAINT [DF_DeviceLocation_Latitude] DEFAULT ((0)),
[Longitude] [numeric](18, 6) NOT NULL CONSTRAINT [DF_DeviceLocation_Longitude] DEFAULT ((0)),
[status] [nvarchar](50) NULL CONSTRAINT [DF_DeviceLocation_status] DEFAULT (N'on'),
CONSTRAINT [PK_DeviceLocation_1] PRIMARY KEY CLUSTERED
(
[sTime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
I will create a Windows service with installer which will read the log files on specific interval. Insert entries into table whenever a new entry is found.
Hope to work with you again.
$100 USD em 3 dias
5,0 (61 avaliações)
6,5
6,5
27 freelancers estão ofertando em média $119 USD for esse trabalho
Hello,
As an experienced vb.net developer and having sound knowledge in ms sql server, i am very much interested to create the required windows service. I have already developed this kind of service and i can do it in short time. Looking forward to have a positive response from you.
Thanks
Hi
This will be quick tak with my experience in .net and SQL server . I can deliver this within a day
I am a Dedicated Senior .Net Developer and Database Administrator with 20 years of experience in Web/ Windows and Android Developments,Administration, Project Management System
analysis, and Database Developments. Delivering quality solutions to complex
business problems within scope, budget and tight schedules whilst meeting strict
specifications both functional (for users ) and technical (for Developers) , from project
planning, estimating to delivery.
SKILLS AND ABILITIES
• Web | Windows Developments
• C# | Vb. Net | ASP. Net
• SQL Server | MY SQL | EXCEL | MS ACCESS
• MVC| | Web Forms | Win Forms
• Web Services | API
• Entity framework | nHibernet
• Java scripts | J query | json
• HTML | PHP
• CSS | Bootstrap ,
• Android Developments
• IIS | Windows Server 2017
• Crystal Reports | iText Sharp
• XML | XLT
• System Analyst
• Agile | Scrum | Waterfall Developments
Hi I could do it by today. I'm sure I could help you with this work. I'm ready to start right now. So please let me know if you are interested. Regards
I have seen the project - windows service vb.net /SQL 100$.
I have been working in these fields((.NET, Microsoft SQL Server, SQL, VB.NET)) for 7 yrs as a freelancer.
I will never disappoint you and i will try my best to deliver good result always.
Hope to work with you.
Thank you.
hello sir
you can check my review also on freelancer profile
i have 10 years experience in Programming in asp.net c# mvc web, window and android technology , i can do your work as per your requirement. let me know if my profile suitable for your project. thanks
Solution: I will create a ETL tool to load your log file data into sql server table. I will create one filewatcher service which will read the data only when there will be file and execute the ETL task.
I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below:
Database - SQL Server, Oracle, MySQL
BI - Microsoft MSBI and Informatica ETL
Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc...
Cloud - Azure (Paas and IaaS)
Let me know if you want to discuss further.
My Technical background
• A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain
• Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently.
• Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models
• Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas
• Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
Hello,
Let me do it for you.
Please view the profile to see more works of mine.
Let's discuss so I can provide you more details about me.
Waiting for Your Reply soon.
Regards,
Mousumi
Hello.
I'm an experienced full-time developer.
I can fulfill your needs most accurately and quickly.
I have enough experiences in MySQL.
I enjoy coding, and I value my client's trust and I commit myself to any job, taking full responsibility in completing projects on time.
I believe communication is very important, and you can communicate with me at any time.
I think our trust is very important.
If you hire me, I will do my best for you.
Let's meet and discuss more.
Thanks.
Dear employer!!!
I read carefully job description just before.
I am an experienced Desktop App designer and developer with wide Expertise
I am able to offer good prices and deliver great work.
I will work for you with longterm, fulltime, real-time online!
Language :
C++, C#, VisualBasic, Java, Qt, Python, Scirpt
Skill
Database(MySQL, Access, Excel, MSSQL...)
Network (tcp/ip, socket, tcp and udp protocols like http)
Video processing, Image processing(OpenCV, OpenGL...)
Programming (multi-threading, Driver development...)
Platform (linux, windows, macos, Ubuntu, embedded os...)
Business management system(UX, UI...)
Thank You & Regards
Hello, I can create this for you. I will first send you a demo and if you like it then you can pay. You don't need to pay anything until you see it works properly.
Hi,
I have 17 years of experienced in development. please let me know to discuss the project further. I'm using vb.net, mssql,vb6,xslt,oracle and mysql. Also doing mobile development using B4X.
Thanks,
Marlou
Assalamu Alikum,
I can do your job. I have overall 8+ years of experience in Microsoft .NET. I have experience in both desktop and web application.
jazakallah khair,
Aslam Iqbal
hello,how are you. i read your bid carefully.
i am C#, VB.Net expert and have full experience for 7 years.
C#, VB.Net is my top skill and my interested skill.
I can provide most quality and high fast.
if you want to success, please contact me.
Then, I will give you good result.
hire me.
Hello , I have gone through your Requirement and I am sure I can help you with this project.
I am having 9 Years of experience .Net Technologies worked on both Web and Windows applications development and deployment.
Worked on :
ERP System, HR Payroll, POS
Skill Set : ASP.NET, MVC, C#, VB.NET, Win-Forms, Javascript, SQL, MySQL, SSIS, SSRS
Thanks,
Yogesh
Hello,
I have gone through your requirement and I am sure I can help you in your requirement.
I have experience into window service application and i have already created this type of window service in past.
I am available as per your time.
I'm full-stack developer having over 10+ years of experience in Microsoft .NET, ASP.NET, C# Programming, MVC, Microsoft SQL Server, WebAPI, JSON, WinForm, HTML5, CSS3 and JavaScript.
I would love to assist you efficiently.
So you will have all the services under the single roof and it will save your money and time as well.
I'm hoping to build my profile here, so willing to work for a discounted rate- best quality assured.
I am keen on helping you with the project.
I look forward to hearing from you
Thanks
Viral Sarvaiya