Dear Freelancers:
DATA LOAD
We have a 6.4 vTiger system, we need a SIMPLE php TOOL that will load excel files directly into 3 custom modules built with module builder.
One module is a load of new entities with direct mapping of some 10 excel colums to vTiger fields.
The other module will only UPDATE a single value, needs to match a unique field and update another based on the column name of the excel.
The final module is a bit more complex, it will use a maping of a field on another CRM MODULE to fill a value, and the other 3-4 values are direct load.
All loads need to report errors of rows that where not able to be loaded and for what reason (sql error is fine)...
There's code that sends email if some value in one of the module is higher than a specified value, this code needs to still work in a way or another.
OTHER DETAILS
Enable history in 3 custom modules, as I can´t see the update history, ¿is it possible?
There is no search by 1 custom module for some reason, ¿is it possible?
Contact system ID to be forced to be equal to an ID in another field in the contact itself, then start contact ID numbering from the next apropiate one to keep numbering going forward from the last forced contact ID. ¿Is it possible?
Regards,
Akma
Hi,
We have hands on experience with Wordpress,Magento and are available to start right away!!!
Follow the link to our Portfolio and some of our previous work :
Portfolio: https://www.freelancer.com/u/CodeWolves.html
Ping us to discuss the details now.
Regards!
Code Wolves Inc.
Hi 1 Thanks for the invitation. I will be happy to help you with this "importation" tool. I will need more details during the project but I understand mainly what you want. Hope to do business with you. Thanks !
We are team of excellent developers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description for projects and we understand what you want so we are confident that we can do it easily in mention time. We assure you that you will be completely satisfy with our work. And after delivering your project if you feel some issue in understanding the projects then we will teach you free until you understand.
If you have any question then feel free to ask. We are here for you.
Thank you
Demon Developer Team
Hi, I have read through your project description. I will work as per your direction with 100% accuracy. And I will deliver your project before your timeline. I am waiting for your response to discuss more about the project. Thanks
Hi,
I am a PHP developer.
I will use any orm library to do the import and work with transaction so that you don't end up with inconsistent data. In order for you to see errors, I can make the program keep running (with a flag of failure) and store all the exceptions in a bag. Then at the end, transaction will be aborted and you will be presented with all the errors.
To enable history I will need to keep another copy of tables with additional field datetime. So whenever I am going to do an update, I will create record in the revision table.
>There is no search by 1 custom module for some reason, ¿is it possible?
Please explain this.
Contact system ID I think is auto generated, so after contact is inserted I will use the last insert ID and use that to fill in information in other tables which use the contact system ID.