Today I needed to enter a lot of table table entries into RE. Specifically New Zealand's Cities & Suburbs. I did not want to spend hours putting them into the front end so I created a profile to do the work for me and I thought it might be useful for others as well.
The profile takes a text file with all the new table entries and imports into the RE DB.
There are 3 columns:
1: CodeTableID. Required (This is the Number of the table you want to populate. You have to get this number from the SQL table: 'CODETABLES')
2: LongDescription. Required
3: ShortDescription. Optional
Once you start the program it IOM will give errors on all lines but it actually saves the table entries in the backend. You can ignore these errors.
Once you are done importing, go to the actual table in RE and sort it using the standard sort utility. This will make sure all sequence numbers are properly saved.
I took the coding from Blackbaud's website Knowledge base: BB114248
I am not sure how to attach the profile so just leave a comment and I can email it to you. (Or if somebody can tell me how to do it I'll attach it.)
Note: Use this profile on your on risk. I cannot guarantee it will work the same way it worked for me. I suggest the profile only to experienced users.