Develop a Mac Application

We have a text file of government data that is 653.9 MB uncompressed it is the US DOT Federal Motor Carrier Safety Administration census file. The file contains tabular data in a plain text file each record contains approximately 170 fields and there are 1,497,640 lines or records in the file. Additionally the file is laid out like a CSV file but instead of using CSV delimited values it uses a tilde (~) delimited value.

Our project requires a programmer to write a runtime application that can take this file and parse out each record and each field and then submit the fields into a MySQL database. The app can interface with the SQL server or export the data to CSV or SQL dump files as long as the files are not too large to be imported and the data ends up in a SQL database.

Additional terms of the project.

We require a debugged compiled runtime version of the software that does what's described above and will run in Mac OS X Mavericks 10.10. If you prefer to deliver a Java, C++ Terminal File or Obj C Coacoa based interface we as long as it will run on Mac OS in JRE or Native Environment Coacoa or Terminal that's up to you.

We also require non-compete/NDA/IP rights to the work project.

We also require delivery of source code, documentation for any APIs or libraries used to create the project.

We will provide a copy of the data file via a link from our google drive.

For your review here are a few commands showing the first 10 lines of the file and a word count of the file.

FYI when we try to import the data with Excel using the data import utility it crashes Excel -- it's a big file.

Here is a link to a technical description of the fields contained in the data file:

[login to view URL]

Here is an overview of the datafile:

[login to view URL]

Here is a brief 2 line sample and word count:

A~C ~1018~VERNON PUNT~PUNT TRUCKING~~US~08~26285 389TH AVENUE~STICKNEY~003~SD~57375-6235~~6057324422~~6057324677~US~26285 389TH AVENUE~STICKNEY~003~SD~57375-6235~~46~F~MC~157777~~~~~A~~A~~~~~~1~~~~~~X~X~~~X~~~~~X~X~~~~~~~~~~~~~~~~N~0~6~11~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~6~0~6~C~0~4~~0~0~~0~4~4~~~~~~550000~500000~~~~~~~COMPASS0000001224~109~44~~2012~19740601~20131029~~~~~LS056SD~~20130827~1~~N~~VERNON PUNT~ROGER PUNT

A~C ~1034~JAMIE ADAMS~ADAM'S AUTO BODY~~US~08~515 NORTH 1400 EAST~ST GEORGE~053~UT~84770~~8016733800~~~US~515 NORTH 1400 EAST~ST GEORGE~053~UT~84770~~49~B~~~~~~~B~~A~~~~~~1~~~~X~~~~~~~~~~~~~~~~~~~~~~~~~~~~N~1~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~0~1~0~1~A~1~0~1~0~0~0~0~1~0~S~9095~19870519~~~0~5000~C~19871015~~~~~LS75WC1~109~33~~~19740601~20020128~~~~~LS056SD~~~3~~~~~

jamesmbp:~ james$ wc -l /Users/james/Desktop/[login to view URL]

1497640 /Users/james/Desktop/[login to view URL]

Taidot: C++ -ohjelmointi, Cocoa, Java, Mac OS, Objective C

Näytä lisää: ut source, jre 4.2, java develop 7, google tabular, code review for java, ask a programmer, a dot b dot c, server 2012 terminal server, big data java, obj c, mac os x 10.7, mac os x 10 6, mac os develop, mac os 10.3, write an mac application, ut software, sql l, sql commands, server mc, server 2012 administration

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #7620394

18 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, I am a Mac OS developer. I can create such an app. I have worked a lot with text parsing, including CSV, and created apps that interact with various databases. I understand that the file is large and cannot b Lisää

$777 USD 4 päivässä
(40 arvostelua)

Dear sir. To get me in here, will be one of your Gold. I am a high quality and top mobile developer. I have rich experiences in developing mobile app for over 5 years. Before felling in love with mobile apps, I had wor Lisää

$736 USD 10 päivässä
(16 arvostelua)

I am an expert in delivering customized scripts and softwares willing to discuss further about the project

$526 USD 10 päivässä
(56 arvostelua)

Hi, I have read your post and understood your requirement and I have great experience in handling -Native: iOS, Android (Objective-C, Swift, Java), PhoneGap, JNI, NDK (C/C++),Cocoa, Cocos2d game engine, OpenGLES, Lisää

$1030 USD 10 päivässä
(10 arvostelua)

Hello, I can get you Java application that does this work. I have few questions though. Please ping me if you are interested. Thanks Gokul

$300 USD 3 päivässä
(95 arvostelua)

Hi James, I have a couple of questions about your project: 1. I know it's not important for you, but do you need GUI for the app or we can make just a console app? (We can have both GUI and make app understand comm Lisää

$526 USD 5 päivässä
(13 arvostelua)

A proposal has not yet been provided

$526 USD 10 päivässä
(6 arvostelua)

Hi, For previous Mac OS X projects, have a look at clients' reviews section on my profile. I think it can be done in Python, could run from mac Terminal and exported via MySQL db dump. Feel free to ask further infor Lisää

$500 USD 7 päivässä
(32 arvostelua)

I like jobs with huge data and will be happy to help you. I prefer to deliver the Java application. I know many languages, but Java is simpler for me. I have Mac OS X for debugging.

$750 USD 10 päivässä
(44 arvostelua)

I'm expert in data parsing / processing with more than ten years of experience and many completed projects (see my profile for more details) that's why I'm sure you'll be impressed with my work. I can create Mac OS Lisää

$333 USD 5 päivässä
(59 arvostelua)

Hi, Thanks for providing opportunity to bid on this project. I am interested to work with you. Please let me know your convenient time for discussing about project. Looking forward to hear from you. Thanks for Lisää

$388 USD 10 päivässä
(18 arvostelua)

Hi, my name is Matt and I'd like to help you with the different approach. Yes, the problem is not the data but the tool for using it (Excel). And also creating a software to read it and parse it well can be error pr Lisää

$670 USD 7 päivässä
(6 arvostelua)

Hello, We are a team of software engineers with 6+ years of experience in professional software development. We would create the application in Delphi using the FireMonkey (FMX) framework. FMX allows creating nat Lisää

$750 USD 20 päivässä
(3 arvostelua)

Hi, I've checked the format of this data file, I can make an app that handles the big data file and export it to SQL server. Please contact me I'll work with you for it. Looking forward to working with you. Re Lisää

$350 USD 10 päivässä
(7 arvostelua)

Dear sir or Madam, I would like to offer something slightly different than you are asking. I have extensive experience working with major corporations (Morgan Stanley, Safeway Inc, etc) performing the tasks you need Lisää

$2222 USD 10 päivässä
(0 arvostelua)

I have Java and SQL programming experience (more than 3 years), I'm a bachelor degree student and I can deliver a good source code with clear documentation.

$666 USD 5 päivässä
(0 arvostelua)

Parsing text and inserting data into database is what I had done several times before using Java and C++. Having said that the data file will have to be evaluated first, if we really need any real programming. Pro Lisää

$277 USD 10 päivässä
(0 arvostelua)

I am a professional mobile developer. 
My rate is indicative of what the product will be like. I am sure you can find someone with cheaper rates but my experience is what you get and what you pay for. I have an eye Lisää

$722 USD 5 päivässä
(0 arvostelua)