Encerrado

finish USSCM library inventory dbase - repost 2

Finish dbase project for tracking small inventory as books come in and go out. Bar-coded books are scanned into a text file with an existing third-party iPhone app and sent via email attachment to Mac OSX desktop mail. The user will drag and drop the attached file onto the target PYTHON application, which launches it, causes it to read the latest inventory .xls file, lookup in the in-house Hal Leonard/Mel Bay and external Amazon API details for new items, then update the inventory file by adding or subtracting its contents from the existing inventory then writing it back to its directory as a newer inventory file, named "[url removed, login to view]". The program avoids editing fields other than those in the dropped file. Program-un-editable fields may have hand-edited data in them.

This project is 2/3 finished and should be picked up by a programmer experienced with writing for python and MacOSX.


Programmer's notes to be done:
-Add/subtract operations with a StockControl spreadsheet file against an existing inventory file. The function headers are there but not implemented. It's currently just reading in the whole StockControl file to create the initial inventory file while I was getting the catalog lookups working.
-Spreadsheet may be updated manually.
-A simple user interface so you don't have to mess with a command line or use hardcoded file names. Ideally, the GUI would allow for editing the database directly with drag and drop without manually editing the spreadsheet file and re-parsing it.
-Amazon API lookup of item details for items not in Hal Leonard/Mel Bay catalogs (searching by ISBN, unsure if it can search by UPC too). It's possible that there may be alternative services for ISBN lookup as well.

Skills required:

Mac OS X

Python

Habilidades: Mac OS, Python

Ver mais: writing to text app, writing to a file in python, small project in python, searching os x programmer, searching app programmer, python writing to file, python writing to a file, new spreadsheet app, amazon editing services, python iphone app, writing bay, writing & editing services, spreadsheet API, small python project, operations inventory, leonard, data editing to text file, create an api with python, amazon inventory, text parsing python, spreadsheet amazon services, amazon simple search, gui implemented, ISBN amazon, catalog interface

Acerca do Empregador:
( 5 comentários ) somerville, United States

ID do Projeto: #5114487

2 freelancers are bidding on average $320 for this job

rohanjshah

Hello Professor, As discussed earlier I have understood the requirements. Django Framework we will use to create cool CRUD screen for Database viewing and editing functionality and we will find the files through MacOSX Mais

$250 USD in 7 dias
(8 Comentários)
4.9
NTechcorporate

Hi, Hope you are doing well! We have gone through your requirement and we understand that you are looking for highly skilled, qualified, and experience Python development team for your project. Our developer Mais

$400 USD in 9 dias
(3 Comentários)
4.8
suraj99p

I am expert python programmer. I can do this task. I would like to go though current work. We can further discuss about the work.

$240 USD in 5 dias
(2 Comentários)
2.5