Centralpoint Module Gallery

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

This tool, found under both Import Utilities and Tools (within the client console) is a powerful way to convert your data into multi tiered taxonomy, which will ready your records for import. It was designed to assist Oxcyon staff (initially) when receiving large sets of client data, which needed to have a taxonomy built 'around it'. In this video you will see examples of why it is important, and how to use it to make your information (records, documents, products, anything), become almost instantly, search able records, organized by taxonomy....online. Only Centralpoint provides tools like this which understand the day to day realities of harmonizing your information, and one of the many reasons we have been named to Gartner's Magic Quadrant for Digital Experience Platforms. If you find this tool interesting, you will also want to see our Data Cleaner tool which allows you to Auto-Classify all of your information within your enterprise.

Centralpoint supports SAML 2.0 to support Deep links for authorized users who are logged in. You will find the Deep Links module under the Admin section of your client console. SAML 2.0 empowers you to broker authentication of your logged in members, so they may access other SAML 2.0 compliant applications with a single click (eliminating the redundancy of logging in again).

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

If you would like to reset hits, ratings or clicks on any particular record, please enter the comma separated list of GUIDS, and execute. To remove clicks on any of these records (in addtion to hits and ratings, please change the value of -1 to zero (0). To obtain the GUID for any record in your site, simply open that record in the console, and then (top right/drop down) click on View/Hide Properties, and you can copy the Data ID (not the module ID) into this comma separated value box. Additiionally, may add -1 to exclude Hits or Ratings (example, should you only want to reset clicks, hits or ratings)

It is HIGHLY RECOMMENDED that you back up your website prior to executing this tool. Note: Deleting these records will leave you with no historical information regarding your member's activity, or anonmyous site acitivty. 


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Application Trace, when enabled will track any page loaded on the front end of the site, including the application 'trace'. This tool, when enabled, will show the incremental page load steps, including times. It is typically used to isolate a problem within any page's load. As with page tracing generally, you can view trace information at the bottom of individual pages. Alternatively, you can use the trace viewer (Trace.axd) to view trace information collected and cached by ASP.NET when tracing is enabled. Be sure to turn off Application Trace, when you are completed diagnosing your site or webpage.  More about this tool.

This tool is really designed for highly skilled developers to help them better understand what is happening 'behind the scenes' during any individual page load, in which to troubleshoot or 'trace' what is occurring during the page load..


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This tool will provide a full back up of your site's database (within SQL), and will also back up all related site files used within your site. To adjust the 'Maximum Backups', you must go to the Centralpoint Master Management Console. If you do not have access to your Master Management console, kindly contact your hosting or network administrator.

Note: This is highly used tool, by anyone and is typically a good idea to run this prior to any major work you do to your website (massive data imports, or any type of major enhancements to the site). In this way, all work has been properly saved, should you ever need to 'Restore' that back up. 


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This tool will clean your web site, file system and database. It will audit files no longer referenced in the database and delete them, it will also run complete database maintenance routines, restart any (saved items in) cache memory, and restart the entire website application. Note: This is a good tool to use, if there is ever some performance anomoly on your website, based on some spike in traffic, or if you feel like some activity on the site has slowed it down in some way. ..

This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This is rarely used tool, which eliminates all previously uploaded files into the directory (like images, documents, files). It would be a tool to use, when creating or setting up a new site, to ensure that no remaining files uploaded to the previous (or creator site) is present. 

The template file shows an example (only) of how you would name your media files (images or documents (pdf, doc, xls, ppt, jpg, png, etc.). By uploading this new excel file, ALL previous media files will be deleted and only these will remain. You will note that this tool requires a full back up be done prior, due to the breadth of this of type of change. 


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Over the course of time all of the searches conducted within your site are saved. This tool would be used to flush all previous saved search routines in your site, allowing you to re calibrate the relevance of more recent searches being made. This tool was created to prevent  'previously searched keywords' from the database, putting you in charge of when you want to re calibrate those keywords searched. Note: You would like not need to use this unless you are capturing search terms from unwanted users to your site (profanity or bot created searches)  This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint Crosswalks

The Centralpoint Crosswalks tool (typically a script) found within the Module Designer is a great illustration as to why you need a centralized and comprehensive platform to manage your content. Crosswalks provide cross-references to related information within your site, putting all of the information at your fingertips. By leveraging Centralpoint's taxonomy and WYSIWYG object-oriented programming, you are able to automatically suggest and recommend related information for virtually any page you manage. , This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint boasts exceptional Data Transformation tools that automate the aggregation of data from diverse sources. It facilitates both indexing and ingestion of both structured and unstructured data. This encompasses the capability to gather information from a variety of systems (such as SQL, Oracle, IBM, XML, JSON, CSV) as well as files from folders (like PDFs, Word documents, images, videos).

Moreover, these tools offer Data Mining to automatically classify each record and assign the appropriate metadata and Taxonomy upon import. This empowers you to conduct searches and locate records across disparate systems, uncovering relationships that might exist between all records.

Centralpoint Data Sources & Reporting

Centralpoint Data Sources allow you to display dynamic content anywhere you desire on your site. This tool enables you to speak directly to Centralpoint's database (or others) to determine the type of content you want available, creating mobile content. For example, let's say while users are reading a news article, you want to display all related products immediately to the right of the article. This is where a data source comes into play. This deep dive video shows all features of data sources, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint's Database Table Lookup allows you to review any database within Centralpoint to better understand its table structure. This can help you clearly understand any integration, or it can simply demystify how all of the information is stored within Centralpoint. It is helpful to see it from the database perspective, and this utility allows you to do just that., This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Because taxonomy supports N-Tiered relationships this means that should you ever want to delete a taxonomy tree, or individual taxonomy terms, you would need to do so manually, indvidiually, until all nodes of that taxonomy tree were deleted. This tool was created to allow all taxonomy items under a particular parent to be deleted in one fell swoop. Without this tool, each taxonomy found under the parent would have to be deleted manually, and individually and be time consuming. 

Note: You will want to confirm that the taxonomy (or family tree) you are deleting is not already in use by other modules, prior to deleting. If you delete the taxonomy list or tree, and it was in use prior, then you will need to retag all of those records to a new taxonomy post facto. It is highly recommended that you back up your site (See Tools/Backup) prior to the deletion of any taxonomy.


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint Design Styles

Centralpoint Design Styles allow you to maintain your website styles, classified by Audience and Role, to render distinctly designed websites. These styles primarily relate to colors, fonts, images, and other design elements. The global attributes are always available, but the majority of this module's attributes are controlled by the Site Type. Centralpoint styles support your own CSS, but allow you to manage all of your CSS in a way that can be re-used on your other websites., This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint Dynamic Scripts

Centralpoint's Dynamic Scripts module allows you to retrieve data from any module and then format it as a CpScript to be placed anywhere on your site. For example, if you want to feature the Top Five news articles and Top Four events on your homepage (in descending order), the Dynamic Scripts tool empowers you to create individual scripts for each, and then place them anywhere on your homepage. You can control the record count, sort order, CSS, and anything you need to easily create dynamically serving ..., This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint Error Reporting & Monitoring

Error Reporting is managed in two locations, first within the Client Console of each individual Centralpoint Portal and also at the Uber Console, by Oxcyon. 

This tool typically used by senior developers, allows you to see the SQL Query for any module in your site. By selecting any module, it will provide the complete SQL Statement for all records from that module. This Query can then be used to create Data Sources, Data Transfers, or to build any report.
It has been optimized for use within Data Transfer, and although it could be used for reporting or others tasks (to filter record sets), it is not optimized for those purposes.


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

When migrating or extracting documents 'from' Sharepoint this tool is essential to retreive and restore binary images and documents. It will allow you to create a new file structure of all documents (previously in Sharepoint) into a new file directory, wherein files will no longer be binary. From this new directory, typically imports are run in order to migrate these records into Centralpoint. This would be a tool used by senior developers.

Note: This tool will mimic the file directory previously maintained in Sharepoint (including the documents). This tool gives you the option to control various versions of Sharepoint (old to new), wherein some fields below pertain only to certain versions of Sharepoint. 


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This tools was created in order to take any encoded form state string, in which to decode. Enter the encoded form state string and click decode. This would be strictly for developers. 
Note: Form state stores information about a form, their controls and their values. That information is encrypted, which is why we developed this tool....allowing to decode the form into an unencrypted format, including its values. 


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint Global Login SSO

Centralpoint's Cross-Forest Single Sign-On (SSO) extends support to various authentication methods, including AD (Active Directory), ADS, LDAP, LDAPS, SAML 2.0 (Okta, Ping, Symantec), Windows Authentication, oAuth, and Open ID (Twitter, Salesforce, Google, Facebook), all available right out of the box. This comprehensive support ensures secure authentication for all your diverse users—employees, partners, customers—from a central and unified point. This feature operates as a secure hub, enabling the secure distribution of information and data collection from each user. User activities, including traffic, form submissions, and requests, can be seamlessly integrated into your multitude of back-office systems via our Web API.

This tool would only be used in the case of multi portal development, within a Master Enterprise environment. Since Centralpoint leverages rapid application development, this means a newly created site was created by another site (it's parent). This suggests that records found in the creating site may need to be flushed and cleaned prior to the launch of the new site (although not always the case, should you want records to be preserved). Should you want to flush all values, and ensure a clean deployment, this tool  will DELETE all previously deleted Users (IsDeleted = 1) will delete any and all records from Searches, Survey,  Email Broadcasts, Clicks, Ecommerce Test Orders and Leads.

It is recommended to only use this tool when launching a new website.


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint Integration with Salesforce

Centralpoint integrates with Salesforce users to welcome -- and authenticate -- them to your website. The website login has been equipped to handle multiple internal and external authentication sources (global logins). These authentication sources only work with the website; they are not utilized in console logins. When a user logs into the site's front end, this module is queried for live records and authentication is attempted using the entered username and password.

This is managed via Centralpoint's Global Login module which supports oAuth integration (out of the box). The scopes which you wish to glean about that user (upon login) are up to you, and the depth of how many scopes your users may wish to share is their election when logging in. You will find the Global Login module, under the Admin section of your Client Console. 

Centralpoint's IP Management blocks or automatically authenticates users based on their IP addresses. The "IP Address/Range" attribute is a string comprised of four parts, separated by dots(.). Each part can be either a single byte (1-255), a star (*), or a byte range (x-y). A star is shorthand for the byte range, 1-255. The "Action" attribute allows you to input directions to dictate events when a user in the given IP range accesses the site. If "Block" is selected, the user will be blocked from accessing the site at all. Conversely you can give authentication access to users, based on their IP Address range. This tool can be found under the ADMIN section within the Client Console

Although Centralpoint supports a trigger to automatically determine a record's geo code on submission and/or during import, sometimes the values become outdated, and/or it is not available at the time of import or data entry. This tool allows you to retroactively apply geo codes to any records, within a module, based on certain files (like street, city, state, zip), in which to determine each record's geo code and apply that to the record. Here you would select your module, define which fields should be used to determine the geo code and submit. This tool could take some time, depending ont he number of records (as it is looking up and applying the geo code for each submission it has to do). 


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This senior developer tool allows you generate the SQL Query (command) for all fields relative to Taxonomy or Audiences. Taxonomy and Audiences are considered System modules (not containing ordinary content), and hence require this tool to extract data from any of these modules. , This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint's Digital Experience Platform serves as an omnichannel Knowledge Management and content management ecosystem. This universal platform caters to organizations of all sizes and industries. It streamlines information flow from your business through distributors to end users (B2B2C), and reciprocally tracks user actions (C2B2B). It's a groundbreaking User Experience Platform causing a major shift in enterprise content management and portal domains. Discover more about our innovative approach that reinvents the wheel.

Creating an organizational chart showcasing all enterprise audiences is effortless. Simply generate a new record within your Client Console's Admin section. This tool provides three jQuery views: Centralpoint Wheel (Traditional), Centralpoint Sunburst Wheel (latest version), and Treeview. Selecting a view alters its rendering. Once the record is created, clicking the View link displays your visual enterprise mind map. Place this link anywhere on your site to offer users an insightful perspective.

This tools was designed to Hash encrypt any password. Simply enter your password into the first box and click hash. It will then provide you the hashed version of your password. This is a rarely used, but powerful tool for senior developers only to troubleshoot password related issues. 
, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This tool will enumerate all records found within your site, and give you a count of the number of records found in each area. This is a very helpful tool to give you a quick snapshot of how many records are in use within your site. The second line item in the report shows records in the DATA CURRENT table, which would represent live records found within your website. The remaining categories show ancillary records (like clicks, leads (impressions), audiences, taxonomies, members, etc.


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint forms capture a result each time the form is submitted. These form results can be deleted in the client console, relative to any form. (Example, select form results, and you are free to delete all previously submitted forms). This tool is designed to assist clients who have collected data (in form results), which you may need to remove WITHOUT deleting the entire form result record (Example: Should you accidentally collect credit card or social security numbers within a form, when compliance does not allow that), you may need to eliminate ONLY  those values (credit card numbers or social security numbers) from each submission made over time. 

You will need to first get the GUID of the Form itself (by opening that form in the console, then selecting (from the top right drop down list (Show/Hide Properties) and copying the DATA ID for that form. You would then enter in the ID of the field, that you wish to remove. Executing this tool will remove all instances of that field (only) from all results (submissions) against that form. 

, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

When migrating client from older Content Management Systems, the URL query string often differs. This tools is designed to replace any old URL schema with new URL schemas, which could be found within the Body Copy of any webpage. (Example: You may have an old webpage which was imported in from another system, and within the body of that webpage, you have hyperlinks which point to your older url (website). This tool allows for all references to be changed en masse upload. 

Note: It is HIGHLY RECOMMENDED that you back up your website prior to executing this tool. It is also recommended that you thoroughly review this list to make sure it is thorough, and that you test the path of your new URLs first. (Example: There is an opportunity to review your system name (naming convention) prior to replacing all of these hyperlinks to the new names.)


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Relations allow certain fields to carry with that record, when being searched. (Example: The details view of any record contains all fields in the relation, but some fields are excluded only within the search results (for performance). Sometimes new fields are added to modules, which have not been considered in the intial relations during the module's creation. This tool allows for any new fields added to the module to be considered, having those relationships rebuilt. 



, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Clicks is a table in Centralpoint's database which records the click of each page (Only in the event you are using clicks.aspx for those modules or pages which you will want to track). Without clicks you will not have the business intelligence to determine each page's access and for logged in members (who has clicked on which page). 

This tool will delete all clicks found in this database, and reset them all to zero. It is HIGHLY RECOMMENDED that you back up your website prior to executing this tool. Note: Deleting these records will leave you with no historical information regarding your member's activity, or anonmyous site acitivty. 


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This tool is rarely used by senior developers if the module configuration was faulty and need to be reconfigured. This tool will allow you to bring the configuration to the default
This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This tool will restart your application at the IIS level. This will result in removing all website (server side cache), and flush your site of all current sessions. Note: Upon revisitng your website (front end) after executing this tool, you may notice a slight delay. This is a result of the recompilation of your site, code, and cache. As you click around the site, you will see it speed up.

This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This rarely used tool allows you to restore ALL records, within any individual module, by user ID. Here you would enter in the GUID of the user id, select your module, and all records will be restored back to when that particular User ID, had last modifed them. (Example: A new employee edits a number of your records incorrectly over a period of time, and you want to restore en masse back your original versions). 


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This tool is used when generating a web service. A service key is unique to each server, and considering that you could have multiple service keys involved regarding numerous web services, this tool allows you to generate a unique, and secure service key whenever you need one. 
This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint Sponsored Keywords

Centralpoint's Sponsored Keywords, also known as Reverse Hyperlinks, link words after the web page has rendered. One hyperlink could create potentially thousands of live instances on your pages! This module is used to create a list of terms that will be linked -- without manually linking each term --  when they render on the website. The terms will be highlighted on the site and when a user hovers his/her mouse pointer over each one, the entry's content will be displayed. 

This tool allows you to summon the SQL Query (or command) for any Taxonomy within the site. This Query can be used to import into another site. (Example: You have developed an amazing and deep taxonomy, which you may want to extract so that you can import it into another site exactly as it was). This is a very powerful tool that allows you to import tiered taxonomy into Centralpoint. This tool supports no more than 3 columns (or 3 tiered taxonomy) (per import). This tool currently requires that your first tier be named 'Client Specialty', the second tier be called 'Serviceline Keyword' and third tier be named 'Page Keyword'. The values need to be


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

This tool allows you to take any URL and have it encoded properly. (Example: sometimes a url may contain certain spaces or values which do not render it correctly for the web browser). This tool will ensure that your URL be friendly to any web browser, should it contain unusual charcters. Enter a string in the text box below and click encode to prepare it to be added to a query string variable. 


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

URL Rewrite permits Web administrators to easily replace the URLs generated by a Web application in the response HTML with a more user friendly and search engine friendly equivalent. Links can be modified in the HTML markup generated by a Web application behind a reverse proxy. URL Rewrite makes things easier for outbound response content and headers rewriting with outbound rewrite rules that work with HTTP request and response headers and with IIS server variables.

You will want to upload an Excel spreadsheet here which must contain the following fields (URL and SystemName columns). In order to see the template file for what your upload should like, you can download it here. 


, This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.

Centralpoint Workflow

Centralpoint's Workflow module allows you to manage the various workflow steps involved with online form submissions. Whether it is a simple one-step approval process or it involves multiple parties to each approve the document at different intervals, Centralpoint Workflow allows you to manage the process every step of the way. The Workflow module works in concert with the Forms Management module, routing individual forms through the appropriate workflow. , This tool can be found under the Development section within the Client Console, under 'Utilities'. Log in the Client Console, click on development, and search for this tool within this page. You can also ask your production manager to turn on the 'Tools' section of your client console. When this is done, each tool will appear individually within the console, for easy access.