Helpful Tips on the Export and Import Function in RPM

Subject

The information here provides some helpful tips, and more detail into the Export and Import functions in Rockton Pricing Management (RPM). This includes the options available for Admin and Non-Admin users, and helpful tips for using the function.

More Information

The export and import capabilities within Rockton Pricing Management (RPM) is simple and powerful. These functionalities enable data transfer between companies or servers. You can export data, edit the data in Excel, then import the revised data back into RPM. This is a valuable tool when making multiple modifications to records at once. It also serves as a useful feature for exporting data for reporting purposes.

When exporting, you are prompted with the message: “Will you want to re-import these records?”.  If you select Yes, the export file is generated in a format that allows the file to re-import data into RPM. If you select, “No, just exporting”, the file is used for review or data manipulation outside of RPM and attempting to use it for re-import may result in errors. When in doubt, select Yes.

The Export and Import function can also be used to copy data from one company to another. For more information, please see KB article: How to Copy Data from One Company to Another Company in RPM.

The ability to export or import may differ based on the user’s privileges in RPM. Users with Administrator Privileges in RPM have the ability to export and import from any RPM web page that supports these functions. This includes virtually all RPM pages, except Settings and View Pricing Diagnostics, which do not currently allow exporting or importing.

Here is a listing of each page and what is allowed for an Administrator user:

Favorites menu:

  • Pricing Scenarios – Export and Import allowed

Pricing menu:

  • Price Schedules – Export and Import allowed
  • Price Calculations – Export and Import allowed
  • Pricing Filters – Export and Import allowed
  • Price Books – Export and Import allowed
  • Price Sheets – Export and Import allowed
  • Price Sheet Details – Export and Import allowed
  • Quantity Breaks – Export and Import allowed
  • Rounding Rules – Export and Import allowed

Acumatica/Dynamics GP Data menu:

  • Customers – Export and Import allowed
  • Customer Attribute Values – Export and Import allowed
  • Customer Attributes – Export and Import allowed
  • Items – Export and Import allowed
  • Item Attribute Values – Export and Import allowed
  • Item Currencies – Export and Import allowed
  • Item Unit of Measures – Export and Import allowed
  • Item Attributes – Export and Import allowed
  • Unit of Measure Schedules – Export and Import allowed
  • Unit of Measure – Export and Import allowed
  • Currencies – Export and Import allowed
  • Document Attributes – Export and Import allowed
  • GL Accounts – Export and Import allowed
  • Locations – Export and Import allowed

Tools menu:

  • Pricing Scenarios – Export and Import allowed
  • View Diagnostics – No Export or Import available
  • Settings – No Export or Import available

For a user who does not have Administrator Privileges in RPM, there are limits as to which web pages they can export and import from. RPM limits these users in the type of data they can import. For any page where the data originates from the ERP, a non-Admin user is not able to import.

Here is a listing of each page and what is allowed for a non-Admin user:

Favorites menu:

  • Pricing Scenarios – Export and Import allowed

Pricing menu:

  • Price Schedules – Export and Import allowed
  • Price Calculations – Export and Import allowed
  • Pricing Filters – Export and Import allowed
  • Price Books – Export and Import allowed
  • Price Sheets – Export and Import allowed
  • Price Sheet Details – Export and Import allowed
  • Quantity Breaks – Export and Import allowed
  • Rounding Rules – Export and Import allowed

Acumatica/Dynamics GP Data menu:

  • Customers – Export only
  • Customer Attribute Values – Export only
  • Customer Attributes – Export and Import allowed
  • Items – Export only
  • Item Attribute Values – Export only
  • Item Currencies – Export only
  • Item Unit of Measures – Export only
  • Item Attributes – Export and Import allowed
  • Unit of Measure Schedules – Export only
  • Unit of Measure – Export only
  • Currencies – Export only
  • Document Attributes – Export and Import allowed
  • GL Accounts – Export only
  • Locations – Export only

Tools menu:

  • Pricing Scenarios – Export and Import allowed
  • View Diagnostics – No Export or Import available
  • Settings – No Export or Import available