For example, putting in 'open geo_03a' will then open one of the campaign maps, seeing how you just did this when you were in a multiplayer game, people will still be able to join your game even if your in a campaign map. Now go back in game, in the console write the following: open 'the name of the file/map' and then hit enter, you should then be brought to that map. These are the list of maps that were in the campaign and also multiplayer, the next step is to choose one.
It is indeed still possible, first you'll need to host a server (use gameranger unless you have and know how to use a server box) then your gonna wanna open up the console once you are in your game (you have to be the host of the server in order to use the console) then your gonna wanna go in your program files and locate the folder called 'maps' here is it's default directory: Star Wars Republic Commando > GameData > Maps.