MySQL Data Base

Budget $300 - $1500 USD
Bids 13
Average Bid $855

I only know the basics about this kind of stuff so I am sorry if I have left out and important information about what I need.

Briefly - I need a MySQL data base to hold transaction informatiand from my customers. Currently it is s pread sheet that a few of the staff in the office use and we want it to be a data base on-line so that we can all access it simultaneously. It is quite simple and is really just mainly used to keep track of an orders status eg. wether they are open, or closed, or wether more information is required etc.

Currently, I download some excel files from my internet banking each day, then add the days data to a spreadsheet and manually copy down formulas etc. I simply have not had time to do the basic VBA to automate it.

What I need.
------------
I need to be able to download the files from my internet banking, and then upload them to the data base over a web page. There are three files that come from the bank, each a different currency of that days transactions. So there are all the transactions for USD, EUR, and GBP. I am guessing each will need its own table.

Each of the files from the bank "does not" only have the current days data. So if I download the file today it may have about 100 records in the file covering a few days, and only 20 to 30 may be new. Each record is unique so when the file is uploaded only the 20 or 30 new files should be appended to the tables.

Once the new data is uploaded, I need to be able to view all of the pages together as 1 whole page will all of the transactions. I also need to be able to view all deposits, all withdrawals etc.

Each transaction is associated with an Order number which does not come over with the downloaded banking information so I need to manually enter in an Order number for each transaction. So there needs to be a feature where I can add an order number for each record.

I also need to be able to add a comment next to each transaction. The comments should be editable, and it would be good if a time stamp was automatically added when a comment was posted.

And I need to be able to change the status of each transaction and I should be able to rename any of the statuses and add more statuses if I need to. The statuses are sensitive so for now just make them status a), b), c), d), e), f).

Once there are records in there I need to be able to view the information filtered by status a), b) etc and also all together.

To access the data base there should be a sign on page which can have multiple users so I need the ability to create new users and passwords, and also to have a guest account with limited access.

Also some transactions do not have enough information to be able to work out what the order number is so I need to be able to view a page with all of the transactions that do not yet have an order number.

There also needs to be a summary on the pages that calculates the total amount outstanding on orders that have not yet been filled. This should be by currency. I also need another page that has the same thing but also allowes me to enter an exchange rate to convert all the currencies to USD, and also allowes me to enter in values of amounts we have in other accounts etc and then calculates what the surplus is.

Soon we will be getting data from other bank accounts as well and the excel files downloaded will have a different format in terms of the colums data is in etc so you should begin knowing that new pages will need to be uploaded and different colums will be used.

Oh, and 1 more thing, not all of the data is used from the pages now. Only some of the columms need to be uploaded.

This is financial information so needless to say it needs to be very secure and have no holes in it. Before payment is made a 3rd party will will check the code and the data base to make sure it is secure. If any holes are found you will need to fix it all before I release the escrowed money.

I think that just about covers it. I hope that is enough info, if not please let me know.

Thanks

Post a Project Like This

This project was awarded to

kallidan

Kalli is nothing short of fantastic. I had a project in mind but my technical knowledge was not so good so I didn't exactly know what I needed. Kalli walked me througjh the whole process and was very patient with my limited knowledge. Kallis quote came in cheaper than everyone elses yet there was no reduction in quality. This guy is a professional and everyone should just choose him right now for a top quality job at a very very good rate.
About the Freelancer
kallidan Profile Picture

