EzeScan Authority Server
EzeScan Authority Server
Breadcrumbs

Tables tab

A bit of history first…

Over time many EzeScan clients have made use of the EzeScan Profiler spreadsheet like the Objective EDRMS one shown below.
worddav1f2e9b89714a0703fea2f82802a4a6c0.png
Figure 25 - Example of an Objective EDRMS EzeScan Profiler spreadsheet

  • The concept is to build up a spreadsheet with the details of various document types and include metadata values to speed up document capture process in the KFI profiling stage of documents.

  • Each PC client using the EzeScan Profiler spreadsheet requires an ODBC connection to the spreadsheet.Each time a new PC was set-up to use EzeScan it required an I.T. Admin person to create the ODBC settings.

  • If the spreadsheet requires updating then the users are unable to do any profiling of documents which utilise it.

  • If a large number of users were accessing it at once it would occasionally "lock up" with an ODBC error being indicated.

Now for the future…

The EzeScan Authority Server now has the ability to replace the EzeScan Profiler spreadsheet with the Authority Tables facility.
The tables are created on the EzeScan Authority Server by an EzeScan administrator and then (going forward) may be either maintained via the EzeScan PC client Admin > KFI Lookups (the easiest way) or via the tables tab in EzeScan Authority Server or can be maintained in a spreadsheet outside of the Authority Tables and uploaded with new changes.
Authority Tables uses a SQLite database to hold the table data.

  1. Please refer to the KFI User Guide for details on maintaining the tables via the KFI Lookups function. This section will only deal with the Authority Tables set-up on the server.


  1. This functionality could replace the KFI Lookups currently used across your organisation as it will centralise them into one place - far more easier to create and maintain!

    One example is the Batch Names used when by the batch scan process.


Creating a new Authority Lookup Table - using the "Automatic" method

  1. This is the quickest and by far the easiest way to create your Authority Lookup tables, especially if you have an existing Profiler Spreadsheet. It simply becomes a conversion process.Prior to commencing this process take time to consider a naming convention for the tables about to be created.


Either use your existing Profiler spreadsheet or create a new one. You may need assistance if creating a new one - please contact EzeScan Support or your reseller for details.

  1. The spreadsheet column headings will become the column names and you cannot have any spaces in the names.

    For example Document Description

    must be now be

    Document_Description

    Allowed column name characters are A to Z (upper or lower case), 0 to 9, _ (an underscore), $ and ' (an Apostrophe).

    EzeScan general design recommendations are to use A to Z (upper or lower case), 0 to 9, _ (an underscore) only when naming columns.


worddav60052171b3691decb44a1e0b04e4c2bb.png
Figure 26 - Example of a Profiler spreadsheet (for HPE Content Manager)

  1. Run a spell check on the file and sort the columns once completed.


Once the spreadsheet has been completed, save it as a CSV file (e.g. Profiler.CSV)

Creating the new table

  1. Click on the Tables tab

  2. Select the + Add a table option

worddav0310339abb6da8688572031ffd325646.png
Figure 27 - Creating a new Authority Lookup table (several have already been created)

  1. Give the new table a name (use those naming conventions suggested earlier)

  2. Click the Browse button and browse for the CSV file created earlier

  3. Once the CSV file has been selected; click + Create Table button

worddav6d3eeba7411c9064fb2690829f103e7b.png
Figure 28 - Creating a table using an existing CSV - browse for the CSV file

  1. worddav7c327acee4839766e2c129c2f4e2d294.png A success message should appear once the import is completed and the table is added to the list.


worddav0892e3b5297d186e9407316aa937fc77.png
Figure 29 - new Authority Lookup Table added to the list

  1. Clicking on the table link (e.g. Profiler_General) will open the table. Available options are… Edit Table allows for: adding additional columns editing column names deleting columnsWarning - may affect any KFI's using this table Export as CSV export the table to make bulk changes or additions and then re-import (refer page - Appendices for more) Add data allows for addition of new rows of data Refresh will refresh the screen as well as all of the tables

Creating a new Authority Lookup Table - using the "Manual" method

  1. Prior to commencing this process take time to consider a naming convention for the tables about to be created.

    The manual creation process is excellent for creating small lookup tables such as Batch Names.

Creating the new table

  1. Click on the Tables tab

  2. Select the + Add a table option


