What's New in Version 7.0
You can easily identify the most important new features with the  icon.
Content of this Page
·	Data Import
•	Data Import Using the Database Wizard
•	Data Import from Text Files 
•	·	Edit
•	·	Views 
•	·	Attributes 
•	·	Queries 
•	·	Saving and Exporting Data
•	·	Reports
•	Excel Reports
•	Internal Reports
·	InfoZoom Office Add-Ins
·	Command Line Parameters
·	Sample Tables
·	Licensing
·	Optimizations 
Data Import
Data Import Using the Database Wizard
Adding data sources (database systems and MS Access files)	New functionality: Specifying the field order while adding the data source.
Until now the fields of database tables were adopted into the InfoZoom source table in the order specified in the data source.

You can now determine the order when selecting the fields or in the source table properties.
Topic: Adding data sources	
Adding data sources (all types)	Expanded functionality: Changing the selection of the fields to be adopted
Until now, the selection of the fields could only be changed in the InfoZoom source table only after being adopted into it.
To change the selection, the window Data Fields is now also available. This window simplifies the operation so that you can
·	Select all data fields in one step,
·	Cancel the complete selection,
·	Select individual fields or cancel their selection as well as
·	Specify the order of the fields.
Topic: Changing compilation for the data import	
	New functionality: Limiting the number of records to be imported with the new field Number Data Records	
Defining filters	New functionality: Using dates as filter criteria
Until now, dates could not be used as filter criteria to limit the data to be imported.
Now, you can limit the data to be imported using dates. For this purpose, you can also define filters for table columns with dates.
Topic: Delimiting data	
Data Import from Text Files
Compiling data for import 	New functionality: Limiting the number of records to be imported with the new field Number Data Records	
Edit
Search and replace	Expanded functionality: The Search/Replace window is also opened with the <F3> function key.	
Views
Reset 	New functionality: Reset All
With "Reset All," (also using the keyboard shortcut <Ctrl + F8>) the table is reset to the initial state and the following actions are performed in addition: 
·	Open value lists are closed.
·	Open report windows in which no changes have been made are closed.
·	A hidden table or hidden data in a table is displayed.
With "Reset Table (Reset)," the table is still reset only to the initial state. The function key <F8> can be used for this purpose.
Topic: Reset	
Attributes
Select All Values	Expanded functionality: Also selecting all values with the <Ctrl + A> keyboard shortcut	
Insert Attributes	Changed functionality: <Ctrl + A> keyboard shortcut changed to the <Ctrl + Shift + A> keyboard shortcut	
Open and close Attribute Group 	Expanded functionality: Opening and closing is possible now for all Attribute Groups	
Move Attributes	Expanded functionality: Automatically open and close Attribute Groups at move
Until now, you have always had to explicitly open attribute groups that were not yet opened or close attribute groups that were already open before moving attributes.
During movement, Attribute Groups are now automatically opened when you move the cursor onto the button  in front of the name of the Attribute Group. An Attribute Group is also automatically closed when you move the cursor onto the button  in front of the name of the Attribute Group.	
Defining derived Attributes with formulas	New function: ConvertGeoCoordinate 
 (Converts the geographic latitude and longitude for the map view according to various coordinate systems and returns a string.)	
	New function: Latitude 
 (Converts the geographic latitude using coordinates from various coordinate systems and returns a decimal.)	
	New function: Longitude 
 (Converts the geographic longitude using coordinates from various coordinate systems and returns a decimal.)	
