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.


-> 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 0.00

In column I: It always has to be 0.00

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.

Compétences : Conception graphique , HTML, PHP, Design de site internet

en voir plus : web layout design download, two column web design, things you need to know that a important in excel, strange design, spanish at locations, save the date spanish, save the date in spanish, open office layout design, m&t bank, m & t bank, l want make web, layout web design download, i want design a bank website, h.s.a. bank, how to open website, how to design a web address, excel macro how to, excel macro file location, c&f bank, c and f bank, e serve, i want to make our website one year, xls, txt, office macro

Concernant l'employeur :
( 4 commentaires ) Morelia, Mexico

Nº du projet : #2326066

Décerné à:


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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(24 Commentaires)

8 freelance font une offre moyenne de $48 pour ce travail


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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(21 Commentaires)

Easy job. I'd be using [url removed, login to view] 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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(10 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(9 Commentaires)

easily enough to be done in a couple of hours.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(12 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(11 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)