 |
 |
 |
 |
|
|
|
|
This document is divided into 3 sections. Click to go there:
RoAccess RoLoader RoPages
RoAccess Version 6.0 Major release.
(Prior major release was 5.60)
This release takes advantage of the Rochade 6 Extended Names and Name Groups. Item Names can be up to 512 characters. This includes path reports, graphics, spread sheet output, and Virtual Hierarchies.
RoAccess 6.0 requires Rochade 6.20 or higher, which has a number of fixes and enhancements in handling its extended names. The prior Rochade 6.0 and 6.1 are insufficiently stable in the extended names area.
Note: We recommend that you set RoAccess 6.0 in a parallel testing environment before deployment. While we have tested it, it is a major new release and may contain errors. As you know, we typically don't get many bug reports, so hopefully it is pretty stable.. Also, the new longer names and unusual characteristics of Rochade V6 may take some familiarization to fully utilize.
- Note: Re-Import
ROA_PROC.001, as new procedures have been added.
Installation notes: ROA_PROC.001.
- Note: Re-Import IMROACC.001 into
your Data Database.
Installation notes: IMROACC.001
Rochade Extended Names are supported. Do not use the following characters in a name: comma, parenthesis, @, ^, * , (, ), ", or colon as they typically have special uses in Rochade and may cause errors or unpredictable behavior. Item names can contain spaces.
For German users, if the System ItemTypes (like AP-MODELL) do not function correctly, try switching to using the English version of the System Item Types (@sys_types in AConfig.pro and AConfig.pl).
RoAccess style Long Identifiers are no longer supported, as RoAccess is now using Rochade V6 long identifiers. Be sure to convert back to short names before upgrading to RoAccess 6.0.
For those doing programming, the passed $iN used to be the internal Rochade ID, a colon, followed by the long name. Now $iN is only the internal, classic/generated name. If you have added functionality to RoAccess, get in touch with us for help in converting to be compatible with 6.0
If you have merely upgraded to a Rochade 6.2 server, then you will see no difference with RoAccess. RoAccess will run as usual. The difference, is you can now in addition create extended named Items. You can also rename a normal Item (name <= 32 characters) to a longer name and vice versa.
RoLoader and RoQuery are also using extending naming.
RoAccess will determine which Name Group you have configured for your Subject Area. If no Name Group is configured, then the default Name Group will be used. The default Name Space is used. The Subject Area Name Space configuration is FLAT. TREE will be implemented later after Rochade provides more comprehensive support for it.
Renaming an Item: When you rename an Item, all versions of that Item are also renamed throughout the database. This is a feature of V6 name groups and name spaces. Renaming does readjust all links to that Item.
Note: ItemName_Equivalents was mentioned in AConfig.pro. Do not use this feature. It was a temporary feature for a customer until V6 came out.
Here are the large number of new features since the last
5.60 base release:
| User Request: The LT and LTS
users can optionally default ItemList to display ALL Items (active,
inactive, etc.). Active is the default for all users. User Request: You can disable the display of the DEFINITION attribute by listing which ItemTypes the DEFINITION attributes is to be suppressed for. User Request: 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. User Request: 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. User Request: Summary of Subject Area Logons. Now you can see how many times each Subject Area / Project was logged into. User Request: The Procedure Version screen now also displays the version of the Rochade server. User Request: When you log in, you will be advised how many days until you account expires, per Rochade 6.20 user parameters. New: When logging on, you will be told if your account has been locked because of too many incorrect logins. User Request: You can list only the ItemTypes that actually contain Items. New: Text attributes can contain HTML to give you all the flexibility that HTML can offer. User Request: Now you can list only those ItemTypes that actually have data. User Request: When you log in, you will be advised how many days until you account expires, per Rochade 6.20 user parameters. User Request: 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. New: You can specify two different ways to log on: using the newer $LOGON command or the older $MOVELOG command. By default, the newer $LOGON command is used, which will tell you if your account is locked and if your account is expiring soon. New: Stand Alone RoLoader is available for companies who do not have RoAccess. It loads Rochade V6 extended named Items. |
|
User Request: 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. Change: The Command Interpreter did not work correctly on some versions of Rochade because Rochade handled the work areas differently on different versions of Rochade. |
|
User Request: You can now display only ItemTypes that actually have data!
Many times, only a small fraction of the ItemTypes in a RIM actually receive
data. It is a waste of time for business users to see things that don't
have data. Also, wouldn't you rather see only things that actually have
data? Now it's your choice. You can toggle between viewing all the
ItemTypes in the TypeList screen, and listing just those that actually have
date. You can also set a default if you want business users to normally
see by default the populated ItemTypes. This is a real convenience! User Request: Because Rochade has been incorrectly and seemingly randomly creating hidden Items, the Show Hidden Items DBA Utility now will allow you to delete all the hidden Items in your Subject Area. Or if you are in a Virtual Hierarchy, it will let you delete all the hidden Items in all the configurations of your hierarchy. These bogus hidden Items were breaking path reports, and creating incorrect inactive Items. Now you can get around the Rochade bugs and continue with you Repository effort. User Request: After a Subject Area Wide renaming has been done, AP-PURGE is called to force the Rochade server to do ALL garbage collection THEN not later. This removes all the bogus "shells" left behind by the Rochade server that erroneously show up as Inactive Items until garbage collection removes them. User Request: The Command Interpreter now will automatically compile before running, so you can put IF, ELSE, WHILE, etc. instructions. You can use BEGIN-DATA and END-DATA pairs. User Request: Alternate Item Names. You can now specify a text attribute that contains the Item Name you would like to see in the ItemList and the ItemGet pages. These can be arbitrarily long, and can contain spaces. Look in AConfig.pro and AConfig.htm for details. User Request: The display of the DEFINITION attribute can be suppressed for arbitrary ItemTypes. Many times scanners put "garbage" and a lot non-useful information in the DEFINITION attribute, so no one wants to see it. Now you can suppress the display of the DEFINITION attribute. User Request: Adding support for L-Type link attributes. L-Type link attributes have been under a constant state of change, but appear to have settled down now, so we will support them. User Request: The Rochade server is starting to randomly generate large numbers of hidden Items for no understandable reason. We extended the DBA utilities to help you find and identify these bogus hidden Items so they can be deleted. User Request: The Rochade stored procedure trace output file now only contains the results of the latest run. Before, each run appended its results to the end of the file, making it more difficult to find the information you needed. User Request: The Command Interpreter button now automatically displays if for all LT and LTS users. User Request: A new button "Login" appears in the TypeList screen. This allows you to easily change the User, Server, Virtual Server or database.
Change: L-Type links can now be shown in Item detail displays
and spreadsheet output. |
|
User Request: The Drag-and-Drop icon works for Reports
created by RoQuery and other less used screens. This allows you to create
custom RoQuery reports and mail them, so the recipient merely clicks on the
email to run the report. This always uses up-to-date data. |
RoAccess Version 5.60 Major release.
(Prior major release was 5.10)
- Note: Re-Import
ROA_PROC.001, as new procedures have been added.
Installation notes: ROA_PROC.001.
- Note: Re-Import IMROACC.001 into
your Data Database.
Installation notes: IMROACC.001
The following have been added since RoAccess version 5.10:
|
User Request: Easy to use XML Import Service. User Request: Blob uploads and updates can be recorded in the Audit History Log and XML Audit Export file. User Request: XML Import Service can be rebuilt on you Windows system using provided build scripts. Full source code for the two Windows services is included. User Request: SpeedTest utility now has timings for 1200 and 2400 MHz CPUs. User Request: RoDbServer now runs even faster. User Request: The Audit Transaction log can now be also in XML, including blobs. This can be useful for repository replication. User Request: Enterprise Portal added. This facilitates name uniqueness when creating Enterprise-Wide Virtual Consolidations. There are a number of DBA screens that give reports to help determine what needs to be done, and and potential problems. There are both foreground and background options for longer running procedures. User Request: When link attributes are displayed, the order of the displayed links is governed by the SORT or NOSORT extended metadata or system defaults. NOSORT allows you to enter links in a specific order, and the order of displayed links is not sorted. This has always been true. However, now links that are set as SORTED will be displayed as sorted regardless if the links were entered by Autopilot, RoLoader, a scanner or buss, or customer loader program or script. These script many times do not do a sort, but merely append the links to the end. Now RoAccess will display these links sorted regardless of the order the links were added. User Request: User Buttons (that allow you to run custom programs from standard screens) can now test the values of attributes to decide if the button should or should not be displayed. This is in addition to testing the user name, user class, ItemType, etc. User Request: User Screens created in Front Page or Netscape Composer are now intelligent. They can now have scripting embedded that is performed at run-time. That means visual elements can be controlled and affected at run-time based on the values of data. This is an extremely powerful feature. You also now have additional variations on how data can be presented, such as link attributes. User Request: Most users run in the frames mode. When certain screens are run, they go into full screen mode for ease. However, sometimes with a BACK button is clicked, MSIE will go to the initial login screen because of its well known limited cache. Now, these full screen applications will pop up in a new window. When you are finished just close the window, and your other window will still be there. This is a great convenience. User Request: Now building faster running, optimized "monolithic" applications is extremely easy. Just run a batch file. User Request: ppp.pl now produces fewer diagnostics and is bundled with scripts to make creating "monolithic" applications very easy. User Request: Active State's 5.8.0 (latest version) verified to work. User Request: General Ad Hoc Query Language. You can now interactively specify a query and path plus all the attributes to be retrieved. User Request: General Report Writer. This allows you to pre-build reports and then have them executed on a button click or via a menu. No programming required. User Request: RoAccess now provides automatic full reports for RIM and Subject Areas. These are invoked by "Report" buttons that automatically appear on Item displays for AP-MODEL and AP-SUBJECTAREA Item displays. You can modify and extend these report templates to meet any special needs. It utilizes the standard Ad Hoc report writer. User Request: Master Detail processing. This is a major usefulness enhancement that greatly simplifies handing the creation of links, creating the linked to Items, editing those Items and ultimately deleting those Items. User Request: Login Expiration Notification. Rochade has no RPL instructions to tell when a user account will expire. RoAccess has found a way to circumvent this shortcoming and alert the users when their accounts will expire so they can be renewed in advance. User Request: User Friendly Item Names option. This allows Items to be displayed having certain characters replaced with a space and the first letters of each word group be capitalized. Example: the Item CUSTOMER_IDENTIFICATION can now be displayed as "Customer Identification". User Request: Easy emailing of URLs to any RoAccess screen. Drag-and-drop the Email icon at the top of a screen. You colleagues can then click and see the live data you need them to see. Perfect for group collaboration, making Favorites and Rochade URLs in documents. User Request: Item Name filter. When displaying Item Names, such as an Item List or as a single Item display, you can use the automatic "User Friendly Item Name" options, or you can supply your own routine to change how Item Names are to be displayed. Example: the Item "CUSTOMER_ID" using the standard option could be displayed "Customer Id". If you want ID and other acronyms displayed, you can write a special routine to process Item Names exactly as you desire, and it could be displayed as "Customer ID" User Request: Alternate Display of Referenced By Section. This give a second way to display the Referenced By section in Item Details display by displaying the information in the order that a business oriented user would like to see it. This is another RoAccess option. User Request: Alternate method of placing ItemType and ItemName on the Item Display screen. This was found more pleasing to may Business (non-technical) users. User Request: The TypeList screen has a new button "General Query" You can interactively do Ad Hoc Queries (including path relationships). This appears if you have purchased RoQuery. User Request: Simplified Hierarchical Subject Areas buttons (Checkout, Drop, and Promote) are now all activated with one configuration option. User Request: RIM and SubjectArea reports are automatically available when you view an Item of AP-SUBJECTAREA or AP-MODEL. User Request: DBA Utilities Screen. A new button to do a report on the current Subject Area. User Request: User Buttons now allow you to specify additional variables besides the standard system variables when invoking user applications. Also useful for custom applications where "switches" on existing programs are desire. New: ItemGet will automatically display a Report Buttons when Viewing a RIM (AP-MODEL) or AP-SUBJECTAREA Item. When clicked, it invokes the new General Report Writer to display information using complex path reports. User Request: RoAccess has implemented database wide sequence generators for automatic sequencing of Item Names User Request: After the Login screen, you can have a screen other then the normal Application Select (Select Subject Area) screen come up instead. This extremely useful when you want to preselect the Subject Area and set other parameters for the user or class of users. User Request: The "Legend" on the Item Detail screen is now a popup. Since the Legend was always the same for each Item displayed, it was a needless waste of screen real estate. Now, the display screen is smaller, displaying only real data. You can display the Legend by clicking the hyperlink at the bottom of the screen. User Request: When displaying embedded hyperlinks in a text attribute, the actual URL is no longer displayed. If it is a mailto: URL, then the screen displays "Send Mail". Otherwise, it displays "Click here". This greatly improves the look of your Metadata screens. There are two new URL features: "http://$s/" has $s translated to the current server name, which is useful for writing relative URLS that are not related to RoAccess, such as accessing other repositories. The other is "url:" which is useful for relative URLs that are related to RoAccess. Both of these conserve space, especially for 5.x Rochade servers, and add flexibility to help Rochade be the central repository for your company. Correction: Binary Attributes are now listed in the "Attribute Quicklist" popup. Correction: If one Item results from filtering for a Path Report, it automatically runs the path report without giving the erroneous message: "No Item has been selected." User Request: RoAccess now comes with over 40 industrial strength Java Applets at no additional charge. A "intelligent Tree" applet is utilized in the Path Reports. New Feature: Compatible with Rochade 6.0 Servers. Small change. (Note: if you write RPL code, be aware the $PRE command acts differently from what the documentation says!) New Feature: Virtual Hierarchical Subject Areas. Like Autopilot Hierarchical Subject Areas, only more configurable. You can move hierarchy trees, delete internal Subject Areas from the hierarchy, and more. You need this flexibility. You can now work with only normal Subject Areas, and never have to build an Autopilot Hierarchical Subject Area. This is because RoAccess creates Hierarchical Subject Areas "virtually" for you. You get the best of both worlds: HSA capability but only use standard Subject Area or Projects. This is a major feature addition. New Feature: Gateway Applications. Allows one Subject Area or Project to be a "gateway to another". Suppose each week you are creating new Subject Areas just to contain the latest scanned and otherwise automated imported data, which is run weekly. Your users may have difficulty remembering the name of the "latest" or "current" Subject Area, because each "new" Subject Area will need to have a new name, like Current_200203006. Having to know the constantly changing name of a Subject Area is not user friendly. Now they can always log into the same Subject Area called, say "Current", buy they will always open the latest one, because RoAccess will gateway to the correct Subject Area for you. You don't need Autopilot. You can do the configuring from RoAccess in seconds. This is extreme user friendliness. New Feature: User Request: Automated Document Versioning. Now any ItemType with blob/binary attributes can keep all prior versions of a document in the same Subject Area for later recall. You show or hide version in the ItemList screen. You can create new versions from the Item display screen. And no programming is necessary. You just tell RoAccess in the configuration file which ItemTypes are to handled for automatic versioning. This is a major feature addition. This is not the same as "Rochade Versioning", where you can only have one "version" in a Subject Area. With RoAccess, you can have a hundred different versions in the same Subject Area! New Feature: User Request: Additional run-time debugging features for application development. You can never have too many development aids. New Feature: User Request: List All Subject Areas/Projects DBA Utility. Helps keep track and manage systems with large number of Subject Areas and Projects. Lets you see inside a Subject Area even if you are not the LT or LTS for them. Why is this useful? Suppose you have 75 RIM's and 400 Subject Areas, and you change an ItemType that is in 50 of those RIM's. You need a list of every Subject Area that may need to be Reorganized. This is just one of the many tools RoAccess provides to make your life a bit easier. New Feature: User Request: WEB Server Timeout Diagnostic. Now you can easily determine if your timeout settings are correct on your WEB server. With the number of conflicting WEB server parameters or settings that override others, the timeout value may not be what you think. This tells you exactly what the timeout setting is! Helpful for long running queries and reports. New Feature: User Request: More flexible Links. When viewing links with Long Identifiers, the lines can be come so long as to require scrolling the screen to the right to see link qualifiers. Now you can opt to allow the link lines to break to allow the link qualifiers to be on the next line. As you use Long Identifiers more and more, this becomes a real user friendly feature. New Feature: User Request: You can now embed https:// URLs. Now, when you enter a https URL into a TEXT attribute, it will accept and display it as a valid URL. New Feature: User Request: You can default the ItemList screen to use the "Long Form". You have always had the ability to select the Long Form of Item List display. (Long Form displays the DEFINITION or other attribute to the right of each Item.) But for some situations, especially for non-technical users, you want the Long Form so the user can get as much information at a glance as possible to help him make his selection the first time. So now you can script when the ItemList screen will automatically switch into Long Form mode. Very useful user friendly option. New: Handles several bugs that were introduced into MSIE 6.0 so you applications will still work. Corrections: The TypeList screen now displays the "Work Configuration" button the first time it is displayed. The ItemList screen now tells you if you did not select an Item. You can now rename an Item with a double quote in its name. New Feature: User Request: Windows logins can set the LOGON_USER environment variable. You can now tell RoAccess to force the LOGON_USER to be the RoAccess user. This can greatly enhance security because a user cannot change or try to use a different user name. New Feature: User Request: User Created Screens from FrontPage or any HTML editor. If you don't like the standard display screen for an Item, you can create your own and RoAccess will use it instead! So now you can create DHTML applications without having to be an HTML expert! Click here. New Feature: User Request: You can easily send a RoAccess URL to a colleague a URL to view any RoAccess page, report, graphic, spreadsheet, or anything at all. RoAccess generates it for you automatically. This URL can be embedded in an email, MSWord document, Excel spreadsheet, Visio graphic, browser Favorites/Bookmarks or be embedded as a link in any HTML page. Click here and click here. New Feature: User Request: User Friendly Attribute Names. Now you can have RoAccess display attribute names that are more meaningful for business and non-technical users. Click here. New Feature: User Request: Work Configuration. Now when listing Items for linking, deleting, renaming or simply viewing, you can specify that only those Items in the work configuration will be listed. This is helpful for Projects and Hierarchical Subject Areas. This option appears on various screens. New Feature: User Request: Enhanced Version Info Screen. Now you can not only list all the configurations the Item is in, but they are hyperlinked, so you can immediately display any of them in that particular configuration. Click here New Feature: User Request: Version Difference Screen. Now you can compare two versions of an Item in a side-by-side display so you can see exactly what is different between the two different versions of an Item, attribute by attribute! Click here. New Feature: User Request: "Drop or Hide". Now when deleting an Item if you are in a Project or a Hierarchical Subject Area, you can choose to DROP and item, if the system default (frequently HIDE) is not what you need. New Feature: User Request: Promote and Checkout. Now we provide capability for easily checking out or promoting Items in a Hierarchical Subject Area. New Feature: User Request: Finished Button. Now, after running RoLoader, if you click the new "Finished" button, it exits the RoLoader system without having to do several BACKs. This is a convenience option. New Feature: User Request: Added User Friendly ItemType names. Now an ItemType name can have mixed case and spaces. Example: ORA/TABLE can be displayed as "Oracle Tables" or "Oracle Physical Tables". You can configure what is to be displayed as well as under which conditions they can be enabled or disabled at runtime. When making user friendly interfaces, presenting plain language ItemType names is very useful. Example: you can display User Friendly ItemType names to business users, but not to DBA and technical users. New Feature: User Request: Ability to call a user written function to filter or modify the ItemTypes that are displayed on the TypeList screen. This will allow you to display different ItemType lists based on the user or other conditions without having to resort to user class profiles and their shortcomings. When making user friendly interfaces, presenting only the ItemTypes a user or user class in really interested in is very useful. New Feature: User Request: Ability to default the ItemType list to Long Form. You can also configure under what circumstances to default to Long Form. When making user friendly interfaces, presenting the Long Form is very useful because it gives the non-technical users more information to explain what they are working with. New Feature: User Request: You can already output stored reports in text, and HTML. Now you can output them in CSV (comma separated) or TSV (tab separated) format for direct loading into Excel. New Feature: User Request: The Videos can be installed anywhere, and described in the $videos _search_path variable. Since they require a lot of disk space, you can now put them on a different disk or even a CD. They no longer need to be placed in the RoAccess directory tree. New Feature: User Request: Document Storage. Added ability to store Outlook Express emails in RoAccess. When clicking the Icon, it automatically downloads your stored email, runs Outlook Express and displays the email, including any attachments! Expanded: ROA_login_startup.pl: allows much more freedom in what all you can do with a "Static Urls".
New Feature: The Item Display screen now indicates which Link
Attributes are mandatory.
New Feature: stat. Allows you to get file information at runtime, useful to developers.
More Movies: documentation references more ScreenCam training
and demo movies.
Movies Download Faster. New Feature: Cookies program development utilities will work under WEB servers that even don't set the current directory correctly.
More Documentation: how to deal with WEB server and browser
timeouts for long running queries. More custom programming
aids and examples.
New Feature: .PNG graphics are fully supported New Feature: You can now write an optional filter procedure to process the list of Items that will be displayed in the ItemList screen, and modify that list before it is displayed. You may want to conditionally hide certain Items, like versions of documents to show only the most current document. User Request: Word wrapping in text fields can be determined by the PIC statement. A PIC=C130 will wrap at column 130. This is useful for storing things like source code that you do not want wrapped. The DEFINITION attribute defaults to a PIC of C80, but can be made to be multi-line. User Request: Fewer mouse clicks. You can now go from the TypeList screen directly to Spreadsheets. Before, you had to first select an ItemType, then list Items, then click Spreadsheet, then reelect Items. You now completely bypass that unnecessary initial ItemList. User Request: The Subject Area Selection Screen is now closer to the top of the window, not wasting the space. User Request: Path Reports can now be run for multiple Items at one time. User Request: The AP-INTERFACES POST-REPORT ability to call a stored procedure to specially process the output of a path report before it is returned to RoAccess has been implemented. User Request: If you post process a Path Report, the results can now be lined up in columns. User Request: Creating of Items is now logged in the audit history User Request: ROA_login_startup.pl now has a yellow background and set a flag telling the program it runs that it was run by ROA_login_startup.pl, so a BACK can skip over the ROA_login_startup screen. User Request: ItemTypes that are mixed case in the TypeList screen are BLUE. User Request: a flag to allow clients running old Autopilots and Rochade servers to have RoAccess only use a 2 digit year. User Request: When editing data, and you leave the form before saving it, RoAccess now takes advantage of a special MSIE only feature to keep from leaving the screen and losing your data. User Request: more documentation on Link Cardinality Change: DEFINITION attribute is now 80 characters width by default
|
End of new features for RoAccess 5.60 |
RoAccess Version 5.10 Major release.
(Prior major release was 5.03)
The following have been added since RoAccess version 5.03:
- ScreenCam Movies: we are starting to make full multimedia training videos and videos to show how RoAccess can be used to make the most of your RoAccess and Rochade investment. Several are available on our WEB site www.RoAccess.com. The Select Application Screen On-Line Help has a movie that is included with this new version, and is a sample of what is to come.
- User Request: If ItemList displays more that a set number of Items (set in AConfig.pl), it displays a QuickJump Index at the top, such as ABCDEF. Clicking on D immediately jumps to the Items that have D as their first letter. This is great when you have a large number of Items listed.
- New: User Request: Each screen now dynamically sets as its Title the name of the screen , Item Type and Item name. This allows you to have multiple windows open, and tell them apart on the WIndows Task Bar.
- New: User Request: Security Feature: We were asked to provide an option to default newly added users to be read only. When you create a new user in Autopilot, that user has the default permissions, which typically include full edit/create/delete and rename permissions. This is usually not what you want. The only way to restrict a user's permissions is to assign him to a user class. If you forget to assign a newly created user to a user class, he gets all permissions. Not a good default. Now there is a variable you can set in AConfig.pl to force any users that have not been assigned to a user class to be considered read-only. This means all new users begin as read-only. If you want users to have more permissions, then you can assign them to such a user class.
- New: ItemTypes Quicklist. You can now have a floating frame
of the TypeList. This gives
you 3 frames: TypeList on left, ItemList in middle, and
Item Display on the right. This was
a user request. If you are using non-frames mode,
it will pop up a second window which
works with your original windows to list the Items.
- New: User Request: The Item Display screen now has a "Types"
button to directly bring up the
ItemTypes list display.
- New: you can now enter a link qualifier with parens (). They will be silently removed. Some users thought they had to add the parens themselves (but RoAccess does it for you).
- New: you can create RoAccess hyperlinks in the HTML Stored
Reports. So you can create links to display Items, reports, graphics,
spreadsheets, etc.
- New: User Request: ROA_login_startup.pl besides displaying
a password field, now also display the user name so you can change it if
you wish. It also will pass parameters other than the standard ones.
- User Request: More Extended Metadata: You can now specify
the cardinality of a link attribute and whether the cardinality is to be
mandatory or optional. If it is mandatory, you cannot add more that
the number of links. If it is "optional", you will receive an advisory
message saying you are exceeding the suggested cardinality, but you will
be allowed to add the additional links.
- User Request: More Extended Metadata: Creating Inactive Items from the Link Add Screen: Inactive Items have been such a source of so many problems for so many people, we were asked to extend the Extended Metadata so you can require that links from particular link attributes must be selected from the list, and to not present the empty field where a user could enter a name. Now you can ensure that a link always goes to an existing, active Item. This is real piece of mind! By default you can either select the target link Item from a List Box or you can enter an Item that does not exist into a field, which typically creates an Inactive Item in the process.
- User Request: You can now set User Preferences. Now you can specify default databases to open, default Edit/Display modes, different Cascading Style Sheets, plus other options.
- User Request: Feature for projects in development where your WEB server is administered by another group. Temporary files can be used to make new applications by cutting and pasting, and are useful for analysis of what your application is doing. But, how can you get these temporary files, if you don't have root or Administrator privileges? You can now disable temporary file security. The temporary files directory is normally set to no access by anyone, which will not allow even you to access these temporary file. Now, there is an AConfig.pl option that will loosen security so you can get at your own development temporary output files. Once you have verified you new application, you can turn security back on. Having a development server that is administered by another group can really slow down development. RoAccess is helping to solve that problem.
- User Request: The TypeList screen (List of ItemTypes) now indicates by color which ItemTypes allow mixed case Items/Instances and which are upper case only. This is useful when using a wildcard filter to find Items.
- User Request: Now RoAccess notifies you when a Subject Area or Project has been taken off-line (suspended). No further access is allowed until is put back on-line (IN-WORK). Since you could have literally thousands of users world-wide accessing your site, no locks are put on the database so you can SUSPEND it at any time. This is very flexible.
- User Request: Several users wanted an easy way to view all
the RoAccess buttons and i
mages on one screen. This makes creating their own sets
of button and graphics easier.
Display this URL: http://yourserver/roaccess/images/images.html.
This is created by
the program /roaccess/images/make_images_html.pl.
- User Request: Add a "Forward" button to match the "Back" button that appears on all screens.
- New: User Preferences Screen. RoAccess gives you options to make your data access sessions more convenient than ever. For example, it can remember you most used Subject Area, and if you typically want access it in Edit or Display mode. Also, now each user can have his own Cascading Style Sheet. If you log in as different users, each can have a different background color, plus all the other things you can change in a Style Sheet.
- New: The ItemList screen not has a quick index set of hyperlinks at the bottom of the screen to match the one at the top. This is a convenience feature.
- New: The Help, Back and Forward buttons are smaller and grouped so the three of them occupy the space of only one button.
- New: The Help, Back and Forward buttons are smaller and grouped together to take less room on the screen.
- New: the TypeList screen now displays the number of ItemTypes displayed.
- New : all the RoAccess run-time images now have the same color palette.
- User Request: When you upload a Blob (a file or graphics) RoAccess now automatically adds the time/date and user for that upload. Now you can tell just when that file was uploaded. This is important for document management purposes.
- User Request: For custom applications run from custom buttons, if you are running in non-frames mode, specifying a NEW window now creates a new window for your application to run it
- User Request: The "Long Form" of Item Lists now supports the original DEFINITION attribute plus the optional &LONG-FORM-ATTR and &LONG-FORM-ATTR-TYPE. This means you can define the DESCRIPTION or any other attribute to hold the Long Form explanation line.
- User Request: the Back buttons are intelligent, being able to go back 1 or more prior screens when appropriate.
- User Request: When entering very long URLs (hyperlinks) into text attributes, they are no longer wrapped at 60 characters. They are kept in their entirety, no matter how long they are.
- User Request: Some versions of MS Internet Explorer do not delete "temporary" cookies correctly. This caused RoAccess to use to "old" user class, if a user had been changed to a new user class. Even though this is a browser bug, we added code to handle this.
- User Request: Back buttons are on just about all screens and error screens, plus on-line documentation. This solves BACK problems in several versions of both Netscape and MSIE browsers.
- User Request: When viewing System ItemTypes, such as AP-SUBJECTAREA, there are a number of important Value Attributes (like &ACCESS, &MACODE and such) that are not part of the RIM, but are used anyway. The ItemGet screen now displays all these special value attributes at the bottom so you are looking at the COMPLETE Item. This is extremely important when you are trying to quickly analyze profiles, user classes, subject areas and ItemTypes.
- User Request: Documentation and sample scripts for how to handle Rochade 5.4 batch clients running under Unix. They use shared libraries, and this script shows how to set LD_LIBRARY_PATH for those batch applications you have that running under cron or other timers.
- User Request: Supplied stored procedure ROA_TRACE now automatically detects the operating system, and adjusts the output trace file accordingly. This makes tracing the remotely running RPL and stored procedures very easy.
- User Request: two new stored procedures to return the name real itemtype (that may include an extension like PERSON.EXT) and the name of the ItemType profile given the generic ItemType name (like PERSON). Makes custom application programming easier for sophisticated needs.
- User Request: Now all on-line help pages have BACK buttons.
- User Request: Stored Reports output screen has additional buttons to run new reports, etc.
- User Request: When an Item is being displayed, you can now go directly to Stored Reports passing that Item Name in as the seed Item. We've also added buttons to the Report Output Screen to allow you to easily run another report or go back directly to he ItemGet split screen that you started from.
- User Request: The DBA utilities can be run by certain specified users. See AConfig.pro for detail.
- User Request: If ItemList displays more that a set number of Items (set in AConfig.pl), it displays a Quick Jump Index at the top, such as ABCDEF. Clicking on D immediately jumps to the Items that have D as their first letter. This is great when you have a large number of Items listed.
- User Request: Back buttons. As WEB applications become more complex, utilizing frames, JavaScript and events, some browsers have difficulty handling the BACK button correctly. We now put a BACK button on every page. Not only does this work for all browsers and versions of browsers, but the BACK actually is back for that frame. If you have displayed 30 Items in the right frame, a BACK normally will have to unwind all 30. However, now you can do a BACK on the LEFT frame directly. This is extremely useful.
- User Request: Item Lists are sorted more intelligently.
Upper/lower case are treated equivalently, and German umlauts now
appear where one would expect them to be. This is a very important
enhancement. Details:
We are no longer doing the sort in Rochade, because:
So now RoAccess does the sorting. Now Items Tommy and tommy1 will appear next to each other.Rochade cannot make "t" and "T" equivalent, The Rochade sort places all Items starting with a lower case letter appear after the list of all Item Names starting with a capital letter. Example: Items Tommy and tommy1 can appear pages apart in a sorted listing merely because tommy1 starts with a lower case t. To a person, they should be next to each other in a sort. Rochade sort places German umlauts after all letters, not where you would expect them to be. This would make "ä" and "a" not be next to each other at all, but separated with other entries.
- User Request: on the Spreadsheet options screens, clicking a button will uncheck non related or conflicting buttons.
- User Request: The Delete Item ItemList panel, no longer pre-selects the first Item on the list.
- User Request: TypeList and ItemList no longer display the Items List and TypeList in bold.
- User Request: Extended Filtering displays have the radio button to select Extended Filtering removed, since it is already in the Extended Filtering screen.
- User Request: Standard RoAccess screen buttons can now be hidden based on the results of a scripting language.
- User Request: User buttons used to add custom screens can now appear or not on various screens based on the results of a scripting language. Now, buttons appear only when you want them. Click here.
User Request: RoAccess can now default users who have not been placed into a user class, to be treated as read-only. Click here.
- User Request: Each screen now dynamically sets as its Title the name of the screen , Item Type and Item name. This allows you to have multiple windows open, and tell them apart on the Windows Task Bar.
- New: ItemTypes Quicklist. You can now have a floating frame
of the TypeList. This gives you 3 frames: TypeList on
left, ItemList in middle, and Item Display on the right.
This was a user request.
If you are using non-frames mode, it will pop up a second window
which works with your original windows to list the Items.
- New: if you enter parens in a link qualifier, they will be automatically removed since they are not allowed in a link qualifier.
-New: Types Quicklist. New: ListAllPatches screen to determine what patches have been applied. Writelocks Items in Hierarchical subject areas not in work configurations. ItemName of 0 can be created. Doing an ItemList for Stored Reports in Long Form displayed definition twice. Allowing edit of an Item with no owner if edit-only-by-owner option is set. Corrected automatic passing of user defined variables. Substitute user for delete and rename improved.
-New: RoAccess now write locks an Item that is in a Subject Area Hierarchy but was not in the work configuration.
-New: RoAccess now write locks an Item that is in a Subject Area Hierarchy but was not in the work configuration.
- User Request: This patch allows RoAccess running against German Rochade Repositories to be able to display a great deal of Meta-Meta Data from the system ItemTypes, such as: AP-MITARBEITER and AP-AUSWERT. The Rochade repository has a wealth of Meta-Meta Data, and now you can browse and drill through it with ease regardless which version of the Rochade server you are running.
- New: MSIE 5.0 has several known caching problems where it is
unable to download certain files, while Netscape and prior version
of MSIE do just fine. A new configuration variable instructs
RoAccess to download files of specific extensions using a different protocol,
that MSIE 5.0 seems to work with.
Affects: AConfig.pro and DownLoad.pl
- New Feature: User Request: Fast Attribute Finder Popup implemented
- User Request: Make the Session Info Popup delay 1 second before popping up
- Change: we are dropping support for MSIE 3.02a. We had one company
that
absolutely needed it. They no longer do.
- Change: Extended Filter screens no longer have
a button for extended filter,
since it already on that screen.
- Fix: Copy Item from the ItemGet page, did not properly display
- Fix: The file upload did not properly handle filenames with spaces
in them, which is
very common on Windows system.
- Fix: When doing an Item selection for Stored Reports in Long Form
format, the
definition was displayed twice.
- Fix: Rochade has a security option that only the owner of an Item
can edit it. This
corrects the problem where if an Item had no owner, then
it could not be edited.
- Fix: Stored Reports did not always select the proper report name.
- Fix: If you select Subject Areas from the TypeList screen, it no
longer reverts to English.
- Fix: &STAMP updated when updating a link attribute
- RoAccess screens are being updated to make sure they are HTML 4.0
EN Transitional compliant.
- Fix: spreadsheet exports to a .csv file handle double quotes properly.
- Fix: when trying to update a Link Attribute for an Item that was
locked by Autopilot,
an incorrect error message was displayed.
- Fix: An Item update now checks to see if the Item was deleted or
renamed by another
user while you were in the process updating it.
- Fix: now the ItemList screen cannot be placed into edit mode for
system ItemTypes. This
is same as the ItemGet screen
- Fix: you can now update/delete link qualifiers even if they had extra
sets of
parens in the link qualifier. Also fixed where sometimes
a link qualifier would
not match for deleting/updating.
- Fix: The delete and rename screens now have only one set of help
buttons.
- Fix: links to ItemTypes over 30 characters long corrected.
- Fix: better auto conversion to upper case for wildcard searches and
Item creation.
- Fix: When toggling between Edit and Display Modes, the Item List
screen retains the
same list of Item/Instances.
- Fix: MSIE 3.02a can now Edit Items. Before, a JavaScript error prevented
it.
- Fix: When autochaining between certain update screens, Netscape users
will no longer see a
"Document Interrupted" message. It was not a problem,
but the message was not necessary.
- Fix: When displaying an ItemList using the Long Form options, A DEFINITION
whose first
line is blank is properly handled. It should never
be blank, though.
-Change: The Delete Item ItemList panel, no longer pre-selects the
first Item on the list.
- Fix: spreadsheet exports to a .csv file handle double quotes properly.
- Fix: an ItemName of 0 (zero) can now be created.
- Fix: RoAccess now write locks an Item that is in a Subject Area Hierarchy
but was not in the work configuration.
- Fix: New: ItemTypes Quicklist. You can now have a floating
frame of the TypeList. This gives you 3 frames:
TypeList on left,
ItemList in middle, and Item Display on the right.
This was
a user request.
RoAccess Version 5.03 (Enhancement
and Maintenance Release) Superceded by 5.10
-New: When running a Path Report, if you by using a wildcard or the Extended Item Filter1) select from a list of link qualifiers, 2) select from a list plus be able to create a different qualifier if none are appropriate (*), or 3) select from a list, or allow NO link qualifier (NIL), or any combinations of these three.
RoAccess Version 5.02 - Feature and Maintenance Release
Superceded by 5.03
RoAccess Version 5.01 - Feature and Maintenance Release
RoAccess Version 5.00 - Feature/Maintenance Release
- User Request: When adding User Buttons to run user screens
to RoAccess, you can now also
specify which frame to run it in (RIGHT, LEFT, etc.).
- User Request: The Spreadsheet Icon is not available for both
Display and Edit modes.
- User Request: Stronger support for Style Sheets. You
have much more freedom to choose fonts
spacings and colors to help match corporate standards.
- Note: The default RoAccess.css Style Sheet has changed.
If you are using Style Sheets, you may
with to look at it to see what additional options you
now have.
- User Request: The display of the ItemGet screen
is now much more dense. This means you can
now display more for a given screen height. Using
Style Sheets you can control spacing to suit
your needs.
- User Request: When selecting a Path Report, the DEFINITION
is now also displayed to help identify
the Path Report you are looking for.
- Change: the mime types for certain downloadable files from blob attribute
storage have
been changed to match industry
standards. This will not require any changes on
your browser settings.
This will match what is already there.
Excel: from application/msexcel to application/vnd.ms-excel
HTML Documents: from text/plain to text/application
Powerpoint: from application/mspowerpoint
to application/vnd.ms-powerpoint
Added Acrobat reader .pdf files as a
"blob storable/downloadable" file type.
- New: Advanced graphics. For graphical path reports,
you now have a lot more options:
portrait, landscape, left-to-right or top-to-bottom,
spacings and more. You can also assign
a shape, color and fill style to each ItemType
for visual identification and uniformity.
- New: When clicking on an Item in a graphic report, the frame
that pops up can now be fully
used for updating, running reports, and all other screens.
- New: More style sheet support. You can specify BODY
and HEAD tags independently, now.
See AConfig.pl for details.
- Note: a number of improvements and enhancements for Long Identifier
support has been added.
- Note: Version 5.0 an above allow you in an optimized manner
to access Subject Areas with
the same name in different databases and different servers
using special cookies. These cookies
are not compatible with prior version of RoAccess.
To switch between RoAccess 4.x and 5.x
either just exit your browser first, or run "roaccess/cgi-bin/clear-cookies.pl"
from a bookmark.
- New: RoPages PlugIn can be enabled and display on the TypeList
screen.
- User Request: You can now specify a site dependent default
user for RoAccess. Several companies
wanted a default user for the majority of accesses.
The entry goes in AConfig.pl and pre-loads
this user in the Login "User Name:" field.
- New: Spreadsheets can be sent to your browser as a download
file (no more cut and pasting).
This means you can save it as a file, or automatically
have Excel run and load the file.
- New: You are able to load spreadsheets with Excel "soft returns"
in a cell. RoLoader will also
wrap text attributes that exceed 256 characters long.
- New: Added support for legacy Rochade scanners that
incorrectly put an @ sign as the first
character of an Item Name. Although it "works" in
Autopilot, because of the way RPL happens
to run, it is an error because @ is NOT the REAL first
character or the Item Name.
- New: Added Microweb capability. The
Microweb server is a small, standalone WEB server
that makes CD-ROMable applications.
- New: On Login screen, if first server is not responding or
down, you can select any of the
other servers by clicking their radio button. Before,
if the first server was unreachable, the error
message prevented selecting an alternate database server.
- User Request: on small screens, a "Reset All Fields" was not
very useful, and just added
another bottom that was unnecessary. They have been
removed and the screen look nicer.
- Change: when renaming an Item, the core classes are now used, since
Autopilot has changed
how rename works with versioning.
- Note: Whether you have selected Frames or Non-Frames mode, is no
longer stored in a cookie.
This allows you to have one window in frames and another
not. Also it allow certain screens
to decide dynamically if they want to change the frames
mode. This is transparent to the
ADK users.
- Note: A number of enhancements have been made to Test.html, the installation
verification
screen. It will better help pinpoint any installation,
WEB, graphics or permissions problems.
This will make life easier for you.
- Fix: the candidate attributes listed for a spreadsheet are follow
user class profile correctly.
- Fix: for spreadsheets, if you select "Use the Items already listed
on the Item List Screen"
and display a spreadsheet, if you BACK to this page, the
option will be retained correctly
so you can run other spreadsheets with the same settings.
- User Request: now even internal and system diagnostic messages
are language specific
- Fix: if Long Name Support is enabled, but not for the current ItemType
for an ItemList, then
the extended search might miss some Items.
- Fix: if you do a Revert to Short Names for an ItemType that is currently
under Long Identifier
Support two times in a row, you will now only receive
the normal success message. Before
there was a needless error message.
- Fix: When rebuilding long name ItemTypes, the core classes rename
is now used.
- Fix: ItemList using links (not buttons) has ItemGet display Long
Identifier ItemName correctly.
- New: Native executables are available on several platforms,
including NT. This way
perl does not need to be installed on the WEB server.
- New: Final Graphics
- New: Message of the Day. Variable $db_message can have an
optional multi-line
message of the day, which appears on the right panel of
the Login screen.
- New: Link Qualifiers can now be very long
- New: In addition to LT and LTS, you can specify additional
users with permission to
view the History Audit Log.
- Change: The first line of AConfig.pl should be changed from
"require('AConfig.pl');"
to 'RoaRequire('AConfig.pl');" The is to make it
compatible with the software to create
native executables from perl.
- Change: Some screens are creating slightly different HTML to be compatible
with newer
standards.
- Fix: extended text attributes are handled properly in Spreadsheets
and Extended Item Search
- Fix: When adding a link for a link attribute with multiple target
ItemTypes, the displayed text
not gives the "from" ItemType as a reminder.
- Fix: You can now have Subject Areas with the same name on different
databases and
different servers, all with different configuration paths.
The format of the stored cookies
has changed.
- Fix: build_RoPerlServer.sh correctly builds install_RoPerlServer.sh
- Fix: SpeedTst.pl is not longer created ppp.pl. This will allow
you to substitute the POSIX
finer grained time measurement file, rather than the default
1 second resolution htime.pl
- Fix: added graphics compatibility code so you can display the ItemType
and ItemName
of the graphic elements a graphic path report. Plus
some code to get around a Netscape
4.08 bug on resizing a window.
- Fix: For Item List name filtering (both simple and extended), there
is now only one OK box.
Two boxes, although identical, was confusing. Also,
the "Do Not Limit Number Of Items" box
is now a checkbox, and clicking it no longer automatically
submits the query. This makes for
a more uniform look and feel with other screens.
- New: added Acrobat .pdf to mime types to the automatically
started applications list when
a Acrobat .pdf file is downloaded from an Item's blob
attribute.
- Fix: Spreadsheet generator on rare occasions would give an error
about odd number of elements.
This is fixed.
- Fix: for the standard and extended ItemLists, a lower case wild card
will be automatically
converted to upper case if Items for that ItemType have
been declared as upper case only.
- Fix: occasionally a referenced by link in ItemGet for an Item with
a Long Identifier would
upon clicking display the Short Id at the top of the ItemGet,
not the Long Id.
RoLoader Version 4.00
Requires RoAccess 6.00
Enables loading of Rochade V6 extended names and name groups.
Loads S/T-Type and L-Type link attributes.
RoLoader Version 3.00
User Request: Do not wrap link lines if they have extremely long link qualifiers
User Request: Automatically correct "cell format errors" when the .tsv file is generated by a program. Several classes of tsv errors are now tolerated. This makes creating specialized extract and reformatting programs creating RoLoader files easier for you.
User Request: Identify Item Names that are blank or contain blanks and treat them as validation failures.
User Request: For long running loading jobs, prints a "Loading..." message so you can be certain the job has not completed. Then writes "Finished" at the end. More user friendly.
User Request: 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.
User Request: 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.
Corrections: 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.
Also corrects a bug in wrapping long lines
RoLoader Version 2.15 Patch Level 02(Prior major release was 2.14)
User Request: 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.
User Request: Display the number of new Items created and the total number of Attributes written
User Request: 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.
User Request: provide a number of advisory messages like: No data to load, no columns selected to load.
User Request: 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.
User Request: You can now load the default value for Text Attributes if the cell is null.
User Request: There is an advisory message that warns you if you have disabled all columns for loading or there are not columns to load.
User Request: some very old spreadsheets contain invalid
characters in the data, that show
up as little squares in Excel. RoAccess now ignores
them.
User Request: Long URLs (hyperlinks) that are being loaded are no longer wrapped or truncated.
User Request: More RoLoader explanations and examples.
- New: Handles extremely long, complex text cells from Excel.
- New: If the ItemName has spaces in the name (Rochade does not allow
spaces in
an Item Name), leading and trailing spaces are removed,
multiple spaces are replaced
by one, and then any spaces are replaced by the under
line character "_".
Example: if your ITEM_NAME cell has " PROGRAM
SALEDB ", then the final
ItemName will be "PROGRAM_SALEDB".
- Fix: A cell with a single 0 (zero) was not loaded
- New: 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".
- Fix: links to ItemTypes with names that are longer than 30 characters
corrected.
- Fix: Items being created now automatically capitalized if the ItemType
is designated upper
case items only.
- Fix: links to ItemTypes who name is >30 characters is corrected.
RoLoader Version 2.15 Patch Level 02
User Request: Do not wrap link lines if they have extremely long link qualifiers
User Request: 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.
User Request: Identify Item Names that are blank or contain blanks and treat them as validation failures.
User Request: For long running loading jobs, prints a "Loading..." message so you can be certain the job has not completed. Then writes "Finished" at the end. More user friendly.
User Request: 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.
User Request: 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.
Corrections: RoLoader now uses the colors in your user level Cascading Style Sheets.
-Fix: RoLoader: Very long link qualifiers can be loaded via RoLoader.
- 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.
- If the ItemName has spaces in the name (Rochade does not allow
spaces in an Item Name), leading
and trailing spaces are removed, multiple spaces
are replaced by one, and then any spaces
are replaced by the under line character "_"
Example: if your ITEM_NAME cell has "
PROGRAM SALEDB ",
then the final ItemName will be "PROGRAM_SALEDB".
- A cell with a single 0 (zero) is loaded properly
RoLoader Version 2.13
New: RoLoader now 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. New: you can now load link attributes where there are multiple target ItemTypes. Click for more info.
RoPages Version 3.00
-New: RoPages is now about 75% faster. Since RoPages is
designed to handle large numbers of concurrent
RoAccess users, efficiency is of high importance.
RoPages Version 1.00
RoQuery Version 3.00 Patch Level
00
Requires RoAccess 6.00.
Implements Rochade V6 extended names and name groups.
RoQuery Version 2.00 Patch Level 01
User Request: Default Report. Now, al Items of the same ItemType will be grouped into the same HTML Table until an Item of a new ItemType is found. If there are are only Items of one ItemType, then they will all be put in the same table. Before, sometimes the HTML tables would be segmented into a number of tables all having the same ItemType. This reduces the number of tables, and greatly enhances the ability of the results to be exported to Excel or a processing application. It also lookes nicer.
-New: Additional diagnostics for application
developers. Compatible with Rochade 6.0
-New: RoQuery is the only ad-hoc query and reporting tool. You
interactively create complex reports that know how to follow Rochade links.
The reports can then be stored and connected to button so they can be run with a
single mouse click. You can pass parameters to the reports can be general,
taking the ItemType and ItemName at run-time. It also make application
development much, much easier because it not only lets you specify a query (like
SQL_PREPARE) but also retrieves the various Item and Attributes that you have
specified.