Multi-Shop Export Tool in BCP Report Center

Selecting Shops

You have several methods to select the shops for your export:

Method 1: Dropdown Selection

• Select the Shops dropdown field.

• Select individual shops from the list.

• Selected shops automatically move to the top for easy visibility.

• Use Select all or Deselect all buttons for quick selection.

Method 2: Search Function

• Use the search box within the dropdown to find shops by:

  • Shop ID (e.g., "7881")

  • Shop Name (e.g., "AVators Automotive CSA Training Shop")

• Search results update dynamically as you type.

Method 3: Paste Shop IDs

• Select the "Paste ShopIds" button on the right side of the Shops field.

• Enter a list of Shop IDs (e.g., "7881, 10194").

• Select Apply to select those shops.

Note: You can only select shops that your account has been granted access to.

Setting the Date Range

1. Select the date range field.

2. Select your desired start and end dates.

   • Maximum range: 366 days (one year).

Configuring Report Parameters

Each report has specific parameters you can adjust. Technician, Service Advisor, Inspection Type, and RO fields display all data by default and cannot be filtered in multi-shop exports.

Email Delivery Settings

1. Destination Email: Your account email is pre-populated.

   • You can change this to send the report to a different email address as needed.

2. Include Summary Statistics (optional):

   • Check this box to receive summary statistics in the email body.

   • Leave unchecked to receive only the data file attachment.

Export Constraints

Review the expandable "Export Constraints" section to see the constraints per export:

• Maximum shops per export: 50

• Maximum date range: 366 days

• Maximum rows per export: 200,000

• Maximum attachment size: 25 MB

• Truncation: Exports exceeding row/size limits will be truncated

• Processing time: Up to 1 hour for large exports (typically much faster)

• Concurrent exports: One export at a time per user

Executing the Export

1. Review all selections.

2. Select the Export button at the bottom of the window.

3. You can close the window and continue working in BCP while the report populates.

4. The completed report will be emailed to your specified address.

Understanding Your Export Results

When your export is complete, you'll receive an email containing:

• Email Body: Summary statistics (if selected) showing aggregate metrics.

• Attachment: CSV file with report data from all selected shops.

Frequently Asked Questions

Which shops can I include in my multi-shop export?

• You can only export data for shops that your BCP account has been granted access to. This is determined by your account permissions, not the multi-shop export feature itself.

How long does it take to receive my export?

• Most exports complete within a few minutes. However, large exports (many shops, extended date ranges, or high data volume) can take up to 1 hour. You'll receive an email as soon as the export is ready.

What format is the exported file?

• Exports are delivered as Excel-compatible files that can be opened in Microsoft Excel, Google Sheets, or other spreadsheet applications.

Why can't I select specific technicians or service advisors in multi-shop export?

• Multi-shop exports automatically include all technicians, service advisors, inspection types, and ROs by default to ensure comprehensive data across multiple locations. Individual filtering for these parameters is available when viewing single-shop reports.

Troubleshooting

Export Not Received:

1. Check spam/junk folders: The email may have been filtered by your email provider.

2. Wait for processing: Large exports can take up to 1 hour; be patient.

3. Contact support: If the issue persists after 2 hours, contact AutoVitals Support.