Open Forum

Project Controller Module

  • 1.  Project Controller Module

    BRONZE CONTRIBUTOR
    Posted Aug 07, 2019 11:55 AM
    ​Would there be a way to set project controller projects for specific maintenance years as "inactive" in mass for specific job codes or to exclude specific job codes? This will clean up and manage projects so that purchase orders or time and entry labor time will be accessible only for active projects. Thank you for your help.

    ------------------------------
    Gail Norvell
    Finance Director
    Elephant Butte Irrigation District
    Las Cruces NM
    ------------------------------


  • 2.  RE: Project Controller Module

    TOP CONTRIBUTOR
    Posted Aug 07, 2019 12:08 PM
    Hi Gail,

    I do a mass update in SQL for things like this.

    I dump what data I need into a spreadsheet, in this case need project ID and a certain status.

    I then write part of a SQL statement in the row....update pjproj set status_pa = 'i' where project = '

    In the next field on the row, I do a Concatenate formula to do the complete SQL statement....

    I then copy those 2 fields to all the rows....

    Then copy the complete SQL statement into SQL and execute....

    I hope this makes sense....I hope the example screenshot below is clear enough...lol

    Thanks,
    Michael




    ------------------------------
    Michael O'Neill
    Director of Finance
    Eastex Telephone Cooperative
    Henderson TX
    ------------------------------