How to batch edit Global Database in XPSWMM

Mel Meng
2 min readJun 27, 2022


source: Innovyze Support Portal

XPSWMM provides a very intuitive point and click user interface, which makes it very easy for users to start building a model.

However, when it comes to batch editing tasks, the window centric workflow might not work too well.

In this article I’ll show you how to use XPSTables to batch edit Global Database in the spreadsheet like user interface. This applies to most of the database types.

RDII Database

For sanitary sewer modelling projects, the rain derived inflow and infiltration are defined in the RDII database.

If you have 20 basins to calibration, it can feel quite tedious to change the rainfall for all of your profiles. An easier way is to use XPTables.

RDII Database in XPTables

Go to XP Table and create a new RDII table under Global Database.

Populate the table with all the fields in RDII,

You might need to close the XPTables tab and reopen it to see the new table.

To change the rainfall profile in batch,

  1. select the rainfall column
  2. Click the block edit tool
  3. set it to the new rainfall profile



Mel Meng

Empowering Water Experts