1. |
- Centralpoint Module Gallery
- Content Management, Deep Dive - Video Overview, Development Tools (Utilities), Knowledge Management, Strategy
- Everyone: All Users
- 12/28/2015
- Relevance: 181
-
-
12/31/9999 11:59:59 PM
-
Centralpoint, Oxcyon, Gartner, Magic Quadrant, MQ, Digital Experience, Portal, SSO, SAML, AD, Data Migraiton, Document Management, Metadata, Taxonomy, Enterprsie Content Management, Knowledge Management, metadata,ontology,intranet,portal,transformation,Artificial Intelligence,aggregation
-
Centralpoint's Data Cleaner (otherwise known as Data Goverrnance) collaborates seamlessly with Centralpoint's Data Transfer utility, automating metadata and Taxonomy assignment for your content. This empowers the transformation of any information that lacks proper metadata. Regardless of the information type—raw data from databases like Oracle, IBM, SQL Access, Excel, and documents such as PDFs, MS Word, or Excel—Data Cleaner ensures metadata and Taxonomy application to each record upon import. This process allows for your terminology, product skus, laws, policies, and other pertinent information to be leveraged as a way to enrich your metadata, taxonomy and ontology....automatically.
Centralpoint's Data Cleaner covers HTML, Taxonomy, and Keywords, granting you the ability to manage condition dictionaries, including determining how many instances of a word or part number correspond to specific Taxonomy or keywords. For further insights, explore the extensive features we offer for MDM (Master Data Management).
The best way to understand how this tool can benefit your organization is to actually see it. We encourage you to set up a demonstration with us, so that we may step through the various routines online, via a MS/Teams Meeting demo, and we can address any of your questions or challenges .If you are interested in this new module, you may also want to see our Taxonomy Pre-Import Tool. Be sure to see our Data Transfer module for more information.
Types of Data Transformation which are supported and the required fields needed for each:
- Structured Data Sources
- MS/Sharepoint -Source Site URL, Title, List Title, Username, Password
- Oracle -Connection String/table name, any query or filter (credentials)
- MS/SQL -Connection String/table name, any query or filter (credentials)
- MS/Office 365- (Ondrive) Authorization, Source Folder (Office365 file Selector), Source Recursive (y/n), Source End Point (bulk or changes)
- OLEDB - Connection String/table name, any query or filter (credentials)
- ODBC - Connection String/table name, any query or filter (credentials)
- XML- ReadXML -XML Source (path to xml), Available tables and columns, Source Table Index
- XML- CpCollection –Source XML (path to xml), Default File, Source Directory, Number of Files to select, XSLT
- Delimited TXT (oledb)– Source Directory, Source Delimiter used, Source Text Qualifier, Source Header Row, Source Select Command
- Delimited TXT (Stream)– Source Directory, Source Delimiter used, Source Text Qualifier, Source Header Row, Source Select Command
- Active Directory – (Used to build employee directories typically) – Directory Path, Filter
- MS/Excel – Source File (path to excel, if not uploaded into centralpoint), Source Header row, Source Select Command (if any)
- RSS/ATOM- Source Feed URL (Web path to RSS Feed), Feed type (atom or rss)
- MS/Access- Source File (Path), Source Select Command (query)
- MS/Office365 – Source Authorization (Authorize), Source Folder, Source is Recursive, Source End Point
- Custom Provider – Typically used when ingesting from a WebAPI/Web Services – Source Type, Source Parameters (Custom covers virtually any configuration) wherein certain security considerations or custom methods must be passed in order to authorize or encrypt.
- Centralpoint to Centralpoint (Modules, Audiences, Taxonomy, Roles) – This is used when transforming data Centralpoint to Centralpoint or to an outside system, or after staging and testing initial imports.
- Unstructured
- File path (and/or credentials) to spider (Network drive, Any file path, web based drive (OneDrive- Source Directory, Source Pattern, Source Options. This feature also has the ability to spider all sub folders within a larger shared drive, ingested each record, and where applicable, fully text indexing, converting and preserving PDF, Word, XLS, PPT, Images, Videos and more. Additionally, the names from file folders (within the shared drive) may be included within the data cleaner/governance rules, to better organize content. Please see (below) Data Triage, which allows for your shared network drives to be ingested, allowing each file by type to be automatically organized into it's own unique module within Centralpoint.....automating the organization of all your information each day (via scheduled routines) and be made available on the internet, considerate of roles and authentication of each user.
When to consider INDEXING vs. INGESTING Data using Centralpoint Data Transformation
- Centralpoint supports both indexing or ingesting data. This is because you will want a federated search against all records, but need to preserve where some records currently live. In another case, you may need to have a new system of record or home to MOVE records into Centralpoint.
- You may want to avoid duplication of your records
- You may may need to consider the size of certain files (like CAD, Hi resolution images, etc.)
- You may need to consider the security of the file paths in which your files live today and user’s network accessibility to them.
- Indexing vs. Ingesting– The difference is whether you want to leave the record were it is found (to avoid duplication) in order to make it search able within Centralpoint, or whether you want to sunset an old system, where the new record will now live in Centralpoint as it’s new home. When creating your data transformation routine, the difference will be when field mapping ALTERNATIVE URL. Alternative URL is only used when indexing, allowing the path to record to be recorded in Centralpoint (as well as the enrichment), wherein the user will be returned to the original source, should they have the access to see the record. If you are intending to move the record to Centralpoint as the new system of record, then DO NOT USE Alternative URL, and make sure each record is moved during the ingestion (via an available) File Upload field.
- Security Consideration- Whether you are ingesting or indexing records using Data Transformation, always be sure to map the security roles from the system or path your scanning, in which to maintain who may see or access records (either indexed o ingested in Centralpoint)
Data Governance (Data Cleaner) considerations, when executing your Data Transformation.
Data cleaning is a separate module found under the Centralpoint Data Transformation suite of tools, which allow you to set up data governance rules which may work in unison with your Data Transformation routines.
- Keyword Generator – Used to enrich, supplement or add new keywords to any record, where certain values are is found (during mining).
- Example: If the word ‘apple’ is found, add keywords of ‘fruit, food, nutrition, pectin’ which will enhance search (searching fruit, and relate anything apple to any other record which may also relate to fruit or food)
- What it will ask you for this routine : Search for?, attributes, add keywords
- Taxonomy Generator- Used to apply one or more metadata/taxonomy types when certain value(s) are found.
- Example: If the word ‘apple’ is found, apply to N-tiered taxonomy under Food/Fruit, which will enhance search (searching fruit, and relate anything apple to any other record which may also relate to fruit or food)
- What it will ask you for this routine Search for?, case sensitive?, regex?, Taxonomy
- Attribute Generator – Used to apply new values in any field within one or more modules when certain value(s) are found (during mining).
- Example: If the term ‘Top Secret’ is found within any document, apply the value for the Role=Top Secret, to the ‘Roles’ attribute for any module. This will override the security roles for all documents which contain ‘Top Secret’
- What it will ask you for this routine : Search for?, regex?, value to add, attribute, which modules?
- HTML Cleaner- Used to clean or scrub any HTML or code where certain values are found (during mining). Often used to fix older or bad HTML or convert bad characters from MS/Word or faulty HTML being ingested.
- Example: Should you need to replace any fault HTML, codes or characters which includes “<b>Apple<b>, and replace with <b>Apple</b> (correcting the original faulty html)
- What it will ask you for this routine : Search for?, replacement type (html/text), replace with?
- Attribute HTML Cleaner- Used to apply new values into certain fields into specific modules whenever certain values are found (during mining)-allowing you to apply new values to any attribute as a result
- What it will ask you for this routine : Search for? , replacement type (html/text), replace with, attribute to add, which modules?
- Data Triage- Used to redirect certain file types into certain modules.
- Example, when spidering a shared network drive or database, you may want to deposit all documents containing ‘Marketing’ references into a module designated for only Marketing, or place all Excel documents found into it’s own module. This is used to organize content by type (within separate modules)
- What it will ask you for this routine: Search for?, regex (yes or no), searched attribute, destination modules, logging attribute
-
-
-
-
-
-
-
2/19/2024 12:08:54 PM
-
https://qc.xoprod20.com/Uploads/Public/datascrubbingthumbnail.jpg
-
|
2. |
- Centralpoint Module Gallery
- Data Aggregation, Data Transformation, Deep Dive - Video Overview, Development Tools (Utilities)
- Everyone: All Users
- 3/23/2023
- Relevance: 181
-
-
12/31/9999 11:59:59 PM
-
Data Governance, Automated Metadata, Govern, Data Rules, Data Cleaner, metadata,ontology,intranet,portal,transformation,Artificial Intelligence,aggregation
-
Centralpoint's Data Cleaner (otherwise known as Data Goverrnance) collaborates seamlessly with Centralpoint's Data Transfer utility, automating metadata and Taxonomy assignment for your content. This empowers the transformation of any information that lacks proper metadata. Regardless of the information type—raw data from databases like Oracle, IBM, SQL Access, Excel, and documents such as PDFs, MS Word, or Excel—Data Cleaner ensures metadata and Taxonomy application to each record upon import. This process allows for your terminology, product skus, laws, policies, and other pertinent information to be leveraged as a way to enrich your metadata, taxonomy and ontology....automatically.
Centralpoint's Data Cleaner covers HTML, Taxonomy, and Keywords, granting you the ability to manage condition dictionaries, including determining how many instances of a word or part number correspond to specific Taxonomy or keywords. For further insights, explore the extensive features we offer for MDM (Master Data Management).
The best way to understand how this tool can benefit your organization is to actually see it. We encourage you to set up a demonstration with us, so that we may step through the various routines online, via a MS/Teams Meeting demo, and we can address any of your questions or challenges .If you are interested in this new module, you may also want to see our Taxonomy Pre-Import Tool. Be sure to see our Data Transfer module for more information.
Types of Data Transformation which are supported and the required fields needed for each:
- Structured Data Sources
- MS/Sharepoint -Source Site URL, Title, List Title, Username, Password
- Oracle -Connection String/table name, any query or filter (credentials)
- MS/SQL -Connection String/table name, any query or filter (credentials)
- MS/Office 365- (Ondrive) Authorization, Source Folder (Office365 file Selector), Source Recursive (y/n), Source End Point (bulk or changes)
- OLEDB - Connection String/table name, any query or filter (credentials)
- ODBC - Connection String/table name, any query or filter (credentials)
- XML- ReadXML -XML Source (path to xml), Available tables and columns, Source Table Index
- XML- CpCollection –Source XML (path to xml), Default File, Source Directory, Number of Files to select, XSLT
- Delimited TXT (oledb)– Source Directory, Source Delimiter used, Source Text Qualifier, Source Header Row, Source Select Command
- Delimited TXT (Stream)– Source Directory, Source Delimiter used, Source Text Qualifier, Source Header Row, Source Select Command
- Active Directory – (Used to build employee directories typically) – Directory Path, Filter
- MS/Excel – Source File (path to excel, if not uploaded into centralpoint), Source Header row, Source Select Command (if any)
- RSS/ATOM- Source Feed URL (Web path to RSS Feed), Feed type (atom or rss)
- MS/Access- Source File (Path), Source Select Command (query)
- MS/Office365 – Source Authorization (Authorize), Source Folder, Source is Recursive, Source End Point
- Custom Provider – Typically used when ingesting from a WebAPI/Web Services – Source Type, Source Parameters (Custom covers virtually any configuration) wherein certain security considerations or custom methods must be passed in order to authorize or encrypt.
- Centralpoint to Centralpoint (Modules, Audiences, Taxonomy, Roles) – This is used when transforming data Centralpoint to Centralpoint or to an outside system, or after staging and testing initial imports.
- Unstructured
- File path (and/or credentials) to spider (Network drive, Any file path, web based drive (OneDrive- Source Directory, Source Pattern, Source Options. This feature also has the ability to spider all sub folders within a larger shared drive, ingested each record, and where applicable, fully text indexing, converting and preserving PDF, Word, XLS, PPT, Images, Videos and more. Additionally, the names from file folders (within the shared drive) may be included within the data cleaner/governance rules, to better organize content. Please see (below) Data Triage, which allows for your shared network drives to be ingested, allowing each file by type to be automatically organized into it's own unique module within Centralpoint.....automating the organization of all your information each day (via scheduled routines) and be made available on the internet, considerate of roles and authentication of each user.
When to consider INDEXING vs. INGESTING Data using Centralpoint Data Transformation
- Centralpoint supports both indexing or ingesting data. This is because you will want a federated search against all records, but need to preserve where some records currently live. In another case, you may need to have a new system of record or home to MOVE records into Centralpoint.
- You may want to avoid duplication of your records
- You may may need to consider the size of certain files (like CAD, Hi resolution images, etc.)
- You may need to consider the security of the file paths in which your files live today and user’s network accessibility to them.
- Indexing vs. Ingesting– The difference is whether you want to leave the record were it is found (to avoid duplication) in order to make it search able within Centralpoint, or whether you want to sunset an old system, where the new record will now live in Centralpoint as it’s new home. When creating your data transformation routine, the difference will be when field mapping ALTERNATIVE URL. Alternative URL is only used when indexing, allowing the path to record to be recorded in Centralpoint (as well as the enrichment), wherein the user will be returned to the original source, should they have the access to see the record. If you are intending to move the record to Centralpoint as the new system of record, then DO NOT USE Alternative URL, and make sure each record is moved during the ingestion (via an available) File Upload field.
- Security Consideration- Whether you are ingesting or indexing records using Data Transformation, always be sure to map the security roles from the system or path your scanning, in which to maintain who may see or access records (either indexed o ingested in Centralpoint)
Data Governance (Data Cleaner) considerations, when executing your Data Transformation.
Data cleaning is a separate module found under the Centralpoint Data Transformation suite of tools, which allow you to set up data governance rules which may work in unison with your Data Transformation routines.
- Keyword Generator – Used to enrich, supplement or add new keywords to any record, where certain values are is found (during mining).
- Example: If the word ‘apple’ is found, add keywords of ‘fruit, food, nutrition, pectin’ which will enhance search (searching fruit, and relate anything apple to any other record which may also relate to fruit or food)
- What it will ask you for this routine : Search for?, attributes, add keywords
- Taxonomy Generator- Used to apply one or more metadata/taxonomy types when certain value(s) are found.
- Example: If the word ‘apple’ is found, apply to N-tiered taxonomy under Food/Fruit, which will enhance search (searching fruit, and relate anything apple to any other record which may also relate to fruit or food)
- What it will ask you for this routine Search for?, case sensitive?, regex?, Taxonomy
- Attribute Generator – Used to apply new values in any field within one or more modules when certain value(s) are found (during mining).
- Example: If the term ‘Top Secret’ is found within any document, apply the value for the Role=Top Secret, to the ‘Roles’ attribute for any module. This will override the security roles for all documents which contain ‘Top Secret’
- What it will ask you for this routine : Search for?, regex?, value to add, attribute, which modules?
- HTML Cleaner- Used to clean or scrub any HTML or code where certain values are found (during mining). Often used to fix older or bad HTML or convert bad characters from MS/Word or faulty HTML being ingested.
- Example: Should you need to replace any fault HTML, codes or characters which includes “<b>Apple<b>, and replace with <b>Apple</b> (correcting the original faulty html)
- What it will ask you for this routine : Search for?, replacement type (html/text), replace with?
- Attribute HTML Cleaner- Used to apply new values into certain fields into specific modules whenever certain values are found (during mining)-allowing you to apply new values to any attribute as a result
- What it will ask you for this routine : Search for? , replacement type (html/text), replace with, attribute to add, which modules?
- Data Triage- Used to redirect certain file types into certain modules.
- Example, when spidering a shared network drive or database, you may want to deposit all documents containing ‘Marketing’ references into a module designated for only Marketing, or place all Excel documents found into it’s own module. This is used to organize content by type (within separate modules)
- What it will ask you for this routine: Search for?, regex (yes or no), searched attribute, destination modules, logging attribute
-
-
-
-
-
-
-
2/19/2024 12:07:44 PM
-
https://qc.xoprod20.com/Uploads/Public/Blogs/datacleanerthumb.png
-
|
3. |
Centralpoint features distinctive Data Transformation tools for automating Aggregation from diverse sources. It accommodates indexing and ingestion of both Structured and Unstructured data. This translates to aggregating information from various systems (SQL, Oracle, IBM, XML, JSON, CSV), even folders with files (PDF, Word, Images, Videos). The tools include Data Mining, which auto-classifies each record with accurate metadata and Taxonomy upon import. This empowers seamless searching across disparate sy...
- Site Map
- Everyone: All Users
- 10/18/2016
- Relevance: 181
-
-
12/31/9999 11:59:59 PM
-
SQL Migration, Data warehousing, data migration, content migration, Data Mining, Automate Metadata, mass migration, data movement, sharepoint migration, sharepoint alternative, Oracle,
-
-
-
-
-
-
-
-
1/4/2024 10:01:47 AM
-
-
|
4. |
Centralpoint's Data Cleaner (otherwise known as Data Goverrnance) collaborates seamlessly with Centralpoint's Data Transfer utility, automating metadata and Taxonomy assignment for your content. This empowers the transformation of any information that lacks proper metadata. Regardless of the information type—raw data from databases like Oracle, IBM, SQL Access, Excel, and documents such as PDFs, MS Word, or Excel—Data Cleaner ensures metadata and Taxonomy application to each record upon import. This pro...
- Site Map
- Everyone: All Users
- 8/21/2018
- Relevance: 181
-
-
12/31/9999 11:59:59 PM
-
Data Mining, Automated Metadata, Taxonomy, Classification, Roles based, Security Assignment, Indexing, Crosswalks, Mashups
-
-
-
-
-
-
-
-
9/13/2023 1:53:00 PM
-
-
|
5. |
This document outlines procedures and protocols for notification of and response to a security incident or breach involving unencrypted electronic personal information processed and/or maintained by Oxcyon and its extended providers, servers, clients and organizations. SECURITY INCIDENT NOTIFICATION REPORTING & INVESTIGATION PROTOCOL A. Security Incident Reporting In the event that a data owner, technology staff member, or Information Technology Services representative identifies a potential s...
- Site Map
- Everyone: All Users
- 5/12/2011
- Relevance: 85
-
-
12/31/9999 11:59:59 PM
-
Big Data, Centralpoint, Digital Experience, Security Policy, Oxcyon, Security, Incident, Cloud, Hosting, Managed service, monitoring
-
-
-
-
-
-
-
-
2/1/2018 2:24:49 PM
-
-
|
6. |
Philosophy The value of data as a resource is increased through its widespread and appropriate use; its value is diminished through misuse, misinterpretation, unnecessary restrictions to its access, or failure to maintain quality. Most importantly, wide access to data will enable consumers to identify new relationships in data and new information previously unknown or unavailable. This is the domain of data mining and to some degree what-if analysis. Oxcyon endorses and supports this within the appropri...
- Site Map
- Everyone: All Users
- 2/3/2021
- Relevance: 80
-
-
12/31/9999 11:59:59 PM
-
-
-
-
-
-
-
-
-
3/14/2022 10:44:46 AM
-
-
|
7. |
As part of our commitment to your Centralpoint data governance success, we not only build the initial data governance rules, metadata structures, taxonomies, and ontologies tailored to your organization but also empower your team. We offer comprehensive training to your staff, equipping them with the knowledge and tools to effortlessly incorporate new conditions as your business evolves. Think of us as your data science "sherpa," guiding you through the intricate terrain of data governance, ensuring tha...
- Site Map
- Everyone: All Users
- 9/13/2023
- Relevance: 10
-
-
12/31/9999 11:59:59 PM
-
-
-
-
-
-
-
-
-
9/13/2023 2:13:28 PM
-
-
|
8. |
- Centralpoint Update History
- Everyone: All Users
- 4/8/2013
- Relevance: 8
-
-
12/31/9999 11:59:59 PM
-
Centralpoint Updates, Centralpoint Version, Oxcyon Release, Centralpoint Release, Digital Experience, Magic Quadrant, ECM, Content Management, Portal, Enterprise, User Experience, MDM, Master Data Management, Gartner
-
-
Feature |
Summary |
Admin > Roles
|
The Users property, which can be accessed by clicking Page Options… > Show/Hide Properties after selecting a role, now contains separate Members and Site Architecture > Administrators links. These links take you to the respective module’s grid view automatically filtered by the selected role.
|
AudienceGoogleMap CpControl
|
Fixed a JavaScript error that occurred when multiple Audiences had Geocodes.
|
Chrome on iOS
|
An issue caused by ASP.NET 4 incorrectly detecting Chrome on iOS as a "downlevel" browser has been resolved.
|
Content > Generic Enhanced A - J
|
Taxonomy Subset Field 1 - 6 and Taxonomy Subset Root 1 - 6 module properties have been added. They can be used to populate existing or custom attributes with lists of selected taxonomies.
|
CpUpload Control
|
A new Dialog property has been added to the CpUpload control which is used for File Upload attributes created using Master > CMS > Modules and attribute (cpCollection) XML files. The Default option will cause the file upload dialog to be selected based on the Admin > Properties > File Upload Type attribute as it is now. The new Standard and FileExplorer options allow you to force the control to ignore the property and render the standard or file explorer dialog respectively.
|
Data Transfer
|
Source & Destination > Source = "Delimited Text" has been renamed Delimited Text (OLE DB) and a new Delimited Text (Stream) option has been added. The new Delimited Text (Stream) option does not require a Schema.ini file with custom delimiters.
|
Data Transfer
|
New Source Site and Source Order By attributes have been added under Source & Destination > Source = Standard Module. The Source Site attribute provides options to import standard module content from a different site. The Order By attribute provides control over the selected records when the Source Limit attribute is in use.
|
Data Transfer
|
A new Members & Administrators option has been added to the Destination attribute.
|
Data Transfer UtcNow CpScript
|
A new Format parameter has been added to prefix or suffix the return value. Include '{0}' in the format string where you would like the DateTime to be placed. It can also be used to format the date itself: {0:d}.
|
Design > Dynamic Feeds
|
This module has been updated to function properly when no value is provided in the Type = "RSS" > URL attribute.
|
Form Control CpScripts
|
An issue with the DateTime constant used in the default parameter has been resolved. It also has been updated to accept full date formats.
|
FormState CpScript
|
A new ChangeToUtc parameter has been added. Setting this value to ‘true’ will automatically convert a DateTime value to UTC.
|
FormUpload CpScript
|
A post back issue when Type = "Resource" has been resolved. This type has also been updated to set the form state value to "/Resource.ashx?sn=SystemName".
|
Policies Module
|
The File Manager Network Path in Module Properties has been added. If that has a value, and File Explorer is used, the file will be moved to that directory and deleted in Centralpoint.
|
Procedure Manuals > Policies
|
The contents of an uploaded document is now extracted and added to a hidden attribute for search indexing regardless of the option selected in the Conversion attribute.
|
Procedure Manuals > Policies
|
Support has been added for .rtf, .xls, and .xlsx files.
|
Procedure Manuals > Policies
|
The Type = "RTF Editor" > Content attribute is now automatically populated with the contents of uploaded Word Documents.
|
Procedure Manuals > Policies
|
A new Type = "File Explorer" option has been added. When selected a document can be uploaded within a folder structure using a file explorer control. A new File Manager Network Path module property has also been added. When populated the file structure created in the file explorer will be duplicated on the network path, and the files will be removed from the Uploads directory.
|
Site Architecture > Module Designer
|
A new "[, cpsys_Distance]" constant is now supported in all Results View (#2) > Order By attributes. When a proximity search is executed it is automatically sorted by distance first. This constant allows you to override that functionality and sort by some other value before the distance. This constant cannot be placed at the beginning of the attribute, and must include the square brackets and comma-space.
|
Site Architecture > Module Designer (Physician Directory)
|
The Results View (#2) > Order By attribute has been updated to accept 512 characters.
|
-
-
-
-
-
-
4/22/2013 9:36:38 AM
-
-
|