PaperCut supports a number of data import methods ranging from simple text file imports to scripting interfaces and programming APIs. Because data migration from a legacy system is a once-off operation a simple text file import will usually suffice and can quickly be managed using standard tools such as Microsoft Excel. (Or Vi macro’s if you’re a unix guru :-)
- Export the GPAS balances into a format that can be opened in Excel. For example, use
ldapsearch to dump username and balance to a text file then import into Excel.
- Make sure the username is in the first column and the balance in the 2nd column. Leave all other columns blank. You may need to “massage” the data and ensure it’s clean before importing.
- Save as a tab-delimited text file (important that it’s Tab Delim rather than CSV)
- Import the file using
Actions -> Batch User Import...
More information on using PaperCut’s Batch User Import and Update option is covered in the user manual. You can read this online here:
Keywords: GPAS, iPrint, Novell, NDPS, legacy application import, print control system migration