Project Detail

URGENT - Data Mapping from CSV or Excel File to Flat File  

URGENT - Data Mapping from CSV or Excel File to Flat File is project number 406794
posted at Freelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status:

Selected Providers: AlxP

Budget: $50-400

Created: 03/23/2009 at 20:50 EDT

Bid Count: 70

Average Bid:
$ 121

03/28/2009 at 20:50 EDT

Project Creator: DESIGNERSCOUT
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

Hello, help need urgently.

We have order management system, from where we can export the data as csv format. To deliver data information to forwarding (transportation) company, they request a flat file (txt file) in a predefined structure.

The flat files consists of 2 lines per our 1 datarecord (means in CSV one line, as one record, in output file two lines)

The first line is a header information line with 412 characters in 44 numeric and alphanumeric fields. The second line contains item related informations. Some fields are obligatory, most not.

The fields have predefined lenghts.
Alphanumeric fields must be filled with blanks right aligned to the predefined length if any entry, or just blanks if no entry in datasheet.

Numeric fields must be filled with zeros left alligned to the predefined length or just zeros if no entry in datasheet.

What we need: Any solution, that imports the data from our excel or CSV sheet, converts the data to its predefined format and length, and makes an output file according to the predefined structure.

We have no idea how to make this data mapping. Anyone has a tool or any idea to serve us with a solution in very short time?

Attached is a sample of our excel sheet, the description of the flat file output, and a sample of a final txt output (these is just sample output, and does not match with our excel data sheet).

cant upload files here. Please download from: http://www.s265001613.online.de/datamapping.zip

Messages Posted:9 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

150

1 day

03-23-2009 21:37 EDT

quality work, ready to start.

help

 

100

1 day

03-23-2009 23:51 EDT

hi please see pmb

help

 

50

2 days

03-24-2009 00:45 EDT

Hi Good day, Don't waste ur single $$. Ready to start the project. Regards C.Rajesh B.E

help

 

50

1 day

03-24-2009 19:04 EDT

Check Your Private Message Box

help

 

80

3 days

03-23-2009 21:20 EDT

I can do this job for you. See PM for details.

help

 

100

1 day

03-24-2009 01:12 EDT

Hi, Pls. check PMB. Thanks

help

 

80

1 day

03-24-2009 08:29 EDT

Excel developer since 1997. I know exactly what you need. As there is no such thing as ready made tool, I would develop in 1-2 days for you an Excel tool that would do the job every time you need it. Can do. Regards, Svet.

help

 

70

2 days

03-24-2009 01:09 EDT

Hello. Please check your PM. Thanks.

help

 

50

1 day

03-24-2009 11:15 EDT

Please see PMB.

help

 

160

4 days

03-24-2009 00:57 EDT

Please check PM. Thanks.

help

 

100

2 days

03-24-2009 00:12 EDT

Hi, I am ready to complete this work now, I have checked your sample and its ok for me. Interested to work with you long term, you will get the 100% quality of such type of works.

help

 

50

1 day

03-24-2009 00:56 EDT

please check the PM

help

 

50

2 days

03-24-2009 02:31 EDT

kindly refer PMB, Thanks

help

 

50

1 day

03-23-2009 22:26 EDT

Hello Sir/Madam. I have much confidence in your project. For more details, please check your PMB. Regards.

help

 

50

0 days

03-23-2009 22:58 EDT

**************************************** Dear Customer, An exciting proposal is waiting for you in the PM. Please check the PM from us. *********************************** Regards, Crispy

help

 

50

1 day

03-24-2009 13:56 EDT

Hello :) Have a demo ready, Pls respond for details

help

 

50

1 day

03-24-2009 23:08 EDT

Please check your pmb, thanks

help

 

100

2 days

03-24-2009 02:04 EDT

Hello, We have gone through the requirements. We can do the project in two days. One day for development and one day from proper testing. For more details, please open PMB. We have eminent group of Developers + Designer. We know PHP + MySQL + AJAX + XML in programming. We are looking forward to your positive reply and long term business relationship with you. -------------------------------------------------------------- About Us: We have very rich experience of OpenSource script installation like osCommerce, Joomla, CRE loaded etc. We also have expertise in technologies like AJAX, PHP/MySql. Thanks, Ankur LAMP Team

help

 

75

3 days

03-24-2009 01:13 EDT

Hi We have reviewed the sample files. The datasheet (CSV) file has errors 5;12 3;5;1.810 0 5;12 3;5;950 5;12 3;5;1.320 0 5;12 3;5;1.549 0 Apparently 'decimal' has been treated as a delimiter. We cannot decide where a number starts or ends. We are also unsure what is expected of a floating 6 digit with decimal. Please clarify.

help

 

50

1 day

03-24-2009 03:26 EDT

Hello, I'm ready to do your simple task. Regards.

help

 

390

5 days

03-24-2009 00:42 EDT

Please see detail on PMB. regards

help

 

50

2 days

03-24-2009 20:24 EDT

