Cordex®CXCHPControllerSoftwareManual|8-Linepowersystems
8.8.1. Export line power channels
Pre-amble:Alinepowerconnectioninthecontrolleristheshelf,slot,andchanneltogetherwhich
indicatesitsphysicalpositioninthesystem.Thetotalconnectionsonacontrollerforalinepowersystem
isbasedonthemaximumshelves(9)×maximumslots(12)×maximumchannels(4),foragrandtotalof
432totalconnectionsifmodulesareinsertedinallshelvesandslots.
Howtoexport:withalinepowersystemcreatedandmodulesassignedtothesystem,ausercangoto
Systems > Line Power System > Inventory > Line Power Channels andselecttheExport Channel
Details buttontoexportaCSVfilewithallthecurrentlyexistinglinepowerconnectionsavailable.The
exportedconnectionsarebasedonthemodulesacquiredforthelinepowersystem.
Thesections:(1)'SortExportedLinePowerChannels'willhelpsortthelinepowerconnectionsin
MicrosoftExcelasthefilerowswillbeoutoforderandsortingwillmakeiteasiertoenterdata.(2)'Enter
dataintoaLinePowerChannelsFile'willhelppopulatetheexportedCSVfileemptycells.
8.8.2. Sort exported line power channels
Afterexport,ausercanopenthefileinaCSVeditingprogramsuchasMicrosoftExcel.InExcel,
forbetterreadability,itisalwaysrecommendedtosortthedatapresentedastheShelf/Slot/Channel
datacolumnswillbeoutoforder.Aftersortingthedata,ausercanstartenteringtherequireddatain
sequentialorderforwhatchannelbelongstowhichload.
To sort channel data in Microsoft Excel:
1. Highlightalltheavailabledata.
2. SelecttheData tab.
3. SelectSort withintheData tab.
4. IntheSortWindow,addthe"Shelf"columnforSort By usingthedropdownlist.Additionally,verify
theSort On valueis"CellValues"andtheOrder valueis"AtoZ".
5. IntheSortWindow,selecttheAdd Level button.
6. IntheSortWindow,forthenewlevel,addthe"Slot"columnforSort By.
7. SelectOk intheSortWindowtoviewthedatainsequentialorder.
8. Aftersorting,followsection'EnterdataintoaLinePowerChannelsFile'fordetailsonwhattoenter
intotheemptyCSVfilecells.
8.8.3. Enter data into a line power channels file
WhenopeningthelinepowerchannelsCSVfile,therearemultiplecolumnswithheadings.Some
columnsarenottobechanged,somearerecommendedtoenter,andsomearerequiredtobefilledin.
FillintheemptyCSVcellsbasedontheinformationbelow.
0350058-J0 Rev AL Page 121