gcstruct_uebersetzung.py 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. import sys
  2. from pathlib import Path
  3. sys.path.insert(0, "C:\\Projekte\\Python\\gcstruct")
  4. from gcstruct import GCStruct # noqa:E402
  5. def get_base_and_import_dir(base_dir):
  6. if base_dir is None:
  7. base_dir = Path(".").absolute()
  8. else:
  9. base_dir = Path(base_dir)
  10. import_dir = base_dir
  11. if base_dir.name == "scripts":
  12. if base_dir.parent.parent.name == "Portal":
  13. base_dir = base_dir.parent.parent.parent
  14. import_dir = base_dir.joinpath("Portal/System/IQD/Belege/Kontenrahmen")
  15. else:
  16. base_dir = base_dir.parent.parent
  17. import_dir = base_dir.joinpath("System/OPTIMA/Export")
  18. elif not base_dir.joinpath("GCStruct_Aufbereitung").exists():
  19. base_dir = Path("//192.168.2.21/verwaltung/Kunden/Luchtenberg/1 Umstellung SKR51/")
  20. if not base_dir.exists():
  21. base_dir = Path("//media/fileserver1/verwaltung/Kunden/Luchtenberg/1 Umstellung SKR51/")
  22. import_dir = base_dir
  23. return base_dir, import_dir
  24. def gcstruct_uebersetzung(base_dir=None):
  25. base_dir, import_dir = get_base_and_import_dir(base_dir)
  26. struct = GCStruct(str(base_dir.joinpath("GCStruct_Aufbereitung")))
  27. input_files = [f for f in import_dir.glob("Kontenrahmen_kombiniert*.csv")]
  28. print("Quelldateien:")
  29. for file in input_files:
  30. print("* " + file.name)
  31. struct.skr51_translate(input_files)
  32. print("Kontenrahmen_uebersetzt.csv erstellt.")
  33. # copyfile('c:/Projekte/Python/Gcstruct/Kontenrahmen_kombiniert.csv', base_dir + 'GCStruct_Modell/Export/Kontenrahmen_kombiniert.csv')
  34. struct2 = GCStruct(str(base_dir.joinpath("GCStruct_Modell")))
  35. struct2.skr51_translate2(str(base_dir.joinpath("GCStruct_Aufbereitung/Export/Kontenrahmen_uebersetzt.csv")))
  36. print("SKR51_Uebersetzung.csv erstellt.")
  37. struct2.skr51_vars()
  38. print("SKR51_Struktur.csv erstellt.")
  39. if __name__ == "__main__":
  40. gcstruct_uebersetzung()