Sedang Disiapkan

TXT to XLS

I need a website (i already have the domain and host) to do the following:

An user uploads a TXT file, and the website converts it to xls (giving it a very specific format).... and the user then can download the xls.

Detail:

-> We have 34 locations. Each location has an ID of 3 digits (035, 131, 177, 173, etc)

-> At the end of the day, each of the locations generate a TXT file, that contains info that they have to upload in a bank website. BUT they have to upload that info in a very specific XLS file. The main problem is that it is impossible to pretend that all of our locations could know how to open that TXT file, give it format, and finally save it as an XLS file.

-> So, we came up with an EXCEL macro, which I'm attaching ([url removed, login to view] and [url removed, login to view]).

-> The problem we have, and that is the reason we want to make a website, is that half of the locations can't execute the macro (because they have open office)

Things to consider:

The names of the TXT files always have the same structure... the only thing that changes is the ID of the location (3 digits) and the date (YYYYMMDD). For example:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

We do NOT need the following columns of the txt files:A, B, D, F, H, K, L, M

We only need the following columns of the txt files: C, E, G, I, J

SO, the structure of the XLS files go as follows:

In column A: the day (in strict DD format, for example if it's may 6th, we need it to be 06, if it's 3 we need it to be 03) of column E of the txt file

In column B: the month of column E of the txt file

In column C: the year of column E of the txt file

In column D: It always has to be 1

In column E: The amounts of the column I of the txt file

In column F: The same as in the previous column (I mean, columns E and F of the xls file always have to be the same)

In column G: The amount of the column J of the txt file

In column H: It always has to be [url removed, login to view]

In column I: It always has to be [url removed, login to view]

In column J: The names that appear in the column C of the txt file. Here we have looots of problems, because the names can't have ñ, Ñ, á, é, í, ó, ú, Á, É, Í, Ó, Ú, numbers, and characters like: .,%&; etc etc etc. We can only have from A to Z. And in spanish is very common to have ñ an á, é, ó, etc. You can see in the macro that it manually deletes or changes all strange characters that appear in the names.

In column K: It always has to be 7832

In column L: The value that appears in column G of the text file.

In column M: Here we have another problem. This humber varies from location to location... it goes from 17481934 to 17481957 or something like that. But I guess this could be solved if each location has a specific web address. I mean, [url removed, login to view] [url removed, login to view], etc.

The xls file can't have incomplete rows or columns, otherwise the bank website will reject it.

The final xls file has to have two sheet tabs: One that is informative... and the final one, that contains all of the info

At the end of the process, we want the user to download the xls file. The name of the final xls is not important, it could be "[url removed, login to view]", "[url removed, login to view]" or something like that

I'm attaching an original-unchanged TXT file... the final XLS (formato30062012), already converted. And the Excel Macro (Macro and formato) that could serve you as a guide.

Kemahiran: Reka Bentuk Grafik, HTML, PHP, Reka Bentuk Laman Web

Lihat lebih lanjut: web layout design download, two column web design, strange design, spanish locations, save date spanish, open office layout design, want make web, layout web design download, want design bank website, design web address, excel macro file location, e serve, xls, txt, macro upload, macro e, excel macro download file, excel macro txt, save txt excel, save common download, download host website, names spanish, php excel macro, php execute rows, excel macro php

Tentang Majikan:
( 4 ulasan ) Morelia, Mexico

ID Projek: #2326066

Dianugerahkan kepada:

poseidon4o

Hello, I am experienced PHP developer and I want to do this project for you. Please check the private message I have sent you for more information

$50 USD dalam sehari
(24 Ulasan)
5.0

8 pekerja bebas membida secara purata $48 untuk pekerjaan ini

HeNet

Freelancer servers are under high pressure and their system are not working correctly. Lots of bugs. Please do not accept any project and do not award. Thanks.

$30 USD dalam sehari
(21 Ulasan)
5.1
customapps

Easy job. I'd be using https://github.com/PHPOffice/PHPExcel and you'll need PHP version 5.2.0 or higher, PHP extension php_xml enabled, and PHP extension php_gd2 enabled. I can send you a small script to test if you Lagi

$60 USD dalam 2 hari
(10 Ulasan)
4.7
tomek1234

Hi, I'm ready to complete this task. Please Check your private message.

$50 USD dalam sehari
(7 Ulasan)
4.0
mpejic

I done some work, U could see it in your pmb. Contact about more details. Regards.

$55 USD dalam 2 hari
(9 Ulasan)
3.7
yalsoftwares

easily enough to be done in a couple of hours.

$30 USD dalam 0 hari
(12 Ulasan)
3.4
Baxter2008

Hello Pantrikki My proposal is to build you Php Script that will accept the text file, apply the conversions and create a xls file which will be able to be saved to the user's machine. The solution will require addi Lagi

$80 USD dalam 3 hari
(11 Ulasan)
2.7
prashushinde7

Hi i have 3 years experience as a web developer today is the first day of mine on freelancer.com please check my portfolio in my profile and please give me the opportunity to prove myself. please read the private messa Lagi

$30 USD dalam 2 hari
(0 Ulasan)
0.0
birgitzprinz

Hi Sir, I have 3 years experience with ASP.NET, HTML, Javascript. Please contact me if you want to. Regards Doan Cuu Linh.

$30 USD dalam 2 hari
(0 Ulasan)
0.0