Download (free software): BMEcatManager for Access
Data maintenance for BMECat2005 under MS-Access
The BMECat format is the ideal format for data exchange between companies, between the applications of companies, and also between internal and external applications within a company. A typical internal use case is the import of product master data via BMECat into Internet shops.
The BMECatManager open source project is a free software for the maintenance and output of product data for the BMECat (version 2005) data exchange format. With this application, Sepia provides you with your own data maintenance environment based on the Access database software included in Microsoft Office. The data model is relational and can be easily extended. The input mask allows you to maintain an unlimited number of products. The included scripts can be adapted and extended.
Simply add data fields according to the BMECat standard
The BMECatManager does not contain all possible data fields according to the BMECat standard. Users can therefore add individually required data fields to the application themselves. Access to the central location for managing the data fields is possible directly via the input form.
Import of existing data from Excel or .CSV
Access comes with an import wizard that can be used to easily import data from other data sources such as Excel, .CSV or other databases. This allows you to extend or update your existing BMECat data.
Easy adaptation of input masks
You can adapt or extend existing input masks as required. The existing mask definitions are open for development.
OpenSource export module
The included export module for BMECat2005 is written in Visual Basic for Applications (VBA) and can be adapted or extended with some experience in Office programming. In the provided form, the module exports all data, which can be maintained via the input mask.
Most important data fields from BMECat2005 already available
The database corresponds to the requirements for a relational data model. The delivered data model contains the most important data fields of the BMECat standard. If data fields or structures are missing, they can be easily integrated.
Download
Download (free software): BMEcatManager for Access