Закрыт

Export product data from the database to an excel file Synchronize data between the local database and the database that will be uploaded to the hosting

the first requirement

Restore the backup from this link

[login to view URL]

And it is restored using MS Sql management studio

And then a system is created that exports the data in the database to an Excel file in a specific format, and all the data in it is exported to 2 Excel files in a specific format

the first

A products Name

F products Number

L unit price

N barcode Number

P box price

Q Number of unit in box

the second excel file is in this format

A expired date

B product number

C barcode

D number of unit in store

E cost of the unit

F number of box in store

G cost of the box

J products name

the following technologies are used

1. C#

2. layered pattern

[login to view URL] framework core

[login to view URL] programming

[login to view URL] of work and repository pattern

[login to view URL] Design pattern

7. WPF

the second requirement

this is also for 2 databases for other systems, in the same manner as for the first requirement

the third requirement

[login to view URL]

A backup is for a system that was created using technologies

1. C#

2. layered pattern

[login to view URL] framework core

[login to view URL] programming

[login to view URL] of work and repository pattern

[login to view URL] Design pattern

7. WPF

It is required to link the local database with the database that will be uploaded to the hosting and they will be linked through A P I and the new data will be synchronized from the local database to the database on the hosting

And in order to be able to know the tables that have been changed and need to be synchronized, this is done by creating addition tables (that is, a copy of all the tables and the comparison is done constantly between the main table and the copy of it. If it is 1 (meaning a difference between the table and the other) then it is Automatically sync to hosting

If there is no difference between the two schedules, it is not necessary to synchronize it

And automatically if new tables are found, they are also created in the database in the hosting

It is required that the settings for linking the local database and the database on the hosting be in simple steps

Навыки: Программирование на C#, .NET, SQL-сервер Microsoft, SQL, Microsoft Access

Показать больше: export excel file web form, aspnet export datatable excel file, export excel file access database excel vba, excel macro export column text file, export datatable formated excel file using vbnet, mercury quality center export requirement excel file, export dataset excel file asp, export dataset excel file using vbnet, export dataset excel file using aspnet, export datatable excel file vbnet, export datatable excel file vbnet 2008, magento export orders excel file, product excel file opencart, export array excel file, update table sql management studio csv file, vendor product excel file data sheet, synchronize local and remote mysql database, read excel file in php and insert into database, vba code to open excel file from folder and copy data

О работодателе:
( 6 отзыв(-а, -ов) ) tripoli, Libya

ID проекта: #32160748

27 фрилансеров(-а) готовы выполнить эту работу в среднем за $1019

(14 отзывов(-а))
6.2
(104 отзывов(-а))
6.4
MSHOAIBK

Hi . I am an individual software engineer has a solid experience in ✤ Classic ASp | Vb .Net ✤ C# | .NET 5 | .NET Core | MVC 5 | ✤ Web API | Microservices | Blazer | REST ✤ Entity-Framework |[login to view URL] ✤ Sql | No Sql ✤ Lin Больше

$750 USD за 7 дней(-я)
(29 отзывов(-а))
5.8
(20 отзывов(-а))
5.8
hsh564cf84accd96

We will do your work I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in programmi Больше

$750 USD за 7 дней(-я)
(62 отзывов(-а))
5.8
ivanovatale

I’ve spent most of my career developing with C#, vb.net During that time it’s been necessary to attain a working knowledge of many other technologies, including C#, Asp.net Web Forms,Asp.net MVC, SQL Server, MY SQL, S Больше

$750 USD за 7 дней(-я)
(10 отзывов(-а))
5.1
(25 отзывов(-а))
5.2
harune

Hello. I am a Certified PMP (Project Management Professional) & Scrum (Agile) Professional offering services as Full Stack Developer (Frontend & BackEnd), having hands-on experience of developing small, medium and ente Больше

$1500 USD за 15 дней(-я)
(17 отзывов(-а))
5.3
(24 отзывов(-а))
5.1
mihhailovajulia5

Hello. I have read your description very carefully and I can complete it perfectly in short time. I am confident in my skills and always value for client's trust. So I have rich experience in these fields. I can use th Больше

$1125 USD за 7 дней(-я)
(4 отзывов(-а))
4.5
pasievrakhim

Hi, Client As a Software Developer, I have 5+ years rich experiences working with C, C#, Qt, and so on. We have many years of strong experience in C++ Programming, OpenGL, Qt, as a result, we can successfully complete Больше

$750 USD за 7 дней(-я)
(13 отзывов(-а))
4.5
(5 отзывов(-а))
4.6
(5 отзывов(-а))
4.6
aminechafai14072

I am database expert with extensive experience from the field. I can definitely help you the required data movement and manipulation. Please reach out to me to discuss the plan of implementation.

$950 USD за 8 дней(-я)
(10 отзывов(-а))
4.3
vbtise

Professionals are accessible 24/7/365 to help you restore the backup, Using the link, MS SQL management studio is used to recover it. Then a system is established that exports the database's data to an Excel file in a Больше

$1125 USD за 7 дней(-я)
(1 отзыв)
4.1
RomanMatveev1

A C# and SQL Expert! Hello, dear client! I am a professional C# developer and making UI with WPF is my most confident field. I have checked your requirements carefully. I can restore you data correctly and make a good Больше

$750 USD за 7 дней(-я)
(6 отзывов(-а))
3.7
fliudmyla1

Hi, Dear. Database Export! I`ve read your project post very carefully and I`m really interest in your project. I`ve rich 6+years of experience and knowledge in C#, .Net core, MSSQL, Exel. If you hire me, I can start ri Больше

$1125 USD за 7 дней(-я)
(7 отзывов(-а))
3.7
(1 отзыв)
2.2
SergeyKuznetsovv

Hi, ⭐@Your web expert here!!!@⭐ Please check calahex.com. I've read your job description several times and I eventually decided to bid. I've been a web expert for 5+ years and I think I am a best fit for your project. Больше

$750 USD за 3 дней(-я)
(2 отзывов(-а))
2.2
dPenXetri1

Hello, Very recently, I wrote a program that sychnronizes product /sales data between local database (Paradox ) and WooCommerce, Original goal was to export into CSV simply, but eventually with WooCommerce.. I believ Больше

$1125 USD за 7 дней(-я)
(2 отзывов(-а))
2.2