Product Packaging Data Extract

The first time the Product Packaging Data Extract job runs it creates a snapshot of product events from the day prior to the day the job runs. (Products created or updated from 00:00:00 to 23:59:59, FlexNet Operations server time, on the previous day are captured when the job runs). Subsequently, when this job runs, it creates a snapshot from the end time of the last successful run to the current time.

A successful run of this job results in the extract information getting downloaded as a zip file. The output contains the details of products and their dependent entities (such as maintenance, suites, part numbers, and license models). It also captures features (including their version, state, and quantity) that are associated with the products. The job output is a snapshot of products created or updated; it does not include historical product data.

The name of the zip file would be Products-<date and time>.zip. Inside the zip file, the output is grouped into four CSV files which contain the following information:

•

ProductsExtract-<date and time>.csv—Contains the main product record information and details about dependent entities

•

ProductsLicenseModel-<date and time>.csv—Contains the license model details that are associated with the products

•

ProductsPartNumber-<date and time>.csv—Contains details about the part numbers associated with the products

•

ProductsRelation-<date and time>.csv—Contains details about the relationships between the products and the related products

The naming format in the zip file and the CSV files is “YYYY-MM-DD-HH-MM-SS” (for example, Products-2019-06-07-16-29-10.zip).

The first line of the job output contains the header information for the table described by the CSV. If no products were created or updated in the job period, the CSV output includes only the header row content.

Note:The date/time format of the data extract is controlled by the Use ISO 8601 time format in extracts configuration option. For more information, see Configuring System Settings | General Options in the FlexNet Operations User Guide.

Sample Output: Product Packaging Data Extract Job - Product Extract

ProductName, OrderableType, Description, Version, State, PackageName, PackageVersion, PackageVersionFormat, LicenseTechnologyName, UsedOnaDevice, UsageModel, LicenseGenerator, FnpVersion, AllowDownloadObsoleteFrInPortal, AllowDownloadObsoleteFrInAdmin, StartDate, EndDate, Product Line, AllowUpgrades, AllowUpsells, AllowRenewals, UpgradeEmailTemplate, Feature|Bundle Name, FeatureType, FeatureVersion, FeatureCount, FeatureDescription, FeatureState, SuiteProductName, SuiteProductVersion, SuiteProductState, SuiteProductQty, CA[PROD|Prod_boolean_new], CA[PROD|product_NUMBER], CA[PROD|Product_boolean], CA[PROD|Product_mal_val], CA[PROD|product_date], CA[PROD|TestProduct], CA[PROD|Prd], CA[PROD|Product_boolean1]

ExtractMaintenance1556128254153,bo.constants.orderable.type.maintenance,test,1,bo.constants.states.draft,,,,,,,,,,,,,Uncategorized Products,FALSE,FALSE,TRUE,,,,,,,,,,,,,,,

Suites_extract1,bo.constants.orderable.type.uniform_suite,Suites_extract11,2019/21,bo.constants.states.draft,Extract121,4564,Fixed,NEW_LIC_TECH,FALSE,,TEST_LIC_GEN_CONF,,TRUE,FALSE,,,UncategorizedProducts,,,,,,,,,,,Product_extract1,1.0,bo.constants.states.deployed,2,FALSE,,FALSE,,,sdgsfg,fsdfg,FALSE

PhotoPrint,bo.constants.orderable.type.licensedProduct,,2,bo.constants.states.deployed,PACKAGE,1234,Fixed,FlexNet Licensing,TRUE,None,demo,7.1 | 10.1 | 10.8,FALSE,FALSE,2019-04-26T05:30:00Z,2019-05-31T05:30:00Z,Uncategorized Products,,,,DEFAULT,F1,FEATURE,2,12,,DEPLOYED,FALSE,142,TRUE,,11-Apr-19,,TEST12,FALSE

...

When a product supports multiple FNP versions, the output lists all supported FNP versions and separates them with a pipe character (|). The FeatureType column identifies whether the item is a feature or a bundle; possible values are FEATURE and FEATURE BUNDLE. Custom attributes, if any, are displayed in columns following the FeatureState column.

Notice that, for products that contain multiple features or feature bundles, FlexNet Operations structures the CSV output so that a new row appears for each additional feature or feature bundle. On these extra rows, the product name of the product is repeated. Other details are left empty. (See Example for Products Containing Multiple Features or Feature Bundles, below.)

Example for Products Containing Multiple Features or Feature Bundles

