WINDEV - pcsoft: Development of a data synchronization engine between tables in remote Mysql databases.
€400-900 EUR
Anuluar
Postuar over 8 years ago
€400-900 EUR
Paguhet në dorëzim
We would like to create a long partnership with a developer who has knowledge with WINDEV and able to collaborate with our development team on several projects.
To assing this project we would like to see at least two windev projects, based on communications between the database and / or webservices.
this project must be developed on Windev 20 English (or 17-18-19).
The goal of the project is to create a sync mechanism between a central db and several local dbs , geographically located in different locations, enabling local db to download a set of data from the central (eg Changes in data products) and back to the central send other types of data ([login to view URL] sales). Data exchange must be temporized and on demand.
The communication system includes 2 macro software components:
1) Software on local point of sale (1 for local office) that ask the remote central system for possible updates and download it them and put data in the local database.
2) Software installed on the central server that has access to the central database listen on webservice; in response to software in step 1 extracts the updated data and sends them to remote point of sale.
Local point of sale software also detects updates on his local database to be sent to the central system and transmits them to a remote component software (step 2), which writes on central database. Communication are always started from the local component, that controls every data exchange.
For this project it will be fine to handle 2 local point of sales and the central server.
1) A Windows service that runs on each local point of sale where there is the db of the store
2) A set of Web services application server on the remote central system that hosts the central db.
Each local service detects changes since the last sync with central system; the local point of sale software calls a web service in remote central and replicate them changes on the central database. Similarly local point of sales software asks another web service for central server update and receives changes from the central db since the last sync.
The tables to be synchronized between db with identical structure.
For this project consider only 5 tables (we provide a dump)
Central to point of sales update(download):
-ARTICOLI
-BARCODE
-ARTIPV
Point of sales to central update(upload):
-SCONTRINO, bill/ticket header from a point a sales
-RIGA_SCONTRINO, items row details for single bill/ticket
Each table includes a field "Last Modified timestamp". At each time sync expiration it immediately detect updated records since the last data exchange, for both directions.
In this project we don’t consider replication for physically deleted records. (our real database tables has a specific "trash tables”).
Both in local point of sales than in Central server provide text log file.
It is necessary to develop two additional small applications that for console monitoring for the state of the data exchange, one for the local point of sales and one in central server.
Local sync monitor Software(view pdf for more detail)
First mask, a table in which rows are the list of the DB tables to be synchronized and the 6columns:
The Configuration Parameters to set the dialogue between the two components on different servers and the credentials to access local database.
A service monitor (state)
A simple connection test between the Local service and webservice
Central sync monitor Software (view pdf for more detail)
A Mask;Rows are list of it has various point of sales
For every Row a function with double-click (or somewhat similar for more detail) that open a table detail similar of Local sync fist mask but only the first 3 columns.
Open Log folder button.
Delivery of the application with full WINDEV project sourcecode.
Dear Sir,
This is Sikander. I have read you job specification and came across your requirements about this project. I have 14+ years of experience in software development and I am ready to start this job. Please discuss in detail. So I can give you exact time frame and budget for this. I will provide you best services in development. Please have a look at my Profile, Ratings and feedback. Please let me know, if you want to see the samples of my work.
I am working in Microsoft technologies and you can find the details below.
My Skills includes:
1) .Net (Web/Windows) asp.net
2) MVC
3) Entity Framework
4) WPF/WinForms
5) MSSQL Server
6) SQL Server Reporting Services
7) Javascript/JQuery
8) WebServices/WCF Services
9) MySQL
10) Hosting Sites
11) Mailchimp
12) AngularJS
13) Recently Worked on Vending Machine solution with Monetary apparatus and Shipping Goods motor also worked on Kisok applicaiton.
many more......
I have no fancy talks, no false promises and nothing to hide but honesty and a great will to expand our work experience. I am willing to expand my work experience to different clients and in this order I apply for this job in the hope to hear some positive response from you.
I hope you will take us positively and will give us a chance to work with you.
Many Thanks & Regards
Sikander
sir i am an expert of synchronizing system development. i have already developed many synchronizing and some are similar to your project . you can check my portfolios and my previous projects . so i can finish you job faster and with best quality at lowest cost . so please feel free for contacting me i am waiting for you response