Get external "MWh" or "kWh" from website and import to MYSQL

Check if variable is "MWh" or "kWh". on external site on import IF kWh THEN divide by 1000 and show as MWh ============ more detail below Add another column to the Portal page table "lablelled Unit" The unit will either by "MWh" or "kWh" We need this because sometime portal gives MWh and sometimes kWh. It would be good to always display the data in the Portal table and on the Edit Project pages in "MWh". If the Unit column was set to kWh you would divide the number extracted from Sunny Portal by 1000 before displaying