InsZoom: Standardizing Table Names

InsZoom: Standardizing Table Names

When you receive an InsZoom backup, the table names may be prefixed with the firm's name like this:

In order to process the files correctly, use the following Powershell script to remove the firm's name from the prefix:


  2. $Search = "C:\TEMP\inszoom backup\"
  3. $Find = "SmithLaw_"
  4. $Replace = ""


  7. # Get all files starting with "prefix_"
  8. $files = Get-ChildItem -Path $Search -File | Where-Object { $_.Name -like "$($Find)*" }

  10. # Loop through each file and rename it
  11. foreach ($file in $files) {
  12.     # Create new filename by removing "prefix_"
  13.     $newName = $file.Name -replace "^$($Find)", "$($Replace)"
  14.     
  15.     # Rename the file
  16.     try {
  17.         Rename-Item -Path $file.FullName -NewName $newName -ErrorAction Stop
  18.         Write-Host "Renamed: $($file.Name) -> $newName"
  19.     }
  20.     catch {
  21.         Write-Host "Error renaming $($file.Name) to $($newName): $_"
  22.     }
  23. }


    • Related Articles

    • InsZoom: Read Me First

      Before working with InsZoom, please review the following articles: Standardizing InsZoom Table Names

    • PCLaw Backups: Generating a Table List

      The following instructions will help you create a table list from PCLaw. Locate the PC Law Data To find out where the PC Law data exists, find a PC Law shortcut, right-click on it, and choose "Open File Location". Repeat this process until you are in ...

    • Tabs3 Backups: Creating a Table List

      When connecting to TABS3, there are a few different database servers that may be used. To determine the correct database system, open the TABS3 System Configuration Utility: Then click Help > About System Config. You will then see something like this ...

    • Extracting single level lookup table data from NetDocuments Admin

      NetDocuments provides the ability to download the lookup table metadata in a CSV format. From NetDocuments Admin interface. To accomplish this, do the following: 1. Select “Profile Attributes” from Navigation pane. 2. Select the Attribute Table, in ...

    • Extracting Parent/child lookup table data from NetDocuments Admin

      NetDocuments provides the ability to download the lookup table metadata in a CSV format. From NetDocuments Admin interface. To accomplish this, do the following: 1. Select “Profile Attributes” from Navigation pane. 2. Select the Child Table, in this ...