Difference between revisions of "User:Shawndouglas/sandbox/sublevel3"

From LIMSWiki
Jump to navigationJump to search
(Added Ys to 1.3.2)
(Added a few more items)
Line 548: Line 548:
   ! style="color:brown; background-color:#ffffee; width:1200px;"| Requirement # and requirement
   ! style="color:brown; background-color:#ffffee; width:1200px;"| Requirement # and requirement
  |-   
  |-   
   ! style="padding:5px;" |
   ! style="padding:5px;" | Y
   | style="padding:5px; width:1200px;" |'''1.3.300 The system can manage and store both sample- and non-sample-related data, including images from microscopes, GCMS scans of peaks, PDF files, spreadsheets, or even raw data files from instrument runs for later processing.'''
   | style="padding:5px; width:1200px;" |'''1.3.300 The system can manage and store both sample- and non-sample-related data, including images from microscopes, GCMS scans of peaks, PDF files, spreadsheets, or even raw data files from instrument runs for later processing.'''
  |-
  |-
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; padding:15px;" |
   | style="background-color:white; padding:15px;" | Alfresco Community remains "format-agnostic,"<ref name="AlfSIWI" /> meaning any file type can be uploaded.
  |-  
  |-  
   ! style="padding:5px;" |
   ! style="padding:5px;" | Y
   | style="padding:5px; width:1200px;" |'''1.3.301 The system can manage and store media objects like digital photos, bitmaps, movies, and audio files.'''
   | style="padding:5px; width:1200px;" |'''1.3.301 The system can manage and store media objects like digital photos, bitmaps, movies, and audio files.'''
  |-
  |-
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; padding:15px;" |
   | style="background-color:white; padding:15px;" | Alfresco Community remains "format-agnostic,"<ref name="AlfSIWI" /> meaning any file type can be uploaded, including media files.
  |-  
  |-  
   ! style="padding:5px;" |
   ! style="padding:5px;" | Y
   | style="padding:5px; width:1200px;" |'''1.3.302 The system allows multiple native instruments and users to enter data into the system simultaneously without disruption.'''
   | style="padding:5px; width:1200px;" |'''1.3.302 The system allows multiple native instruments and users to enter data into the system simultaneously without disruption.'''
  |-
  |-
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; padding:15px;" |
   | style="background-color:white; padding:15px;" | One of the guiding design principles of Alfresco Community is to be enterprise scalable, with as few disruptions as possible.<ref name="AlfDesignGuide" /> Note that instruments can't be connected directly to the SDMS; however, instruments can be interfaced to the SDMS through the LabVia webLiMS application.
  |-  
  |-  
   ! style="padding:5px;" |
   ! style="padding:5px;" | U
   | style="padding:5px; width:1200px;" |'''1.3.303 The system can interface with and [[LIMS feature#Import data|import existing data]] from other databases and file shares.'''
   | style="padding:5px; width:1200px;" |'''1.3.303 The system can interface with and [[LIMS feature#Import data|import existing data]] from other databases and file shares.'''
  |-
  |-
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; padding:15px;" |
   | style="background-color:white; padding:15px;" | Complete folder-based file structures can be imported into Alfresco Community using a number of methods.<ref name="AlfForDirTree" /> It's assumed webLiMS users can also move files from other webLiMS applications to the SDMS, but this needs to be confirmed.
  |-  
  |-  
   ! style="padding:5px;" |
   ! style="padding:5px;" | N
   | style="padding:5px; width:1200px;" |'''1.3.304 The system supports data capture from a Citrix-based environment.'''
   | style="padding:5px; width:1200px;" |'''1.3.304 The system supports data capture from a Citrix-based environment.'''
  |-
  |-
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; padding:15px;" |
   | style="background-color:white; padding:15px;" | Aside from capturing metadata data from imported files of a sufficient MIME type, Alfresco Community doesn't seem to offer data capture capabilities. However, other webLiMS applications can capture instrument and other data, and that data can then be managed and stored in the SDMS.
  |-  
  |-  
   ! style="padding:5px;" |
   ! style="padding:5px;" | Y
   | style="padding:5px; width:1200px;" |'''1.3.305 The system allows file indexes to be stored centrally while associated files are stored geographically.'''
   | style="padding:5px; width:1200px;" |'''1.3.305 The system allows file indexes to be stored centrally while associated files are stored geographically.'''
  |-
  |-
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; padding:15px;" |
   | style="background-color:white; padding:15px;" | Alfresco Community uses Solr for indexing, and it has "no need to duplicate indexes on every machine in a cluster," suggesting indexes could be stored on a central machine.<ref name="AlfWikSolr">{{cite web |url=https://wiki.alfresco.com/wiki/Alfresco_And_SOLR |title=Alfresco And SOLR |work=Alfresco Wiki |publisher=Alfresco Software, Inc |accessdate=04 November 2014}}</ref>
  |-  
  |-  
   ! style="padding:5px;" |
   ! style="padding:5px;" |
Line 596: Line 596:
   | style="background-color:white; padding:15px;" |
   | style="background-color:white; padding:15px;" |
  |-  
  |-  
   ! style="padding:5px;" |
   ! style="padding:5px;" | N
   | style="padding:5px; width:1200px;" |'''1.3.308 The system allows full on-screen review and approval of native instrument data prior to database commitment.'''
   | style="padding:5px; width:1200px;" |'''1.3.308 The system allows full on-screen review and approval of native instrument data prior to database commitment.'''
  |-
  |-
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; padding:15px;" |
   | style="background-color:white; padding:15px;" | Alfresco Community can not interface with instruments and does not have this functionality. However, optional middleware could add this functionality.
  |-  
  |-  
   ! style="padding:5px;" |
   ! style="padding:5px;" |
Line 614: Line 614:
   | style="background-color:white; padding:15px;" |
   | style="background-color:white; padding:15px;" |
  |-  
  |-  
   ! style="padding:5px;" |
   ! style="padding:5px;" | N
   | style="padding:5px; width:1200px;" |'''1.3.311 The system can automatically normalize and store incoming data to a technology-neutral format like XML.'''
   | style="padding:5px; width:1200px;" |'''1.3.311 The system can automatically normalize and store incoming data to a technology-neutral format like XML.'''
  |-
  |-
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; width:100px; text-align:center; font-style:italic;"| Response:
   | style="background-color:white; padding:15px;" |
   | style="background-color:white; padding:15px;" | Alfresco Community doesn't seem able to convert imported files to another format.
  |-  
  |-  
   ! style="padding:5px;" |
   ! style="padding:5px;" |

Revision as of 18:30, 4 November 2014

This is sublevel3 of my sandbox, where I play with features and test MediaWiki code. If you wish to leave a comment for me, please see my discussion page instead.

Sandbox begins below

  • Y: Meets requirement in commercial off-the-shelf solution as delivered/configured (or vendor provides service)
  • YC: Meets requirement only with customization (additional code, using a third-party application, etc.)
  • N: Does not meet requirement
  • I: Informational response only, N/A
  • U: Unknown


1.0 Demonstration

1.0 Demonstration
Requirement code Requirement # and requirement
N 1.0.000 The system can be tried via an online and/or on-site demonstration.
Response: The developers do not seem to host an online demo of Alfresco Community Edition.

1.1 Information technology

1.1.1 General IT

1.1.1 General IT
Requirement code Requirement # and requirement
I 1.1.100 The system operates with a traditional client-server architecture, with software installed on each machine that needs to access the system.
Response: Alfresco uses client-server technology, though the client is web-based. See 1.1.101.
Y 1.1.101 The system operates with a web-based interface, hosted on a server and accessed via a web browser on most any machine.
Response: Alfresco operates with a content application server[1], while users connect to it via web, mobile, and other types of clients. As Alfresco is integrated into the webLiMS suite of applications, the content application server is hosted in the cloud.
Y 1.1.102 The system contains a single, centralized database that supports multiple sites and departments.
Response: Alfresco's content repository "is comparable to a database, except that it holds more than data." The development team describes this further in their documentation:
The actual binary streams of the content are stored in files managed in the repository, although these files are for internal use only and do not reflect what you might see through the shared drive interfaces. The repository also holds the associations among content items, classifications, and the folder/file structure. The folder/file structure is maintained in the database and is not reflected in the internal file storage structure.[2]

Alfresco also allows users to set up "sites" for separate projects or user groups to manage custom content.[3]

Y 1.1.103 The system's database conforms to the Open Database Connectivity Standard (ODBC).
Response: Alfresco Community comes bundled with PostgreSQL, which has an associated ODBC driver. The software can also be run against MySQL.[4]
Y 1.1.104 The system is designed so upgrades to the back-end database do not require extensive reconfiguration or effectively cripple the system.
Response: Alfresco Community allows administrators to extend and override database properties through repository configuration files[4], presumably with little impact to the system.
Y 1.1.105 The system is designed to not be impacted by multiple users or failover processes.
Response: One of the guiding design principles of Alfresco Community is to be enterprise scalable.[5] This aspect was so important that the developers created a Scalability Blueprint.[6]
Y 1.1.106 The system applies security features to all system files.
Response: Alfresco Community system files, including configuration files, are only accessible to authorized administrators.
Y 1.1.107 The system applies log-in security to all servers and workstations accessing it.
Response: Users must provide a username and password before entering the system via web client. Administrators must also use a username and password to access server-side files. All of this accomplished through the authentication subsystem.[7]
Y 1.1.108 The system provides a workstation and server authentication mechanism.
Response: Alfresco Community employs an authentication subsystem to ensure authentication between client and server.[7]
U 1.1.109 The system applies Secured Socket Layer (SSL) encryption on the web client interface.
Response: Alfresco Community seems to be able to be used in HTTPS mode with some configuration, but it's not clear if it interfaces via HTTPS in default mode. Some documentation and forum posts suggest it's possible for the client to access the server via SSL.[8][9][10]
U 1.1.110 The system encrypts client passwords in a database, with support for multi-case and special characters.
Response: Alfresco Community does not seem to inherently include encryption capabilities, at least for repositories. The documentation for Community makes no mention of encryption on passwords. Several items seem to support the lack of encryption, though this matter needs to be researched further.[11][12]
Y 1.1.111 The system uses TCP/IP as its network transport.
Response: Data can be transferred between client and server via FTP and HTTP high-level application protocols (among others).
Y 1.1.112 The system allows automated backup and restore capability without support intervention, as well as manual backups.
Response: Alfresco Community allows for manual backup and restore by the administrator.[13] Further backup and recovery tools can be added with the Alfresco BART add-on.[14]
U 1.1.113 The system maintains the transactional history of system administrators.
Response: It's not clear if an audit log is maintained of all administrator activity.

1.1.2 Hardware environment

1.1.2 Hardware environment
Requirement code Requirement # and requirement
Y 1.1.200 The system proves compatible with a variety of hardware environments.
Response: The developers state "Alfresco degrades gracefully on low powered hardware, and small installations can run well on any modern server." They also state the optimal hardware configuration.[15]
U 1.1.201 The system can be utilized with a touch-screen.
Response: Alfresco Community can normally be accessed via the Alfresco Mobile application for Android and iPhone.[16] It's not clear if webLiMS users will be able to access their cloud-hosted SDMS using the mobile app, however.

1.1.3 Software environment

1.1.3 Software environment
Requirement code Requirement # and requirement
Y 1.1.300 The system proves compatible with a variety of software environments.
Response: Alfresco Community installation packages exist for Windows, Mac, and Linux.[17]
Y 1.1.301 The system utilizes a non-proprietary database such as Oracle or Microsoft SQL Server.
Response: Alfresco Community comes bundled with PostgreSQL and can also be run against MySQL.[4]

1.2 Regulatory compliance and security

1.2.1 Regulatory compliance

1.2.1 Regulatory compliance
Requirement code Requirement # and requirement
Y 1.2.100 The system can generate accurate and complete copies of records in both a human-readable and original electronic format for review and copying.
Response: Alfresco Community remains "format-agnostic,"[18] meaning any file type can be uploaded. As long as the original file's MIME type allows for indexing, thumbnailing, metadata extraction, etc., the file will be human-readable while maintaining the original electronic format. Review and copy of the file is permission-based.[18]
U 1.2.101 The system supports 21 CFR Part 11 and EU Annex 11 requirements, including log-in security, settable automatic logouts, periodic requirements for mandatory password changes, limits on reusability of passwords, and full electronic signature.
Response: Alfresco Community seems to support many 21 CFR Part 11 requirements. The inherent lack of digital signatures, however, has been referenced on multiple occasions on the Alfresco site over the years.[19][20] Are the add-ons enough?[21] The same problem likely exists for EU Annex 11 requirements.
N 1.2.102 The system supports USP <232>/<233> requirements.
Response: Alfresco Community does not support these requirements.
U 1.2.103 The system supports GALP and/or GAMP standards.
Response: Alfresco Community seems to support some GxP requirements; however, it's not clear if all requirements are met. Users can add digital signatures to PDFs via an add-on, but it's not clear if other non-PDF records can be digitally signed, for example.[20]
Y 1.2.104 The system supports the U.S. DoD 5015.2 Standard.
Response: Through the Records Management module, the Records Management Site can be set up to be DoD 5015.2 Standard compliant.[22]
Y 1.2.105 The system maintains date- and time-stamped audit trails of all data manipulation — such as changes to results, data analysis parameters, and methods — as consistent with all applicable regulations and standards, making the information available for review, copying, and reporting to authorized users.
Response: As long as content auditing is enabled via configuration, reportable audit trails will be captured.[23] The documentation states:
The audit log contains the entire history of an object since the point it was added to the File Plan, and can be useful for finding out about specific events that have occurred during an objects life cycle, and any users that have been involved. Every entry in the audit log is timestamped and where metadata has been changed, the original values and changed values are recorded.[24]
U 1.2.106 The system audit log retains all data, prohibits any deletions, and allows user comments.
Response: As stated in 1.2.105, the entire history of an object is retained. Access to view, export, or file the audit trail as a a record is allowed if the administrator assigns the "Access Audit" permission.[25] It's not explicitly stated whether or not the user can delete any audit content. If the audit log is filed as a record, then those with access to that record can comment on it. It's not explicitly clear if a non-filed audit log can be commented on.
Y 1.2.107 The system maintains audit trails at least as long as the records to which they pertain.
Response: As stated in 1.2.105, the entire history of an object is retained. Additionally, disposition schedules allow associated metadata and an audit trail to remain even after deletion as long as "Maintain Record Metadata after Delete" is enabled during the creation of a disposition schedule.[26] Audit trails for held content are also maintained.[27]
Y 1.2.108 The system provides additional persistent auditing capabilities, such as the audit of cancelled uploads and scheduled system functions.
Response: The Audit Filter can be customized to include additional auditing of system and more complex user tasks.[23]
U 1.2.109 The system provides the ability to both automatically and manually add secure electronic signatures to documents and other data.
Response: See response in 1.2.101 and 1.2.103.
N 1.2.110 The system can automatically validate and approve data prior to being moved to the main database.
Response: The SDMS doesn't seem to inherently have automated data validation and approval tools. Users who file records will need to manually validate that metadata has been captured from the added record and mark the record as complete before it is filed.[28]

1.2.2 Security

1.2.2 Security
Requirement code Requirement # and requirement
Y 1.2.200 The system allows administrators and other authorized users to configure multiple levels of user rights and security by site location, department, group, role, and/or specific function.
Response: The SDMS allows for four types of roles out of the box, each with their own assigned permissions.[29] More flexible security roles and groups can be added by either setting up custom roles on a clean install[30] or installing security add-ons.[31]
U 1.2.201 The system allows administrators and users to reset user passwords.
Response: Alfresco Community doesn't seem to make it easy. An administrator can change the admin password[32], and users are allowed to reset their password in their dashboard[33] and with the addition of the Reset Password Dialog add-on.[34] But it's not clear if administrators can change user passwords without knowing the original user password.[35]
N 1.2.202 The system features and enforces adjustable rules concerning password complexity, reuse, and expiration.
Response: The software does not have this functionality by default. (A commercial add-on may provide this functionality.[36])
N 1.2.203 The system can lock a user out after a specified number of consecutive failed log-in attempts.
Response: The software does not have this functionality by default. (A commercial add-on may provide this functionality.[36])
N 1.2.204 The system provides the option for automatic user logout based on keyboard or mouse inactivity.
Response: The software doesn't appear to have this functionality.
Y 1.2.205 The system makes authority checks to ensure only authorized individuals can use the system to perform an operation.
Response: The system contains configurable authorization enforcement.[37]
Y 1.2.206 The system allows authorized users to modify records, while also maintaining an audit trail of such actions.
Response: Users can view, edit, delete, and download files.[38] As long as content auditing is enabled via configuration, reportable audit trails will be captured.[23]
Y 1.2.207 The system allows authorized users to manually delete records, while also maintaining an audit trail of such actions.
Response: Records can manually be deleted[39] while retaining an audit trail as long as auditing is enabled via configuration.[23] Records can also be deleted automatically as part of a disposition schedule in the Records Management module.[40] Associated metadata and an audit trail will remain as long as "Maintain Record Metadata after Delete" is enabled during the creation of a disposition schedule.[26]
N 1.2.208 The system prompts users to declare a reason for making changes to or deleting data in the system.
Response: The software doesn't appear to have this functionality.
Y 1.2.209 The system allows authorized users to generate a detailed user access record.
Response: As long as content auditing is enabled via configuration, authorized users can view reportable audit trails which include user access records.[23]
N 1.2.210 The system provides email notification of lockout, security access, and improper workstation access.
Response: The software doesn't appear to have this functionality.
N 1.2.211 The system provides a mechanism to allow a user read-only access to stored data.
Response: The software doesn't appear to have this functionality.[41]
Y 1.2.212 The system allows automatic and/or manual holds or locks to be placed on data to ensure it goes unaltered or remains retrievable during a retention period.
Response: Through the Records Management module, users can manually set up holds with user permissions and apply records or folders to the hold.[42]
U 1.2.213 The system can first feed data from connected non-CFR-compliant instruments through a virtual environment that is compliant (audit trailed, secure, versioned, etc.) before being stored.
Response: Not clear if information can be fed into webLiMS, be made complaint, and then stored in the SDMS.
N 1.2.214 The system can control whether users are able to export data to portable long-term storage media like a USB flash drive or recordable DVD.
Response: The software doesn't appear to have this functionality.
U 1.2.215 The system employs automatic file encryption on stored data.
Response: Alfresco Community does not seem to inherently include encryption capabilities, at least for repositories. Several items seem to support the lack of encryption, though this matter needs to be researched further.[11][12]

1.3 General system functions

1.3.1 General functions

1.3.1 General functions
Requirement code Requirement # and requirement
Y 1.3.100 The system offers non-SDMS trained personnel the ability to easily access system data via an intuitive, user-friendly Windows-type graphical user interface (GUI) which permits the display of stored data.
Response: Users can easily access stored data without downloading it via the Document Details page.[43]
Y 1.3.101 The system allows authorized users to configure their GUI to a specific language, character set, and time zone.
Response: The software allows users to change the language at the log-in screen, and additional language packs can be added with language packs.[44] The time zone can be set as a system-wide property.
U 1.3.102 The system permits remote access for users, system admins, and support agents.
Response: The system can be accessed from anywhere using a valid web browser. It's not clear if the webLiMS-hosted SDMS can be accessed via the Alfresco Mobile application. (See 1.1.201)
U 1.3.103 The system allows for the use of navigation keys to freely move from field to field.
Response: It's not clear if keyboard shortcuts or tabbing are inherent to the interface.
Y 1.3.104 The system allows tabular data to be sorted and filtered.
Response: This feature was added in version 4.2.[45]
N 1.3.105 The system can send on-screen output to a printer or file without contradicting read-only statuses.
Response: As read-only statuses don't seem to be supported, this functionality is not available by extension.[41]
U 1.3.106 The system contains one or more spell-check dictionaries that allow authorized users to add, edit, or remove entries.
Response: The SDMS seems to have some minor spell check abilities in the search box, but it's not clear if users can edit the dictionary.[46] Additionally, it's not clear if spell check can be employed during inline editing of documents.
Y 1.3.107 The system uses human-readable metadata tags to better describe, index, and store all captured and archived data.
Response: Metadata extraction occurs automatically via extractors, which can be configured.[47]
N 1.3.108 The system can generate metadata tags via derived value rules.
Response: That functionality is not supported.
N 1.3.109 The system allows users to manually add metadata tags to files.
Response: The system appears to not allow users to add/edit metadata after upload without major customization.[48]
Y 1.3.110 The system provides full metadata, keyword, and field search capability, including the use of multiple search criteria.
Response: The system allows users to search based on numerous facets like file type, creator, creation date, etc.[49]
U 1.3.111 The system allows users to search for similar records based upon a set of metadata tag values.
Response: It's not clear if the latest version includes this advanced search capability. The assumption is it doesn't.
U 1.3.112 The system allows users to build, save, and edit queries for future use.
Response: It's not clear if the latest version includes this advanced search capability. The assumption is it doesn't.
N 1.3.113 The system can automate the search for and extraction of pertinent data, including the export of that data to external applications for additional processing and calculation.
Response: The system doesn't appear to have this functionality.
Y 1.3.114 The system allows users to attach comments to data and files.
Response: Users can add, edit, or delete comments, based upon their role.[50]
U 1.3.115 The system's file viewer/explorer allow users to view native, processed, and archived data in its native file structure.
Response: Complete folder-based file structures can be imported into Alfresco Community[51], but the documentation doesn't explicitly state if that file structure can be viewed in the file viewer.
N 1.3.116 The system can link objects to other objects, e.g. linking a standard operating procedure (SOP) to a test result.
Response: Users appear able to place a link to a different file in the comments of an existing file[52]; however, no file linking mechanism seems to exist.
N 1.3.117 The system notifies users of events like the scheduling and completion of tasks.
Response: Users can receive e-mail notifications of a few system-wide changes[53], but many other notifications like event reminders and new/modified post reminders must be manually programmed into the existing code.[54][55]
Y 1.3.118 The system includes the ability to set up alerts via email.
Response: Users can receive e-mail notifications of a few system-wide changes.[53]
N 1.3.119 The system offers integrated or online user help screens.
Response: Help screens don't appear to be integrated into Alfresco Community, but documentation on the system can be found on the Alfresco website.
N 1.3.120 The system includes data analysis and calculation tools.
Response: Alfresco Community does not include data analysis or calculation tools; however, those tools can be found in other webLiMS applications.

1.3.2 Configuration and customization

1.3.2 Configuration and customization
Requirement code Requirement # and requirement
Y 1.3.200 The system architecture is modular or extensible and can easily and efficiently be modified to facilitate the addition of new functionality as business needs change.
Response: One of the guiding design principles of Alfresco Community is to be enterprise scalable.[5] Users can add additional functionality through the add-ons community.
Y 1.3.201 The system has an application programming interface (API) or a similar software development toolkit (SDK). If web-based, the API should support Simple Object Access Protocol (SOAP), representational state transfer (REST), or both.
Response: Alfresco Community can be extended with the Maven Alfresco SDK[56] or numerous APIs.[57]
N 1.3.202 The system allows a user to independently add fields without requiring reconfiguration of the system, even after routine upgrades and maintenance.
Response: Custom fields are not able to be added by users. Custom Content Models allow administrators to add new metadata fields on the back end, however.[58]
N 1.3.203 The system allows for the integration of additional printers and scanners both locally and externally.
Response: Alfresco Community does not inherently support printers. However, the interface is web-based, and an accessed file can be downloaded and printed to a local machine.[59]

1.3.3 Data capture

1.3.3 Data capture
Requirement code Requirement # and requirement
Y 1.3.300 The system can manage and store both sample- and non-sample-related data, including images from microscopes, GCMS scans of peaks, PDF files, spreadsheets, or even raw data files from instrument runs for later processing.
Response: Alfresco Community remains "format-agnostic,"[18] meaning any file type can be uploaded.
Y 1.3.301 The system can manage and store media objects like digital photos, bitmaps, movies, and audio files.
Response: Alfresco Community remains "format-agnostic,"[18] meaning any file type can be uploaded, including media files.
Y 1.3.302 The system allows multiple native instruments and users to enter data into the system simultaneously without disruption.
Response: One of the guiding design principles of Alfresco Community is to be enterprise scalable, with as few disruptions as possible.[5] Note that instruments can't be connected directly to the SDMS; however, instruments can be interfaced to the SDMS through the LabVia webLiMS application.
U 1.3.303 The system can interface with and import existing data from other databases and file shares.
Response: Complete folder-based file structures can be imported into Alfresco Community using a number of methods.[51] It's assumed webLiMS users can also move files from other webLiMS applications to the SDMS, but this needs to be confirmed.
N 1.3.304 The system supports data capture from a Citrix-based environment.
Response: Aside from capturing metadata data from imported files of a sufficient MIME type, Alfresco Community doesn't seem to offer data capture capabilities. However, other webLiMS applications can capture instrument and other data, and that data can then be managed and stored in the SDMS.
Y 1.3.305 The system allows file indexes to be stored centrally while associated files are stored geographically.
Response: Alfresco Community uses Solr for indexing, and it has "no need to duplicate indexes on every machine in a cluster," suggesting indexes could be stored on a central machine.[60]
1.3.306 The system allows users to organize captured data by project, date, location, instrument, etc.
Response:
1.3.307 The system can route captured data based upon specified metadata tags.
Response:
N 1.3.308 The system allows full on-screen review and approval of native instrument data prior to database commitment.
Response: Alfresco Community can not interface with instruments and does not have this functionality. However, optional middleware could add this functionality.
1.3.309 The system keeps all captured data and its format intact and captures modifications of that data as a version, including date and time of those modifications, for regulatory purposes.
Response:
1.3.310 The system has a tool that allows users to capture data printed to it as a searchable PDF file.
Response:
N 1.3.311 The system can automatically normalize and store incoming data to a technology-neutral format like XML.
Response: Alfresco Community doesn't seem able to convert imported files to another format.
1.3.312 The system allows incoming and entered files to be converted into other open formats like JCAMP-DX, TraML, mzML, mzXML, AnIML, pepXML, and protXML.
Response:
1.3.313 The system can capture and store native instrument and processed data based on a scheduled time or a real-time event, such as upon file creation.
Response:
1.3.314 The system allows users to manually upload instrument data files that are not part of a scheduled upload.
Response:
1.3.315 The system allows for the specification of a retention period for captured native instrument and processed data and can enact it based on date-based metadata fields or a future event.
Response:
1.3.316 The system can remove data from client machines upon upload and/or backup, based on a schedule or retention policy.
Response:
1.3.317 The system allows users to review, restore, and reprocess original native instrument data on the original instrument acquisition software.
Response:
1.3.318 The system allows users to open and view captured native instrument files without restoring them.
Response:
1.3.319 The system allows captured processed data to be reused by other applications without having to reprocess it.
Response:
1.3.320 The system provides a method to extract data points from captured processed data and present it in a human-readable format.
Response:
1.3.321 The system can parse captured data files containing specified metadata into a live results table.
Response:

1.3.4 Data archiving and migration

1.3.4 Data archiving and migration
Requirement code Requirement # and requirement
1.3.400 The system provides data archiving functionality for all contained data, without requiring an off-line mode.
Response:
1.3.401 The system allows for a configurable scheduled archive, not requiring human interaction with the data to be archived.
Response:
1.3.402 The system allows for a scheduled archive of data directly captured from a specific native instrument.
Response:
1.3.403 The system permits native instrument data to be archived and restored with its original directory structure.
Response:
1.3.404 The system allows for the specification of a retention period for archived and migrated data and can enact it based on date-based metadata fields or a future event.
Response:
1.3.405 The system ensures that held or locked native instrument data not captured during a scheduled archive will be captured during the next scheduled archive.
Response:
1.3.406 The system can perform archive and restore functions simultaneously with data capture and viewing functions, without disruption.
Response:
1.3.407 The system allows native instrument and processed data migrated from an old SDMS version to be backed up and restored without alteration.
Response:

1.3.5 Instruments

1.3.5 Instruments
Requirement code Requirement # and requirement
1.3.500 The system bilaterally interfaces with instruments and related software based on the Unix and Windows platforms.
Response:
1.3.501 The system can download data directly from laboratory instruments.
Response:
1.3.502 The system can track and report on the usage of attached laboratory instruments.
Response:
1.3.503 The system can automatically (or manually allow an authorized user to) remove an instrument from potential use when it falls out of tolerance limit or requires scheduled calibration.
Response:
1.3.504 The system maintains a reportable database of preventative maintenance, calibration, and repair records for attached laboratory instruments.
Response:
1.3.505 The system can schedule calibration, verification, and maintenance tasks on attached instruments and make that schedule available for viewing.
Response:
1.3.506 The system allows users to create and edit instrument maintenance profiles.
Response:

1.3.6 External system interfaces

1.3.6 External system interfaces
Requirement code Requirement # and requirement
1.3.600. The system supports a library of common electronic data deliverable (EDD) formats.
Response:
1.3.601 The system can transfer data to and from other record management systems.
Response:
1.3.602 The system integrates with Microsoft Exchange services.
Response:
1.3.603 The system can import data from and export data to Microsoft Word, Excel, Access, and/or Powerpoint.
Response:
1.3.604 The system can interface with non-Microsoft programs.
Response:
1.3.605 The system can interface with enterprise resource planning (ERP) systems.
Response:
1.3.606 The system can interface with internal and external laboratory systems like laboratory information management systems (LIMS) and electronic laboratory notebooks (ELNs).
Response:
1.3.607 The system can leverage the application programming interface (API) of other systems to establish integration between systems.
Response:
1.3.608 The system provides a real-time interface for viewing live and stored data transactions and errors generated by interfaced instruments and systems.
Response:
1.3.609 The system supports dockable mobile devices and handles information exchange between them and the system.
Response:
1.3.610 The system supports the use of optical character recognition (OCR) software.
Response:

1.3.7 Reporting

1.3.7 Reporting
Requirement code Requirement # and requirement
1.3.700 The system includes a versatile report writer and forms generator that can generate reports from any data in the system.
Response:
1.3.701 The system can interface with a third-party reporting application.
Response:
1.3.702 The system allows the development of custom templates for different types of reports.
Response:
1.3.703 The system maintains template versions and renditions, allowing management and tracking of the template over time.
Response:
1.3.704 The system uses Microsoft Office tools for formatting reports.
Response:
1.3.705 The system provides multiple ways to visualize data in reports, including graphs, trend bars, pie charts, spectrum, etc. for the purpose of presenting information and identifying trends.
Response:
1.3.706 The system makes graphic and tabular data vector-scalable in reports.
Response:
1.3.707 The system allows for internal hyperlinking to source data in reports.
Response:
1.3.708 The system allows users to manually adjust inaccurate data parsing routines for reports.
Response:
1.3.709 The system can indicate whether a report is preliminary, amended, corrected, or final while retaining revision history.
Response:
1.3.710 The system can automatically generate laboratory reports of findings and other written documents.
Response:
1.3.711 The system provides an ad-hoc web reporting interface to report on user-selected criteria.
Response:
1.3.712 The system can automatically generate and post periodic static summary reports on an internal web server.
Response:
1.3.713 The system can transmit reports in a variety of ways including fax, e-mail, print, and website in formats like RTF, PDF, HTML, XML, DOC, XLS, and TXT.
Response:
1.3.714 The system supports PDF/A, an ISO-standardized version of the Portable Document Format (PDF).
Response:
1.3.715 The system includes a rules engine to determine the recipients of reports and other documents based on definable parameters.
Response:
1.3.716 The system provides printer-friendly audit trails for cleaner reporting of audit data.
Response:
1.3.717 The system provides an interface for external clients to search, generate, and view processed data reports based on metadata tags.
Response:
1.3.718 The system provides document workflow management tools for streamlining their creation, review, modification, and approval.
Response:

References

  1. ↑ "Alfresco architecture". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/concepts/alfresco-arch-about.html. Retrieved 28 October 2014. 
  2. ↑ "Alfresco content respository". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/concepts/content-repo-about.html. Retrieved 28 October 2014. 
  3. ↑ "Alfresco sites". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/concepts/sites-intro.html. Retrieved 28 October 2014. 
  4. ↑ 4.0 4.1 4.2 "Database Configuration". Alfresco Wiki. Alfresco Software, Inc. https://wiki.alfresco.com/wiki/Database_Configuration. Retrieved 28 October 2014. 
  5. ↑ 5.0 5.1 5.2 "Guiding design principles". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/concepts/alfresco-principles.html. Retrieved 28 October 2014. 
  6. ↑ "Alfresco Scalability Blueprint". Alfresco Software, Inc. http://www.alfresco.com/resources/whitepapers/alfresco-scalability-blueprint. Retrieved 28 October 2014. 
  7. ↑ 7.0 7.1 "Authentication subsystems". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/concepts/auth-subsystem-intro.html. Retrieved 28 October 2014. 
  8. ↑ dholgado (4 October 2007). "Howto Secure Alfresco with https: access?". Alfresco Forums. Alfresco Software, Inc. https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/configuration/howto-secure-alfresco-https. Retrieved 28 October 2014. 
  9. ↑ webberj (11 July 2013). "Change Alfresco to use SSL and "Share" stops authenticating!". Alfresco Forums. Alfresco Software, Inc. http://forums.alfresco.com/forum/installation-upgrades-configuration-integration/configuration/change-alfresco-use-ssl-and. Retrieved 28 October 2014. 
  10. ↑ de la Fuente, Toni (1 April 2014). "Alfresco Tip: How to enable SSL in Alfresco SharePoint Protocol". blyx.com. http://blyx.com/2014/04/01/alfresco-tip-how-to-enable-ssl-in-alfresco-sharepoint-protocol/. Retrieved 28 October 2014. 
  11. ↑ 11.0 11.1 "Transparent Alfresco Repository Encryption". Skytizens Co. Ltd. http://www.skytizens.com/ระบบจัดการเอกสาร-alfresco/repository-encryption/. Retrieved 28 October 2014. 
  12. ↑ 12.0 12.1 "Alfresco Encryption Module". Alfresco add+ons. Alfresco Software, Inc. https://addons.alfresco.com/addons/alfresco-encryption-module. Retrieved 28 October 2014. 
  13. ↑ "Backup and Restore". Alfresco Wiki. Alfresco Software, Inc. https://wiki.alfresco.com/wiki/Backup_and_Restore. Retrieved 28 October 2014. 
  14. ↑ "Alfresco BART (Backup and Recovery tool)". Alfresco add+ons. Alfresco Software, Inc. https://addons.alfresco.com/addons/alfresco-bart-backup-and-recovery-tool. Retrieved 28 October 2014. 
  15. ↑ "JVM Tuning". Alfresco Wiki. Alfresco Software, Inc. http://wiki.alfresco.com/wiki/Repository_Hardware. Retrieved 01 November 2014. 
  16. ↑ "Mobile". Alfresco Wiki. Alfresco Software, Inc. https://wiki.alfresco.com/wiki/Mobile. Retrieved 01 November 2014. 
  17. ↑ "Alfresco Community installation files". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/concepts/download-community.html. Retrieved 01 November 2014. 
  18. ↑ 18.0 18.1 18.2 18.3 Esplin, Richard (22 June 2011). "Alfresco Content Formats". SIWI: Stuff I Want on the Internet. http://richard.esplins.org/siwi/2011/06/22/alfresco-content-formats/. Retrieved 01 November 2014. 
  19. ↑ mstoakes (17 May 2007). "FDA 21 CFR Part 11 Compliance". Alfresco Software, Inc. http://forums.alfresco.com/forum/non-technical-alfresco-discussion/fda-21-cfr-part-11-compliance-05172007-0124. Retrieved 01 November 2014. 
  20. ↑ 20.0 20.1 priyanjali (2 March 2009). "Alfresco for 21 CFR Part 11 - Digital Signatures". Alfresco Software, Inc. https://forums.alfresco.com/forum/developer-discussions/add-ons/alfresco-21-cfr-part-11-digital-signatures-03022009-0629. Retrieved 01 November 2014. 
  21. ↑ "Digital Signature". Alfresco add+ons. Alfresco Software, Inc. https://addons.alfresco.com/tags/digital-signature. Retrieved 01 November 2014. 
  22. ↑ "Creating the Records Management site". Alfresco Records Management 2.2. Alfresco Software, Inc. http://docs.alfresco.com/rm2.2/tasks/rm-create-site.html. Retrieved 01 November 2014. 
  23. ↑ 23.0 23.1 23.2 23.3 23.4 "Content Auditing". Alfresco Wiki. Alfresco Software, Inc. https://wiki.alfresco.com/wiki/Content_Auditing. Retrieved 01 November 2014. 
  24. ↑ "Auditing and reporting". Alfresco Records Management 2.2. Alfresco Software, Inc. http://docs.alfresco.com/rm2.2/concepts/rm-auditing.html. Retrieved 01 November 2014. 
  25. ↑ "Viewing and audit log". Alfresco Records Management 2.2. Alfresco Software, Inc. http://docs.alfresco.com/rm2.2/tasks/rm-audit-viewing.html. Retrieved 01 November 2014. 
  26. ↑ 26.0 26.1 "Creating disposition schedule steps". Alfresco Records Management 2.2. Alfresco Software, Inc. http://docs.alfresco.com/rm2.2/tasks/rm-dispschedule-createsteps.html. Retrieved 01 November 2014. 
  27. ↑ "Creating holds". Alfresco Records Management 2.2. Alfresco Software, Inc. http://docs.alfresco.com/rm2.2/tasks/rm-create-hold.html. Retrieved 01 November 2014. 
  28. ↑ "File a record". Alfresco Records Management Community 2.3a. Alfresco Software, Inc. http://docs.alfresco.com/rm-community/concepts/rm-tutorials-08.html. Retrieved 01 November 2014. 
  29. ↑ "User roles and permissions". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/references/permissions_share.html. Retrieved 01 November 2014. 
  30. ↑ "Custom Permissions in Share". Alfresco Wiki. Alfresco Software, Inc. https://wiki.alfresco.com/wiki/Custom_Permissions_in_Share. Retrieved 01 November 2014. 
  31. ↑ "Security". Alfresco add+ons. Alfresco Software, Inc. https://addons.alfresco.com/tags/security. Retrieved 01 November 2014. 
  32. ↑ "Security and Authentication - How to reset the admin password". Alfresco Wiki. Alfresco Software, Inc. https://wiki.alfresco.com/wiki/Security_and_Authentication#How_to_reset_the_admin_password. Retrieved 03 November 2014. 
  33. ↑ "Changing your password". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/tasks/profile-password.html. Retrieved 03 November 2014. 
  34. ↑ "Reset Password Dialog". Alfresco add+ons. Alfresco Software, Inc. https://addons.alfresco.com/addons/reset-password-dialog. Retrieved 03 November 2014. 
  35. ↑ yannicuLar (5 April 2013). "Alfresco WebServices API, Change User Password". Stack Overflow. Stack Exchange, Inc. http://stackoverflow.com/questions/15837068/alfresco-webservices-api-change-user-password. Retrieved 03 November 2014. 
  36. ↑ 36.0 36.1 George, Nimmi (1 January 2014). "Implementing Account Lockout feature in Alfresco". Alfresco Forums. Alfresco Software, Inc. https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/authentication-ldap-sso/implementing-account. Retrieved 03 November 2014. 
  37. ↑ "Authorization And Access Control". Alfresco Wiki. Alfresco Software, Inc. https://wiki.alfresco.com/wiki/Authorization_And_Access_Control. Retrieved 03 November 2014. 
  38. ↑ "Working with files". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/concepts/library-items-individual.html. Retrieved 03 November 2014. 
  39. ↑ "Deleting content". Alfresco Community 5.0 Documentation. http://docs.alfresco.com/community/tasks/library-item-delete.html. Retrieved 03 November 2014. 
  40. ↑ "Disposition schedules". Alfresco Records Management 2.2. Alfresco Software, Inc. http://docs.alfresco.com/rm2.2/concepts/rm-dispschedule.html. Retrieved 03 November 2014. 
  41. ↑ 41.0 41.1 edwsin (7 December 2012). "Restrict User from downloading document". Alfresco Forums. Alfresco Software, Inc. https://forums.alfresco.com/forum/developer-discussions/repository-services/restrict-user-downloading-document-12072012-0830. Retrieved 03 November 2014. 
  42. ↑ "Managing records holds". Alfresco Records Management 2.2. Alfresco Software, Inc. http://docs.alfresco.com/rm2.2/concepts/rm-manage-holds.html. Retrieved 03 November 2014. 
  43. ↑ "Viewing content". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/concepts/library-folder-intro.html. Retrieved 03 November 2014. 
  44. ↑ "Language Packs". Alfresco Wiki. Alfresco Software, Inc. http://wiki.alfresco.com/wiki/Language_Packs. Retrieved 03 November 2014. 
  45. ↑ Roast, Kevin (22 August 2013). "Alfresco Community 4.2.d". Kev's blog. http://blogs.alfresco.com/wp/kevinr/2013/08/22/alfresco-community-4-2-d/. Retrieved 03 November 2014. 
  46. ↑ Roast, Kevin (2 October 2014). "Alfresco Community 5.0.b". Kev's blog. http://blogs.alfresco.com/wp/kevinr/2014/10/02/alfresco-community-5-0-b/. Retrieved 03 November 2014. 
  47. ↑ "Configuring metadata extraction". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/tasks/metadata-config.html. Retrieved 03 November 2014. 
  48. ↑ yuhuayang (14 August 2013). "Edit Metadata upon upload". Alfresco Forums. Alfresco Software, Inc. https://forums.alfresco.com/forum/developer-discussions/alfresco-share-development/edit-metadata-upon-upload-08142013-1955. Retrieved 03 November 2014. 
  49. ↑ Roast, Kevin (27 June 2014). "Alfresco Community 5.0.a". Kev's blog. http://blogs.alfresco.com/wp/kevinr/2014/06/27/alfresco-community-5-0-a/. Retrieved 03 November 2014. 
  50. ↑ "Managing your comments". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/concepts/library-comments.html. Retrieved 03 November 2014. 
  51. ↑ 51.0 51.1 mws (15 May 2013). "Upload a directory tree". Alfresco Forums. Alfresco Software, Inc. https://forums.alfresco.com/forum/end-user-discussions/alfresco-cloud/upload-directory-tree-05152013-1508. Retrieved 03 November 2014. 
  52. ↑ "Sharing content". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/tasks/library-item-share.html. Retrieved 03 November 2014. 
  53. ↑ 53.0 53.1 "Controlling your email notifications". Alfresco Community 5.0 Documentation. Alfresco Software, Inc. http://docs.alfresco.com/community/tasks/profile-notifications.html. Retrieved 03 November 2014. 
  54. ↑ mcasanket (26 December 2011). "Calendar event reminder by email". Alfresco Forums. Alfresco Software, Inc. https://forums.alfresco.com/forum/end-user-discussions/alfresco-share/calendar-event-reminder-email-12262011-0629. Retrieved 03 November 2014. 
  55. ↑ satsel (30 April 2014). "Share discussion email notification". Alfresco Forums. Alfresco Software, Inc. https://forums.alfresco.com/forum/end-user-discussions/alfresco-share/share-discussion-email-notification-04302013-0438. Retrieved 03 November 2014. 
  56. ↑ "Maven Alfresco SDK". Alfresco Wiki. Alfresco Software, Inc. https://wiki.alfresco.com/wiki/Maven_Alfresco_SDK. Retrieved 03 November 2014. 
  57. ↑ "Developers Guide". Alfresco Wiki. Alfresco Software, Inc. https://wiki.alfresco.com/wiki/Developer_Guide#Developing_against_the_Alfresco_Repository. Retrieved 03 November 2014. 
  58. ↑ "Step-By-Step: Creating A Custom Model". Alfresco Wiki. Alfresco Software, Inc. http://wiki.alfresco.com/wiki/Step-By-Step:_Creating_A_Custom_Model. Retrieved 03 November 2014. 
  59. ↑ Imrie, George (29 June 2012). "Printing direct from Alfresco". Alfresco Forums. Alfresco Software, Inc. https://forums.alfresco.com/forum/installation-upgrades-configuration-integration/integration-other-systems/printing-direct. Retrieved 03 November 2014. 
  60. ↑ "Alfresco And SOLR". Alfresco Wiki. Alfresco Software, Inc. https://wiki.alfresco.com/wiki/Alfresco_And_SOLR. Retrieved 04 November 2014. 
Retrieved from "https://www.limswiki.org/index.php?title=User:Shawndouglas/sandbox/sublevel3&oldid=16319"