worddav0310339abb6da8688572031ffd325646.png
Figure 30 - Creating a new Authority Lookup table (several have already been created)

  1. Give the new table a name (use those naming conventions suggested earlier)

  2. Click + Create Table button

worddav1f173f6349111ef22c40177bcdbcd146.png
Figure 31 - Creating a table using the "manual method"

  1. Once the table is created it will be added to the Tables list

  2. Tick the box next to the new table name

  3. Click on the table link

worddavcc27d5dfee89cef351a0c3292eff86c6.png
Figure 32 - Select the table and click on link to open

  1. Click on the Edit table link

worddav21d80d37981559973624b5539185e742.png
Figure 33 - select the Edit table function

  1. Complete the four items to create the new column names in the tableEnter a column namee.g. Batch_NameSelect Typee.g. StringTick the box  for mandatory or leave box unticked  for non-mandatoryClick the + Add button to add the column

  2. Add more column names if required OR click the Close button to complete


worddav9f82694e5670ba95ad61e409136c48e4.png
Figure 34 - Creating a column in the table

Adding Table Data (rows)

Once the table columns have been created it is now time to add the row values

  1. Tick the box next to the table name

  2. Click on the table link

worddav4506d6a0339c0919b11837f2b1c9dfd2.png
Figure 35 - opening the table to add some data (rows)

  1. Select the + Add data link


worddav75655f83663f605bc119ea15a02bd36b.png

Figure 36 - click the add data link to begin adding new rows

  1. Add the name into the field

  2. Click the + Save Data button

  3. Repeat the above steps to add additional rows

worddav2361aa3d1799783eab81d01f70fa27fa.png

Editing Table Data (rows)

Use the worddavbca40add5ffe04de8e730b2767707284.png pencil icon to editing a row name

Deleting Table Data (rows)

Tick the row name box and then use the worddavd2e7ed3c39064d92b1bef613feaad93e.png Delete selected option to permanently delete a row

Deleting a table

Tables can be deleted from the Authority Service by following the below procedure.
Select the table to be deleted, making sure its checkbox is ticked.
worddav23c53a622b3a1c6a439633f8d3518c96.png


Choose the "Delete selected" option as shown below.


worddav62cb2a57dace76e4d560da1e29e4cacc.png

There will be a confirmation dialog and as long as all is correct and the intended table is listed, choose the "Delete table" button and the table will be deleted fully.


worddav4a676eb585f06d50cca5a8406b286064.png


Exporting the table and editing in Microsoft Excel

An option included with the current release of the Authority service is the ability to download a table as a csv file. Once downloaded the table can be edited in Excel and the table in the Authority service can then be replaced with the edited csv file.

To Export:

Select the table to be exported by clicking on the table name.
worddav23c53a622b3a1c6a439633f8d3518c96.png


When the table opens, choose the Export as CSV option.


worddav3fb5e9f1ef6b696d7e24bb47c046467f.png


Save the file to a suitable location.

To Edit the CSV file:

  1. Although CSV files do open in Excel by simply double clicking on the icon, this process should not be used for editing CSV as the Excel defaults can have unanticipated results.

    For example Folder/Container IDs like 03/06/17 will be converted to a date format.

  2. To safely edit a CSV file it should be imported as Text into Excel with the field types configured as Text.3.

  3. Open Excel with a blank workbook.

    1. Choose the Data Tab and then the "Get Data From Text" ribbon item, browse to the CSV file and open.


worddav240e2ebb266589be03005b7bac4ba1a5.png


Figure 37




4. The Text Import Wizard will open at step 1, be sure the highlighted items are chosen prior to clicking the Next button

worddav024a0ccd6a3840bd53cdfc6f37c98f76.png

Figure 38

5. In Step 2 of the Wizard, set the delimiter to Comma making sure no other delimiter is ticked, no other changes should be required.

worddav0472b848c0ad0891bc9fac90ad50ee09.png

Figure 39

6. In Step 3 we need to set the columns from "General" to "Text".

Select the first field and then scroll the fields all the way to the right and using the Shift key, select all the fields and change the "Column data format" to "Text".
When all fields have been set with a column data format of "Text" the Finish button can be clicked to load the CSV file into Excel.


Figure 40

7. Excel will ask if you'd like to place the data in an Existing or New Worksheet, the existing worksheet will be fine.


When editing has been completed choose to save the file as a CSV file and upload into the EzeScan Authority service by following the Delete/Create new table process