Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Creating a import/export or deletion script


This topic is 7847 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello anyone,

I am a beginner DB developer and I need some help working with already created sophisticated DB's. I have a faculty DB that has over 100 files in it and there are only 30 faculty and staff members. I am trying to create a script that will export or delete all faculty records that are inactive. I have been trying very hard to create this. Can anyone help please?:

Thanks

Geeker

Link to comment
Share on other sites

well, with only a hundred records, it seems easier to just sort them bei staff name & eliminate the doubles/inactives by hand. takes 30 mins at most and guarantees accuracy.

You could write a scrpt that would trash entries that have not been changed for a year or so based on modification date, or any record, that is not referenced within a certain period of time by a literature database or whatever your staff ilist is used for in a multi-file solution ... (like deleting any user in this forum who has not logged in within 18 months ...).

Link to comment
Share on other sites

This topic is 7847 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.