Em Andamento

Develop a scheduler to generate an Excel file and send file to another server

I am looking for a C# and SQL Server developer, which can design and develop an automatic process to schedule a weakly process to do the following steps:

Write a select query to fetch data and generate the output in an Excel file. ( will provide the query criteria to fetch data)

Save the file in a specific directory.

Call an API to send the Excel file from the windows server to the target server. (This API has been developed, just needs to be called and pass the right parameters. (will provide the information in a later stage)

A scheduler to do the above task on a specific date and time on a weekly basis. i.e, once a week at a specific date and time which needs to be configurable (the date and time, the file name and the path of the file).

Log activities, i.e, keep the history of the process (number of records generated, time and date of the file has been generated and sent.

The data resides in a SQL server DB, there are only 3 to 4 tables to generate the data from them. There are around 1000 records to be generated in the Excel file.

The generated Excel file needs to be sent to another server using a developed and ready API. There is only a need to call the API and pass the parameter with the right information to send the generated Excel file from server A to server B.

The post API is developed and it is working. Just need to be called and pass the correct parameter to the API.

Habilidades: Programação C#, Arquitetura de software, .NET, Microsoft SQL Server , Servidor Windows

Veja mais: excel send file vba outlook, generate excel chart csv file, excel send email existing file, excel send file outlook, send text file server client tcp socket programming, net generate excel file pivot, client server send xml file java, generate excel file multiple worksheets jsp, java mobile application send data file server, send csv file form excel database, send xml file server delphi, send zip file client server wcf, vba excel send file, vb excel send file email, we are looking for experienced developer to develop android application with below features user login by email fb twitter gtalk, we are looking for experienced developer to develop android application with below features: user login (by email fb twitter gta, I need an android developer to develop a learning app for school children, how to generate excel from xml file, how to send text file from client to server in c#

Acerca do Empregador:
( 1 comentário ) Salisbury, United Kingdom

ID do Projeto: #32222713

Concedido a:

ahmedkamran9

Hi, I’m a UK based expert in databases and c# applications with many years of experience. I can help you to extract the data from SQL server and to generate excel file. Im looking forward to work with you. Regards, Kam

£75 GBP em 7 dias
(2 Comentários)
1.8

38 freelancers estão ofertando em média £181 nesse trabalho

(411 Comentários)
8.0
helmot

Hi, I am C# developer and work with visual studio 2022 and dotnet6. After reading your requirements, I think we can do it for you in a simple web page. You most have some fixed queries with specified columns and some v Mais

£200 GBP in 7 dias
(177 Comentários)
8.1
TopSEOExpertscom

Hi, What about developing it as a command line tool which outputs the excel file to a certain directory and send it to the API and also output the log to a file. This way you can run it using windows scheduler at anyti Mais

£250 GBP in 4 dias
(203 Comentários)
7.8
(1572 Comentários)
8.0
maverick44000

Hi Sir, I am skilled in SQL server, Excel and C#. I can automate all these tasks on the click of a button and get them scheduled on weekly/daily basis. Please invite for discussion and share more details. Thank you, Mais

£200 GBP in 3 dias
(49 Comentários)
7.4
(78 Comentários)
6.5
(68 Comentários)
6.5
prakash2813

⭐⭐⭐⭐⭐ Hi there, I am java-python-C# developer with 7+ years of experience in web and desktop app and game development. I have strong expertise in front end, back end and database. I just read the details and looks an Mais

£220 GBP in 3 dias
(65 Comentários)
6.3
paskal77

Hello, I read the description of your project and I can develop the project with the details that you mention. Read Sql server tables, generate excel send it via api (already developed by the client) to a remote server Mais

£60 GBP in 4 dias
(94 Comentários)
6.2
youssefEngineer

Hello sir, Im python expert, and software developer, i created many complex softwares before, i can make this software and provides code + executable, Dealing with apis and excels is something i do almost in every pro Mais

£200 GBP in 3 dias
(21 Comentários)
6.1
(100 Comentários)
6.4
(20 Comentários)
5.7
vovakovalkov80

Hi, I am interested in your offer as a developer with 10 years of experience. I wanna do my best for you with my experience and diligent efforts. For a cheap price, you'll get more than you want in a short period of Mais

£200 GBP in 7 dias
(7 Comentários)
4.9
(27 Comentários)
5.0
(13 Comentários)
4.7
malkesh3m

*Hello..., My Availability: 40+ hours/week. Ready to start work immediately. I read your requirement of #.NET and SQL server Developer to Write a select query to fetch data and generate the output in an Excel file. I Mais

£200 GBP in 7 dias
(11 Comentários)
4.1
valeriaomeldev

Hello Haydar, I have + 10 years of experience in programming development, in partiuclar, I am very familiar with C# and dot net. Until now I have completed lots of projects successfully, also I have always installed VC Mais

£400 GBP in 3 dias
(1 Comentário)
3.7
vw1514518vw

Ready to develop the required software tool to schedule and perform the tasks you described Regards,

£200 GBP in 5 dias
(1 Comentário)
3.8
dmitriysenkojob

Hello! Ready to help you with your project. Let's discuss details in the chat. I am experienced C# developer, so don't worry about quality and timing.

£60 GBP in 3 dias
(13 Comentários)
3.7
estebansalpeter

Hello there! C# would be great to use to program a standard windows service, but... why not do it in python? The scheduling might be done both as a config txt file or just by programming the script to run as a windows Mais

£175 GBP in 7 dias
(2 Comentários)
2.6