Defining derived Attributes with classifications	Expanded functionality: New possibility "<unchanged>" for determining the name of a class	
Calculate derived Attributes	Expanded functionality: New calculation mode "After data loading" for recalculation	
Entering and editing comments	New functionality: Assigning or removing permissions for entering and editing comments	
Queries
Assigning or withdrawing permissions for queries
(Permissions window; Table Settings tab; modify Table Group)	Changed user interface: Define Queries checkbox renamed to Generate and Change Queries	
Defining and editing queries	Changed user interface: Functions for queries can only be called up in the toolbar (query bar)
Until now, the functionalities for queries could be called up both in the toolbar (query bar) and as well as in the menu item View | Queries.
The functionalities for queries can only still be called up in the toolbar (query bar).
Removed: View | Queries menu item	
Exporting and importing queries 	New functionality: Exporting and Importing Queries	
Saving and Exporting Data
Saving tables (*.fox file) or templates (*.fot file)	Expanded functionality: When saving a table or template, check whether it has been changed in the meantime.
Until now, it was not checked whether another user changed or saved the table or template in the meantime.
In order for the table or template not to be overwritten inadvertently and unnoticed, InfoZoom now stores the time of the last saving procedure when the table or template is opened. Using this point in time, the system checks the table or template as to whether it has been opened by another user in the meantime during saving (File | Save). If this is the case, you will be informed accordingly in a system message. In the system message, you decide whether the file should be overwritten. If the file should not be overwritten, you can save it under another file name if necessary.	
Exporting data into text files	Expanded functionality: Determining text identifiers
Until now, double quotation marks have been automatically used as text identifiers.
With the new Text Identifier field, you can now determine whether and which text identifier should be used.
Topic: Text Identifiers	
Reports
Excel Reports
Generating Excel Reports	Expanded functionality: Support of Excel Version 2010	
Internal Reports
Generating and editing internal reports	Expanded functionality: Adaptation to Excel Version 2007
Until now the internal reports were geared to Excel up to Version 2003. The editing features for the internal reports were analogous to Excel up to Version 2003. 
Now the internal reports are geared towards Excel Version 2007. The following expansions are the result:
·	The number of rows and columns in the report have increased to 1,048,576 (previously: 65,535) and 16,384 (previously: 255).
·	Report can also be saved in Excel file format "*.xlsx."
·	Rows and columns can be filled automatically with data using the familiar autofill box from Excel (autofill function).
·	For the selection of colors, the complete Windows color palette is available (previously: 56 available colors).
Please note: Reports that contain more than 65,535 rows and/or 255 columns can be saved in Excel file format "*.xlsx" only. Saving as an InfoZoom report file (*.irp) with a link to the InfoZoom table is not possible. When saving a report whose number of rows and columns exceeds the specified values, you will be informed in a system message. If pertinent, you can change the data selection in the InfoZoom table.	
Displaying numeric values in internal reports	Expanded functionality: Determining the locale for the display of numeric values
Until now, the display of the numeric reports corresponded with the currently set language (Options window; General tab; Language field).
You can now select a deviating locale for the display of numeric values in internal reports. For this purpose, there is a new field: Locale for Numeric Formats (Options window; Reports tab).
Topic: Locale for Numeric Formats	
Adding up values in internal reports	New functionality: Adding Up Values with Autosum	
InfoZoom Office Add-Ins
InfoZoom Office Add-Ins	Expanded functionality: Availability for Office Version 2010
Until now, the Add-Ins could only be used for Microsoft Office 2007.
Now Add-Ins are also available for Microsoft Office 2010.
For each Add-In (InfoZoom Excel Add-In and InfoZoom Word Add-In), an installation is available that can be used with Office 2007 and Office 2010. Tips for installation can be found in the "Getting_Started.rtf" file of your InfoZoom installation.
The Add-Ins have also been optimized for use:
·	The Add-Ins can now be enabled on demand during Office-applications
Upon enabling the menu items for InfoZoom menu items are available in the tab for working with InfoZoom. The menu items are grouped into menu groups according to their functionality.
Office 2010 permits the individual adaptation of the menu bar so that you can supplement the InfoZoom tab by additional menu items according to your needs. You can thus integrate frequently required Excel functions into the InfoZoom tab for quick access.

·	In the Word Add-In, you can now use the separate Designer window to select and assume attributes, analogously to the Excel Add-In. You can position the window to the left or right of the Word document and also hide it.	
Command Line Parameters
Command line parameter for data import	New command line parameter: -maxRecords for limiting the number of records for the import from text files	
Command line parameter for data export	Expanded functionality: Determining text identifiers
Until now various command line parameters could only be used for data import.
Now the following command line parameters can also be used for data export (save).
·	-doubleQuotes
·	-singleQuotes
·	-noQuotes
The permission of the command line parameter -noQuotes for the export of data may affect the existing batch files. This affects batch files in which the -noQuotes command line parameter is used for the import of data and that also contain commands for the export in the same command line. In such lines, an additional -doubleQuotes command line parameter must be inserted before the export instruction.
The named command line parameters can be used together with the following command line parameters.
·	-saveCopyAsTXT
·	-saveCopyAsCSV
·	-saveObjextsAsTXT
·	-saveObjextsAsCSV
Topic: Saving an InfoZoom table to file
	
Sample Tables
Sample table: "FormulaOneSample.fox“
("FormulaOne" directory)	Expanded sample table:
·	Supplement to the current data for the Formula-1 season 2010 (to Race 15/2010) as well as additional data, amongst others the attribute group "Scoring System" (point system of Formula-1).
·	Modification (normalization) of the queries "Maximum Points per Season" and "Most Average Points per Driver" with comments.	
Sample table: "ErsteBundesliga.fox"
("Bundesliga" directory)	Expanded sample table: Supplement to the current data for the Bundesliga (German major soccer league) Season 2009/10 and additional data, including match times, coats of arms of the German states, and a "Team Comparison" query.	

Licensing
License conditions	Expanded functionality: Viewing license conditions
Until now, you could only view the license conditions from the program folder for you InfoZoom installation. 
Now you can also view the license conditions directly from InfoZoom.
Topic: License Conditions	
License monitoring	Changed Functionality: License Monitoring with Dongles
Until now, the administration software of "CodeMeter" has been installed together with InfoZoom. 
Installation now takes place separately because two installations (32-bit and 64-bit operating systems) are available. Tips for installation can be found in the "Getting_Started.rtf" file of your InfoZoom installation.	
Optimizations
Performance optimization 	Optimizations that lead to an acceleration of operations on large tables, especially in the case of multiple processor systems, have been made.	
Note: Further information regarding optimizations can be found in the "Improvements.rtf" file in your InfoZoom installation.