420
Hi Folks - I'm looking to flag a good number of projects across multiple databases as "Inactive," but am wondering if there is a better way to do so than manually? Is this something I could use Transaction Import for, or might there be another method?
I'm on SL V7.
Many thanks,
Justin Fishwick
*This post is locked for comments
Hi Perumalsamy,
I seem to run into a lot of errors on the TI import attempt, is there a sample you can give of what the code might look like if I just want to update the given field of Set Status_pa in the TI file?
Many thanks,
Justin
Ahh - thank you! This is just the lead I needed. I know to get the triggers to run correctly TI would work best. I'm going to give this a try and report back in the next week or so.
Thanks again, Perumalsamy!
Hello Justin,
You can use Transaction Import to update the status flag of Project Maintenance screen.You need to prepare data file with comma separated format(csv) and generate the control file of Project Maintenance screen using the Control macro Generator screen from Administrator Module.
The data file should start with "Level0,Update"
You can import the data using the Transaction Import screen.
You can also use below Query to update the flag of Project maintenance Screen
Update PJProj Set Status_pa ='I' where Project in ('Project Id which need to change as Inactive')
Hope this help.
Thanks,
Perumalsamy R
You could update the pjproj records with a SQL command.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (