zdavatz/cpp2sqlite

Import new Rose `kunden_alle_dynamics_ce.csv` file

zdavatz opened this issue · 0 comments

  1. Update the zurrose binary.
  2. There is a new file we need to import: kunden_alle_dynamics_ce.csv
  3. The old one can then be ignored: Kunden_alle_NEU.csv
  4. Columns A, B, C can be ignored.
  5. Column D is the Knr Rose.
  6. Column E is the GLN.
  7. Column D can have double entries with the same Knr Rose but different preferences in columns F and G.
  8. The preferences in Kunden_alle_NEU.csv file used as column headers C, D, E, F are now separate lines with the same Knr Rose. The mapping in the new file is now vertical, not horizontal anymore. You can directly use the preference names in column F in the new file kunden_alle_dynamics_ce.csv the value is then in column G in the new file.
  9. The Ort is now the value after the , in column H.
  10. Important: The format of the JSON output files should not change.