In Progress

app for iphone,ipad vehicle vin decode, and pictures to sql database - repost

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.

Skills: iPad, iPhone, Mobile App Development, SQL

See more: manualy, vin number, server database update android, decode the, create-app-for-android/, create windows phone app, car app, app database, android sql, android driver, android app read sql, repost windows phone, database app android iphone, ipad app inventory, vin ipad android inventory app, android create folder, create android key, mobile phone vin code, read sql server android, pictures model, vin iphone, mobile inventory, phone payment app, bar code database app, app model

About the Employer:
( 17 reviews ) Bridgeview, United States

Project ID: #4873013

Awarded to:

qitsol

We are iphone, ipad experts.

$3092 USD in 20 days
(38 Reviews)
7.5

24 freelancers are bidding on average $2944 for this job

WangJin

Hi, Sir. I am serious bidder. Please check your PMB.

$4123 USD in 20 days
(87 Reviews)
8.1
TeamValens

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

$4320 USD in 32 days
(12 Reviews)
7.4
hanzhen18

Hello Sir. Please check PMB!

$2577 USD in 21 days
(67 Reviews)
7.2
SevenStarInfo

Hi, Thank you for considering our proposal and please contact us for further discussions. Please check your PMB for more details and portfolio. Thanks!

$2800 USD in 40 days
(32 Reviews)
7.1
appstudiozsl

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

$3608 USD in 30 days
(8 Reviews)
6.9
WangJinHao

Hi, Can I see the document?

$3092 USD in 30 days
(45 Reviews)
6.8
ShenHua

plz check pmb

$3092 USD in 30 days
(55 Reviews)
6.6
lbear9090

Hi, Sir. I have 7 years experience in this field. I can do this perfectly, I am ready for you. Thanks.

$3092 USD in 30 days
(38 Reviews)
6.6
zhengnami13

Dear sir, Please kindly check PMB. Thanks.

$2680 USD in 30 days
(45 Reviews)
6.6
FreeSkyTeam

Hi, our team is professional iOS, Android, Microsoft developer team. We can make this app for you. Please find detail solution in private message.

$3608 USD in 30 days
(12 Reviews)
6.4
SICS

Hi, Please check private message. Thanks

$2577 USD in 30 days
(15 Reviews)
6.3
wanggil

Hi, I have read your requirement carefully. I am an iPhone | Android software expert with rich experience. I have done many successful iPhone | android apps and games: single, multi-player, cocos2d, unity3d. And I More

$2319 USD in 3 days
(8 Reviews)
6.3
diamond1027

Hi dear, I am a mobile app/game professional developer. I have rich experiences on this fields for 7 years. You can confirm my results on my reviews and portfolio. I have checked your requirements in carefully. I c More

$2368 USD in 30 days
(29 Reviews)
6.2
hireafreeelancer

Please Check Your PMB!!!! Thank You

$3000 USD in 30 days
(42 Reviews)
6.2
itsnineit

hello i have gone through your requirement earlier too and am really interested in working on the same i think we did get the document before but not sure if you updated it furtther we can agree to your terms but on More

$4222 USD in 50 days
(7 Reviews)
5.9
pcasso

Sending PM

$2157 USD in 25 days
(22 Reviews)
5.8
neviasoft

Making your ideas happen! Please Check PM, Thank you.

$3684 USD in 40 days
(12 Reviews)
5.8
Brsoft1

Hello, Experts are here, please check PMB for more details. Thanks,

$2577 USD in 30 days
(14 Reviews)
5.6
NeoNoXtraOrdnry

Dear Sir, please see my reputation to make your decision. Please see PMB

$2842 USD in 30 days
(32 Reviews)
5.5
samitXI

I am ready to start this project..... thanks

$2680 USD in 40 days
(12 Reviews)
5.4