Field to Column Mapping in Reverse Wizard

Thread is closed for posting
3 posts, 0 answers
  1. Ben
    Ben avatar
    1 posts
    Member since:
    Oct 2007

    Posted 17 May 2009 Link to this post

    A picture is worth a thousand words. Too bad I can't embed one in this forum post. Please have a look at this screen capture I threw up on imageshack.

    I'm not a long time user of OpenAccess. I just installed it a few days ago. I may very well be doing something wrong. I'm trying to create classes using the reverse engineering wizard for three tables. As shown in the screen cap, I have the phones table, the sipaccounts table, and the phonetoaccount table that joins them together. I'm pretty sure I understand how to use the wizard to create the classes. I just think the wizard is failing to do something that it should.

    Shouldn't I be able to type a column name in the "Field to Column Mapping" section and have it generate some mapping xml? Also, shouldn't what I type in there *stay put* and be there when I come back into the wizard? I can enter the appropriate mapping information, click Generate & Save Config, and the wizard regenerates the class files and closes. When I go back into the wizard, the "Field to Column Mapping" information is gone.

    I was able to work around this by manually editing the mapping xml, but I would like to confirm whether I am correct in assuming this is where and how the mapping information needs to be set.

    Also, the following forum post suggests the same problem, but was never followed through to resolution.
    http://www.telerik.com/community/forums/orm/general-discussions/one-to-one-relationships.aspx

    Thanks,
    Ben Holtsclaw

  2. Ady
    Admin
    Ady avatar
    589 posts

    Posted 18 May 2009 Link to this post

    Hello Ben,

     The behavior you describe was a regression in an earlier version which has been fixed. Referring to your image, you should see a combo-box in the 'Column' column where you can select a table column and should not have to manually type in stuff there.

    This fix is available as an internal build for customers.

    You can try the following as a workaround :

    1.     Please select the tree node for the column that you want to specify in the grid. You can see the full column name on the right hand panel. For example in the phonetoaccount.AccountId table the column : AccountId INTEGER

    2.     You should specify the value in the exact same format so that the reference is stored and retrieved when you save the mapping.

    3.     Please note that there are 2 spaces between the column name and its type.


     Hope this helps.

    Sincerely yours,
    Ady
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. Ady
    Admin
    Ady avatar
    589 posts

    Posted 18 May 2009 Link to this post

    Hello Ben,

     I am not sure whether my previous reply was posted completely. I guess not, due to an internal error. Here is the workaround again
    1. Please select the tree node for the column that you want to specify in the grid. You can see the full column name on the right hand panel. For example in the phonetoaccount.AccountId table the column : AccountId INTEGER
    2. You should specify the value in the exact same format so that the reference is stored and retrieved when you save the mapping.
    3. Please note that there are 2 spaces between the column name and its type.

    Greetings,
    Ady
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
Back to Top