Licenses Import

Feature Description

The ImportLic application serves to import the licenses from CSV file. You can only import the license, or assign it to the computer or user in the same time.

Command Line Syntax

ImportLic.exe /input "path and name of the CSV file" {/conn "connection string" | /server "database server name" /db "database name"} [/import] [/force] [/headers] [/help]

Detailed Description of Parameters

Parameter	Description
/input	The import CSV file name and path.
/conn /server /db	These parameters contain connection settings for the ALVAO database. You can use connection strings (e.g. /conn "Data source=.\sqlexpress;Initial Catalog=test;Integrated Security = True"), or enter a specific SQL server and database (e.g. /server ".\sqlexpress" /db "test"). If you use the /server and /db parameters, the system will connect to the database using Integrated Windows Authentication. If you specify all parameters, only the /conn parameter will be used. The parameters /server and /db will be ignored.
/import	Import the data. If you do not use this radio button, only the syntax data check in the CSV file will be performed.
/force	Forces the data import also in the case there are errors in them.
/headers	Use if the first line of the file contains the column names.

Description of All Supported Columns

Warning:

The order of columns is fixed, it does not depend on the column name.
Therefore, the imported file has to contain all columns, only the values in them can be empty.
This applies also in the case of using the force parameter.

Warning:

The dates must be entered in correct form, e.g.: "1.12.2014" or "2015-12-01".

License

Column name in CSV	Options	Check	Required
Product	Exact product name from the ALVAO software products library – SWLIB.	Yes	Yes
LangId	License language – it can be either empty value, or the language code number (INT type) in the database: (1029=CZE,1051=SVK,1033=ENG,1031=GER,1036=FRA,1034=SPA,1040=ITA,1038=HUN,1045=POL, 1049=RUS,1060=SLO,1053=SWE,1055=TUR,1050=CRO,1041=JAP).	Yes	No
License name	Name of the existing license in the database, or an empty value (the license name will be the same as the product name).	No	No
Number	Number of licenses purchased – INT number, must be entered.	Yes	Yes
License kind	One of the following values must be entered: per device, per user, per connection or per processor.	Yes	Yes
License mode	You can enter any text, we recommend to use one of the following values: SaaS, Assurance, Select or Open.	No	No
Valid from	Date the license is valid from – the date must be entered in correct form.	Yes	Yes
Valid to	Date the license is valid to – can be empty value or the correct form of a date.	Yes	No
Support to	Date the given license is supported to – can be empty value or the correct form of a date.	Yes	No
License type	License type – must be one of the following values: Normal, Float, Multi, OEM, or CAL.	Yes	Yes
License activation key	License activation key – enter any text or empty value.	No	No
Asset number for license	Inventory number for license – enter any text or empty value.	No	No
Certificate number	Any text or empty value – if entered, the program searches the certificate in the DB by this number. If found, it will assign the certificate found in the DB to the created license, otherwise it creates a "Certificate" type document and assigns it to the currently created license.	No	No
Request	Requirement for license – enter any text or empty value.	No	No
License cost center	License cost center – enter any text or empty value.	No	No
Price	License price – any number of INT type or empty value must be entered.	Yes	No
Website Address	If the product is downloaded from the Internet, enter the URL link for downloading the product or empty value.	No	No
Bundle	Enter "1" if the product is a part of bundle package, enter "0" otherwise.	Yes	Yes
Note	Note to license – enter any text or empty value.	No	No

License Items

Note:

This part is may not be filled in the license – in that case the license will be created without license items.

Column name in CSV	Options	Check	Required
Computer	Network name of specific computer in the DB – the computer must exist in the database.	Yes	No
Item activation key	License item activation key – enter any text or empty value.	No	No
Item cost center	License item cost center – enter any text or empty value.	No	No
Inventory number for item	Inventory number for license item – enter any text or empty value.	No	No
Requirement for item	Requirement for license item – enter any text or empty value.	No	No
Item note	License item note – enter any text or empty value.	No	No

Document

Note:

This part does not have to be filled in again. In that case no document will be created in the newly created license.

Column name in CSV	Options	Check	Required
Invoice ID	Enter any text or empty value.	No	No
Invoice ID 2	Enter any text or empty value.	No	No
Issue date	Invoice issue date – the date must be entered in correct form.	Yes	No
Attachment path	Document attachment path (searched in shared documents) or empty value.	No	No
Vendor	Vendor name is searched in the DB, if found, it will assign the record found, otherwise new vendor with this name is created. Can be empty value also.	No	No
Voucher note	Enter any text or empty value.	No	No

Scenarios

An example of the CSV file

