AnsweredAssumed Answered

Importing Records With Set Parameters

Question asked by spinny on Mar 30, 2010

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 

Outcomes