We worked a lot in data conversion and data manipulation and we are willing to develop a module for you to convert the data from CSV to txt with the defined format. I will implement it in 1 day and give you 1 day for testing and comments fixing

help

 

50

3 days

03-24-2009 07:44 EDT

Hi, I can create command line util witch understands either of two formats.

help

 

150

1 day

03-24-2009 04:30 EDT

I'm ready to start, please read PM for more details

help

 

79

2 days

03-24-2009 16:41 EDT

Hello DESIGNERSCOUT , I did such job recently. I can do this job in one day. The second day is for testing. For more details, please open PMB. Best regards, The MS

help

 

400

3 days

03-23-2009 23:05 EDT

Hi , I have 7 years of experience in developing softwares using Borland Delphi. I can develop a small conversion software for you to convert the csv file to txt file. Thanks, DelSystems

help

 

100

2 days

03-23-2009 23:25 EDT

Please see PM.

help

 

75

1 day

03-24-2009 03:06 EDT

Solving with an excel VB macro.

help

 

50

2 days

03-24-2009 07:34 EDT

this could easily be done by VBA Functionality. I've done several things like this on my job as IT-Consultant. The macro can be used manualy on each new CSV imported in Excel. As an Alternative i would suggest to build a small perl-script which does the job directly on the csv-file.

help

 

350

4 days

03-24-2009 18:37 EDT

I have completed a similar kind of project using a tool called Pentaho(kettle).Its a open source tool.I will develop the script using the tool and will pass it you.You will be able to generate the output file by just executing a batch file.

help

 

50

2 days

03-24-2009 05:37 EDT

Hi, Please see the PM for exact bid details. Thanks in Advance.

help

 

220

7 days

03-23-2009 21:06 EDT

(No Feedback Yet)

Dear sir or Madam , I would like to cooperate with you . I can complete this project ! Thanks !

help

 

400

180 days

03-23-2009 21:31 EDT

(No Feedback Yet)

rate of transformation is 1$ per word

help

 

250

2 days

03-23-2009 21:43 EDT

(No Feedback Yet)

I can do this project! please choose me! thanks a lot!

help

 

50

1 day

03-23-2009 22:34 EDT

(No Feedback Yet)

Dear sir/madam Can i done the job. Pls See P.M.B. thanks John pol.

help

 

100

1 day

03-23-2009 22:46 EDT

(No Feedback Yet)

I would appreciate your consideration. Hope we can do business together. -- Hugh

help

 

250

2 days

03-23-2009 22:58 EDT

(No Feedback Yet)

Why Me? Look at my profile and you'll see

help

 

150

7 days

03-23-2009 23:21 EDT

(No Feedback Yet)

Have experience in programming (java,C/C++) and Database. Confident about doing the work. Delivery time really depend on the work size but my estimation is 7 maximum. Please feel free if you need further information

help

 

200

2 days

03-24-2009 00:19 EDT

(No Feedback Yet)

I have an automated solution for you. I can design a sheet that will automatically produce the required outputs everytime you have a csv file. Just accept my bid and I will try to finish it within 1 to 2 days. Congratulations on choosing the best solution.

help

 

70

1 day

03-24-2009 01:00 EDT

(No Feedback Yet)

Hi It's easy to do. Regards, Iqbal

help

 

350

10 days

03-24-2009 01:27 EDT

(No Feedback Yet)

I have gone through all the data sheets you have provided and i notice that you when you extract the data it is with field delimiter ';'. I need to access to your system and provide you with a program which would extract your data in future in proper format as you desire and when you convert it into text file, it will change it one line header and respective lines as per your Order Lines Info (Article_number onwards details.). Rest other info is your header info. I can provide you with a solution.

help

 

100

1 day

03-24-2009 02:42 EDT

(No Feedback Yet)

i will do this project

help

 

50

1 day

03-24-2009 02:47 EDT

(No Feedback Yet)

Dear DESIGNERSCOUT! I have more then 8 year experience in VB&VBA and make similar job with data transformation for ERP Sunsystems.

help

 

170

3 days

03-24-2009 03:18 EDT

(No Feedback Yet)

Hi, I have years of experience in developing data entry applications where we produce outputs as per client's requirement on different format of CSV, Excel or LFP files. I can do this job for you and can provide a customised application to you for conversion or can do conversion for you on per file bases. Looking forward for your response. Thanks, Sarbland

help

 

100

2 days

03-24-2009 04:52 EDT

(No Feedback Yet)

We are an IT company and engaged in software application development for more than 12 years. Let us join hands and we'll ensure ZERO defect and on-time delivery. For the solution here, its an easy thing to do and we have past experience in fetching data from SQL database and preparing a flat file based for AS400 processor. Can execute this very comfortably withing 2-3 days with complete testing done. Will provide you algo for the program and if required, a detailed doc for the flow as well. Can be done using several programming language, will prefer to use Excel Macro in your case as for that no additional installation will be required. Please approve our bid and send us the actual files to proceed further. Thanks & regards, C & FP InfoCity Pvt. Ltd.

