leechilcoat1
Occasional contributor

Bulk updates of asset records

Hi all. Does Flexera (FlexNet in particular) offer a tool to do bulk updates to asset records that can be used by a hardware administrator? For example, the HP Asset Manager application comes with an app called Connect-It, which can use a spreadsheet as source data, and then map the data in the spreadsheet to records and individual fields in the asset repository database. Very simple to use without having an extensive programming background other than simple SQL scripting. Just curious if Flexera offers something similar? Thanks for any input.
5 Replies
Natalie
Moderator Moderator
Moderator

Business Importer / Business Adapter Studio

Hi Lee,

You can use the Business Adapter Studio to build an adapter that reads such a spreadsheet. Then the Business Importer can be scheduled to load the data at a time of your choosing. You can connect to a spreadsheet or a database, as required.

Natalie@Flexera
Natalie Overstreet Lias
Senior Product Manager
I don’t speak for Flexera, and we should all be grateful for that
adrianphilpott
Occasional contributor

Re: Bulk updates of asset records

I have a similar issue and have just seen this after posting a similar request.  I also used to be a HPAM user and use Connect-IT.  I know our Admin uses 'the beacon' to bulk upload records, but each time it means troubling him and waiting for him to get round to it.

0 Kudos
JohnSorensenDK
Moderator Moderator
Moderator

Re: Bulk updates of asset records

@adrianphilpott 

As soon as you (your colleague) have developed an adapter that reads such a spreadsheet the Business Importer can be scheduled to load the data at a time of your choosing and with a given frequency, e.g. every day at 01:00 AM.

I.e. if you have another process (or manually) create the spreadsheet with data to be bulk updated and/or inserted and copied it to this pre-agreed folder from where the Business Importer would find it and process its data.

Thanks,

0 Kudos
adrianphilpott
Occasional contributor

Re: Bulk updates of asset records

Thanks, @JohnSorensenDK  .  Is there a link to a user guide for how we run the Business Importer, please?  Currently I receive a weekly spreadsheet of what HW assets have been installed and which have been replaced.  I load this in MS Access and that produces two output files from this data: 1) a list of new records to create, 2) a list of records to set the status to 'Disposed'.

Each Access export file is an XLS sheet with all the field names set to those neede by my Admin to load through the beacon.  So the process to produce standard consistent sheets with the right column headings is already there.

I spoke to my Admin and I'm not sure hw knows about the Importer, unless him using 'the Beacon' is the same thing.

Thanks.

0 Kudos