All oDesk Jobs » Search Results » Job Facts
 oDesk Verified
Payment Method
Flag as inappropriate
Process of a CSV File
Open
Date Posted:October 30, 2009
Planned Start Date:October 30, 2009
Type:Hourly
Main Category:Software Development
Sub Category:Desktop Applications
Skills: Python
Visual Basic
.NET
more
Estimated Workload:Part-time - 10-30 hrs/week
Estimated Duration:Less than 1 week
Last Buyer Activity:October 30, 2009
Candidates: 66 - average $13.39/hr
Interviews: none
 
In Progress
Start Date: 
Hourly Rate: 
Last Date Worked: 
Hired Provider: 
Hours Worked: 
Offline Hours: 
Bonuses: 
Refunds: 
Completed
End Date: 
Feedback to Provider: 
Feedback to Buyer: 
 
Buyer Facts
Member Since:October 16, 2009
Country:Australia (GMT+09)
City:Adelaide
Jobs Posted:3
Jobs Filled:2
Jobs Not Yet Filled:1
Current Team size:2
Hours billed, last 30 days:57
Total oDesk Hours:57.17
Feedback Score: -
 

We have a financial csv file containing financial details that will be extracted from paypal each month.

Your job would be to process this file and categorize and summarize the contents.

You would maintain in a simple database (could just be a text file) a list of rules concerning categorization and report accordingly.

Essentially this is just a data extraction project with the ability of the user to add/modify/delete their own categories and choose which field(s) and part of/all contents of these fields are "defined" as a category.

This gives the ability to assign their own categories to any transaction in the csv file.

The CSV file contains both debits and credits (sales, money transfers, refunds, purchases, etc).

A debit transaction is a minus figure, a credit transaction is a positive figure.

Fee's are paypal charges in a separate field and need to be tracked as well.

To categorize a specific transaction the user should select

a) debit or credit

b) The Type e.g. "Refund" or "Payment Sent" or "Payment Received" or "Subscription Payment Received" (there are many others) - This maps to a field in the CSV file.

In the case of debits

c) The name (another csv field) would "map" to a specific user specified category

d) the currency (USD, AUD, etc), gross amount, fees, and nett figures (all csv fields) would be retrieved


In the case of credits

e) The item title (if NOT empty) is the major classification for category

otherwise if title is empty then the name and from email address is used as the category

f) the currency (USD, AUD, etc), gross amount, fees, and nett figures

In the case of e) and f) all are csv fields.

Some types see b) above are not to be included in the processing (you would ignore this record and not include it in figures).

Unless a record is "excluded" as per the rule about it should always be included.

For each "category" of records about you maintain a separate running total.

Note the "Category" shown here is the user entered category (see below).

At the end of the file, you would create a summary file showing all categories, number of entries per category, and amounts (totals, and fees).

You would also create a new csv file containing a category code, date, and transaction reference (unique field in original CSV file).

Effectively this is all the "records" which have been processed, but assigned to their categories.

Another file would also be created containing all records that a category could not be found for (no rules were entered by the user). This is so the user could see the records, and then enter rules for these records, and re-process the csv file. Eventually this file would be empty as all records got categories.

All user specified categories would need to be permanently recorded in a database (might just be a text file) so that future processing uses these settings.

The user needs to be able to add/edit/delete these categories.

Finally, there needs to be a file that is created to record any tax payable or deductable for australian orders.

If an order is placed for a business in australia, 10% GSt is applicable, and if a customer makes a purchase and the live in australia, 10% GST is applicable.

This file would contain any records that meet this criteria so the relevant amount can be submitted to the tax department.

Both the details of each transaction and the overall total of GST for debits and total of GST for credits needs to be recorded, together with all transactions.

Determining whether a record is needing to be included as a "GST" transaction involves looking for several possibilities searches (all in the original csv file).

1) If the Country field has data in it, include if the value is "Australia"
2) If the email address for the record has ".com.au" as part of it.
3) If another field says "Non-US".

It will be a combination of 1 or more of these parameters.

There may be more minor functionality than listed here (to do with categories) but this is effectively what we are looking for.

