loading matrix items - ER map?

Apr 04, 2007 1 Replies

First reply

Glenn Adams [MVP - Retail Mgmt

-> -> RMS 2.0 changes the matrix table structures - haven't looked at them yet... Glenn Adams Tiber Creek Consulting DO NOT respond to me directly but post all responses here in thenewsgroup so that all can share the information.

Read the full reply

Hi, I need to convert an old Clarion database to RMS. I extracted most of the fields the customer needs but I am a loss how to map matrix items into RMS database using osql or import utility.



Seems like matrix item is defined in the itemclass table but I cannot find the link between the item table to the itemclass table.



I tried SOSchema document but it is not of great help. It would be very nice to have the ER map.



Any help is greatly appreciated.


ItemClassComponent.ItemClassID -> ItemClass.ID ItemClassComponent.ItemID -> Item.ID

RMS 2.0 changes the matrix table structures - haven't looked at them yet...

Glenn Adams Tiber Creek C> Hi, I need to convert an old Clarion database to RMS. I extracted

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required