ProductName, OrderableType, Description, Version, State, PackageName, PackageVersion, PackageVersionFormat, LicenseTechnologyName, UsedOnaDevice, UsageModel, LicenseGenerator, FnpVersion, AllowDownloadObsoleteFrInPortal, AllowDownloadObsoleteFrInAdmin, StartDate, EndDate, Product Line, AllowUpgrades, AllowUpsells, AllowRenewals, UpgradeEmailTemplate, Feature|Bundle Name, FeatureType, FeatureVersion, FeatureCount, FeatureDescription, FeatureState, CA[PROD|Prod_boolean_new], CA[PROD|product_NUMBER], CA[PROD|Product_boolean], CA[PROD|Product_mal_val], CA[PROD|product_date], CA[PROD|TestProduct], CA[PROD|Prd], CA[PROD|Product_boolean1]

PhotoPrint,,,,,,,,,,,,,,,,,,,,,,FB1,FEATURE BUNDLE,,4,,DEPLOYED,,,,,,,,

...

Above, the product PhotoPrint contains a feature called F1 and a feature bundle called FB1.

Sample Output: Product Packaging Data Extract Job - Product License Model

ProductName,ProductVersion,LicenseModel,DefaultTransactionKey,VirtualTransactionKey

PhotoPrint,v1,Enterprise Activation,,Demo1

PhotoPrint,v1,Lic Model_Nov21_1,,

Prod_new,v4.2,Embedded Counted,,

...

In this example, the product PhotoPrint is linked to two license models (Enterprise Activation and Lic Model_Nov21). FlexNet Operations structures the CSV output so that a new row appears for each additional license model. On these extra rows, the product name of the product is repeated. Other details are left empty.

The columns DefaultTransactionKey and VirtualTransactionKey are only applicable to trusted license models.

The column ProductVersion is only included if the configuration option Show product version in extract file (under System > Configure > FlexNet Operations > Embedded Device Settings) is selected.

Sample Output: Product Packaging Data Extract Job - Product Part Number

ProductName,ProductVersion,PartNumber,PartNumberDescription,AvailableForTrial,RelativeLicenseModel

PhotoPrint,2,PN_NT,,FALSE,FlexNet Licensing

PhotoPrint,2,PN_T,,TRUE,Enterprise Activation

...

For products that are mapped to more than one part number, FlexNet Operations structures the CSV output so that a new row appears for each additional part number. On these extra rows, the product name of the product is repeated. Other details are left empty.

The column RelativeLicenseModel indicates the license model that is mapped to the respective part number (optional).

Sample Output: Product Packaging Data Extract Job - Product Relations

ProductName,ProductVersion,ProductType,RelationshipType,RelatedProductName,RelatedProductVersion,RelatedProductType

ExtractMaintenance1556128254153,1,bo.constants.orderable.type.maintenance,bo.constants.orderable.relationType.isMaintenance,P1.32_1,2018-21,bo.constants.orderable.type.licensedProduct

ExtractMaintenance1556128254153,1,bo.constants.orderable.type.maintenance,bo.constants.orderable.relationType.isMaintenance,ExtractProduct1556128254153,1,bo.constants.orderable.type.licensedProduct

Suites_extract1,2019/21,bo.constants.orderable.type.uniform_suite,bo.constants.orderable.relationType.demoOf,Suites_extract1,2019/21,bo.constants.orderable.type.uniform_suite

Suites_extract1,2019/21,bo.constants.orderable.type.uniform_suite,bo.constants.orderable.relationType.ProductionVersionOf,Suites_extract1,2019/21,bo.constants.orderable.type.uniform_suite

PhotoPrint,2,bo.constants.orderable.type.licensedProduct,bo.constants.orderable.relationType.upgradeTo,PhotoPrint,2,bo.constants.orderable.type.licensedProduct

PhotoPrint,2,bo.constants.orderable.type.licensedProduct,bo.constants.orderable.relationType.hasMaintenance,CM,1,bo.constants.orderable.type.maintenance

PhotoPrint,2,bo.constants.orderable.type.licensedProduct,bo.constants.orderable.relationType.upgradeFrom,PhotoPrint,2,bo.constants.orderable.type.licensedProduct

...

For products that are mapped to several other products, FlexNet Operations structures the CSV output so that a new row appears for each additional related product. On these extra rows, the product name of the product is repeated. Other columns are populated as appropriate.