How to find ASC contact information in Customer Support Portal

If you require ASC change on the number of assets in your account you need to open Admin case for Customer Service Team to process the request. If you require to update ASC on all serial numbers in your account - be sure to attach the CSV report from your account containing all serial numbers for ASC change.

How to export CSV file with serial numbers to the tool and ensure each serial number contains leading zero(s):

Google Sheet:

1. Go CSP>Assets>Account Actions>Download CSV
2. Open the report in Google Sheets > File>Download>  CSV
3. Open a new Google Sheet > Import > Browse the file you just downloaded in Step 2.
4. In the pop up window make sure to de-select  " Convert text to numbers , dates and formulas"
5. The new sheet will contain customer's inventory of serial numbers preserving the required leading zeros

MS Excel:

• Open a blank Excel workbook: Do NOT double-click the CSV file to open it directly.

• Go to the "Data" tab in the Excel ribbon.

• In the "Get & Transform Data" group (or "Get External Data" in older versions of Excel), click "From Text/CSV".

  • Note for older Excel versions: If you don't see "From Text/CSV," you might need to enable "Legacy Wizards." Go to File > Options > Data and check "From Text (Legacy)" under "Show legacy data import wizards." Then, on the Data tab, you'll find it under Get Data > Legacy Wizards > From Text (Legacy).

• Browse and select your CSV file, then click "Import."

• The Text Import Wizard will appear.

• • Step 1 of 3: Choose File Origin and Delimited.

    • Original data type: Select "Delimited" (as CSV files are typically delimited by commas).
    • File origin: Usually, you can leave this as the default, but if you're experiencing strange characters, you might need to adjust it (e.g., to Unicode UTF-8 if your CSV contains special characters).
    • Click "Next."

  • Step 2 of 3: Choose Delimiters.

    • Delimiters: Check "Comma." Uncheck any other boxes that might be pre-selected (like "Tab" or "Space"), unless your CSV uses multiple delimiters.
    • You'll see a preview of how your data will be separated into columns.
    • Click "Next."

  • Step 3 of 3: Select Column Data Format.

    • This is the crucial step for preserving leading zeros.
    • In the "Data preview" section, click on the column(s) that contain your serial numbers (or any other data where you want to preserve leading zeros).
    • Under "Column data format," select "Text".
    • Repeat this for all columns where you need to preserve leading zeros.
    • Click "Finish."

• Import Data dialog box:

  • Excel will ask where you want to put the data. Choose "Existing Worksheet" and select the cell where you want the data to start (e.g., A1), or choose "New Worksheet" to import it into a fresh sheet.