We do now support CSV import to PAM. It’s in the latest version here: https://hq.nitrosell.com/support/RMSSO/
When you select a spreadsheet, you need to map between its columns and PAM fields. Note that it does not support RMS field updates and the spreadsheet must have a SKU column, with values corresponding to the ItemLookupCode values in RMS.
Please also note that it does not create items – that should always be done through RMS; it only updates existing ones.
For export, you can use RMS Store Ops Administrator. This query will return all item rows joined with PAM data:
select * from item inner join nitroasl_pamtable on itemid = item.id
File > Export will enable you to export it to CSV, which can be opened in Excel.
Should you need any assistance, please open a support ticket.