Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Export all Aliases

Posted on by Microsoft Employee

I'm exporting an inventory file out of RMS.

I've got accumulated aliases - some items have 2,3,or more aliases.

When I run:

"Select * from Alias"  

It returns just 3 columns: ID, ItemID, and Alias - but I need a query that returns ALL aliases.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export all Aliases

    If you only need to look up alias for each item that you enter.    The quickest way to is to use RPS Item Manager Addon from retailpossolutions.com      Let me know if this helps

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export all Aliases

    Rad - you're right - i had completely failed to notice that the item ID repeats in that list - I kept expecting to see multiple entries tied to the master Item record...

    On to a little excel wizarding i guess.

  • Verified answer
    RMS Wizard Profile Picture
    RMS Wizard 1,205 on at
    RE: Export all Aliases

    Click on the Item ID column title and you will notice the sorted list shows a line entry for each alias. The Item ID will appear multiple times if an item has more than one alias. This is more obvious if you run Store Operations Manager, Reports, Items, Alias List and sort the report by Item Lookup Code. To export data from the report, click the Export icon in the report toolbar, set Destination to File and File Format to CSV or Tab Delimited.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export all Aliases

    This doesn't fix my issue.

    My problem isn't that I am missing the rest of the item properties.

    My problem is that when I look at an item within RMS - many of them have multiple aliases listed: UPC, EAN, internal item code, etc.

    I would assume that running " select * from alias " would generate a list of ALL of those aliases - but instead, it appears to only return ONE alias per record.

    Where are the rest of the aliases stored??  How do I run a query to return them all?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export all Aliases

    That table only holds the aliases, no item properties.  What you need to do is join the item table to the alias table.

    Try this:

    select * from alias

    left join [item] on [item].id = alias.ItemID

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans