0 Replies Latest reply on Mar 30, 2010 2:56 PM by spinny

    Importing Records With Set Parameters

    spinny

      Title

      Importing Records With Set Parameters

      Post

      Hi All,

       

      I have changed the setup of my recruiting database so all the players are held in one database.  I have 2000 records to import into my main data table a lot of which have comments and ratings associated with them.

       

      What I need is an import that does the following:

       

      Checks all records to be imported against firstname, lastname, dob field

       

      If no match, import record and place playernumber, teamname, tournament, comment and rating in first available eval fields.

       

      If match – only import playernumber, teamname, tournament, comment and rating and place in first available eval fields

       

      The first available eval field could be recognized by looking at the Eval1comment and the eval2comment field until it finds the first one with no text in it and then import into that eval set.

       

      I have a set of 10 evaluation field sets:

      These fields are:

      Eval1Place

      Eval1Team

      Eval1Number

      Eval1Comment

      Eval1Rating

       

       

      Can this be done?

      Thanks,

       

      Andy