10 More Reasons to Like Arbutus (21-30)

  1. Variable arrays
  2. Directly read spreadsheets and access tables
  3. Wizard-wide data
  4. Summarized duplicate presentation
  5. Re-link directly to spreadsheets
  6. View entire file when editing layout
  7. Intelligent table deletion
  8. Temporary file prefix
  9. Pre-sort when Extracting or Exporting
  10. Hide tables and other objects

Note: The following 10 More Reasons to Like Arbutus are aimed at technical or advanced users. Questions or comments? Please contact us.

See: 10 More Reasons to Like Arbutus (31-40)

 

21. Variable arrays

Arbutus allows you to store many separate values in a variable array. Arrays are limited in size only by your memory (RAM), so millions of array entries are possible. Array values may be created either by assigning values, or through the use of the SAVE FIELD command, which will transfer an entire table column into a variable array. Arrays can be used to:

  • Store tabular information
  • Provide input to commands
  • Improve performance
  • Support customizable user interfaces through dialog boxes

 

22. Directly read spreadsheets and access tables

When reading spreadsheets or access tables, you can take a snapshot of the data at a point in time (flattening), or directly read the source without flattening. Flattening ensures the data remains unchanged. Directly reading it ensures the most current data is automatically used.

 

23. Wizard-wide data

When defining tables, the data definition area is the full width of the screen, providing the maximum view of the data.

5-4-view-entire-file-1

 

24. Summarized duplicate presentation

When analyzing for duplicates, the tabular output summarizes the result to a single line per key, showing the number of items duplicated. This provides a quick reference to the duplicates found, rather than a cumbersome detailed listing. Of course, each line includes a drill-down link that immediately lists the entire set of duplicates for that key.

5-4-duplicates

25. Re-link directly to spreadsheets

When accessing refreshable sources, such as spreadsheets and XML, you can directly re-link to a different source file (like a spreadsheet), even if the data is flattened into an intermediate file.

5-4-re-link-directly

 

26. View entire file when editing layout

When editing a table layout, you can view all the data in the table, even if it involves millions of rows. In addition to scrolling and page up/down, you can directly position to any row in the table.

5-4-view-entire-file-2

 

27. Intelligent table deletion

When deleting tables, the underlying data file is intelligently deleted as well. If Arbutus created the table data, then the default is to automatically delete the data file as well. Of course, you can still control whether the data file is deleted. If the table is an original source file (defined in the Wizard), then the data is not deleted.

delete27

28. Temporary file prefix

With Arbutus, you can specify an automatic temporary file prefix. If specified, Arbutus will automatically delete any objects that start with this prefix when a project is closed. This applies to any object type, including tables, indexes, and procedures.

prefix28

 

29. Pre-sort when Extracting or Exporting

When extracting or exporting data, you may specify that the table be pre-sorted first. This greatly simplifies the creation of appropriate data files.

 

30. Hide tables and other objects

Any objects in a project may be hidden to improve the user interface. This can be used, for example, to prevent intermediate tables from appearing in the Overview. This capability is also useful to ensure that only the ‘top level’ procedure is visible for selection.

Hidden objects can be accessed in the same manner as any others, as long as you know the name. This is typically not an issue, as most hidden objects are only referred to by procedures. With Arbutus, you can also show hidden items, should you forget the name, or need to access them for editing.

 

10 More Reasons to Like Arbutus (31-40)