[LegacyUG] RIN renumbering

2011-12-26 Thread Robert57P_gmail
I have 2 Legacy files I want to merge. To more easily identify which record came from which file (while I do the importing/merging), I'd like to renumber one of the files. File 1 = RIN 1 through 307 File 2 = RIN 1 through 1623 I'd prefer to renumber all RINs (and MRINs) in file 2 so that 10,000

Re: [LegacyUG] RIN renumbering

2011-12-26 Thread Brian/Support
You can have Legacy apply the renumbering during the import of file 2 rather than trying to renumber in file 2 before starting the import. Open file 1 in Legacy File > Import from > Legacy file Select File 2 Follow the prompts and select import into the existing file On the Import screen you have

Re: [LegacyUG] RIN renumbering

2011-12-26 Thread RICHARD SCHULTHIES
I reccomend yo use 10001 instead of 1. It should be obvious why.Rich in LA CA --- On Mon, 12/26/11, Robert57P_gmail wrote: From: Robert57P_gmail Subject: [LegacyUG] RIN renumbering To: LegacyUserGroup@LegacyUsers.com Date: Monday, December 26, 2011, 5:37 PM I have 2 Legacy files I want

Re: [LegacyUG] RIN renumbering

2011-12-27 Thread Bjørn K Nilssen
rPå Tue, 27 Dec 2011 12:27:35 +0100, skrev Mike Fry : > On 2011/12/27 11:53, Bjørn K Nilssen wrote: > >> On Tue, 27 Dec 2011 05:59:19 +0100, skrev RICHARD >> SCHULTHIES: >> >>> I reccomend yo use 10001 instead of 1. It should be obvious why.Rich in >>> LA CA > >> Sorry, but as a Legacy newbi

Re: [LegacyUG] RIN renumbering

2011-12-27 Thread Bjørn K Nilssen
il wrote: > > From: Robert57P_gmail > Subject: [LegacyUG] RIN renumbering > To: LegacyUserGroup@LegacyUsers.com > Date: Monday, December 26, 2011, 5:37 PM > > I have 2 Legacy files I want to merge. To more easily identify which > record came from which file (while I do the

Re: [LegacyUG] RIN renumbering

2011-12-27 Thread Mike Fry
On 2011/12/27 11:53, Bjørn K Nilssen wrote: > On Tue, 27 Dec 2011 05:59:19 +0100, skrev RICHARD > SCHULTHIES: > >> I reccomend yo use 10001 instead of 1. It should be obvious why.Rich in >> LA CA > Sorry, but as a Legacy newbie it is not obvious to me why he should add 10001 > instead of 1

Re: [LegacyUG] RIN renumbering

2011-12-27 Thread Laird
Hi Bob, I have been down this road before, but it has been a couple of years ago. I feel your last option is the best. (make all USER IDs equal to "FILE 2 RINs) It WILL preserve the original RINs. I would renumber using Brian's suggestion. 1 If there are missing/skipped RINs I think this

Re: [LegacyUG] RIN renumbering

2011-12-27 Thread RICHARD SCHULTHIES
sen wrote: From: Bjørn K Nilssen Subject: Re: [LegacyUG] RIN renumbering To: LegacyUserGroup@LegacyUsers.com Date: Tuesday, December 27, 2011, 1:53 AM På Tue, 27 Dec 2011 05:59:19 +0100, skrev RICHARD SCHULTHIES : > I reccomend yo use 10001 instead of 1. It should be obvious why.Ric