Getting Started/Exports
From PERPWiki
Some sections of pERP show a little disk icon, the Export CSV Control. Clicking this icon will download a complete copy of the data you're looking at, not just what's showing on the screen. For example, you may have only five suppliers showing in the Supplier List, but you will download the entire list of suppliers.
1101;AL-TECH COMMUNICATIONS INC.;103;CAD;2006-08-31;1;;;;0;1;ALT002;
Above is a sample line from the data export.
This file may not be immediately useful in other software such as Excel because it uses semicolons as separators (so it is not really a Comma Separated Values file but a SSV). A CSV file gets really fouled up in countries that use a comma as a decimal separator; the SSV format is more universal.
The semicolon separated file can readily be imported into Excel or other spreadsheet software. Directions for doing this are in your Excel documentation. Basically, it's File > Import and follow the directions. Once you have imported the file, you can use Excel to manipulate (sort, filter etc.) the data.
