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