Spreadsheet Parsing Scripts
$250-750 USD
Pagato alla consegna
This project is very straightforward: the client receives a series of spreadsheets that have comission based information. These spreadsheets need to be sanitized and parsed, and then have the data output in a CSV (with specific columns depending on the data and source spreadsheet) so they can be imported into another database.
The functionality will be simple: a user uploads a file to a page, and the server parses the file, generates the CSV and offers it back to the user for download.
The logical order is this:
1. Based on the file that is submitted, determine which parser should be used. (There will be 9 different parsers you need to create. One for each file format).
2. Prompt the user to confirm that the filetype is correct. (i.e., "This appears to be a XXX spreadsheet. Is this correct?" with a yes / no response).
3. The page will prompt the user to enter a month and year. (This will be used later).
4. The parser cleans up the file, and then matches the company names in the files to ones that already exist in the database table "company". This is accomplished by matching names directly to records in the existing database company table, and if there are no direct matches, then looking up an alias table to see if there are records there. For example. On one spreadsheet, "Widgets Inc" may be listed as "Widgets Incorporated". So, Widgets Incorporated is an alias of Widgets Inc. If there is no matching record found in either table, the page must prompt the user to match records. This prompt will need to use jQuery select2 for autocomplete and present options based on an ajax search.
5. Once all the companies are matched, the parser will parse out relevant data, and create the CSV file for download.
We will provide for you:
1. The database structure.
2. Sample spreadsheets for you to build a parser.
3. Base classes that already handle the database operations, which are based on [login to view URL]
4. The server and server support. (Debian 6).
5. Remote access to a sandbox computer upon which you can test the exported CSV. (Since the Exported CSV has to be able to be imported into another database, the test will be to take the exported values and import them in a copy of the real database.)
Other requirements:
1. The parsers must be 100% reusable objects. Inline scripting is not allowed unless absolutely necessary.
2. The [login to view URL] file must load each of the classes and loop through them to test and determine (intelligently guess) which parser is appropriate for a given file that is uploaded. The page must say: "We have detected a Widgets Inc spreadsheet. Is this correct?" As it loops through all the parsers that are in the parsers directory, it shoudl try each one to determine which parser is the appropriate one for that spreadhseet. The spreadsheets all have defining characteristics which you can use to perform tests on.
3. The object MUST be re-usable. They will be incorporated into a larger CRM project in the future, and we do not want to have to re-code anything. The larger project may end up using these as base / parent classes, but we do not want to have to re-code in order to do the future project.
Expectations
We expect that we will build the base page first, and then the parsers one at a time. We'll give the parsers to the client to test one at a time and incorporate their feedback as they go through it.
Additional Information:
This is NOT a complicated project. It's simple CSV parsing, and all the parsing logic can be hard coded in each class. All the lookups will be in a MySQL Database for ease of lookups, and the output file will have roughly 5-7 columns.
Rif. progetto: #5329094
Info sul progetto
Assegnato a:
Hi, Please find our quote for this project. I understand Prabal had discussed with you about the details. I don't know the exact time estimate and milestones that have been discussed with you as Prabal is looking at Altro
19 freelance hanno fatto un'offerta media di $449 per questo lavoro
Hi Hphinc. I can make the client server architecture for you that would reformat the uploaded file in desired format and offer it back for download. I have done various similar tasks before and I can manage one again f Altro
Hello, I am have read your requirements. I am clear with it. Lets start it right away :) Thanks
Hi, I would like to apply for this parsing project. Please contact me if you have any questions. Best wishes, Sasha
Dear sir, I've read your requirement carefully and understood it clearly. It's detailed enough. With expertise in both PHP, HTML5 and much experience working with Excel/CVS, I would be a good fit. Kind regards, LY
Can we discuss this in detail before start this project,to know more about us please check in Private Message. We have a team of professionals,they have more than 11 year of experience,so we can manage this work and Altro
I have read your project. I think I am the perfect man to do your project. Though my profile is new, I have worked on similar project in a team(freelancers). I will complete your project as short time as a man can do. Altro
we are qualified and reliable web (and desktop and mobile app) designer and Im interested in getting the APIs for you as well as designing/developing this app for you (and many more apps) that you want, if it is still Altro
