Bulk Actions on SIMs

• Primary method: Under the SIMs menu:
  1. Select Manage SIMs.
  2. Choose the required filters to generate the set of devices you want to modify.
  3. Use the Actions menu to Export all as CSV.
• Secondary method: Under the Reports menu:
  1. Select Build > Account Devices Detail report.
  2. Choose the filters for the set of devices you want to modify.
  3. Click Generate Report > Download.
  Note: This method of retrieving SIM information omits SIMs that are not assigned to a Pool.

Below is an example of a .CSV named SIMsExported.CSV, which contains an exported list of SIMs:

Let's call the upload file for bulk operations UPDATEATTRIBUTES-template.CSV.

If you open SIMsExported.CSV into a spreadsheet such as Microsoft Excel, you see single quotes around each identifier (e.g. '89011702278871667857').

If you search and replace to remove all the single quotes, Excel treats each identifier as a very large number and converts it to scientific notation, which eliminates the specificity of the number (e.g. 8.90117E+19).

To avoid this, you can manually format each cell as a label by beginning each cell with a single quote and removing the trailing single quote (e.g.'89011702278871667857).

However, this process is cumbersome and often impossible for larger actions.

To more effectively format the identifiers from the SIMsExported.CSV file:

Method 1 - Google Sheets

1. In Google Sheets, start with a blank sheet. Then import the SIMsExported.CSV file. To do so, select File > Import > Upload >Browse, select a locate file, and click Open.
2. In the Import file box, enable Convert text to numbers, dates, and formulas and set the following configuration:
   • Import location: Replace current sheet
   • Separator type: Detect automatically

   In the column of SIM identifiers, the number is followed by a single quote (e.g.89011702278469573160'). However, if you put your cursor on the cell, you will see that the SIM identifier starts and ends with a single quote (e.g.'89011702278469573160').

3. Click Import data.
4. Perform a search and replace to remove the single quotes:
   1. Select Edit > Find and replace > Find > Replace, and do not check any boxes.
   2. Click Done to remove the trailing single quote. Now if you put your cursor on the cell, you will see that the SIM identifier starts but does not end with a single quote (e.g. '89011702278469573160).
5. Click Insert > Sheet to add another sheet into the Google spreadsheet in a new tab.
6. Repeat Step 2 to import the Bulk Actions template that you want to populate, such as UPDATEATTRIBUTES-template.CSV.
7. Return to the first tab with the list of SIM identifiers and copy the full range of identifiers to the clipboard.
8. Return to the second tab with the Bulk Actions template, locate the column to contain the SIM identifiers, such as accessProfileID, and paste the SIM identifiers.
9. Make any remaining changes to the template for the bulk operation.
10. Select File > Download > Comma Separated Values (.csv) to save the sheet as a .CSV file . Google saves the current tab as a .CSV file and downloads it to your computer's normal download location.

Method 2 - OpenOffice and LibreOffice

1. Open the .CSV file in OpenOffice/LibreOffice.
2. In the Fields section at the bottom, select the fields to import.
3. In the Fields section, change Column Type from Standard to Text.
4. In the Separator options section, change Text delimiter (OpenOffice) or String delimiter (LibreOffice) from double quotes to single quotes. This ensures the data imports as text instead of floats.
5. Click OK to import the data.

Example CSV Upload File

Here is an example of a .CSV file to update the attributes on two SIMs:

My_UPDATEATTRIBUTES_file.csv

operation,deviceProfileId,accessProfile1Technology,accessProfile1ID,accessProfile1IDType,accessProfile2Technology,accessProfile2ID,accessProfile2IDType,accessProfile3Technology,accessProfile3ID,accessProfile3IDType,deviceName,currentLocation,reportGroup,applicationType,agentId,customAttributeName1,customAttributeValue1,customAttributeName2,customAttributeValue2,customAttributeName3,customAttributeValue3,customAttributeName4,customAttributeValue4,customAttributeName5,customAttributeValue5
UPDATEATTRIBUTES,,LTE,89011702278469573160,ICCID,,,,,,,MyDevice1,CALIFORNIA,,,,,First_attribute,,Second_attribute,,,,,,
UPDATEATTRIBUTES,,LTE,89185000190416000167,ICCID,,,,,,,MyDevice2,CALIFORNIA,,,,,First_attribute,,Second_attribute,,,,,,

Method 3 - Microsoft Excel with a Formula

1. Open SIMsExported.CSVin Excel and delete all the columns that you do not need (e.g., Only keep the ICCID or EID column as column A).
2. Save the updated file as a separate .CSV, such as MySIMs.CSV.
3. Open MySIMs.CSV in Excel and insert a formula in column B to remove the trailing single quote. For example, if the SIM identifier in cell A2 is '89011702278469573160', enter this formula in cell B2:

   =RIGHT(LEFT(A2,LEN(A2)-1),LEN(A2)-2)

   This adds the following value in cell B2: 89011702278469573160.

4. Copy the formula for all rows of SIM identifiers down column B.
5. Save your changes, using a different file name, such as MySIMsClean.CSV. Keep the file open in Excel.
6. Open the Bulk Actions template that you want to populate, such as UPDATEATTRIBUTES-template.CSV.
7. Locate the column to contain the SIM identifiers, such as accessProfile1ID.
8. Format this column as Number format, without any decimal places. To update the column format:
   1. Select the blank column, including the column heading.
   2. Right-click the column and select Format Cells > Number.
   3. Set the decimal places to 0.
9. Return to your spreadsheet of SIM identifiers (MySIMsClean.CSV) and copy the full range of identifiers to the clipboard.
10. Return to the Bulk Actions template (UPDATEATTRIBUTES-template.CSV), right-click row 2, and select Paste Options >Values.
11. Save your changes.
12. Make any remaining changes to this template before running the bulk operation and save the template as a .CSV file.
    Note: The next time you open the file in Excel, the SIM identifiers return to scientific notation.