Käynnissä

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

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: [url removed, login to view]

Taidot: C-ohjelmointi, tiedonsyöttö, tietojenkäsittely, Excel, Perl

Näytä lisää: excel data web csv, open excel files, csv excel, what is record in data structure, what is online data, what is numeric data entry, what is data structure in c, what is data structure, what is data in data structure, what is alphanumeric data entry, what is a data structure in c, what is a data structure, what data structure, what are data structure, request management tool, online help with excel, need of data structure, how to solution, flat file upload, data structure that, data structure solution, data request system, data entry management system, data entry alphanumeric, alphanumeric data entry

Tietoa työnantajasta:
( 2 arvostelua ) New York, Israel

Projektin tunnus: #406794

Myönnetty käyttäjälle:

AlxP

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

50 $ USD 1 päivässä
(0 arvostelua)
1.4

68 freelanceria on tarjonnut keskimäärin 123 $ tähän työhön

svet63

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, S Lisää

80 $ USD 1 päivässä
(61 arvostelua)
6.6
gangabass

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

80 $ USD 3 päivässä
(212 arvostelua)
6.3
spawar

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.

100 $ USD 2 päivässä
(50 arvostelua)
5.9
alexander2007

Please check PM. Thanks.

160 $ USD 4 päivässä
(32 arvostelua)
5.8
best4best

Please see PMB.

50 $ USD 1 päivässä
(107 arvostelua)
5.7
mtech2009

please check the PM

50 $ USD 1 päivässä
(18 arvostelua)
5.6
askfarhan

hi please see pmb

100 $ USD 1 päivässä
(9 arvostelua)
5.4
mdkass

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

50 $ USD 1 päivässä
(26 arvostelua)
5.0
ExactSystems

Please see detail on PMB. regards

390 $ USD 5 päivässä
(5 arvostelua)
4.6
ITservice

Hi, Pls. check PMB. Thanks

100 $ USD 1 päivässä
(7 arvostelua)
4.5
crajeshbe

Hi Good day, Don't waste ur single $$. Ready to start the project. Regards [url removed, login to view] B.E

50 $ USD 2 päivässä
(11 arvostelua)
4.4
wincent

quality work, ready to start.

150 $ USD 1 päivässä
(11 arvostelua)
4.4
marcinzygmunt

Check Your Private Message Box

50 $ USD 1 päivässä
(3 arvostelua)
4.3
MustafaSR

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

50 $ USD 1 päivässä
(18 arvostelua)
4.2
mahfuzmurshed

Please see PM.

100 $ USD 2 päivässä
(47 arvostelua)
4.1
crispymasala

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

50 $ USD 0 päivässä
(15 arvostelua)
3.7
zszabo

Solving with an excel VB macro.

75 $ USD 1 päivässä
(3 arvostelua)
3.6
vnb400

kindly refer PMB, Thanks

50 $ USD 2 päivässä
(6 arvostelua)
3.1
cheungkc

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 decid Lisää

75 $ USD 3 päivässä
(6 arvostelua)
3.1
TheMS

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

79 $ USD 2 päivässä
(2 arvostelua)
2.9