Voyager to Alma Migration Query: Identify Duplicate Vendor Names

When migrating from Voyager to Alma, you will need to identify and resolve any duplicate vendor names. In Alma, vendor names must be unique.

This query, which you can run using Voyager Prepackaged Access Reports, will identify duplicate vendor names.

SELECT VENDOR.VENDOR_NAME, Count(VENDOR.VENDOR_ID) AS CountOfVENDOR_ID
FROM VENDOR
WHERE (((VENDOR.VENDOR_NAME) Is Not Null))
GROUP BY VENDOR.VENDOR_NAME
HAVING (((Count(VENDOR.VENDOR_ID))>1));

For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.

If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.