Migrating database of Vtiger5.0.4-TB2 to v7.1.0

* 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