If you have a need to extract data from Aimbase, the easiest way to do so is via the various grids found throughout your Aimbase install.

-  The Export function allows you to pull data out of Aimbase formatted as either an Excel spreadsheet or a CSV file. When exporting, only the data in the visible columns and whatever you’ve filtered down to will be exported. Be sure you’ve configured the data exactly as you want it before exporting.  

If the number of records you’re exporting at one time exceeds 10,000, clicking ‘export’ will result in a screen asking you for your email address. Larger data exports such as these require more time to process (typically the data is available within 5-10 minutes, depending on the number of records you’re exporting). When these larger files have completed processing, you’ll receive an email with a link to download the file. You can also find the export within Aimbase by going to Administrations > Data Exports > Exports. 

Below is a list of grids within Aimbase where the most commonly exported data is found. Anywhere below where you see [baseurl] instead your install name. Ex: traversebikes is the base url value in the web address traversebikes.aimbase.com.

Not all installs use data the same way. Refer to the list below and export the data that is relevant to the products within Aimbase you're using. If you have questions about accessing any of this data or whether or not your install utilizes it, please contact your Rollick representative or clientsupport@rollick.io.