Lukket

Data Conversion Utility

Following are the requirements

1. we have to store/load export and import data of different products across the world from source files to predefined database tables

2. we have 6 db tables, 3 tables to store import data and 3 for export data.

3. 3 tables for export and import because we have to store export -import data of 3 different countries viz. India, USA & China. All of them have different fields. Accordingly, our target db tables have 14, 34 and 37 fields for both export and import.

4. Source file extensions could be txt, csv, xlsx or pdf

5. Source files may have not just different format but different data headers as well. For eg. If i get import data of India for this month in '[url removed, login to view]' file and I do have a field in db table named 'port_code' which is mapped to column name 'port_id' of [url removed, login to view], next month in '[url removed, login to view]' we may have 'offshore_port' column which has to be mapped with 'port_code' of db table. So need a way to map input fields with db table columns each time before loading data. This is because we buy export/import data of each month from different data provider. Each provider give data in their own format. so field name may vary in source file so will have to map them to our DB target table.

6. We have to read the file name and store it in 'month' column of db table

7. input files will have a field 'amount' which might be in dollar. so we need to convert it in INR before loading in db. Conversion MUST be as per the conversion rate of the date of transaction.

8. we have to load import export data thrice a month i.e. once for each country

9. Number of rows for import or export for one country will be appx. 20-25 lacks i.e. 6*(15-18 lacks)

10. Considering #9, please suggest hardware as well

11. not looking to buy any licence of any paid software

Færdigheder: Business Intelligence, Data Warehousing, Excel, Java

Se mere: pdf word conversion data entry projects india, pdf doc conversion data entry jobs, ocr conversion data entry projects, jpeg conversion data entry, free pdf word conversion data entry copy past project, data conversion data entry jobs, database testing conversion data, conversion data analysis, company profile data conversion data processing, utility importing data quickbooks, windows utility saves data, conversion data type sql 2005 stored procedure, utility excel data, max post conversion data size, conversion data entry projects

Om arbejdsgiveren:
( 0 bedømmelser ) Delhi, India

Projekt-ID: #12548856

22 freelancers are bidding on average ₹9343 for this job

₹12222 INR in 3 dage
(18 bedømmelser)
4.3
smb310570

Different format and different data headers ? CAN we have all possible "data headers" and "data formats" so that we are able to read the data for our target database ? Please remember to see my MS Access database Mere

₹12500 INR in 10 dage
(7 bedømmelser)
2.3
nevo1234

Dear sir I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. feel free to contact me over Mere

₹7777 INR in 30 dage
(4 bedømmelser)
2.1
stocktimemachine

I deliver quality work and If you're looking for a freelancer that's responsive, effective and on time, look no further. Let's work together to accomplish what you need All our software installation files are complete Mere

₹4444 INR in 30 dage
(1 bedømmelse)
1.5
javacontext

MORE THAN 6 years of JAVA Coding experience. Abstract of my expertise are: -Data conversion to and from various file formats -Web Scraping & Developing Web Scraping Tool -Struts/Spring/Hibernate -javaSc Mere

₹17777 INR in 18 dage
(1 bedømmelse)
0.5
moganpondy

4# assuming that PDF will be in text format, not the image format 5# To address the different column header, we will do a mapping document that will solve the problem. I am planning to write a small utility to load da Mere

₹12500 INR in 13 dage
(0 bedømmelser)
0.0
sathiislam62

A proposal has not yet been provided

₹7777 INR in 3 dage
(0 bedømmelser)
0.0
ehtishamjaved444

I am a electrical technologist as well as i ha v done many jobs in different fields and i assure you that your work will be done according to your requirement regards Ehtisham javed

₹7777 INR in 3 dage
(0 bedømmelser)
0.0
₹10000 INR in 2 dage
(0 bedømmelser)
0.0
₹7777 INR in 3 dage
(0 bedømmelser)
0.0
₹7777 INR in 3 dage
(0 bedømmelser)
0.0
eokjo

I have experienced this similar projects very often. I am one of the most appropriate people. Please reward this project to me.

₹12222 INR in 7 dage
(0 bedømmelser)
0.0
dixitdpatel92

I have worked on such projects at the biggest e-commerce platform in Japan. Having worked on Batch system for 2 years i have expertise in performing such tasks.

₹5555 INR in 20 dage
(0 bedømmelser)
0.0
₹8333 INR in 6 dage
(0 bedømmelser)
0.0
sreedam

I am working on hadoop,mapreduce and its tools like hive,hbase,[url removed, login to view] I am sure I will do your job properly.

₹11111 INR in 3 dage
(0 bedømmelser)
0.0
anavekar

A proposal has not yet been provided

₹8888 INR in 4 dage
(0 bedømmelser)
0.0
techarchs2

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have c Mere

₹8333 INR in 6 dage
(0 bedømmelser)
0.0
₹8888 INR in 3 dage
(0 bedømmelser)
0.0
nouman307

Hi ! I am ETL expert in database. For your project i will right you a simple free utility which will load all the data in database in one click. I have 4+ years of experience in data migration. Just recently i worked Mere

₹3333 INR in 3 dage
(0 bedømmelser)
0.0
₹7777 INR in 3 dage
(0 bedømmelser)
0.0