app for iphone,ipad vehicle vin decode, and pictures to sql database - repost
$1500-3000 USD
Paid on delivery
Looking for an app for android devices for vehicle inventory
take picture of the vin bar code, decode vin to year, make, model, let the user update aditinoal fields manualy susch as, color, key, title, damage, etc
take several pictures of the car it self
Add vin number, make, model, year and all other user input to SQL database
Create a folder on driver /pictures/vin# and add pictures to it.
Read attached doc for functional plan and milestone payment plan: AEC app Database func
Server platform: WINDOWS SERVER 2008
Full copyright.
Specifications below, as i can not attach the doc
MAIN WINDOW
A) LOG IN
B) SCAN VIN
C) FIND CAR
D) TAKE PICTURE
A) LOG IN –username, password check user credentials from Comsprt_bobmack_Users table, if log in successful set AEC_Office from Comsprt_bobmack_Users, remember log in.
B) SCAN VIN – turns on the device camera for bar code scanning, scans the bar code, decodes information from vin_dec_table: aYear, Make, Model, etc.
1) If scan successful, search for existing VinID
a) If not existing VinID, create OrderID, decodes bar code from vin_dec_table and updates fields: aYear, Make, Model, opens NEW CAR window for user input for remaining fields see B).
b) If VinID found, change status to received, open NEW CAR window for field editing see, 1A) NEW CAR.
1A) NEW CAR –Fields: VinID (input from scanner), Make, Model, aYear, Color, Damage, New_Used, Keys, Running, Wheels, Airbag, Radio,
2) Include TAKE PICTURE at the bottom of the window see D).
3) If scan unsuccessful ask if user wants to scan again, or manual user input VinID, at least last 8 digits/letters to check if car already exists in the system, if no create NEW CAR see B) if yes go to existing OrderID
C) FIND CAR
1) SCAN VIN – see B)
2) Manual user input: search for VinID, open OrderID for editing and TAKE PICTURE
Note: For Manual user input: search by at least the last 8 digit/letters of the VinID.
If VinID is not found, ask user to “Add new car” by SCAN VIN or NEW CAR
If more than one search result, prompt to select correct car.
D) TAKE PICTURE - turns on camera on the device to take car pictures, and auto-upload to the server using FTP. Creates folder name: VinID on FTP directory. Add option to review pictures before submitting, delete function and re-take function.
1) SCAN VIN – search for VinID, TAKE PICTURES, FTP create folder VinID, upload pictures.
2) Manual search – user input: search for VinID - TAKE PICTURES, FTP create folder VinID, upload pictures.
Note: Need to be able to limit picture size. For Manual user search: search by at least the last 8 digit/letters of the VinID.
If VinID is not found, ask user to “Add new car” by SCAN VIN or NEW CAR
If more than one search result, prompt to select correct car.
MILESTONES
1) SCAN VIN barcode, check for existing VinID, if found update status to received, if no insert into new Order update status to pending. TAKE PICTURE several pictures, create on ftp folder name: VinID, and upload pictures.
2) User input for NEW CAR fields
3) FIND CAR, LOG IN
4) GRAPHIC DESIGN
Milestone payment plan:
1) Milestone %35
2) Milestone %30
3) Milestone %15
4) Milestone %20
Existing Tables:
Table: comsprt_bobmack_orders_tmp
Fields: OrderID (auto #)
Order_date (auto)
VinID (nvchar 50)
Status (nvchar 50)
Table: Comsprt_bobmack_Car_tmp
Fields: OrderID (retrieved from comsprt_bobmack_orders)
VinID
Make (nvchar 50)
Model (nvchar 50)
aYear (nvchar 50)
Color (nvchar 50)
Damage (Yes/No)
New_Used (new/used)
Keys (Yes/no)
Running (Yes/No)
Wheels (nvchar 50)
Airbag (Yes/No)
Radio (Yes/No)
Table: Comsprt_bobmack_Users
Fields: AEC_Office (nvchar 50)
Username (nvchar 50)
Password (nvchar 50)
Need table for vin decoding: vin_dec_table (See VIN Example doc.)
Create and API for integration into MS Server SQL database.
Project ID: #4873013
About the project
Awarded to:
23 freelancers are bidding on average $2955 for this job
Hi, With over 900+ Apps Developed, we are the leaders in Mobile App Development with expertise on iPhone, Android & BlackBerry. Please have a look on our Portfolio in PMB. Lets discuss the Project in detail. L More
Hi, our team is professional iOS, Android, Microsoft developer team. We can make this app for you. Please find detail solution in private message.
Hi, Thank you for considering our proposal and please contact us for further discussions. Please check your PMB for more details and portfolio. Thanks!
Hi, Thanks for posting an interesting project . we can deliver the project in full perfection. please check your INBOX for future communication. Best Regards, Siddhant Karkare
Hello, We are mobile apps and game development company having 4 years of experiences. Please check your PMB for more details. Thanks.
Hello. We will give you maximum return of your investment on the basis of Quality and Satisfaction. Just have a look at PMB.