Desktop program to interact with Google drive and some websites -- 2

I am looking for a skilled developer who can create a desktop program that will have a login page (subscription with stripe) and it will interact by scraping data from files that were created using CIECA. This is database files and can be opened using excel (A1 First name A2 last name, etc. each customer has about 8 files, each with different information regarding the customer). It also will scrape 2 websites for part number and price and shipping time, Google Drive and known websites (ebay, amazon). The program should have the following features:

- pulling data from from files on our Google Drive: The program should be able to pull data from files between the user's computer and our Google Drive account. This will allow the user to easily produce the information needed.

- Web scraping capabilities: The program should be able to scrape specific websites as requested by the user. This will allow the user to gather data from these websites and use it within the program for comparison information.

-Be able to parse a database files written by Cieca and can be opened in excel. 1 customer has 8 files. Each file is a different piece of information. For example, one file is a name, a different file is a vehicle, a different file is insurance, etc. Must be able to parse it, be able to edit in our program, and then export it into the exact same file type in a seperate folder.

- login integration: The program should have the ability to integrate with a login account. This will allow us to control users access. We should have control to turn on or off access, see their name, email and user should be able to reset their password. This will be linked to Stripe for subscription checks using their api. On startup, it should also check for updates, and be able to update automatically.

The flow of what we need works like this. We want the program to login, then display some basic information that is scraped from the spreadsheet. If user clicks on that file in our program, then it opens up and the program displays the automobile parts. It will then allows us to edit certain aspects of the data (will discuss further with candidates) it will display that data. With the push of a button, we can edit it to add some words before the description, or we can edit each line description and price manually. We then apply it and press the export button. The program then exports it in the same formats to a different folder,

The purpose of this is to find and purchase car parts. What we need our software to do, is to grab the exported field from file A, and allow us to edit certain aspects (will be discussed), and then export it into folder c. Let's call that one "module" of what it can do.

Module 1 - pulls file A, displays data, allows us to edit the words, then press export into folder B

But our program has additional modules.

Module 2 - this will gather data from file c (it's a price and part number), as well as price and part number from file A, and then scrape eBay and Amazon, and 2 other sites (we will discuss with candidate) and our google spreadsheet and display them. It should have the option to choose some variables for eBay and Amazon (such as shipping time, buy now, auction price, condition, etc). It should then display each price and we should be able to put the mouse over it and it displays those properties I mentioned above). It should also have be a link. So if it displays the price, and we click on it, it opens up that website page. We should have the ability to have it pull the data and let the user decide. For example, if there is multiple parts for sale on eBay, then it should have a drop down where it listed the different options (price and shipping time). We should be able to click each of them to open up the web page, and choose which one we want within the program. (Under settings, we should be able to choose how it displays, lowest price plus shipping, lowest price, fastest delivery, etc). This way it displays each of the parts from each possible locations for us to make informed choices on where to order from.

Module 3- have a place to put specific information. (Will discuss). So we could choose an "insurance company" and it displays some information from the file that is in file A. It also has a place to add numbers (will discuss what is needed), and press save. This will save it to this file based on information from the file (will discuss what specifically). It should also display any history of change. For example, if we add $65 for one part, but last time it was $63, then both should be displayed. As well as highest number for that location. Meaning if I am using this program at business 1, then it lists only the highest of business 1, basically "my history".

Module 4 - allows that information from folder A to be used. Based on that file, we can extract some data. On our Google drive, we have updated information that is used. We will call it a letter to mail somebody. But it is a template that has variables. For example, a customers name. So on our program, when we choose that specific template (there will be many), it may have the letter written out, but have {NAME} where it will be replaced with the name based from the file we choose in folder A. So when it shows that letter in the program, it now says the customers name instead of that variable. (We will discuss the variables needed). It then needs to be able to be printed or create PDF file in the format of the template.

Module 5 and module 6 are not part of this, and I don't want to discuss here as to not confuse anyone, but please now, that will be future work.

The program should sync with our server to make sure it is updated automatically, as well as check to make sure we have granted them access. All files should be uploaded to our Google drive, not theirs. But also have the main templates that don't change, but they should be able to upload their data for certain aspects. For example, if they add a dollar amount for a certain file, it should be updated on our drive, but it is referenced in their computer.

This means that the program should have a user-friendly interface that allows the user to easily navigate and use.

Ideal skills and experience for this job include:

- Experience with Google Drive API

- Preferably Experience with Cieca standards

- Experience with Stripe API

- design aspects for use ability

- file types I know it uses when it's exported into folder A. The files are labeled with the following extensions ad1, dbt, lin, ttl, pfh, pfo, type 1, env

-must have experience and efficient with time

-this is not an hourly project.

데이터 처리 Google APIs Google Sheets 프로그래밍 UI / User Interface

프로젝트 ID: #37428928

프로젝트 소개