In Progress

Java/Netbeans Project: Import Discount Bank Structured Files into a MySQL Database

For a detailed description open the included MS-Word file PROJECT20170102.DOCX.

This is just a brief summary:

OBJECTIVES

Write Java software to import structured text files into MySQL database. There are 17 file types and up to 18 files to import into 18 database tables.

The import is straightforward: every file is mapped to a table of the same name and the data is arranged in a simple way:

Each text line represents a DB record (unless it is a header row, and it is skipped) and each field has a fixed location and width. Except for one field, all fields are mapped ‘as-is’ One field is translated. The software that you will submit is a Java application that accepts a directory name and imports all the contained files into the database.

.

ENVIRONMENT

The project should be delivered as a portable Netbeans 8 project with all source code included, Java, SQL or whatever. A single project should include the library and the main module.

The base package name should bae [url removed, login to view]

The class that contains the interface is [url removed, login to view] and it is the class with the main() method.

SPECIAL INSTRUCTIONS

The library and application should support Windows and Linux operating systems. In 99%, if you take care to always use [url removed, login to view], and never use the symbol “\\” then you will be fine. NOTE: If I do not wish to find any “\\” in the code I will ask you to change it before accepting anything.

For the DB access Use JPA 2.1, either EclipseLink or Hibernate implementation.

Make sure that your tables support Hebrew OEM 862 encoding (This is only important for one table)

DELIVERY

Your delivery should consist on:

• MySQL script file to create the 18 tables into a database called ‘backoffice’. The names of the tables are provided in section ‎4 The Files.

• Netbeans 8 project with the name DiscountDataImporter with everything that is needed to build and run the application.

• The submitted architecture and code are expected to professional grade with clear, modular and object oriented design. I will reject ugly code.

Skills: Java, MySQL, Software Architecture

See more: data transfer text files mysql database, send files mysql database, uploading multiple files mysql database, script inserting files mysql database, php uploading files mysql database, create mysql database installtion script php project, access mysql database swing form netbeans, handling uploading files mysql database, import mysql files mysql database, reading xml files mysql database, php ajax uploading files mysql database, osommerce language files mysql database, ajax uploading files mysql database, upload files mysql database using vbnet, xml files mysql database

About the Employer:
( 17 reviews ) Yavne, Israel

Project ID: #12946295