Zu Content springen
Deutsch
  • Es gibt keine Vorschläge, da das Suchfeld leer ist.

How To update customers-list in Dev-Polarion

This article describes the process to update the list of customers in the development Polarion instance with data exported from proAlpha.

I. Email to Karim to get new export (maybe even formatted, if not, do these:)
II. Prepare CSV for Import 
1. Convert to ANSI to avoid having to pick 65001: Unicode (UTF-8) in superlong drop down in Excel 

2. Replace first comma (after numbers) with semi-colon to use that as separator as some customer names have commas
   ^(\d+), => $1;
(Check if there are customers with " in name that shouldn't be removed as it's part of branding; right now we have "Volta" Kraftfahrzeug-Elektrozubehör-Vertrieb where removal is okay) 

3. Import data into Excel 

4. Sort by customer ID 

5. Remove dummy/test entries:
   23 asdf
   999990    Testkunde
   999992    Fantasiekunde
   999999    Mustermann GmbH & Co.KG

6. Export as CSV (this is ANSI and includes quotes around customer names with comma)
   a. remove the quotes for Volta   

7. Replace single " with double "" (so they're escaped after we did step 8)

8. Add " at beginning and end of each name (";" => ";"" and "$"=>""$" (plus first and last line))

9. Remove leading "023202,Volocopter GmbH"

III. Update "D:\alm-repo\customers.csv" in bctalm repo

IV. Start "Customer import (update enum from csv)".

V. Manually in Monitor: <https://polarion.bct-technology.com/polarion/#/monitor>
run script "Customer import (update enum from csv)"
Polarion Admin -> Scheduler has the configuration:
  <!-- This updates the customer enum based on the customer.csv. Do this after updating customer.csv. -->
  <job cronExpression="0 15 2 * * ?" disabled="true" id="script.job" name="Customer import (update enum from csv)" scope="system">