private void processSchedulingProjectProperties ( ) throws SQLException { List < Row > rows = getRows ( "select * from " + m_schema + "projprop where proj_id=? and prop_name='scheduling'" , m_projectID ) ; if ( ! rows . isEmpty ( ) ) { Row row = rows . get ( 0 ) ; Record record = Record . getRecord ( row . getString ( "prop_value" ) ) ; if ( record != null ) { String [ ] keyValues = record . getValue ( ) . split ( "\\|" ) ; for ( int i = 0 ; i < keyValues . length - 1 ; ++ i ) { if ( "sched_calendar_on_relationship_lag" . equals ( keyValues [ i ] ) ) { Map < String , Object > customProperties = new HashMap < String , Object > ( ) ; customProperties . put ( "LagCalendar" , keyValues [ i + 1 ] ) ; m_reader . getProject ( ) . getProjectProperties ( ) . setCustomProperties ( customProperties ) ; break ; } } } } }
Process the scheduling project property from PROJPROP . This table only seems to exist in P6 databases not XER files .