Monthly Archives: June 2013

Dong Shin 06.06.2013

  • continue working on FA/RA
    • working off the list from today’s meeting
    • changing table names and column names to match application fields
      • budget_centers
        • funding_transaction_name -> req_description (fundingTransName, fundingTransactionName)
        • funding_transaction_number -> req_id (fundingTransNumber
        • funding_transaction_type -> req_type (fundingTransType
      • funding_transaction_names -> req_descriptions (FundingTransactionName
      • funding_transaction_numbers – > req_ids (FundingTrasactionNumber
      • funding_trasaction_types -> req_types (FundingTransactionType
  • Viz Tool meeting – copy from Phil’s blog
    • Not quite ready for the demo
    • Req Amt -> “Amount”
    • MIPR Desc -> Funding Description
    • Fix “#” tab title
    • Remove Sub-budget Center name and number from project and move to Req Line
    • Test search/auto claim (add sub-budget ctr) add debug statements so we can see what’s going on in production environment
    • Add columns for sub budget center and executing budget ctr
    • Project management screen in doubling Total Budget need to clean up tables…
    • Search functions (still!) need to be query driven
    • When searching for sub-budget centers, the default should be to cull based on the budget center prefix. There should be an additional search box which overrides the default search (* lists everything)
    • Use alert SQL to produce charts (There needs to be date information, so this may mean that we have to edit the source for text panels)
    • Fix Lenny’s email problem (may be the DB misbehaving. Bounced MySQL)
      • Date field tries to save empty string.
      • Look MySqlIf for clean up after a sql error.
    • Funding status should default to current month
    • Column names
      • Budget Center
      • Budget Center Name
      • Sub-Budget Center
      • Sub-Budget Center Name
      • Executing Budget Center
      • EBC Name
      • Appropriation Year
      • Requisition ID
      • PO Reference
      • ACR
      • Vendor Name
      • Address Line 1
      • City
      • Postal Code
      • Comitted Date
      • Comitted Amount
      • Obligation Date Obligated Amount
      • Expensed Date
      • Expensed Amount
      • Vendor ID
      • Vendor Abbr.
      • PO Start Date PO End Date
      • Contract Type
      • PO Type Code
      • Contract No.
  • Took FA offline until null date error is resolved
  • Demo is now scheduled for June 14

Phil 6.6.13

7:30 – 12:30 SR

  • PIT Crew meeting
    • Not quite ready for the demo
    • Req Amt -> “Amount”
    • MIPR Desc -> Funding Description
    • Fix “#” tab title
    • Remove Sub-budget Center name and number from project and move to Req Line
    • Test search/auto claim (add sub-budget ctr) add debug statements so we can see what’s going on in production environment
    • Add columns for sub budget center and executing budget ctr
    • Project management screen in doubling
    • Search functions (still!) need to be query driven
    • When searching for sub-budget centers, the default should be to cull based on the budget center prefix. There should be an additional search box which overrides the default search (* lists everything)
    • Use alert SQL to produce charts (There needs to be date information, so this may mean that we have to edit the source for text panels)
    • Fix Lenny’s email problem (may be the DB misbehaving. Bounced MySQL)
      • Date field tries to save empty string.
      • Look MySqlIf for clean up after a sql error.
    • Funding status should default to current month
    • Column names
      • Budget Center
      • Budget Center Name
      • Sub-Budget Center
      • Sub-Budget Center Name
      • Executing Budget Center
      • EBC Name
      • Appropriation Year
      • Requisition ID
      • PO Reference
      • ACR
      • Vendor Name
      • Address Line 1
      • City
      • Postal Code
      • Comitted Date
      • Comitted Amount
      • Obligation Date Obligated Amount
      • Expensed Date
      • Expensed Amount
      • Vendor ID
      • Vendor Abbr.
      • PO Start Date PO End Date
      • Contract Type
      • PO Type Code
      • Contract No.
  • Took FA offline until null date error is resolved
  • Demo is now scheduled for June 14
  • Interview for Dong’s paperwork.

FP 12:30 – 4:00

Phil 5.5.13

8:00 – 11:30 SR

  • Backups. Also cleaned out a bunch of Gigabytes since the server’s drive was getting full.
  • More resume stuff.
  • Some email back-and-forth with Shawn

11:30 – 4:00 FP

  • That is, unless I have to pick up part of my vehicle diaspora…
  • I’m going to add the ability to create and store a named sound within BasicAudio. Sounds really don’t need to be created outside of the instance.
  • Lunch meeting with Shawn about R&D. Good meeting with good chili to boot.
  • Got the createSound method working and cleaned up the Console app some more
int _tmain(int argc, _TCHAR* argv[])
{
	BasicAudio *ba = new BasicAudio();
	ba->init();
 
	wprintf( L"\nReady to play mono WAV PCM file(s)...\n" );
 
	WavSampleSound *singleSound = (WavSampleSound *)ba->createSound(L"music", L"Wavs\\MusicMono.wav", 0);
	WavSampleSound *continuousSound = (WavSampleSound *)ba->createSound(L"heli", L"Wavs\\heli.wav", XAUDIO2_LOOP_INFINITE);
 
	int keyIn;
	printf("Type 'x' to quit\nC start continuous\nc stop continuous\nS start single\n");
	bool doit = true;
 
	int channelIndex = -1;
	while(doit){
		if(kbhit()){
			keyIn = getch();
			channelIndex = -1;
 
			printf("key = %c\n", keyIn);
			switch(keyIn){
			case 'x' : doit = false; 
 
				break;
			case 'C' : continuousSound->start();                  // play sound
				break;
			case 'c' : continuousSound->stop();                  // cease sound
				break;
			case 'S' : singleSound->start();						// play sound
				break;
			case 'w' : 
				continuousSound->setEmitterZ(continuousSound->getEmitterZ() + (FLOAT32)0.5);
				break;
			case 's' : 
				continuousSound->setEmitterZ(continuousSound->getEmitterZ() - (FLOAT32)0.5);
				break;
			case 'a' : 
				continuousSound->setEmitterX(continuousSound->getEmitterX() - (FLOAT32)0.5);
				break;
			case 'd' : 
				continuousSound->setEmitterX(continuousSound->getEmitterX() + (FLOAT32)0.5);
				break;
			case 'p':
				ba->printMatrixCoefficients();
				break;
			case '0' : channelIndex = 0; break;
			case '1' : channelIndex = 1; break;
			case '2' : channelIndex = 2; break;
			case '3' : channelIndex = 3; break;
			case '4' : channelIndex = 4; break;
			case '5' : channelIndex = 5; break;
			case '6' : channelIndex = 6; break;
			case '7' : channelIndex = 7; break;
 
			}
			if(channelIndex == -1){
				IXAudio2SourceVoice* voice = continuousSound->getSourceVoice();
				ba->play3DVoice(continuousSound->getEmitter(), voice);
			}else{
				printf("channel = %d\n", channelIndex);
				IXAudio2SourceVoice* voice = continuousSound->getSourceVoice();
				ba->playOnChannelVoice(voice, channelIndex);
			}
		}
 
		ba->run(); // perform periodic sound engine tasks
		Sleep(100);
	}
 
	wprintf( L"\nFinished playing\n" );
 
	// All XAudio2 interfaces are released when the engine is destroyed, but being tidy
 
	ba->destroy();
 
	// printf("hit return to exit");
	// getchar();
	
	return 0;
}

Dong Shin 06.05.2013

  • continue working on FA/RA
    • added check for Comments retrieval in Project Editor
    • fixed Sub Projects’ budgets not adding up correctly
    • put unclaimed and claimed datagrids in VDividedBox
    • fixed SQL error getting comments status
    • fixed Infinity number showing up in Financial Data
    • working on filtering funding status…

Dong Shin 06.04.2013

  • deployed new FA/RA – few bugs
    • COGNOS contracts not grouping correctly
    • SQL errors retrieving comments (project id = null?)
  • discussion about COGNOS ingest
  • continue working on FA/RA
    • fixed COGNOS contracts data not grouping correclty
    • added Search/Filter to Unclaimed Contracts
    • moved all the icons in source file to stylesheet (AccordionDefaults.css)
    • working on query to update requisition data on data ingest – done
      • UPDATE budget_center_contracts bcc1
        LEFT JOIN
        (SELECT bcc.uid AS tuid, c.uid as cuid
        FROM projects p, budget_centers c, budget_center_contracts bcc
        WHERE p.uid = c.project_id
        AND p.center_name = bcc.budget_center
        AND c.funding_transaction_number = bcc.requisition_id) t
        ON bcc1.uid = t.tuid
        SET bcc1.budget_center_id = cuid

Phil 6.4.13

8:00 – 11:30 SR

  • Backups and disk cleaning
  • Conversation with Lenny about how to handle COGNOS uploads
    • non MIPR/EAO are all manually claimed
    • (MIPRs and EAOs) get automatically mapped, and don’t have to go through the claiming process (budget center and Req ID match the budget line item)
    • All unclaimed should always be shown.
    • If a MIPR line item is incorrectly claimed, it can be unclaimed, at which point it will have to be manually claimed

11:30 – 4:30 FP

  • Making nice clean classes for audio
  • Emitter goes into the SampledSound base class – done. Almost easy, though I had to go and relearn how C++ constructors work. Gawd, it’s been a while…
  • Everything else goes into BasicAudio – done. Had some problems with frequency until I realized that I hadn’t zeroed out the listener velocity.
  • And actually, I need to be able to set velocity for doppler effects. Need to add methods like the position methods tomorrow.

Phil 6.3.13

8:00 – 11:00 SR

  • Backups
  • Got the paperwork to start on getting client sites hooked up to the main system
  • Bugs
    • Lenny did the following and got some kind of NULL sql error. It may have happened to Carla as well
      • Created a project
      • Added service PM on the project tab
      • saved
      • Deleted the PM from the project (first tab)
      • Added a Req on the second tab
      • Added the same (now deleted) service PM to the Req.
      • Clicked ‘update’, which threw the SQL error
      • clicked close
      • Checked the record, and everything appeared to be saved properly
      • Other req updates using the same sequence did not cause the error
    • The goal is thenter one EA line item and then link multiple req’s out of unclaimed to it. Is this possible?
    • Unclaimed needs to roll up and subtotal all lines (just with matching req’s? Not sure what to do about blanks, unless there is a way to find other matching sequences)
    • There are a heck of a lot of “UPDATE budget_center_contracts SET budget_center_id= NULL where uid = xx”. It’s probably a good 70% of the logs.

11:00 – 4:30 FP

  • Well, after two days of not being able to work on this due to Comps prep and trouble with a significant fraction of my vehicles, maybe I can get some 3D audio working today.
  • Added everything from How to: Integrate X3DAudio with XAudio2, and definitely got a result – when the emitter position moved off of center, the sound cut out. Now you might think that’s a bad thing, but my guess is that I have some variable that either being set with zero or junk, which is messing up the sound matrix calculations.
  • Using the XAudio2Sound3D project as a source of code to mine, I pulled over the (much more extensive) emitter setup and now have things working, although not as clearly as I’d like. Next is to clean up and package the code into the SampleSound-derived classes.
  • And by the way, this might be a good hard hat to try the rig on: http://www.amazon.com/ERB-19224-Americana-Full-Ratchet/dp/B001LYB7JW
  • Cleared a lot of nonessential (i.e. listening cone)code out of the emitter
  • Realized that I could probably use voice->SetOutputMatrix() to set the channels directly. I added a method that cleans out the dspSettings.matrixCoefficients and then sets a single value in the matrix. Whadaya know – it worked :-)
  • Need to do some packaging of the code, but I now have enough to do tests for the situational awareness system and to get rid of the MIDI boards for the vibrotactile controller.

Dong Shin 06.03.2013

  • continue working on RA/FA
    • Went through req’s, bugs and stuffs page.. Crossed out the ones that are taken care of
    • View Data in Project Editor disabled for the projects that has no Requistions
    • fixed Service PM not saving correctly in Requisitions
    • cleaned up too many UPDATE budget_center_contracts….
    • added icons to Project Mgmt panel