Product;LangId;License name;Number;CAL;License mode;Valid from;Valid to;Support to;License type;Lic. activ. key.;Inv. no. for lic.;Cert. number.;Requirement;Cost center;Price;Web. address;Bundle?;License note;Computer;Item activ. key;Item cost center.;Item inv. no.;Item requirement.;Item note;Invoice no.;Invoice no. 2;Issue date;Attachment path;Vendor;Invoice note Microsoft Windows 2000 Professional;;Win2k;1;per device;Assurance;30.1.2007;15.12.2030;15.5.2008;float;AK-1234;IC-ALL-1234;Cert1;Req1;Center1;1534;www.seznam.cz;0;License1Note;PC1;AK-PC-1;Pc1Center;IC-PC-1;REQ-ITM-1;PC1Note;CF-1234;CF-2-1234;15.8.2006;Invoices\f01.doc;DOD1;Doc.Note 1 Microsoft Windows XP Professional;1029;WinXP;1;per device;Assurance;15.1.2007;15.8.2030;15.5.2008;normal;AK-1234;IC-ALL-1234;Cert1;Req1;Center1;1534;;0;License1Note;PC1;AK-PC-1;Pc1Center;IC-PC-1;REQ-ITM-2;PC1Note;CF-1234;CF-2-1234;15.8.2006;Invoices\f01.doc;DOD1;Doc.Note 1 Microsoft Windows 2000 Professional;1029;Win2k;1;per device;Assurance;15.1.2007;15.8.2030;15.5.2008;normal;AK-1234;IC-ALL-1234;Cert1;Req1;Center1;1534;;0;License1Note;PC2;AK-PC-2;Pc2Center;IC-PC-2;REQ-ITM-3;PC2Note;CF-1234;CF-2-1234;15.8.2006;Invoices\f01.doc;DOD2;Doc.Note 2 Microsoft Windows XP Professional;1033;;2;per device;Assurance;15.1.2008;;15.1.2010;multi;AK-888;IC-ALL-8888;Cert2;Req2;Center1;2256;;0;License2Note;PC1;AK-PC-1;Pc1Center;IC-PC3;REQ-ITM-4;PC1Note;CF-8888;CF-2-1237;15.8.2008;Invoices\f02.doc;DOD1;Doc.Note 2 Microsoft Windows XP Professional;1033;;2;per device;Assurance;15.1.2008;;15.1.2010;multi;AK-888;IC-ALL-8888;Cert2;Req2;Center1;2256;;0;License2Note;PC2;AK-PC-2;Pc2Center;IC-PC2;REQ-ITM-4;PC2Note;CF-8888;CF-2-1237;15.8.2008;Invoices\f02.doc;DOD1;Doc.Note 2

Import of CSV Files with Structure Recommended by ALVAO

The CSV file contains a header with column names. Data in the file will be checked before the import itself. If there are errors in the data, the import will not be performed.
Import command line:

ImportLic.exe /input "c:\data\licence.csv" /server server\sql2008 /db alvao /import /headers

Importing More License Items for One License

You can perform it by copying the line with data in the "License" section, you change only the "License items" section. Example: CSV import of one license with 3 items:

Product;LangId;License name;Number;CAL;License mode;Valid from;Valid to;Support to;License type;Lic. activ. key.;Inv. no. for lic.;Cert. number.;Request;Cost center;Price;Web. address;Bundle?;License note;Computer;Item activ. key;Item cost center.;Item inv. no.;Item request.;Item note Microsoft Windows XP Professional;1033;;3;per device;Assurance;15.1.2008;;15.1.2010;multi;AK-888;IC-ALL-8888;Cert2;Req2;Center1;2256;;0;License2Note;PC1;AK-PC-1;Pc1Center;IC-1;REQ-ITM-4;PC2Note 1 Microsoft Windows XP Professional;1033;;3;per device;Assurance;15.1.2008;;15.1.2010;multi;AK-888;IC-ALL-8888;Cert2;Req2;Center1;2256;;0;License2Note;PC2;AK-PC-2;Pc2Center;IC-2;REQ-ITM-4;PC2Note 2 Microsoft Windows XP Professional;1033;;3;per device;Assurance;15.1.2008;;15.1.2010;multi;AK-888;IC-ALL-8888;Cert2;Req2;Center1;2256;;0;License2Note;PC3;;Pc2Center;IC-3;REQ-ITM-4;Note 3

Note:

CSV contains 2 license items assigned to PC1 and PC2 computers, the last item will not be assigned to any computer.

We do not have complete data available

Use if you want to load yet incomplete data repaired as soon as the documents for them are available.
Load the values only into several columns defined in the header. The file will not be checked and you force the import of incomplete and incorrect data.
Import command line:

ImportLic.exe /input "c:\data\licence.csv" /server server\sql2008 /db alvao /force /headers

Did not find what you were looking for? Ask our technical support team.