Drawing chart

Product	InstalSystem 5
Type of article	FUNCTION AND TOOL
Source for translation	2019-09-27

Description

Content of Drawing chart:

• Content can come from:
  • selected window fields from General data, e.g.:
    • Project,
    • Investor,
    • Designer/specialist.
  • from Data table of Drawing chart, e.g.:
    • Scale,
    • Designer,
    • Drawn by,
    • Verified by,
  • from an external source, e.g:
    • graphic file - Logo.

Layout table comes from one of available templates in program. Template selection is made in Data table.
User can create his own template and save it in program templates (example location: C:\Users\<user>\Documents\InstalSystem 5 EN\AppWindowSettings\Templates).
Base file for creating your own template for Drawing chart is standard Microsoft Excel *.xlsx file (xls format is not supported).

Range of data include when converting to Data table:

• external and internal edges of table,
• text style,
• cell formatting.

Location in the program

Selection default template of Drawing chart for program

• Settings of Default project table template is available in window Settings in section Other settings.
  
  

  1. Selection default template of Drawing chart for program
  
  

Selection predefined template of Drawing chart for project

• Template selection is available in window Data table in field Table template.
  
  

  2. Selection default template of Drawing chart for project
  
  

Selection own template of Drawing chart for project

• Selection own template is available in window Data table from list in field Table template.
  
  

  3. Selection own template of Drawing chart for project
  
  

Example of use

Creating own element template Drawing chart.

• Creating general appearance with division into individual fields with selection of external and internal edge tables.
  The goal is define a table template with such structure of fields:
  
  

  4. Selection predefined template of Drawing chart for project
  
  
  
• Define text boxes for element Drawing chart.
  • Single field in Drawing chart should be made from two cells in *.xlsx file:
    • field title in Drawing chart - here should be enter text in cell directly,
    • content of field filled in Drawing chart - here should be enter text, but as a comment to cell.
      
• Defining element fields of Drawing chart download information automatically from General data.
  Defining these fields looks like in movie above, but with difference that in title field should be entered strictly specified ID field from field in General data.
  List of IDs and their form are below the movie and to avoid confusion, it is recommended to paste ID fields into cells using this list below.
  

• Construction of IDs:
  • #<Single ID field>#
  • #Project info ID>.<ID field>#
  • Construction of IDs must be performed in PL language at this moment
• ID fields from General data:
  • Single ID field - [transl. EN] - specifying a single field (only for project):
    • NumerProjektu - [Project number]
    • WersjaProjektu - [Project version]
  • Project info ID - [transl. EN] - defining from which Project info ID, data should be downloaded:
    • Projekt - [Project]
    • Inwestor - [Investor]
    • Projektant - [Designer/specialist]
  • ID field - [transl. EN] - defining field from specific Project info ID (for project, investor or designer):
    • Opis - [Name]
    • Ulica - [Street]
    • Kod - [Zip code]
    • Miasto - [City]
    • StanRegion - [State / Region]
    • Kraj - [Country]
    • Tel - [Telephone]
    • Fax - [Fax]
    • WWW - [WWW]
    • Email - [E-mail]
    • NIP - [VAT-id]
    • Komentarz - [Comment]
  • Examples of field definitions from template in *.xlsx file:
    • #NumerProjektu#
    • #Projektant.Opis#
    • #Inwestor.Opis#
    • #Inwestor.Fax#
    • #Projektant.Email#

Change appearance and formatting of table fields in template.

• Fonts and formatting fields in project table can be changed from Data table.
  
  

  5. Change appearance and formatting of table fields in template.
  
  

Insert your template of Drawing chart to project.

• Incorrectly created template of Drawing chart or an attempt of loading incorrect format is signaled by diagnostic message:
  • Error reading file %s - wrong format or content.