The program can have a GUI Interface or just be command driven.

Any language is fine, but please indicate which language you will be using.

Thanks

Buyer's Assignment History
Provider From/To Job Title Billed Feedback
466670 10/2009 - Present SEO Forum Posting $66 (22 hrs @ $3.00/hr)
472724 10/2009 - Present SEO Forum Posting $137 (35 hrs @ $3.89/hr)

Candidate List
Title Name Initiated By Date
Expert developer with outstanding C/C++ skills Yasin Hinislioglu Provider October 30, 2009
Bassem Junior C#, ASP.NET, MS SQL SERVER, XHTML, and CSS Developer Bassem A. Provider October 30, 2009
MCTS C#,ASP.NET,Jquery,MVC,SQL,WPF Tasleem A. Provider October 30, 2009
|Experienced Virtaul Assistant||Web Developer Sadiqa Naeem Provider October 30, 2009
C++ Developer with wide range of skills(database, networking, hardware Sergey Zhukov Provider October 30, 2009
█ PROFESSIONAL DEVELOPER/ SCRAPER EXPERT-OFFICE MASTER█ Alex Cayoja Provider October 30, 2009
SyAdmin and DBAdmin with CCNA,CCDA,OCA,SCSA,SCJP(Java certified) Rizky Satrio Provider October 30, 2009
C++, OOP/D, 10 year experienced software professional Yuri Nikiforov Provider October 30, 2009
Accountant/ Bookkeeper/Excel/Peachtree/SAP/Qbook/Access/Data Entry Danissa M. Provider October 30, 2009
Java, Python, Django, Ruby, Rails, C++ Linux Developer Luis C. Provider October 31, 2009
Experienced database developer - exceeds expectations Mark Dillon Provider October 31, 2009
ASP.NET ,VB.NET, C#.NET,.NET 3.5, SilverLight, Developer Solution Mahmoud E. Provider October 31, 2009
VB6 & VBA developer Shaheed Md Khaled Provider October 31, 2009
.Net Developer For your urgent needs Raymond Uy Provider October 31, 2009
◆ College Graduate, Programmer, Tester - C#, Ruby ◆ Robert Dzikowski Provider October 31, 2009
Expert in web and window application ( 10+ Ex) Gyanendra Singh Provider October 31, 2009
Smalltalk Programmer Ajaya Ghosh Provider October 31, 2009
► MS Certified C#.NET/AJAX/ASP.NET/MSSQL/CSS/DHTML developer John Alvin Salamat Provider October 31, 2009
C# - VB.Net - PHP/MySQL - JAVA - MSSQL Server- Application Development Afzaal Ahmad Provider October 31, 2009
Software House Sajjad Yousuf Anjum Provider October 31, 2009
.Net, VB6, ASP, MySQL, MSSql, PHP, Graphic Designing, Kiran Babu Provider October 31, 2009
C#.Net,ASP.Net,VB.Net,J2ME,Windows Mobile,SQL 2000/2005 | Bangladesh Ashifur R. Provider October 31, 2009
Systems Analyst / Developer David Childers Provider October 31, 2009
10+ years of experience in .NET,ASP,PHP,Ajax,Javascript,SQL Server Ajithkumar A. Provider October 31, 2009
SCJP,SCWCD,SCBCD-Java,JSF,Struts,Hibernate,Spring,Oracle Manoj K. Provider October 31, 2009
DEVELOPER-ASP.NET 3.5,2.0,C#,VB,SQLSERVER-2008,2005,JQUERY,AJAX Zafar Gill Provider October 31, 2009
python/django/PHP/HTML/MySQL/C/C++/JSON Satya B. Provider October 31, 2009
C#.Net, VB.Net, RDLC, well suited to OOP and TSQL Golam Chowdhury Provider October 31, 2009
Experience in Core-Java,Jsp,Servlet,Js frameworks,Mysql,Joomla Somnath Jadhav Provider October 31, 2009
Microsoft Office 2000-2007 Expert and VBA/Visual Basic 6.0 Programming Randall K. Provider October 31, 2009
Cross Platform application Devloper Exp in C++/Qt/MFC/C# Vikas Pachdha Provider October 31, 2009
Chrome Chrome Infotech Provider October 31, 2009
Sr. Java/J2ME/Android/Blackberry/Web data scraping Developer Achint Mittal Provider October 31, 2009
VBA Programming, HTML Scraping, Excel Modeling, SQL, Financial Markets Marcus Lewis Provider October 31, 2009
Senior Asp.net developer for ASP/ASP.NET c#/vb.net/vb6.0/ Developer Sanjeev G. Provider November 1, 2009
Software/Systems Engineer Andre Brown Provider November 1, 2009
Software and Web Developer Anil Jain Provider November 1, 2009
2+ years web development and Python, C Programmer and Linux Sys Admin. Chen Allen Provider November 1, 2009
VBA Excel, ACCESS,SQL, VB.net, Programmer, Developer Manjunath L. Provider November 1, 2009
MS Access, Excel, SQL Server Developer / Relational Database Designer Emil Glownia Provider November 1, 2009
Web and Desktop .NET app developer, 5 yrs. exp. Vector P. Provider November 1, 2009
Progemmer / Developer Vihang S. Provider November 2, 2009
Qualified Consultant and Project Manager with 10 year of experience Alessandro T. Provider November 2, 2009
.Net 3.5/2.0/1.1,C#,SqlServer 2000/Asp Programmer Bhavna S. Provider November 2, 2009
Expert Developper(C#, C/C++, Java, PHP, VB.Net, XML,WPF, ASP.Net, JSP, Ayuk Egbe Bate - Eya Provider November 2, 2009
Software Developer, Programmer, Testing, QA,Project Management Sajid Abbas Malik Provider November 2, 2009
Software developer(data mining, statistic, machine learning, math, sto Superx X Provider November 2, 2009
★★Software Engineer/QA/Tester-Data Entry Process Automation Expert★★ M Talha Provider November 2, 2009
Fulltime C#, VB .NET, ASP .NET and SQL Server Developer Reno Enopia Provider November 3, 2009
Programming,Data Entry, Payroll, Bookkeeping Imran Ali Shah Provider November 3, 2009
C/C++/Python Developer Valery K. Provider November 3, 2009
Microsoft Certified Senior Software Engineer Vineet Kumar Provider November 3, 2009
VBA programmer for Excel George Brown Provider November 4, 2009
Software (Web-) developer Nikita Dyumin Provider November 5, 2009
Delphi/C# Oracle/MSSQL sertified developer Anatoliy Aksenov Provider November 5, 2009
Delphi/C++/PHP/MySQL Developer with AJAX/XHTML/CSS skills Dmitriy Makhnyov Provider November 5, 2009
Cheap Website Development(PHP and ASP.Net) and Windows .Net Applicatio Kaushik Mitra Provider November 5, 2009
Senior Software Developer. Delphi, DataBases, Desktop Applications Vladimir Sidorenko Provider November 6, 2009
Senior Web Application & Software Developer C# Asher Sargodha Provider November 7, 2009
.net programmer with C# Binay Rana Provider November 7, 2009
Expert in Vb.Net,C#.Net,Vb6,ASp,Sql Server,Php,MySQL,JavaScript,Ajax,W Suresh S. Provider November 9, 2009
Ruby on Rails, JavaScript, C/C++ and Java Developer Marcelo Castellani Provider November 10, 2009
Expert on web development esp. ASP.NET,Jooml 1.5,PHP,MySQL & SQLServer Muhammed A. Provider November 10, 2009
Delphi Developer Yaroslav G. Provider November 12, 2009
Programmer Analyst - MS Access, Crystal Report, Visual Basic Fred V. Provider November 17, 2009
Software Architect (VB.NET/DELPHI/MS-SQL/ASP.NET/C#),GIS,Biometric Hari Pratap Singh Provider November 22, 2009

Related Trends
Python Programmers
Visual Basic Programmers
.NET Developers
C++ Programmers
Delphi Programmers
MySQL Administrators