Use the following procedure to obtain the Module ID and Server Field Name for a large number of fields at the same time.
To obtain the module ID and field name in bulk
- In the Admin application, click Utility, and then click Show DB.
- When prompted, enter your MySQL user name and password.
- Enter the following query into the Schema name box:
- SELECT MODULEID,MEFIELDNAME,HOSTCRMFIELDNAME,BASETYPE FROM CFG_FIELDMAPPINGINFO
- Click Fetch.
A list of all Module IDs and the module's corresponding Server Field Names are returned, including the data source field name, and the type of field configured. You can copy and paste the information into notepad or a word document and save the information as required.