WORK USING PHP AND EXCEL

Concluído Postado Mar 29, 2016 Pago na entrega
Concluído Pago na entrega

I sell bussiness databases. When a customer buys me i send him only 1 file in csv format. I send it by email and i share with them too an Excel file with some MACROS which do the next actions:

1- Create ONLY one file in EXCEL for all the activities. First of all i select my csv file and then This Excel file with all the activities is generated. More or less these are the actions executed:

• Put in bold the row 1 with the headings and give to this row certain background colour.

• For the rest of rows put a certain background colour.

• Extend the width of each field until the size maximum for that column, but in certain columns would be a maximum width.

• Respect the format of some columns when you convert the csv to excel. For example if you convert the column for the postal code you must give it to its column a text format because the postal code can start by 0 like this one: 08540.

• Make some replacements. For example in the columns with the provinces replace "A Coruña" by "La Coruña".

• Order the database using several columns.

• Insert autofilter in the Excel file.

2- Starting with the file generated in the step 1 create one excel file for each activity. These files must be placed in the folder "ACTIVIDADES".

3- Starting with the file generated in the step 1 create ONLY one file in EXCEL with all the emails (removing duplicated emails). These files must be placed in the folder "EMAILS".

4- Starting with the file generated in the step 1 create one file for each activity with only the emails. (removing duplicated emails). These files must be placed in the folder "EMAILS/ACTIVIDADES".

Now i have problems with those customers who have OPEN OFFICE or a MAC Computer. For this reason i am looking for a solution for all my customers.

Time ago a freelancer developed a php system to do all i have explained but he didn't end it. His system is in php using a library called PHPEXCEL and it works ok but when the csv file is big the system finish the process probably for a reason related with the config of my dedicated server.

These are the things i need to improve:

a) I would like to reduce the time it takes to do all the process. If i execute all the steps in a pc with a little database it takes a maximum of 2 minutes. However if i execute it now in the php system developed by this freelancer it takes more than 8 minutes. I think it takes too much time in the first step and perhaps you could improve it.

b) In the php system you can do the 4 steps one by one. Too there is a button to complete the 4 consecutive steps and create a zip file (the system does it now). I would like only to show the last button.

c) I don't want to have to give to my users login and passwords but you must do it in a way that the user of my platform can't see the file uploaded or generated by other users. Too you must take into account it's possible to have some users using this platform at the same time.

d) When the csv file is bigger than 2 MB the system doesn't finish the process like i explained probably caused by a bad connection with my dedicated server. You must find out this problem.

If you have read all my especifications you must write MAQUILLADOR in your bid.

You can test both systems reading the file enclosed.

PHP Arquitetura de software

ID do Projeto: #10075190

Sobre o projeto

8 propostas Projeto remoto Ativo em há 7 anos

Concedido a:

elsocio

MAQUILLADOR Hola, Me especializo en PHP, y conozco la libreria PHPExcel. Creo que puedo solucionar este problema. En el archivo word adjunto no hay ningún enlace al archivo CSV, por eso no he podido verificar Mais

$111 USD em 3 dias
(16 Comentários)
5.5

8 freelancers estão ofertando em média $212 nesse trabalho

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: P Mais

$210 USD in 3 dias
(247 Comentários)
8.9
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA/.Net/Webscrapping projects, hence i ca Mais

$210 USD in 3 dias
(21 Comentários)
5.0
DRD4tech

MAQUILLADOR I've read all your excel/csv details and I will be happy to discuss your project in chat. See you soon!

$250 USD in 10 dias
(6 Comentários)
2.9
axiomconsultants

Hi there, i have an experience of over 7 years in working on Php, Htmls, JavaScript, WordPress, MySQL, C, C++, JavaScript etc I believe I can help you in your project. looking forward to hearing from you to start i Mais

$200 USD in 10 dias
(2 Comentários)
1.9