* About VtigerCRM
# Official Site: [login to view URL]
# Download Source Program: [login to view URL]
* Assumes
(a) Source Program:
# Vtiger version: 5.0.4 Test Build2
# MySQL database name: mysite_crm0
# MySQL database user name: mysite_crm0 (password: crm123)
# MySQL database user password: crm123
# Vtiger Installation directory: /home/myacct/[login to view URL]
# Access URL, [login to view URL]
# PHP Server version: 5.3.29
(b) Destination Program:
# Vtiger version: v7.1.0 updated 2018.0305
# MySQL database name: mysite_crm1
# MySQL database user name: mysite_crm1
# MySQL database user password: crm456
# Vtiger Installation directory: /home/myacct/[login to view URL]
# Access URL, [login to view URL]
# PHP Server version: 7.0
(c) Other Server Conditions:
# Web Hosting Environment with cpanel accessibility
What you need to do?
------------------------------
You will need to write a php program, named "[login to view URL]":
(i) it will be put in the Destination program folder "/home/myacct/[login to view URL]"
(ii) it will read its initialization file, name "[login to view URL]" which stores the source and destination database credentials
(iii) when accessed by [login to view URL], the migration scripts will read the source MySQL database data (Vtiger5.0.4) as listed below:
d1: "Contacts" and its "Filters"
d2: "Accounts" and its "Filters"
d3: "Products" and its "Filters"
d4: "Notes" and its "Filters"
d5: "custom fields" Settings of "Contacts"
d6: "custom fields" Settings of "Accounts"
d7: "Users" Settings
(iv) it will then re-arrangement the concerned database data so that they can be fitted into their corresponding destination database tables (vtiger7.1.0),
(v) and then write them to the corresponding destination database tables.
(vi) As a result, all Contacts, Accounts, Products, Notes, custom fields, Users, as can be accessed thru the source program (vtiger5.0.4-TB2), [login to view URL], can also be accessed thru the destination program (vtiger7.1.0), [login to view URL]
Your need to be very familiar with VtigerCRM and its database tables for both v5.0.4-TB2 and v7.1.0.
A real test sites (e.g. [login to view URL] & [login to view URL] ) with samples MySQL data will be set for you to work on once you have selected for this project.
========================================
Pls. be noted the followings:
* Contacts Fields concerned:
# Salutation
# First Name
# Last Name
# Mobile
# Email
# Created Time
# Modified Time
# Tag1
# Tag2
# Tag3
# Tag4
# Description
-> Remarks: "Tag1,Tag2,Tag3,Tag4" are custom fields
* Accounts Fields concerned:
# Account Name
# Phone
# Website
# Email
# Industry
# Created Time
# Modified Time
# Tag1
# Tag2
# Description
-> Remarks: "Tag1,Tag2" are custom fields
I have 5 years experience in setup and management of different Linux web hosting servers, Cloud Servers, Server Management, Server Security, Mailing Servers, Email Servers, SSL, Server Monitoring etc.
i will configure your server and email as per your requirement.I am working as server admin from past 5 years and have expertise in the task like this one.
I have a long time experience in managing complicated hosting environments and have solid skills in live migrations, tuning and performance optimizations over Linux OS
I provide so prompt project delivery, thus I perform my responsibilities precisely with my scrupulous attention.
Thanks