help

 

50

0 days

03-24-2009 05:06 EDT

(No Feedback Yet)

Please see my PM. Thank you for you best requirement. it clear. But I think may be there are some mistake about Article_description and Price field.

help

 

120

2 days

03-24-2009 07:12 EDT

(No Feedback Yet)

taking responsibilities

help

 

150

0 days

03-24-2009 07:45 EDT

(No Feedback Yet)

I bid it for $150 totally, include update and service in 1 year. And I am glad to help you with any problem about data processing. Please check PM, thanks!

help

 

50

2 days

03-24-2009 07:29 EDT

(No Feedback Yet)

We can do this job in one day. The second day is for testing. Best regards,

help

 

50

4 days

03-24-2009 07:32 EDT

(No Feedback Yet)

Hi, We can make this done as an error free reliable system. I was working in a SEI:CMM level 5 software company. Currently lost my job bcas of Lay Off. We have already started doing local projects. please visit 4urbeloved.com. We are ready to make this done even less than 50$

help

 

300

7 days

03-24-2009 07:43 EDT

(No Feedback Yet)

Hi, I have good exp in creating excel VBA macros and worked for container liner company. I can create a excel template for you which, will out-put flat file as required. Regards.

help

 

50

1 day

03-24-2009 08:16 EDT

(No Feedback Yet)

Hi, I can do this job. I am very dedicated and diligent worker. I can get the job done within time and I will try to exceed your expectations. Regards. AKVSRKRAO

help

 

100

15 days

03-25-2009 11:35 EDT

(No Feedback Yet)

hai i can complete in this work within 15 days, i am doing like this job for last 10 months, so please consider to give this job for me i can deliver within time and 100% accuracy, regards giri

help

 

150

2 days

03-24-2009 08:44 EDT

(No Feedback Yet)

Have a ready application which reads excel/CSV format and provides a comma delimited file. Would not need much time to write a application which would output a file in pre-defined format.

help

 

50

1 day

03-24-2009 09:06 EDT

(No Feedback Yet)

I can do it.our all applications have fascility to export data in text,excel,csv and html format.

help

 

100

3 days

03-24-2009 10:42 EDT

(No Feedback Yet)

Hi, ready to start. thanks.

help

 

200

3 days

03-24-2009 11:17 EDT

(No Feedback Yet)

I am a Computer Engineer with sound programming experience working in a reputed IT company. I can develop this according to all of your requirement. Hopw to hear from you soon.

help

 

50

1 day

03-24-2009 12:58 EDT

(No Feedback Yet)

I have implemented lot of such jobs. The code is ready only to be formatted as per your flat file.

help

 

121

5 days

03-24-2009 13:32 EDT

(No Feedback Yet)

Hi, Please check PM.

help

 

125

10 days

03-24-2009 13:38 EDT

(No Feedback Yet)

xasadadas scsdasasas

help

 

125

1 day

03-24-2009 17:13 EDT

(No Feedback Yet)

Zoid Technologies has done very similar work in the past. This is a "fixed length" data format, not specifically "csv", but that is not a problem.

help

 

50

3 days

03-24-2009 14:11 EDT

(No Feedback Yet)

I have been doing similar projects in different capacities. It is a very easy task for me to complete

help

 

150

1 day

03-24-2009 14:16 EDT

(No Feedback Yet)

Looking forward working with you... I have knowledge on the ff: PHP, MySQL, MSSQL SERVER, Visual Basic, AJAX, Javascript, photoshop and video editting. I worked many times on data conversion from one file to another.

help

 

50

1 day

03-26-2009 03:37 EDT

(No Feedback Yet)

We are have tool to do the work and can be completed in 1 day time. We can offer you the tool that can help you in furute without spending and money or time.

help

 

130

2 days

03-24-2009 21:09 EDT

(No Feedback Yet)

Please see PMB for examples and details

help

 

50

2 days

03-24-2009 22:49 EDT

(No Feedback Yet)

Hi, I have studied all your requirement, completely understand what you need and examined all the data sheets you have provided and confident to provide you a solution to your problem. Please consider me as alumnus of TU Muenchen with Informatik-Background. Best regards, alex

help

 

50

2 days

03-25-2009 01:19 EDT

(No Feedback Yet)

I m a software professional and worked for big firms. I would make sure that i utilize my skill set to the fullest and deliver the quality product in the given timespan

help

 

60

1 day

03-25-2009 04:28 EDT

(No Feedback Yet)

you don't need a freelancer to do it :) use OpenOffice :P

help

 

200

1 day

03-25-2009 06:38 EDT

(No Feedback Yet)

hi, excellent experience in vba programming

help

 

250

10 days

03-25-2009 06:47 EDT

(No Feedback Yet)

Hi,We are willing to work on this project. We also have more than 5+ years of experience in data entry things and C/C++ developments. Looking forward to work with you... Thanks. P2Psolutions.

help


    Bid on this Project