I've been a freelance programmer for 21 years along working full time at several USA and EU based IT companies. Done various installations and programming for individuals and companies all around the world since 1998, ranging from simple page-hit counter to full-blown e-business solution. As a full stack developer, I'm comfortable with a variety of tool-chains and workflows, and I'm not shy when it comes to server administration or making DNS changes. I feel anxious when projects are not under version control, and I'm obsessed with the quality and cleanliness of my code. I'm comfortable communicating directly with clients, and juggling multiple projects with varying timelines and requirements. If you are looking for fast, reliable, and inexpensive service you have chosen the right programmer for your future project so do not hesitate to contact me today!

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • websoftinfo Profile Picture

    websoftinfo

    Delhi,  India

    Professional Website development and Software Services at affordable prices! Seven Applications is a web & Software develpment firm that specialises in providing outstanding value for money services for web design & development, flash design, web-site re-design and maintenance, e-commerce solutions, corporate style graphics creations and software development, Game development for Windows platforms. Why Seven Applications? Seven Applications is based in the heart of India.. Seven Applications has expertise in the latest web site design, website promotion and marketing trends, producing search engine friendly web design and fully managed technical solutions to offer you, the client, the very best solutions and a lot more bang for your marketing buck! Seven Applications's web site design and web site promotion services will generate sales for your business. We have a strong focus on the major search engines when we build a web site. We research your target sector and aim to produce a web site that not only matches your detailed brief, but that of your desired customers. By taking time at the outset of the project to correctly target our marketing efforts we are able to deliver quality enquiries and unique visitors to your new web site. We look at your main competitors, analyse the style and presentation of their web site design and web site promotion techniques and produce a site that will place you in the top slot in the major search engine listings.we have more then 1000 satisfied client. Seven Applications is also did a Software and web application. 1) Community script 2) Dating website 3) Script customization 4) Software development 5) Affiliate programme 6) Reservation systems 7) Oscommerce Specialist 8) Drupal and Joomla Customization 9) Ajax php Specialist 10) SEO friendly designs with W3C approved. 11) Poker softwares 12) Inventory, Payroll and POS software 13) wireless Applications 14) SMS Applications 15) SEO services 16) filesharing system 17) Freelancing website 17) Game websites 18) Poker game, slot mechine, Casino 20) Share Marketing website 21) AutoSurf website 22) ERP 23) CRM 24) Video Streaming 25) Link Building Seven Applications’s skills cover major modern technologies, computer languages and tools. Our expertise includes ASP.NET, VB.NET, C#, VC++, JSP, PHP, ASP, CGI Perl, Cold Fusion, VB, SQL Server, AJAX, My Sql, C, C++, C#, MsAccess, Javascript, HTML, Javascript, Dreamweaver, Frontpage, Flash 5 & MX, Director, Premier, Illustrtor etc.

    PHP, Perl, ASP, and XML

  • corporal Profile Picture

    corporal

    Atlanta,  United States

    Please check out my work at: https://www.creditcommander.com/CCCOM/default.asp? (Click on the Tour link at the upper right for a tutorial of credit and background software) http://www.microbilt.com/products_sdk.asp (Under the right-hand menu under Resources, click on Virtual Tour) http://www.premiereglobal.com/, http://www.microbilt.com/, http://www.microbilt.com/products.asp, http://www.mycity.com/ http://www.microbilt.com/news_press.asp https://www.creditcommander.com/CCCOM/default.asp? http://www.helpwithmy.com/content/support.asp and subsequent pages, http://www.helpwithmy.com/content/contact.asp, http://us.helpwithmy.com/content/home.htm, http://www.champboat.com/ http://www.elliottawesomesnacks.com/content/home.htm, http://www.billlesterinfo.com/content/home.htm, http://www.championshipgroup.com/content/home.htm, http://zone7.championshipgroup.com/backoffice/, http://www.readingrdi.com/test/home/index.asp?1

    PHP, Perl, ASP, and C Programming

  • kallidan Profile Picture

    kallidan

    Sungai Jodoh, Batu Ampar,  Indonesia

    I've been a freelance programmer for 21 years along working full time at several USA and EU based IT companies. Done various installations and programming for individuals and companies all around the world since 1998, ranging from simple page-hit counter to full-blown e-business solution. As a full stack developer, I'm comfortable with a variety of tool-chains and workflows, and I'm not shy when it comes to server administration or making DNS changes. I feel anxious when projects are not under version control, and I'm obsessed with the quality and cleanliness of my code. I'm comfortable communicating directly with clients, and juggling multiple projects with varying timelines and requirements. If you are looking for fast, reliable, and inexpensive service you have chosen the right programmer for your future project so do not hesitate to contact me today!

    PHP, Javascript, Script Install, and Linux

  • dims Profile Picture

    dims

    Kirov,  Russian Federation

    I offers professional, custom Perl and Database programming services to meet your Internet needs and requirements. I specialize in Perl programming, MySQL database design, (D)HTML, JavaScript and others. I have experience modify Perl scripts like XFileSharingPro, Freelancers etc. __________________________________________ Dmitry Serov Communication: Email Time Zone: GMT+4

    Perl

  • Naz75 Profile Picture

    Naz75

    Lahore,  Pakistan

    PHP, Visual Basic, and Website Design

  • thecloudkernel Profile Picture

    thecloudkernel

    Beit Shemesh,  Israel

    TheCloudKernel is an international premier specialist IT solutions and services company, that combines core technical expertise with a global business perspective. The company's key offerings include product development, migration, porting, re-engineering and e-commerce solutions. TheCloudKernel's state-of-art technology center is completely equipped with modern day technology aids and advancements. The skill rich engineering resource - a great mix of techno-savvy professionals and business-savvy managers from various industry verticals - is adequately exposed to internation al work culture. TheCloudKernel has a proven track record in delivering solutions on par with the best in the world. The company bases its business philosophy on the judicious blend of exceptional customer service and relentless innovation in using advanced technology. This repertoire of benefits translate into new levels of reliability and efficiency for TheCloudKernel's global clientele. Developing solutions that work seamlessly, maintaining global quality standards, TheCloudKernel equips its customers with the edge to surge ahead towards tomorrow, today itself. For faster development of top-quality software at very competitive rates, put TheCloudKernel on your team. TheCloudKernel is there from start to finish to ensure successful projects with a broad service spectrum from total outsourcing to collaborating with your team to boost software development productivity with coaching, mentoring, on-the-job training, help-desk and much more. From large public companies to small start-ups, companies trust TheCloudKernel to help develop the core software products used by their customers. TheCloudKernel specializes in developing software that delivers optimum results addressing real-world issues, while being reliable, easy to use, easy to maintain and easy to evolve. With its iterative "evolving milestone" process, TheCloudKernel can help you reduce development time and deliver better products. Even if your projects have little or no specs (or specs that may change), its process can lead you to the best solution. TheCloudKernel's expert developers have extensive experience in developing leading-edge software using Microsoft technologies. Its current focus is developing web applications for the Microsoft Technologies using ASP and SQL Server and Java Technologies using JSP and SQL Server / Oracle / MySQL. The company was established in 2001. We have in our team native speakers of many languages (mother tongue): Russian, English and Hebrew. Services: Server Side Scripting ASP.NET Active Server Pages (ASP) Servlets / Java Server Pages (JSP) PHP ColdFusion PERL Programming Languages C# VB.Net Java VB C / C++ PowerBuilder COBOL Delphi PASCAL ADA FORTRAN Architectures COM/DCOM Microsoft .NET J2EE Web Services Databases Oracle MS SQL Server Sybase MySQL MS Access DB-2 Foxpro Application/ Web Servers Microsoft IIS Apache Transaction Server Markup Languages HTML/DHTML XML/XSL WML Modeling and Visualization Tools 3D Studio Max AutoCad After Effects Front end Design Tools Adobe Photoshop / ImageReady Visual Interdev Macromedia Flash MX Macromedia Director MX Scripting Languages JavaScript VB Script Action Script Lingo System Analysis/ Projects management MS Project Rational Rose SELECT CASE tools HOW

    PHP, ASP, C Programming, and Visual Basic

  • wasimsohail Profile Picture

    wasimsohail

    Choa Saiden Shah,  United Arab Emirates

    ITech Computers

    PHP, Javascript, Graphic Design, and Translation

  • siamsites Profile Picture

    siamsites

    Assntits,  Somalia

    Freelancer.com sucks, don't use it. The only reason you see this message is that they don't even give you the option to delete your account.

    PHP, Javascript, XML, and Adobe Flash

  • princeraja Profile Picture

    princeraja

    H,  India

    PHP, Perl, ASP, and C Programming

  • CODINGTABLE Profile Picture

    CODINGTABLE

    NEW DELHI,  India

    We are one of the first-rated software outsourcing companies with a constant endeavor and dedication to transform ourselves as the best offshore software development services. At Matrix our focus is on quality offshore software development to global organizations and in the process we continually educate and keep ourselves acquainted with the latest concepts, tools and technologies. In short, it’s our constant endeavor to uphold the academic talent required to meet the business objectives. We have a state-of-art offshore development center in the Indian national capital region where we maintain an array of multi-disciplinary which forms the core of our capability to offer our clients with the benefits of quality yet cost effective software solutions delivered by team of experienced professionals. In short, our offshore software development center acts as an extension to our global clients where we aim at creating associations with our clients' who seek long-standing services. When a project handed over or outsourced to us, we follow a widely tested methodology which involves the creation of a dedicated offshore development unit comprising professionals having domain specific expertise. Likewise, we ensure continuity within the project. The quality practices in MATRIX is evolved through three distinct stages. The first stage was the creation of basic processes to handle all activities relating to order fulfilment. Many companies demonstrated this by aligning their Quality Management Systems (QMS) with ISO 9000 standards. This ensured consistent and orderly execution of customer engagements and provided a framework for measurable improvement. The second stage was associated with a focus on software engineering, which was often achieved by aligning the QMS with the CMM framework and undergoing one or more assessments at increasing levels of maturity. This led to a situation where India now has far more SEI CMM Level 5 companies than any other country in the world. The third stage was driven by the desire to institute processes, metrics and a framework for improvement in all areas including those relating to sales, billing and collection, people management and after sales support. This was characterized by companies aligning their internal practices with the People CMM framework and by the use of the Six Sigma methodology for reducing variation and assuring "end-to-end" quality in all company operations. The journey through these stages has ensured progressively greater engagement of the workforce both in terms of numbers as well as the degree, making the quality culture increasingly pervasive. This increasing engagement has also meant increasing use of friendly and accessible tools to automate workflow, to collect and process metrics and to facilitate collaboration across geographically dispersed teams. The journey has also led to the emergence of a culture of managing increasingly by numbers. The stages have not been strictly linear, as organizations have continued to build on accomplishments even as they moved on to the next stage. For instance, organizations certified to the ISO 9000 family are migrating to the new ISO 9000:2000 standards. Organizations assessed on the CMM framework are aligning their QMS to the new CMMI framework. Finally, organizations working on 'end-to-end' quality are continuing to invest and upgrade their CRM and ERP initiatives, to deepen the rigor and consistency of their internal and customer facing processes. Matrix's mature processes, proprietary methodologies, proven offshore development model and stringent Quality Management Systems minimize development cost; reduce time-to-market and ensure highest quality and cost-effective solutions for our customers. Matrix delivers sophisticated application development methodologies and highly effective prototype-driven Iterative and Incremental Application Development approaches ably supported by our proven offshore delivery model, mature project management practices and stringent software quality standards. These include: # Product development. # Customized development. # New application development. # Rapid application development. Matrix follows Software Development Process that is more conducive not only to type and size of project, but also to the clientýs requirements and budget. # Traditional SDLC based Waterfall Model. # Iterative Spiral Model. # Rational Unified Process. Irrespective of the Software Development Process followed, we have well-developed processes for: # Project Estimation and Initiation. # Knowledge & Responsibility Processes. # Critical Process Identification. # Defect Knowledge Database. # Defect History Management. # Risk Management.

    PHP, Perl, ASP, and C Programming