Desktop Application that Outputs an Excel File that is The Combination of Two Online Databases
Budget: $250 – $750 USD
Background: I cannot give the full details of the websites due to confidentiality of the project, but I will propose the job in abstract terms. I apologize if my word choice is not standard for programmers; I am an engineer but not a developer.
Database A is hosted on Website A. Website A requires credentials and MFA to sign in. I am a user with credentials to Website A. Website A contains a list/database that is constantly updating.
Database B is hosted on Website B. Website B does not require any credentials and can be accessed by anyone. It updates regularly as well.
Database A is a subset of Database B (i.e. all fields in Database A are also in Database B).
Output of Project: A Windows Desktop Application (Windows 10 and Windows 11) that will lookup a specific field from each entry in Database A in Database B and find all additional data from Database B that corresponds to that lookup value. Append Database A with all additional fields that are present in Database B. Let’s call the output of that appending operation Database C. Output Database C as an excel file (just a 2D matrix), where the rows are organized in the same way as the entries in Database A, but there are additional columns that are the additional data that was found in Database B. Anytime the Desktop Application is run, it generates a fresh excel file in the folder that the application is being run from that reflects any changes that have taken place on Website A and Website B.
My guess is that for an experienced programmer/website database programmer this is a very simple task, probably less than 10 hours, but I may be wrong. Please let me know if you have any interest in this project and we can provide many more details. Thank you for taking the time to read.
Both databases are relatively small. ~A few thousand entries, a dozen or so fields per entry, so this is not particularly resource intensive.
Database A is hosted on Website A. Website A requires credentials and MFA to sign in. I am a user with credentials to Website A. Website A contains a list/database that is constantly updating.
Database B is hosted on Website B. Website B does not require any credentials and can be accessed by anyone. It updates regularly as well.
Database A is a subset of Database B (i.e. all fields in Database A are also in Database B).
Output of Project: A Windows Desktop Application (Windows 10 and Windows 11) that will lookup a specific field from each entry in Database A in Database B and find all additional data from Database B that corresponds to that lookup value. Append Database A with all additional fields that are present in Database B. Let’s call the output of that appending operation Database C. Output Database C as an excel file (just a 2D matrix), where the rows are organized in the same way as the entries in Database A, but there are additional columns that are the additional data that was found in Database B. Anytime the Desktop Application is run, it generates a fresh excel file in the folder that the application is being run from that reflects any changes that have taken place on Website A and Website B.
My guess is that for an experienced programmer/website database programmer this is a very simple task, probably less than 10 hours, but I may be wrong. Please let me know if you have any interest in this project and we can provide many more details. Thank you for taking the time to read.
Both databases are relatively small. ~A few thousand entries, a dozen or so fields per entry, so this is not particularly resource intensive.