Another new feature of MEX V15 is the ability to Import data from within the main MEX interface. In this article we’re going to take you through the process of importing data directly into MEX using this functionality.
NB: While creating and modifying export functions is a relatively simple programming job for anyone with the required skills and some familiarity with the MEX database, if you require a customized import function your best course is likely to be to contact MEX to perform the custom work for you.
The Import/Export Data screen has an Import tab from which the various Import functions can be accessed. Each of the MEX Imports functions in the same way, but in this example we’re going to import Assets into the database.
It is important to note:
Now in the Template file in Excel:
(For more information about what fields are mandatory when importing, refer to the help guide section, ‘Importing and Exporting Data’, where there are tables available that detail this information.)
It should be noted that when importing into the Asset Register, if you are updating an existing record and any cell in the template is left blank then the field in MEX will remain unchanged. For example if you have left the Serial Number field blank in your template for an asset that has a Serial Number in MEX, then the Assets Serial Number will remain populated with the original value after the import has been processed.
If you require assistance creating a backup, contact your IT services – or if you are a hosted customer, contact MEX Support.
Prior to the import being processed the spreadsheet will be validated by the system. If any of the records are invalid for any reason you will be advised and given the option of either cancelling the import or proceeding. If you proceed with the import then any invalid records will not be imported. You can see the reasons for any records failure to validate by clicking on the "More Info" hyper-link as shown below.
At the end of the import process you will be advised of any issue with the import.
In the event that you import information that requires an addition to the MEX Control Files then this addition will be made automatically. For example if you are importing records into the Asset Register and you specify an Asset Type that does not yet exist in the Asset Types Control File, then the import process will automatically add the new Asset Type to the Control File. This means that you should take care with the spelling of any information in your spreadsheet that relates to a drop-down in MEX, as to not create a duplicate value (e.g. ‘Forklifts’ vs ‘Fork lifts’).
If you have any question or need our help please contact the MEX support team at email@example.com or call +61 7 3392 4777.
If you find that there are no templates for some of the items you want to import, please be aware that you will need to discuss these with our sales team. They can be contacted on email at firstname.lastname@example.org