Terminé

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

Compétences : Excel, MySQL, PHP, Architecture Logicielle, vTiger

en voir plus : 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

Concernant l'employeur :
( 32 commentaires ) Limassol, Cyprus

Nº du projet : #17080627

Décerné à:

radus28

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_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(48 Commentaires)
6.9

14 freelance font une offre moyenne de $205 pour ce travail

SigmaVisual

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(276 Commentaires)
8.2
fabest

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(72 Commentaires)
7.2
auriclesoft09

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(34 Commentaires)
6.3
BIBINGK

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(49 Commentaires)
6.5
TheArtist1

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(36 Commentaires)
5.7
hassanalvi95

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(17 Commentaires)
4.4
crmexpert001

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(14 Commentaires)
4.0
subhchaitali

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(3 Commentaires)
3.0
tjcg

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
2.6
voronkov

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)
2.5
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
1.6
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
0.0
skinduptruk

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 33 jours
(0 Commentaires)
0.0