Blog Updates

Check out the latest updates from EnGraph Software

Use QueryBuilder to get a list of all places

30 July

Excel logo 2

With ParaPlan, getting data out of the system and into another format like PDF or Excel is easy. Here is a simple tutorial to get all the Places to Excel using our Query Builder.

  1. Click Reports > Query Builder.
  2. Click Load from text, a new window will appear.
  3. Copy the following text into the window, then close the window:

    Manager:PlaceManager
    Method:GetAll
    Shape:
    Where:
    Select:new (StopName, Address, Comment, ID)

  4. Click Execute.
  5. Click Export to Excel.

The list of all the places in the system are now displayed in Excel, where any number of formulas or manipulations could be performed.

Tags: