This file is used for Ecoreal iPM_DB only.

Database Generator is an Excel file with VBA , which is used to generate Product Database(Ecoreal iPM_DB) automatically.

All kinds of products has their corresponding parameters. And generally the same series of products has same parameters, but the value of each parameter of the Products belong to one serie is different.

In the follow picture, showed a series of product called Config_FS_NW. The header, which is highlighted in orange, is the parameters of Config_FS_NW.

The same Con_DB, such as Config_FS_NWZ0001, means they are corresponding to the same Reference No.. (Reference No. is the drawing number of the product)

Reference No. is showed in sheets("Ref.").

• Click Start in sheets("HMI") to start the Generator Tools.

• Parameters and their value is listed in the left listview. Actually I list the all parameters you may use in Ecoreal iPM_DB.

• Double click the item, if you want to change the value. You can choose the value you want or not in the form Filter. Click OK to confirm.

• Choose one item then click Clear(the bottom on the left_top of the Generator Tools), so that you can delete the parameter you do not need.

• Double click items in listview Ref Select to choose the corresponding Reference No. . Here is already set a library system, so that you can search the Reference No. easily. And you also can change the quantity etc.

• When all the options are selected, fill the Con_DB in the left_bottom of the Generator Tools. Then click the button Generator. A new sheet named by what you filled in Configuration is created, and the database is already generated.