NPrinting 12 Release Notes

    12.4.0.4

     

    Bugs Fixed: Cannot get recipient name in hebrew, Embed reports with hebrew characters.

     

    Bugs Fixed

     

    Cannot get recipient name in hebrew

     

    Embed reports with hebrew characters

     

     

    12.4.0.2

     

    Bugs fixed: Out of Memory with Word templare

     

    Bugs fixed

     

    Out of Memory with Word templare

     

    Memory usage has been optimized.

     

     

    12.4.0.0

     

    What's New: Automatically delete Recipients on import, Customize CSV Export separator, New recipients ID field.
    Improvements: More than one document can be attached to an e-mail using CTRL + Click, HTML report not created: report tags now eliminated from message, Enter custom text in dynamic report names and new date formats, Check e-mail address syntax during import, Objects already present in the NPrinting QlikView object list weren’t updated.
    Bugs Fixed: Check invalid character for output file, Group Section Access doesn't generate reports, Schedule date and time formats only Continental style.

     

    What's New

     

    Automatically delete Recipients on import

     

    Eliminate imported recipients who are no longer present in the data source with a task. This feature is controlled by two new properties: the task property "Delete old recipients" and the recipient property "Imported from task", which is read only. The "Imported from task" flag is indicated for a recipient imported by task. A recipient is eliminated from the list when the “Delete old recipients” box is flagged in the same task that imported the recipient and that task is re-launched but the recipient is no longer present in the data source. Only those recipients imported previously by the task but not currently present in the data source are eliminated.

     

    Customize CSV Export separator

     

    Now you can select from among different file formats for text file output: csv: comma separated values skv: semicolons separated values tab: tab stop separated values With an advanced setting window you can define the separator or specify a specific character as your separator.

     

    New recipients ID field

     

    There is the new editable ID field in recipients. If used during an import, it works as a primary key with an higher priority than the Full Name. Managing more than one recipient with the same Full Name is now possible: simply set different IDs: for instance enter your company identification number. Backward compatibility is kept, but please pay attention to the following things:

     

    • if you already have recipients with blank IDs and you reimport them with IDs, there will be two recipient records having the same Full Name. You'll need to delete them by hand before reimporting them
    • it’s not possible to add two to imports to a task if one of the imports uses ID and the other FullName
    • you cannot import recipients from a source that simultaneously contains recipients with FullName and ID set

     

    and recipients with FullName set but ID not set. You need to choose whether you want to use IDs or Full Names as keys beforehand.

     

    Improvements

     

    More than one document can be attached to an e-mail using CTRL + Click

     

    The possibility to add more than one file as e-mail attachments by pressing CTRL+Click has been implemented.

     

    HTML report not created: report tags now eliminated from message

     

    NPrinting now eliminates tags in message bodies for reports not generated. Specifically, if an NPrinting tag lacks a valid referent, it is eliminated from the message. If, for example, you had a report that was generated only when a certain condition was true and a tag for it was embedded the HTML message body, the tag was displayed when the report was not generated. Now the tag is eliminated when the report is not generated. Warning messages in log file have been improved:

     

    • If an NPrinting tag is coherent with the entities connected to the task but the tag has no referent to substitute it (for instance due to a not met condition), the warning: “The following NPrinting tag has no value so it will be removed" will be displayed
    • Any other not valid tag (for instance tags with syntax errors or referring to a deleted QlikView variable) between two double '%' signs having no referent will give the warning: "Warning: The following tag may be invalid but won't be removed"
    • Each tag without a valid referent will generate an individual warning in the log file

     

    Enter custom text in dynamic report names and new date formats

     

    Dynamic report naming offers additional options: any Windows filename standard compliant text that you want can be added to the Custom text field there are additional date formats: yyyy-mm, yyyymm, yyyy mm, mm yyyy, mm-yyyy and mmmyyyy.

     

    Check e-mail address syntax during import

     

    NPrinting now makes a formal control of e-mail addresses during import. If the e-mail address syntax is incorrect, NPrinting will:

    • display an info message during a manually run import
    • write an error message in the log file if the import is executed by task

    If the e-mail address is incorrect, the recipient will be imported without the e-mail address.

     

    Objects already present in the NPrinting QlikView object list weren’t updated

     

    The list of QlikView object displayed in NPrinting is currently updated every two minutes including already listed objects.

     

    Splash screen added

     

    The splash screen image reassures you that NPrinting is loading even if you don’t see it yet. Load time has been optimized.

     

    Bugs Fixed

     

    Check invalid character for output file

     

    Output file names can no longer contain the following characters: /\:?"<>|*. Use of one or more of these characters in a field that specifies the name of a report or other file to be generated/created will result in the warning: "You have entered an invalid character in the "

     

    Group Section Access doesn't generate reports

     

    A task containing a report and a group of recipients with section access enabled, generated no reports. The task worked with Section access and a list of individual recipients. Section Access Reports destined to recipient Groups now works correctly.

     

    Schedule date and time formats only Continental style

     

    Date and time formats now conform to OS settings. Date and time field boxes have been slightly enlarged.

     

     

    12.3.0.10

     

    Improvements: Allow export of more than 65536 rows into Excel workbooks for version 2007 or later.

     

    Improvements

     

    Allow export of more than 65536 rows into Excel workbooks for version 2007 or later

     

    QlikView allows you to export in xls format only. If a QlikView chart contains more than 65536 rows and you export it, QlikView will put each block of 65536 rows into a separate Excel worksheet. NPrinting has solved this problem by merging all the other sheets into the first worksheet and then saving the resultant workbook in xlsx format. This works both for columns and tables.

     

     

    12.3.0.9

     

    Bugs Fixed: Error during connection to the mail server: Verify internet access and E-Mail settings in NPrinting.

     

    Bugs Fixed

     

    Error during connection to the mail server: Verify internet access and E-Mail settings the NPrinting

     

    NPrinting sometimes displays: “Error during connection to the mail server: Verify internet access and E-Mail settings the NPrinting” during scheduled task execution.
    NPrinting will now try to connect to the mail server 4 times. If NPrinting doesn't successfully connect to the server 3 times, it will show this message: “Error while connecting to mail server. Retrying to connect” for each try.
    On the 4th unsuccessful try, this error will appear: “Error during connection to the mail server: Verify internet access and E-Mail settings in NPrinting Options” and NPrinting will no longer attempt to reconnect.

     

     

    12.3.0.8

     

    Bugs Fixed: Table of Contents wasn’t generated when the task was run.

     

    Bugs Fixed

     

    Table of Contents wasn’t generated when the task was run

     

    A Word report Table of Contents was generated during preview but not when the task was run. Now resolved.

     

     

    12.3.0.7

    What’s New: Localization in German.

     

    What’s New

     

    Localization in German

     

    NPrinting now has a German GUI. Online help is still in English.

     

     

    12.3.0.6

     

    Bugs Fixed: NPrinting crashed at startup and NPrinting crashed at startup.

     

    Bugs Fixed

     

    NPrinting crashed at startup

     

    A third party component was corrupted and caused NPrinting to crash at startup before execution. Now fixed.

     

    NPrinting crashed at startup

     

    Manually executed schedules terminated correctly, but NPrinting service executed schedules crashed and gave the “Error: Filter expression incorrectly terminated” message. Resolved.

     

     

    12.3.0.5

     

    Bugs Fixed: Registry key DocObject not configured for Microsoft Office 2013 and Report Task crashes when launched after a Reload Task.

     

    Bugs Fixed

     

    Registry key DocObject not configured for Microsoft Office 2013

     

    NPrinting displays the "Cannot find a supported template editor" error when trying to edit a template with some Microsoft Office 2013 installations. This was because the DocObject registry key hadn’t been created. The new setup file is able to create the correct keys for template type xls, xlsx, xlsm, ppt, pptm, pptx, doc, docx, docm, 32 or 64 bit.

     

    Report Task crashes when launched after a Reload Task

     

    When you use the NPrinting scheduler to run a Report task after a Reload task the first could  crash. There was a workaround: activate the flag  "Close connection when task ends". Now the flag is unnecessary.

     

     

    12.3.0.4

     

    Bugs Fixed: Repeated rows in Excel Reports with images and columns and Erro: O arquivo "" é inválido when running a schedule with the service.

     

    Bugs Fixed

     

    Repeated rows in Excel Reports with images and columns

     

    If an Excel template contains an image and a table on the same sheet, the values in the table were repeated. Everything worked fine with only the table in the sheet. This was due to unexpected behaviour when copying column and table ranges that has now been corrected.

     

    Erro: O arquivo "" é inválido when running a schedule with the service

     

    When running a schedule containing Legacy Excel Report with the service, NPrinting 12.3.0.2 shows the error “Erro: O arquivo "" é inválido”. It was generated by a wrongly managed translation of a string in Portuguese. It has now been corrected.

     

     

    12.3.0.3

    What's new: Improved Excel Pivot Table performance with Microsoft tables and Out of memory bug fixed.

     

    What's new

     

    Improved Excel Pivot Table performance with Microsoft tables

     

    Starting with this release, you can create faster performing Excel Pivot Tables thanks to using Excel Tables as the source.

     

    • You need to build an .xlsx template containing an Excel Table
    • The Excel Table is to be built from column tags with the Keep Source Format option disabled.
    • Then use it as a direct data source for the Excel Pivot Table.

     

    You don’t need to use levels any more.

     

     

    12.3.0.2

     

    Bugs Fixed: Error during connection to the mail server.

     

    Bugs Fixed

     

    Error during connection to the mail server

     

    NPrinting sometimes displayed ”Message: Error during connection to the mail server: Verify internet access and E-Mail settings the NPrinting Options”. We added a 5-minute timeout when connecting to the SMTP server and when waiting for a response. If the server doesn’t answer in 5 mins., task execution continues with the “Read timeout” error message.

     

     

    12.3.0.1

     

    Bugs Fixed: NPrinting Front end doesn't appear.

     

    Bugs Fixed

     

    NPrinting Front end doesn't appear

     

    NPrinting 12.3.0.0 did not start up when clicking on its icon on Windows 2008 R2 and 64 bit servers, rather an error message popped up in the status bar. Fixed for version 12.3.0.1 and higher.

     

     

    12.3.0.0

     

    Summary

     

    What's New

     

    • Report Security: read and write password protection has been added
    • Vizubi PDF Printer Engine
    • QlikView Objects export to CSV files
    • Full support for Excel tables
    • QlikView Objects and Reports Integrated into Reports

     

    Improvements

     

    • Resolution of images in PDF reports
    • QlikView variables with spaces in their names are supported
    • Support for Cyclic Group Dimensions in Report
    • Unsubstituted tags remain in the finished report
    • Temp folder is configurable
    • Dynamic management of report image dimensions
    • Improved label alignment and dimensioning
    • "Wrap Text" table property for Word and Excel reports

     

    Bugs Fixed

     

    • Management of tags rendered invalid in e-mail
    • Rationalization of the reload and partial reload task interfaces
    • "File doesn't exist" error when previewing a Word report
    • Check Task malfunction
    • Running a Help file search locked up NPrinting
    • Objects in containers are useable in reports
    • No More Black background for PNG images with transparent backgrounds
    • “One Shot” Schedule executed more than once

     

    Known Issues

     

    • Cannot Find Supported Template Editor
    • Increase in memory footprint during task processing

     

    What's New

     

    Report Security: read and write password protection has been added

     

    Reports can now be sent with either read password protection, write password protection, or both. Preset passwords in two places, control which passwords are used in one place:

     

    •     preset read and/or write passwords at the individual recipient level in each recipient's settings
    •     preset read and/or write passwords at the Task level for all reports and recipients contained in the task
    •     control individually for each report in a task which type of password protection is applied with the additional choice to set read and/or write passwords for each individual report

     

    Vizubi PDF Printer Engine

     

    NPrinting now installs and uses a completely user-transparent, integrated print engine for report output in PDF. Bullzip PDF Printer is still necessary only for Legacy QlikView Entities, i.e. QlikView content created with NPrinting versions previous to 12.3.

     

    QlikView Objects export to CSV files

     

    QlikView Entities based on the following Objects: TableBox, PivotTable, StraightTableBox, Chart can be exported to Comma-Separated Values (CSV) files.  QlikView Reports cannot be exported to CSV files.
    Be aware that files containing many records can become very large and unmanageable. Currently, the separating character is a ';' and is not configurable, though configurability is in the plans.

     

    Full support for Excel tables

     

    QlikView objects can now populate Excel tables, so you can use Excel table functions.

     

    QlikView Objects and Reports Integrated into Reports

     

    "QlikView Objects" and "QlikView reports" are now managed under “Reports”. They share the features of Office and HTML Reports and can be used in Report tasks.
    Now you can:

     

    • apply "Conditions".
    • export to the following output files: PDF, PNG, JPEG, BMP, TIFF, GIF, CSV, and Print (sends to printer) setting the Quality level and Color mode
    • use our own "Vizubi PDF Printer" which is installed by NPrinting setup.
    • set Report Security only for PDF output

     

    Your previous QlikView Entities are now found under Legacy QlikView Entities.
    Opening NPrinting files containing old QlikView Entities causes a dialog window to appear asking if the user wants to create new QlikView Entities from old QlikView Entities. This can be done by clicking on the "Create New Entities" button in the "Extras" group of the tool ribbon in the main dialog.
    Legacy QlikView Entities can no longer be created.

     

    Improvements

     

    Resolution of images in PDF reports

     

    The resolution of images in PDF files generated from Word, Excel, and PowerPoint reports can be regulated.

     

    Image compression for reports with "Output Format" set to "PDF" in the task report list can be regulated by clicking on the browse button in the "Advanced" column. A combobox containing a "Quality" section will appear.

     

    • "High" is the default (no compression)
    • "Medium" = resolution resampled to 150 dpi
    • "Low" = resolution resampled to 72 dpi

     

    QlikView variables with spaces in their names are supported

     

    QlikView variables names can now contain spaces to make them more legible. NPrinting is now able to display values for this kind of variable.

     

    Support for Cyclic Group Dimensions in Report

     

    A new "Use This Group Field" property has been added to the Table column Properties menu in Word, Excel, PowerPoint and HTML report templates. It is displayed only if the column is a Cyclic Group dimension.
    It has a predefined value, "(Active Field)", and creates reports having active field values. A specific group field can be forced by selecting it from the list.
    Formula and drill-down groups are not supported.

     

    Unsubstituted tags remain in the finished report

     

    Tags contained in a report template that are not substituted with data remain embedded in the finished report. This allows reports containing tags not valid in a given QlikView document but valid in another to become the template for later reports generated through a connection with a QlikView document for which the tags are valid.

     

    Temp folder is configurable

     

    Files that are needed only during data processing are created and deleted by default in the temp folder defined for the user currently using NPrinting or the Service. The 'Temp folder' can be redefined in the Options menu under Report settings.

     

    Dynamic management of report image dimensions

     

    Word and Powerpoint hold image dimensions fixed as defined at the moment the image is dragged'n'dropped onto the template. Later application of filters sometimes caused distortion in the final result due to changes in dimensions.
    The Images node has a new "Stretch" property that can be set to:

     

    • Don't Fit (Default in Excel): embeds images exactly as they are exported from QlikView.
    • Fit Inside: Reduces image dimensions proportionately to fit inside the allotted space in the template as necessary. Image quality is not degraded.
    • Fit Width: image width is held constant as set in the template while image height may be reduced as necessary, but not increased.
    • Fit Height: image height is held constant as set in the template while image width may be reduced as necessary, but not increased.
    • Stretch (Default in PowerPoint and Word): image dimensions are increased or decreased proportionately to fit into the space allotted in the template.

     

    Improved label alignment and dimensioning

     

    A graphics component has been added that facilitates automatic label alignment and dimensioning. This has led to the modification of all forms so that they are dynamic and no longer static.

     

    Other improvements are:

     

    • Use of system fonts.
    • Correct display when monitor resolution is increased.

     

    "Wrap Text" table property for Word and Excel reports

     

    We added the property "Wrap Text" for the Tables in Excel and Word reports. By "Wrap Text" you can set to wrap or not the text in the cells of the final table. This property is available only for Tables and it affected all table columns. For instance, if you set the “Wrap Text” property to false by selecting the table name, all its columns will have the “wrap text” set to false. The property is not available for the single column. The default value is true (the check is activated). “Wrap Text” property works only if “Keep Source Format” is unchecked.

     

    Bugs Fixed

     

    Management of tags rendered invalid in e-mail

     

    A tag validity check is run during the saving of a task. A message is displayed listing any invalid tags that are revealed asking whether to proceed or not.
    The task is saved when responding "yes", or the procedure is aborted when "no". The user may then correct any errors before saving.
    Tags contained in the body or subject of an e-mail message in a task are sometimes removed before dispatch if not coherent.

     

    Rationalization of the reload and partial reload task interfaces

     

    These tasks do not provide for the addition of recipients and so the related menu has been eliminated. Furthermore, the "Task folder with recipient subfolder" and "Recipient folder" output folders are no longer displayed.

     

    "File doesn't exist" error when previewing a Word report

     

    The "File [TemporaryFileName] doesn't exist" error has been resolved. It occurred when trying to preview a report immediately after clicking on Save As.

     

    Check Task malfunction

     

    Clicking on the “Check” button generated error messages even if the task being checked contained no errors.

     

    Running a Help file search locked up NPrinting

     

    Searching the help file sometimes caused NPrinting to quit working.

     

    Objects in containers are useable in reports

     

    Objects inside QlikView document containers are now useable in all reports. This renders NPrinting compatible with QlikView 10 release SR2 and later. It remains compatible with QlikView 9, which does not employ containers, and QlikView 11.

     

    No More Black background for PNG images with transparent backgrounds

     

    “One Shot” Schedule executed more than once

     

    Changing an existing repetitive schedule into a One Shot was not always a success as the task or job was executed more than once. New parameter checks avoid this.

     

    Known Issues

     

    Cannot Find Supported Template Editor

     

    Some users get the "NPrinting cannot find a supported template editor for the file NameFile..." error message when they try to edit or to create an Office report.
    This problem may be due to incorrect installation of Office. In most cases, this occurs when Office 2013 has been installed by an online procedure.
    Here are some suggestions that you can follow to resolve the problem quickly by yourself.

     

    1. Check that NPrinting is correctly configured. Please, have a look at this tutorial to learn how to set up NPrinting: Configure Options In particular, check that the default template folder in report setting options is correctly set.
    2. Make sure that all Office processes are closed when you are working with NPrinting. Use the task manager to close Office processes that are working in the background.
    3. Carry out the repair process for your Office installation. Please, have a look at this tutorial do so http://office.microsoft.com/en-us/project-help/repair-office-programs-HA010357402.aspx

     

    Increase in memory footprint during task processing

     

    RAM needs increase continually during task execution till memory is saturated. Word, PowerPoint and HTML reports manifest this problem. The development team is working hard to resolve this problem as soon as possible.

     

     

    12.2.0.12

     

    Bugs Fixed: OLE error 800AC472, Object Reference not set to an instance of an object, Formatting for numbers in Word and HTML tables is not conserved and Section Access does not work correctly with recipients

     

    Bugs Fixed

     

    OLE error 800AC472

     

    This error happened when dragging the columns of a table to cells inside a level in an Excel template and NPrinting stopped responding. The error didn't occur in PowerPoint, Word and HTML reports and no longer occurs in Excel reports.

     

    Object Reference not set to an instance of an object

     

    This error message appeared when previewing Word reports

     

    Formatting for numbers in Word and HTML tables is not conserved

     

    Numeric data in Word and HTML tables were displayed in English format (',' as the thousands separator and '.' as the decimal separator) even when the operating system was set to or tables were formatted in continental style in QlikView.

     

    Section Access does not work correctly with recipients

     

    QlikView security using the recipient name as an ID became activated for some recipients. The password was not set in section Access and recipients were added to the task. Section access filters were not applied to generated reports, so output was the same for all recipients.

     

     

    12.2.0.0

     

    What's New: use any cell value, new languages, office macros, show top ranks, preview from template editor, hard copies, manage table headers and check for QlikView object modification. Improvements: improved performance, compatibility with Windows 8, LDAP directories and avoid tables interfering with cell referencing

     

    What's New

     

    Use any cell value

     

    Put single cells or specified groups of cells from QlikView table boxes, pivot tables or straight tables where you want in your template.

     

    New languages

     

    Interact with NPrinting in French, English, Spanish or Portuguese. German, Chinese and Italian are coming soon.

     

    Office macros

     

    Automate processes by adding Office macros to your template. Macros you write in Office templates will be active in the generated reports.

     

    Show top ranks

     

    Import only the range of rows you need from your QlikView chart.

     

    Preview from template editor

     

    Just a click to launch a preview in the format you prefer directly from inside the template editor. A real time saver!

     

    Hard copies

     

    Print hard copies of your reports using any available printer.

     

    Manage table headers

     

    Hide QlikView chart table headers in Word or HTML reports using the Show/Hide Header property.

     

    Check for QlikView object modification

     

    Check the state of objects in your template. See if an object has been modified since your last editing.

     

    Improvements

     

    Improved performance

     

    - Save time in

    - Opening and saving NPrinting files

    - Importing and updating recipient lists

    - Fetching QlikView object lists while editing templates.

     

    Compatibility with Windows 8

     

    NPrinting is fully compatible with Windows 8 and Office 2013.

     

    LDAP directories


    Improved importing operations from LDAP directories and Windows Active Directories.

     

    Avoid tables interfering with cell referencing


    Guarantee cell reference validity in your template by disabling table expansion. NPrinting will not shift cells downwards to create a chart and your cell references in functions are safe.

     

    Bugs Fixed

     

    Resolved Bugs:

     

    • Problems with Word table positioning with respect to margins have been resolved.
    • Excel background format in reports is now maintained
    • The calculated condition error in Preview using QlikView 10 SR1 has been fixed.
    • Data alignment in Word table cells is maintained.
    • Word text boxes are now supported inside levels.
    • Better compatibility with Word formats.
    • The "parameter is incorrect" error in creating new templates has been fixed.
    • Hidden columns in Excel templates remain hidden also in generated reports.
    • Table values in filtered levels are restored at each cycle. This resolves an error that arose when some filtered values in a level were not present for certain field values but were present for other values in other cycles.
    • A bug in thread management has been corrected. The problem appears in machines with more than 16 cores and may cause the following problems:
      • NPrinting can't find a supported template editor for the file" error when opening or editing templates
      • NPrinting blocks when running as a service
    • The "cannot perform this operation on a closed dataset" error when importing recipients has been resolved.
    • NPrinting service closed all NPrinting applications in the case of a connection problem. Other users working on the service could lose their work. NPrinting service will now close only the applications opened in its section.
    • The number format in the HTML tables and Word tables will correspond by default with the number format set in the operating system configurations.
    • Recipients section access filters are now applied correctly. NPrinting will generate customized reports based on the section access parameters set for each recipient using the QlikView Security option.
    • The error "Object Reference not set to an instance of an object" has been resolved.
    • The number format in the HTML tables and Word tables will correspond by default with the number format set in the operating system configurations.
    • Recipients section access filters are now applied correctly. NPrinting will generate customized reports based on the section access parameters set for each recipient using the QlikView Security option.

     

     

    12.1.0.0

     

    New features: custom formats in templates, ZIP reports and Attach external files.
    Improvements: better image definition, add more dynamic information in messages, preview reports and temporary file management.

     

    New features

     

    Custom formats in templates

     

    We have unified format management so you can keep the original QlikView format, leverage Office formats, or apply your custom NPrinting formats.

     

    ZIP reports

     

    Create a single password protected compressed archive containing all reports or compress single reports in individual archives Maintain the QlikView table format in your HTML reports or choose custom data formats.

     

    Attach external files

     

    You can now attach as many files of any kind to your outgoing e-mail messages

     

    Improvements

     

    Better image definition

     

    The quality of QlikView images in reports based on PowerPoint and Word templates is significantly improved.

     

    Add more dynamic information in messages

     

    Attached file names and task execution date and time can now be included in the message.

     

    Preview reports

     

    Preview reports in different output formats. The preview function now allows you to preview reports in native format or PDF, HTML and other possible output formats.

     

    Temporary File management

     

    NPrinting automatically removes any temporary files created at runtime.

     

     

    12.0.0.0

     

    What's New: office reports, HTML reports, and embeded images.
    Improvements: improved performance with PDF.

     

    What's New

     

    Create Excel, Word, and PowerPoint reports.

     

    Create HTML reports and send them out by e-mail or publish them on your website.

     

    Embed images of any QlikView object in your Office reports.

     

    Use data from your QlikView documents in your Office and HTML reports

     

    Improvements

     

    Dramatically improve performance creating PDF reports.