Mass Vendor Import

[BlakeDawes]

Good Afternoon! 

I was wondering if there is a import templet to do large amounts of vendor information all at once or if we have to create vendors one at a time..

Thank you!

[mfranz]

Hi,

That would be possible with a Business Import.

https://docs.flexera.com/FlexNetManagerSuite2020R1/EN/WebHelp/PDF%20Documents/On-Prem/UsingFlexNetBusinessAdapters.pdf

Best regards,

Markward

[BlakeDawes]

So the only way to import vendors into FlexNet is to create a new business import since there isnt already created one?

We have over 3000 vendors we work with so im just trying to avoid having my team create vendors one at a time. 

[mfranz]

Well, technically you could push data to the database in different ways. A Business Import would just be the easy and supported way.

[BlakeDawes]

What is some of the other ways? Because we need to start adding this information now and we dont have time to get someone to build us a business import. 

[mfranz]

• You could use the SQL Server Management Studio to add stuff to the "Vendor" table.
• If you're familiar with SQL code, you could write an INSERT statement.
• Or use existing stored procesdures to create the data (maybe VendorAddBatch).
• And, of course, you can still add stuff one by one in the WebUI.

Usually people start with an Excel or CSV list. To process these, a Business Import would still be the way to go.