ECMap uses projects to organize maps so they are easy to locate and use. Projects can be set up in any way that suits your business purposes, such as creating projects based on trading partners or business applications.
You can add a new project, modify a project, delete a project, select a project, export an entire project with all of its associated maps, or import an entire project and its maps.
When you set up your first project, the system creates an Access database file called projects.mdb. This master database file consists of three tables—mproject, mtable, and mxref—which contain information about all of the projects, maps, and cross-reference tables in ECMap. The information in these tables is updated each time that you add, modify, or delete a project, map, or cross-reference table.
The mproject table contains the names of all of the projects in your system. It contains all of the information entered in the following five text boxes on the Project window:
Project Name
Project Description
(Project) Directory
Contact
Phone Number
mtable contains the names of all of the projects and maps in your system. The project name links this table to the mproject table, and the project name/map name combination links this table to the mxref table. Each record in the table contains the name of a project, a map within that project, and the related trading partner information. The mtable table contains all of the information entered on the four tabs of the Map Definition window.
The mxref table contains the names of all the project, maps, and cross-reference tables in your system. Each record in the table contains the name of a project, a map within that project, and a cross-reference table used in that map. The project name links this table to the mproject table, and the project name/map name combination links this table to the mtable table. Since the same cross-reference tables can be used in more than one map, there may be multiple records that have the same cross-reference table name.
The mxref table contains all of the information entered on the Cross-Reference Table window.
When you export a project, ECMap creates a copy of these same three tables, but they contain information only for the project being exported. When you import the project, ECMap uses the exported project-specific information in these three tables to update the master projects.mdb database in the ECMap installation to which the project is being imported.
