Archive for the ‘Spider’ Category

Meet Spider ‘Reverse’

Monday, November 30th, 2015

Spider Reverse is the core of the news for the latest release of Spider, belonging to #Plant version 01.000.35.00.
Starting from a configuration already existing, Spider Reverse allows the automatic generation of configuration files; this function is particularly useful when important modifications need to be applied to the configuration, without using the interactive functions of Spider Configurator.


The whole process for the massive modification of the configuration is performed in three steps:

  • execution of the “reverse” of Spider current configuration to extract Excel configuration files;
  • modification of the files generated at the previous step;
  • loading of modified configuration files, by using the “Loader” function.

Data requested to perform this process are only two: the path to the directory where the ‘Reverse’ folder is located (the configuration files are generated and saved here) and the colour palette to be used for the template colouring (each type of cell will have its own colour).
For more details on Spider Reverse, please check our documentation available for download in our support portal.

Publisher, a new function for Spider

Tuesday, May 12th, 2015

A new function, Spider Publisher, has been implemented to create reports autonomously by extracting data that are common to all Spider projects, belonging to revisions of the datasheet. These data are extracted from a pre-defined database and they are set inside the Spider Configurator. Database tables, corresponding to the sheets that are to be exported, are created with a structure having a row for each item and a column for each item property (and some fixed columns for the project name and ID, document, revision, etc.).

Data are published within Spider section dedicated to datasheet revisions. After the publication, data can be examined inside the database.

By executing the ‘Publish to database’ command a table is created inside the destination schema and data of the current revision are published. If the table is already existing – therefore from the second publication onwards – datasheet data relating to the current revision are appended to data already existing in the table. In case of configuration modifications (adding, renaming or deleting fields), the existing table gets updated and the new requested data are appended; old data are never deleted.

Spider Publisher is part of the release No.  01.000.24.00 of Spider and of the release No. 01.000.04.00 of Spider Configurator. These releases include some bug fixing and other implementations, whose full list can be found in the latest What’s New, available for download by logging into our support portal.

New releases of Spider and SpiderConfigurator

Wednesday, November 26th, 2014

 

Brand new releases of Spider (01.000.23.00) and of SpiderConfigurator (01.000.03.00) are now available for download from our support portal. Log in or register at http://support.cla-it.com/ and get your copy!


Many features have been implemented to make Microsoft Excel users even more comfortable with Spider, by adding Excel-like filters on GRID documents, by hiding or displaying sheet of a Spider document just like Excel does… and this is to name a few.


New tools have been added for Administrators: they can define a structured procedure for issuing a revision of one or more types of datasheet, setting the status (Prepared, Checked, Approved etc.), the sequence and roles of the users who have the right to make the acceptance workflow advance or block the revision itself.

 

 

What else? Many many more… for example, Spider document tree now displays full or empty folders depending on documents being in the folder or not.

 

 

Text cells can now pick pre-defined values from a “Suggestion list”, which can be later modified manually. On these cells, the tooltip displays the associated list name; by right-clicking and selecting “Suggestion list…” (also by pressing Alt + Arrow down) a selection window is shown, similar to the Global list cells window. A suggestion list for a particular cell can be set in SpiderConfigurator.

 

 

Formula results of an Excel sheet can now be saved in the database history and therefore they can also be published in the relevant documents of the data workflow and they will be available for calculation in plugins and report creation.


A format check is performed on dates and numbers: when these data are pasted and Spider cannot recognize the original format, a pop-up asks to insert the date format or the decimal separator in order to read the copy & paste input. This setting is kept for the whole Spider session but it can be modified in the menu command Edit → Number and date format.

 

 

Speaking of date format, also SpiderConfigurator has some check performed when converting a text format into date format; slightly different rules apply for Oracle, SqlServer and Postgres (see the full “What’s new” document for more details).


Attribute domains can now be displayed and changed in the “Modify cell” form.

 

 

Find out the rest of implementations, new features and bug fixing in the full “What’s new” document, available from our support portal (http://support.cla-it.com/)