@echo off
REM Add Labels to the WitpStaff CSV files

REM edit the following 3 Set commands:

REM First enter the full directory path to the source csv files. Close with a \
Set sourcedir=C:\Matrix Games\War in the Pacific Admiral's Edition\tools\witpStaff\db\

REM Second enter the full directory path where the edited csv files are to be stored. Close with a \  
REM Make sure the new directory already exists!!
Set destdir=C:\Matrix Games\War in the Pacific Admiral's Edition\tools\witpStaff\db\

REM Finally enter a text that ist added to the start of the filenames of the new csv files.
REM Can be left empty if the destination is a different directory than the source dir
Set Suffix=Enh_


REM stop editing here
REM ----------------------------------------------------------------------------

Set SrcFile=acclassbombvaluescsv.csv
Set Lbl=acclassID,Lbl,NBL
echo acclassID,Lbl,NBL > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=acclassescsv.csv
Set Lbl=acclassID,productionID,acclassName,actype,enginetype,enginenumber,upgradeClass,upgradeMonth,upgradeYear,availMonth,availYear,realAvailMonth,realAvailYear,turnsTillAvail,estAccumResearch,lastAccumTurn,maxSpeed,cruiseSpeed,climbRate,maxAlt,endurance,normRange,extRange,maxRange,maxLoad,maneuver,durability,armor,natID,buildPlaces
echo acclassID,productionID,acclassName,actype,enginetype,enginenumber,upgradeClass,upgradeMonth,upgradeYear,availMonth,availYear,realAvailMonth,realAvailYear,turnsTillAvail,estAccumResearch,lastAccumTurn,maxSpeed,cruiseSpeed,climbRate,maxAlt,endurance,normRange,extRange,maxRange,maxLoad,maneuver,durability,armor,natID,buildPlaces > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=acclasseswithrangecsv.csv
Set Lbl=acclassID,productionID,acclassName,actype,enginetype,enginenumber,upgradeClass,upgradeMonth,upgradeYear,availMonth,availYear,realAvailMonth,realAvailYear,turnsTillAvail,estAccumResearch,lastAccumTurn,maxSpeed,cruiseSpeed,climbRate,maxAlt,endurance,normRange,extRange,maxRange,maxLoad,maneuver,durability,armor,natID,buildPlaces,CLASSRANGE
echo acclassID,productionID,acclassName,actype,enginetype,enginenumber,upgradeClass,upgradeMonth,upgradeYear,availMonth,availYear,realAvailMonth,realAvailYear,turnsTillAvail,estAccumResearch,lastAccumTurn,maxSpeed,cruiseSpeed,climbRate,maxAlt,endurance,normRange,extRange,maxRange,maxLoad,maneuver,durability,armor,natID,buildPlaces,CLASSRANGE > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=acclassgunvaluescsv.csv
Set Lbl=acclassID,OPGV,DPGV
echo acclassID,OPGV,DPGV > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=acclassnatscsv.csv
Set Lbl=acclassID,natID
echo acclassID,natID > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=acclassnatshelpcsv.csv
Set Lbl=acclassID,natID
echo acclassID,natID > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=acdevicescsv.csv
Set Lbl=acdevicescsv.csv,devicetype,devicename,range,effect,penetration,accuracy
echo acdevicescsv.csv,devicetype,devicename,range,effect,penetration,accuracy > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=acs2armamentcsv.csv
Set Lbl=acclassID,deviceID,number,facing
echo acclassID,deviceID,number,facing > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=actypescsv.csv
Set Lbl=actypeID,actypeName,actypeAbbr,usedRange,canSearch,isFighter,isBomber
echo actypeID,actypeName,actypeAbbr,usedRange,canSearch,isFighter,isBomber > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=acweaponfacingscsv.csv
Set Lbl=facingID,facingName
echo facingID,facingName > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=agmissionscsv.csv
Set Lbl=missionID,missionName,searchDivisor,isSupply
echo missionID,missionName,searchDivisor,isSupply > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=airgroupscsv.csv
Set Lbl=airgroupID,airgroupName,acclassID,commanderID,hqID,baselocID,shiplocID,nationality,acUsable,primaryMission,secondaryMission,missionLevel,capLevel,lrcapLevel,navsearchLevel,aswLevel,range,searchStartAngle,searchEndAngle,aswStartAngle,aswEndAngle,missionTargetLocID,turnsTillAvail,fragmentToParent,fragmentNumber,wasUpdated
echo airgroupID,airgroupName,acclassID,commanderID,hqID,baselocID,shiplocID,nationality,acUsable,primaryMission,secondaryMission,missionLevel,capLevel,lrcapLevel,navsearchLevel,aswLevel,range,searchStartAngle,searchEndAngle,aswStartAngle,aswEndAngle,missionTargetLocID,turnsTillAvail,fragmentToParent,fragmentNumber,wasUpdated > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=base2clustercsv.csv
Set Lbl=clusterID,baseID
echo clusterID,baseID > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=basestatuscsv.csv
Set Lbl=baseID,posx,posy,hqID,airfieldMax,airfieldCurrent,airfieldExpansion,portMax,portCurrent,portExpansion,fortCurrent,fortExpansion,storedFuel,storedSupply,storedOil,storedResources,basename,factoryCount,basetype,natID,originalnatID,appearingFuel,appearingSupply,appearingOil,appearingResources,storedRepair,requestedSupply,garrisonRequired
echo baseID,posx,posy,hqID,airfieldMax,airfieldCurrent,airfieldExpansion,portMax,portCurrent,portExpansion,fortCurrent,fortExpansion,storedFuel,storedSupply,storedOil,storedResources,basename,factoryCount,basetype,natID,originalnatID,appearingFuel,appearingSupply,appearingOil,appearingResources,storedRepair,requestedSupply,garrisonRequired > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=clusterscsv.csv
Set Lbl=clusterID,clusterName
echo clusterID,clusterName > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=commandtypescsv.csv
Set Lbl=commandID,commandName
echo commandID,commandName > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=dumpviewavaillcuscsv.csv
Set Lbl=lcuID,NAME,loctypeName,ApproxPlace,DistFromBase,estAV,isRestricted,hqRestricted,turnsTillAvail,PREPTARGET,MOVETARGET,leaderName,natName,tfID,ApproxShipTarget,BelongsToHQ,posx,posy
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=enginestoragelogcsv.csv
Set Lbl=turn,enginetype,stored
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=enginestoragelogcsv.csv
Set Lbl=turn,enginetype,stored
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=factory2basecsv.csv
Set Lbl=baseID,factoryindex,factorytype,size,repair,doRepair,doProduce
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=factorytypescsv.csv
Set Lbl=factorytype,factorytypetype,factorytypename,side
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=globalstoragelogcsv.csv
Set Lbl=turn,manpower,hi,armament,vehicle,naval,merchant,loadedRes,loadedSup,loadedOil,loadedFuel,freeRes,freeSup,freeOil,freeFuel,japPoints,alliesPoints
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=lcudevicescsv.csv
Set Lbl=deviceID,devicetype,devicename,loadcost,range,effect,penetration,accuracy,ceiling,anti-armor,anti-soft,isStatic
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=lcumovesbasescsv.csv
Set Lbl=lcuID,name,suffixID,posx,posy,estAV,baseID,basename,mover
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=lcuprepsbasescsv.csv
Set Lbl=lcuID,name,suffixID,posx,posy,estAV,baseID,basename,shipx,shipy
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=lcustatuscsv.csv
Set Lbl=lcuID,posx,posy,prepLoc,prepPerc,exp,moral,fatigue,commanderID,hqID,targetID,targetx,targety,storedSupply,requestedSupply,name,suffixID,lcutypeID,natID,turnsTillAvail,fragmentToParent,fragmentNumber,hqType,isRestricted,isStatic,supportGivingSquads,supportRequiringSquads,supportNeutralSquads,disabledSquads,loadcostAP,loadcostAK,estAV,estAA,withdrawDays,opmode
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=leaderstatuscsv.csv
Set Lbl=leaderID,leaderName,availDelay,skill,inspiration,administration,aggresiveness,landOp,surfaceOp,airOp,natID,rankID,commandID,ppValue,
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=leadobjectscsv.csv
Set Lbl=id,name,posx,posy,leaderID,unittype,turnsTillAvail
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=locationtypescsv.csv
Set Lbl=loctypeID,loctypeName
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=nationalitiescsv.csv
Set Lbl=natID,natName
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=neartocsv.csv
Set Lbl=posx,posy,baseID,distance
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=occurencec2tcsv.csv
Set Lbl=ocClassID,ocTypeID
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=occurenceclassescsv.csv
Set Lbl=ocClassID,name,priority,symbol,direction,color
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=occurencetypescsv.csv
Set Lbl=ocTypeID,name
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=rankscsv.csv
Set Lbl=rankID,rankName
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=repairshipsinhexcsv.csv
Set Lbl=ASShips,ADShips,ARShips,posx,posy
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=resusagecsv.csv
Set Lbl=resfrom,resto,amountThousands,needsPort,researchPossible
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=resusagenoresearchcsv.csv
Set Lbl=resfrom,resto,amountThousands,needsPort,turnsTillAvail
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=shipbuildqueuecsv.csv
Set Lbl=shipID,harborLocID,durability,buildspeed,turnsTillAvail
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=shipclassescsv.csv
Set Lbl=shipclassID,shiptype,shipclassName,speed,durability,manuever,endurance,fuel,armorsum,lowAA,highAA,aaCeiling,torptubes,torploads,aswNumber,aswRating,mainweapon,mainweapNum,mainweapShots,fightingValue,specials,upgradeClass,upgradeMonth,upgradeYear,availMonth,availYear,natID,troopCap,bulkCap,liquidCap,tonnage,conversionGroup,attribute
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=shipdevicescsv.csv
Set Lbl=deviceID,devicetype,devicename,range,effect,penetration,accuracy,ceiling
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=shippositionscsv.csv
Set Lbl=shipID,posx,posy,targetx,targety
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=shipposlogcsv.csv
Set Lbl=shipID,turn,posx,posy,movetox,movetoy
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=shipscsv.csv
Set Lbl=shipID,shipclass,shipName,natID,state,commanderID
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=shipstatuscsv.csv
Set Lbl=shipID,harborLocID,tfID,loadedRes,loadedSup,loadedOil,loadedFuel,loadedUnitID,expDay,expNight,sysDamage,floatDamage,fireDamage,isLoading
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=shiptypescsv.csv
Set Lbl=shiptypeID,shiptypeName,navalProduct,carryTroopInFastTFOnly,carryTroopInCargo,isTransport
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=spoilagecsv.csv
Set Lbl=combinedSize,fuelLimit,supplyLimit
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=suffixescsv.csv
Set Lbl=id,suffix
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=targetbasescsv.csv
Set Lbl=lcuID,baseID,basename
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=tfmissionscsv.csv
Set Lbl=missionID,missionName,isTransport
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=tfstatuscsv.csv
Set Lbl=tfID,posx,posy,commanderID,homeHarborID,targetID,targetx,targety,missionID,natID
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=turn2datecsv.csv
Set Lbl=date,turn,storedate,gameday,gamemonth,gameyear
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

Set SrcFile=wdconfigcsv.csv
Set Lbl=gameversion,scenario,natnumber,isPBEM,lastFileRead,pw,dbVersion
echo %Lbl% > "%destdir%%Suffix%%SrcFile%"
type "%sourcedir%%SrcFile%" >> "%destdir%%Suffix%%SrcFile%"

echo Done
pause