vtiger Import XLS files as Taks

Project Details :

Current Situation

a) We use vtiger crm, for Project Management.

b) 1 Project --> Many Tasks

c) Tasks are created by a 3rd software NOT VTIGER. Tasks are sent to us by email attachments as XLS files.

d) We then have to add every XLS task to Vtiger.

Currently, in order to import XLS files into Vtiger, we use the following procedure

1. We manually Open the XLS file

2. We Convert it to CSV file using Excel Macro

3. We Upload/Import it to vtiger (through an external simple PHP system created 5 years ago, one by one -)

In other words we created a PHP script which:

a)Allow us to upload the csv file (CSV file is generated using an EXCEL macro which converts XLS->CSV

b)Reads CSV's file data information eg "data1","data2","data3","data4" etc

c)Insert data into vtiger dabase, in order to create a new task

What we want:

1. We want to modify/create new system where we will be able to Upload/Import XLS file directly to vtiger (without any macros,modifications,etc) Keep in mind that ALL XLS tasks files have the same structure.

2. We want to upload MULTIPLE XLS files at once.

Thanks for watching

Beceriler: Excel, MySQL, PHP, Yazılım Mimarisi, vTiger

Daha fazlasını gör: vtiger 7 import not working, vtiger import not working, vtiger 6 documentation, vtiger wiki, vtiger import contact csv, import xls files linux api, free vbs sample script import txt files xls, import as400 table using excel macro iseries driver, vtiger import big files, import xls files winfax, vtiger import contacts csv, vtiger import large files, import xls files mysql tutorial, import xls files mysql, csv vtiger import, import xls files corel, combine text files using excel macro, vtiger import csv, vtiger import database, import graphic files

İşveren Hakkında:
( 32 değerlendirme ) Limassol, Cyprus

Proje NO: #17080627



Hi 1. Can you share each type of Excel file 2. Do you want to upload each type of file one after one or single attempt? Thanks Sutharsan Jeganathan

%selectedBids___i_period_sub_7% gün içinde 277%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(48 Değerlendirme)

Bu iş için 14 freelancer ortalamada $205 teklif veriyor


Hi, I have experience of working on similar projects, I can update your existing script so it can import data from excel directly. If you are not available now we can agree on timing to chat and discuss on the proje Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(276 Değerlendirme)

Here you can put your comment. This comment will be added with your bid. Please see doc file for more information

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(72 Değerlendirme)

Hi, We are confident that we can accomplish the project as per your requirement. You are requested to go through our Profile to know our domain knowledge and our Services. We have done lots of customization on vTig Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(34 Değerlendirme)

Hi, Expert level VtigerCRM consultant & developer with 7+ years great industry experience in VtigerCRM itself. Please have a look at my profile and check the customer feedback: https://www.freelancer.com/u/BIBINGK Daha Fazla

in %bids___i_period_sub_35% gün içinde294%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(49 Değerlendirme)

I am a vTiger Expert based in Montreal Canada with over 12 years of experience. I did many vTiger project with similar tasks: - I did UI design for both Vtiger and its Customer Portal. - I did build new modules, e Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(36 Değerlendirme)

Hi sir hope you are fine and doing good... I worked with xls apis in java and in C# before... I can make this system in max 2 to 3 days... I think I have understood this and I can do it easily... Thanks please let me k Daha Fazla

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)

Hello Sir / Ma'am, I am having 7 years of experience on vTiger, Sugarcrm. I am ready to show you number of demo of customised crm application. Also ready to give references of my clients Waiting for hearing from Daha Fazla

in %bids___i_period_sub_35% gün içinde188%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)

Hi there, I’d like to be considered for your project. I’m a vtiger developer. For 7 years I’ve worked in development and so I am accustomed to working with all type of vtiger customization and integration . I hav Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

We are passionate team of developers. Till now we have competed in the local market and now we are hitting to the online market as we want to expose our skills and expertise to the another level. We have 6.5 years o Daha Fazla

in %bids___i_period_sub_35% gün içinde161%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Hello, I have experience in PHP and Excel reading-writing, I use PHPExcel library for these goals. The project will be a webpage, the user chooses several Excel files from hard or network disks and will send its to Daha Fazla

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

vbs could start an excel.visible=false instance to convert all xls in a folder to csv. from there FTP will upload multiple csv (or unzip on server folder) from there a single PHP webpage should be able to work th Daha Fazla

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)