Import Instructions
3 Pages
Preview
Page 1
To import Prismaflex event, scale or pressure history data into Microsoft Excel (V7.xx): In program version 6.10 and above, the Prismaflex will automatically download treatment data for each treatment. To manually download the data: 1.
Make sure the PCMCIA technical data card is installed in the Prismaflex PCMCIA card reader.
2.
Switch on the Prismaflex.
3.
From the Choose Patient screen, select Last History, Downld Data and follow the prompts. History can also be downloaded from the End Treatment screen.
4.
When the data has successfully downloaded, switch off the Prismaflex and remove the PCMCIA card.
5.
Put the PCMCIA card into the PCMCIA card slot in your desktop PC or laptop, or into a card reader connected to either of these. If you have a CF card inside a PCMCIA holder, remove the label on the PCMCIA holder, remove the CF card and put the CF card into the card reader. Your laptop should automatically display the contents of the CF card. If not, navigate to “Removable disk” icon under “My Computer”.
6.
There will be a folder or folders labelled with the year.
7.
Open the relevant folder. You will see a list of files with an LOX file extension.
8.
Each file has an 8 digit alphanumeric file name. Right click on the relevant LOX file (look under “Date modified” for the right download date) and use WinZip or 7Zip or a similar decompression tool to decompress the chosen file into a folder of same name using the “Extract to [filename]/” feature. This will create a folder with the same name as the file.
9.
Open the folder you just created. There will be another file with the same name. Right click on this file and use the “Extract to here” selection to decompress this file into the same folder.
10.
You will see a list of 13 files with the same file name but different extensions. The files we are interested in are the ones with extensions PLE (Events), PLP (Pressures) and PLS (Scales).
11.
Open an Excel spread sheet. Depending on the version of Excel you have, the importation of data may vary slightly. From the Data or Import Data menu select “From Text” or similar. Navigate to the last folder you created. You will need to select the file type filter in the bottom right hand corner to “all files” and select the file with the PLE extension. Note that we are treating this as a .txt file even though it has a different extension.
12.
Select “Open”
13.
Select “Delimited” as the file type as shown and press “Next”
14.
Deselect “Tab” and select “Semicolon” as shown, then press “Finish”.
15.
Press “OK” at the box shown below.
16.
The data will now be imported into the Excel spreadsheet and can be manipulated as any other Excel data can. Save the file with a file name that includes at least the serial number of the machine.
17.
Repeat steps 11 – 15 for the files with extensions PLP (pressures) and PLS (scales) if required.