Versions Compared

Old Version 2

changes.mady.by.user Ashrafuzzaman Purno

Saved on

compared with

New Version 3

changes.mady.by.user Ashrafuzzaman Purno

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

We want a tool to handle imports better to ease the mobility of archives between different Asta7 installations and within the same Asta7. The tool should be based on current functionality in Asta5 and adapted to the challenges we have in Asta7.

Info

This tool will be used only for the Single Archive and Excel import from Asta7

Failures and Possible Solutions

...

Failure

Solutions

Challenges

AMID conflict

  • Regenarate

  • Replace all objectReference

PK conflict

  • Regenaret if UUID

  • Input from the user

  • Replace all FK

  • How to handle composite PK?

Unique conflict

  • Regenarate if UUID

  • Input from the user

  • Set null if nullable

FK conflict

  • Set null if nullable

NULL conflict

  • Regenarate if UUID

  • Input from the user

Wrong type

  • Regenarate if UUID

  • Input from the user

  • Set null if nullable

Wrong length

  • Input from the user

  • Remove extra

  • Set null if nullable

FVP Unique conflict

  • Regenarate

  • Input from the user

System Entities

For simplicity and user-friendliness, we should only consider the AKTOR entity As we are only exporting the participant module and tag module for now we can ignore the other system templates for now. We need to consider the AKTOR and TAG entities for this section and ignore AMID/PK conflicts for all participant module sub-entities. For the AKTOR entity and TAG entities, we should add some additional options for handling AMID/PK/Unique/FVP Unique conflicts.

Failure

Solutions

Challenges

AMID/PK/Unique/FVP Unique conflict

  • IgnoreIgnore

  • Replace with the conflicted row

  • If ignored then need to ignore the whole subtree for this row as well

  • If replaced need to replace all objectReference and FK as well

  • Should we consider the possible new sub-entity objects?

  • Should we consider the possible changes for this subtree?

...

  • ?

Implementation