Project Details :
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
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
14 freelance font une offre moyenne de $205 pour ce travail
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
Here you can put your comment. This comment will be added with your bid. Please see doc file for more information
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
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
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
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
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
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
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
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
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