New Product and Feature Announcement

Note: RoAccess now includes RoLoader and RoQuery. They are not separate products.   There is no better value.

• Supports Rochade 7.x
• Visually Attractive screens.  End users prefer it.
• Build Stand Alone Applications
• Create Custom Item Display and Edit screens using Front Page!
• Different users can be presented with different screen having different attributes. Role based.
• Highly end user oriented
• You can implement true role based access.
• Screen content and buttons can be tailored at the user level. Conditionally remove or add buttons. Re-order buttons. Integrate new applications seamlessly.
• Large number of end user oriented options for display and content.
• Reports and applications are context sensitive.  They only appear when it makes sense.
• Create a true virtual hub for Rochade.
• Supports NameSpace attributes
• Support Rochade Extended Naming and Name Groups.
• Item Names can be up to 512 characters, including spaces, unusual characters and mixed case
• Handles all types of links, including L-Type and NameSpace
• Stand Alone RoLoader is for companies that do not use RoAccess, such as WEB Access or custom built installations.  This can bulk load text, value, link and even blob attributes, and create complete NameSpace hierarchy trees, complete with validations.  So now you can load just about all the data you can find.  You can write your own scanners or load linking metadata to fill in the where your scanners and busses leave off. For more information, click here.
• You can conveniently change the order of links in a link or NameSpace attribute
• NameSpace attributes can have fixed or sorted order
• NameSpace links can have link qualifiers.
• A number of enhancements for user created screens.
• Supports and enforces one link to an Item.
• When clicking the "Delete Detail Item" button for a master-detail link, there is now a warning popup that says "Delete Detail Item?" in case you accidentally clicked the delete button.
• Contains a large number of minor enhancements for display and processing of NameSpaces and user created forms.
• Implemented unique and strict order L-type link attributes.
• When listing Items that have the identical base name (like CUST_ID), but but have different NameSpace parents, the identical Items will be further sorted by the fully qualified parent names.  Now, when you have many Items of the same base name, it is easier to visually find specific ones by the sorted parentage names.
• User Graphic buttons can now have standard URL's attached to them. so when clicked can go to other company WEB based systems.  Before, graphic buttons could only start other RoAccess related applications.  For instance, the "application" assigned to the button can be like http://www.google.com
• When in Edit forms, both the single line and multi-line text fields now display using a monospace font.  This makes it easier to line up data that needs to be in specific columns
• You can list only the ItemTypes that actually contain Items.  Why show ItemTypes if they don't contain data?
• Default Path Report.  If you currently don't have a path report defined for a particular ItemType, RoAccess will generate a "Default Path Report" that will show absolutely all relationships an Item can have.  This is incredible power, because now, all ItemTypes start off with a pre-defined Default Path Report.
• Text attributes can contain HTML to give you all the flexibility that HTML can offer.  But to enter text with URLs and email addresses, you can still just enter them without needing to use HTML, and RoAccess will do the rest.
• The Command Interpreter now allows to optionally invoke the pre-compiler.  Now you can run in a normal and a precompiled mode which better emulates both WEB based environments.  Before, the pre-compiler was always invoked.
• Summary of Subject Area Logons.  Now you can see how many times each Subject Area / Project was logged into.
• The Procedure Version screen now also displays the version of the Rochade server.
• When you log in, you will be advised how many days until you account expires, per Rochade 6.20 user parameters.
• The extended search screen now has the "blue info" balls next to teach attribute so you can get an explanation of what each attribute is, conveniently.
• When logging on, you will be told if your account has been locked because of too many incorrect logins.

SQL-Like Complex Queries and Default Reports

• You can now interactively specify a SQL-Like Rochade query and see the results immediately!
• Handles Rochade extended names, NameGroups and NameSpaces
• Displays fully qualified NameSpace names
• The data manipulation language is RQL^TM Rochade Query Language, that is similar to SQL.
• You can specify the attributes to be retrieved of each Item of each ItemType that is returned
• You can specify multiple SEED Items or run the report on the entire ItemType.
• The RoQuery Engine understands links, and will automatically follow links as necessary
• There is a Default Report Writer that outputs HTML or Excel Spreadsheet.
• You can store these ad-hoc reports and run them as a "Stored Report" from a click of a button
• The Query Engine API can be embedded into a custom application to make complex applications easily constructed.
• RoAccess has a number of buttons that will automatically appear if RoQuery is installed to take advantage of its power and flexibility
• For more information, samples and screen captures, click here.

• Completely Web Based.
• Can be run in batch
• The easiest way to load data
• Simple.   You don't need XML knowledge
• No complicated parameter files
• Straight forward.
• Has many options, including powerful validations that can be run before the load to ensure only good data is loaded.
• Supports two orderings for fully qualified names: the RoAccess standard, which is lowest to highest separated by periods.  Also ASG's order which is highest to lowest ordering
• Supports writing NameSpace attributes in addition to normal link attributes
• Can create and load custom NameSpace RIMs
• Handles the population of the IDENTIFICATION attribute many of the standard ASG RIM utilize.
•  Supports loading of NameSpaces and NameGroups
• supports and enforces one link to an Item.
• supports and enforces multiple links to an Item, but each Link Qualifier must be unique.
• Item names can have parenthesis () and commas in them.
• If an Item Name in a link has parenthesis in its name, then tilde (~) characters can be used to identify the link qualifier.  See the OPTION=ALLOW_PARENS_IN_LINK_TARGET section in the RoLoader on-line help.
• RoLoader now gives you a real-time progress indicator telling you what row in the spreadsheet it is currently processing. This is great for long running load jobs.
• A new validation. If you are updating Items that should already exist, you can now verify they do indeed exist.  This is a companion validation to the case where you are loading Items that should not exit and you can verify they do indeed not exist before loading.
• Displays the row number that is being loaded. Helpful for long running load job
• Do not wrap link lines if they have extremely long link qualifiers
•  Automatically correct "cell format errors" when the .tsv file is generated by a program.  Several classes of tsv errors are not tolerated.  This makes creating specialized extract and reformatting programs creating RoLoader files easier for you.
• For long running loading jobs, it pops up a progress window that constantly tells you which line in your spreadsheet file is currently being processed.  Then writes "Finished" at the end. 
• When batch loading large numbers of blob/binary attributes with files (like Excel, MSWord), allow blanks in file names and directories which are common in Windows file systems.
• A "Finished" button.  After RoLoader completes, you can now click the "Finished Button" to go back to the Item screen, and not have to hit BACK three times.  Again, a user friendly feature.  Especially when you have a lot to do and you are in a hurry.
• RoLoader now uses the colors in your user level Cascading Style Sheets.
• When bulk loading links, RoLoader will now automatically convert the target Item names to upper case if that ItemType is defined as upper case names only.  This is a convenience, so you do not have to spend your time making sure the case of names is correct if the target ItemType is capitals only.
• RoLoader has a special option that will allow you to load links that point to  ItemTypes that are not currently in the Subject Area.  See the RoLoader documentation  for details.   This will defeat the normal link attribute validations.
• When the RoLoader initial page displays, a popup now displays the number of rows of data that RoLoader has found, and asks you to compare that with the  number of rows in your spreadsheet.  We have found a large number of older spreadsheet
     data that have data formatting errors.  This will help to detect these so they can be repaired and subsequently loaded.  This will help to assure all data quality before loading.
• Display the number of new Items created and the total number of Attributes written
• all RoLoader to provide the default DEFINITION (time stamp and user name).  This means a file with only one column, ItemNames, can be used to create all those Items.
• provide a number of advisory messages like: No data to load, no columns selected to load.
• Now a file containing a single column (ITEM_NAME) can be used to either create Items (assigning the default DEFINITION) or delete Items.  This file can come as an export from other systems.
• You can now load the default value for Text Attributes if the cell is null.
• There is an advisory message that warns you if you have disabled all columns for loading or there are not columns to load.
•  some very old spreadsheets contain invalid characters in the data, that show
     up as little squares in Excel.  RoAccess now ignores them.
• Long URLs (hyperlinks) that are being loaded are no longer wrapped or truncated.
• More RoLoader explanations and examples.
• Handles extremely long, complex text cells from Excel.
• - Very long link qualifiers can be loaded When bulk loading links, RoLoader will  now automatically convert the target Item names to  upper case if that ItemType is  defined as upper case names only.  This is a convenience, so you do not have to  spend your time making sure the case of names is correct if the target ItemType is capitals only.
• - Fix: Corrects a bug in wrapping long lines.
• - Change: Delete Item: In no Items are selected to be deleted, a message says so.  Before, it just said "success".
• Do not wrap link lines if they have extremely long link qualifiers
• Now all TEXT attributes will receive the "Overwrite or Append" radio buttons by  default,  unless it is defined as a 1 line field in the RoAccess extended metadata.  Also, the DEFINITION attribute also receives "Overwrite or Append" radio buttons.  Although Rochade defines the DEFINITION attribute as only one line, it is common knowledge that the DEFINITION attribute is loaded with multiple lines by Rochade scanners.  So RoAccess will no longer enforce a single line for the DEFINITION attribute for data loading.
  - Handles extremely long, complex text cells from Excel.
• RoLoader bulk loads blobs/files.  For large scale document management projects,  you can conveniently load documents, files, graphics, charts, images, spreadsheets, etc. Click here for more info.
• you can now load link attributes where there are multiple target ItemTypes.  Click for more info.