Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

TermIt - Excel import #449

Closed
lindatothova opened this issue Mar 4, 2024 · 0 comments
Closed

TermIt - Excel import #449

lindatothova opened this issue Mar 4, 2024 · 0 comments
Labels
enhancement New feature or request IPR Initiated/requested by IPR

Comments

@lindatothova
Copy link
Collaborator

Popis

Jako editor TermItu
potřebuji mít možnost importovat slovník ve formátu Excel.
Doplní to stávající import ve formátu Turtle, který není běžnými uživateli moc využívaný.

  • Excel import by měl být inverzní operací k již implementovanému Excel exportu.
  • Bude možné importovat více jazykových mutací v rámci jednoho importu. Každá jazyková mutace bude na samostatném listu Excel s příslušným označením jazykové mutace Czech/ English/ příp.další. Pokud bude Excel soubor obsahovat pouze jeden list a označení jazykové mutace bude chybět, potom předpokládáme, že se jedná o jazyk Czech.
  • Bude možné importovat atributy, které nyní obsahuje Excel export, s výjimkou atributu Identifikátor a Podřazené pojmy, které se odvozují. Atribut Název pojmu je povinný a musí být unikátní v rámci slovníku. Importované atributy musí být definovány na pozici prvního řádku listu Excel. Názvy importovaných atributů musí odpovídat názvům atributů použitým v Excel exportu, tzn. liší se pro Czech a zbývající mutace. Výčet importovaných atributů nemusí být úplný, jako je v Excel exportu, a na pořadí atributů nezáleží.
  • Zadání atributů Nadřazené pojmy a Související pojmy by mělo být omezeno jen na vyplnění názvu pojmu, tj. nebude vyžadován celý identifikátor pojmu.
  • Pro usnadnění přípravy importu a minimalizaci chybovosti, především v názvech atributů, by měla být v dialogovém okně importu k dispozici šablona ke stažení, tj. vzorový Excel soubor s předvyplněnými názvy atributů pro mutace Czech/ English. Součástí šablony by měly být číselníky pro atributy, u kterých jsou potřeba.

Užitečnost

  1. zmíněný scénář bez navrhované funkce realizovat nelze
@lindatothova lindatothova added enhancement New feature or request IPR Initiated/requested by IPR labels Mar 4, 2024
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jun 18, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Add Excel template file for importing vocab…
1858350 
…ularies.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jun 18, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Allow downloading Excel import template file.
3e2b47f
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jun 18, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Add updated Excel template with value lists…
aba8fe0 
… for term types and states.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jun 18, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Make Excel import template file configurable.
c402ab1 
Mainly to allow aligning value lists in the Excel with value taxonomy languages (term types, states) used by TermIt instance.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jun 19, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Refactor SKOSImporter - provide a common Vo…
d36d00e 
…cabularyImporter interface.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jun 19, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Resolve vocabulary importer based on provid…
6020675 
…ed media type.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jun 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Implement import of basic attributes from E…
df2800d 
…xcel.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jun 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Support importing multilingual Excel withou…
839b850 
…t term references.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jun 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Fix properties file encoding issues.
3ae9137
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Add Excel template file for importing vocab…
84c8d0a 
…ularies.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Allow downloading Excel import template file.
30e68db
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Add updated Excel template with value lists…
e141111 
… for term types and states.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Make Excel import template file configurable.
789ae83 
Mainly to allow aligning value lists in the Excel with value taxonomy languages (term types, states) used by TermIt instance.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Refactor SKOSImporter - provide a common Vo…
dc3bace 
…cabularyImporter interface.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Resolve vocabulary importer based on provid…
bf234d7 
…ed media type.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Implement import of basic attributes from E…
7a369ca 
…xcel.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Support importing multilingual Excel withou…
733bbe4 
…t term references.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Fix properties file encoding issues.
905a370
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
Merge remote-tracking branch 'origin/kbss-cvut/termit-ui#449-excel-im…
0765368 
…port' into kbss-cvut/termit-ui#449-excel-import
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Handle term hierarchies in Excel import.
c986a6c
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Handle term relationships within a vocabula…
4edcde2 
…ry by inserting raw data into the repository.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Fix Excel importing issues after testing wi…
4be6c03 
…th frontend.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 25, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Handle null cells in imported Excel.
7f186d6 
Null cells occur when there are no more columns after them.
ledsoft added a commit that referenced this issue Jul 25, 2024
@ledsoft
[Enhancement #449] Simplify vocabulary import components.
9c6a67b 
Allow downloading Excel template file for vocabulary import.
ledsoft added a commit that referenced this issue Jul 25, 2024
@ledsoft
[Enhancement #449] Use the same import infrastructure for importing S…
f0733dd 
…KOS and MS Excel into existing vocabulary.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Handle languages other than Czech and Engli…
fe32cbe 
…sh when importing Excel sheet.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Support sheets with identifier column and u…
44ceee6 
…sing prefixed identifiers as well as full ones.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Jul 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Use semicolon when splitting multiple value…
e82ff37 
…s in imported Excel cell.

Semicolon is used in export as well.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 12, 2024
@ledsoft
Merge pull request #286 from kbss-cvut/kbss-cvut/termit-ui#449-excel-…
c95ab19 
…import

TermIt UI#449 excel import
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 13, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Fix NPX in ExcelImport.
35e4134
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 17, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Set imported term state to configured initi…
7d0ecbd 
…al if Excel does not specify it.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 17, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Modify Excel template download so that it (…
ac67590 
…hopefully) works also in a Docker container.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 19, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Throw exception when sheet contains duplica…
f116f30 
…te term labels.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 26, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Throw exception when sheet contains duplica…
7816a52 
…te term identifiers.
ledsoft added a commit that referenced this issue Aug 26, 2024
@ledsoft
[Enhancement #449] Split new vocabulary import into separate tabs for…
8630055 
… SKOS and Excel.
ledsoft added a commit that referenced this issue Aug 26, 2024
@ledsoft
[Enhancement #449] Adjust import vocabulary page style to better sepa…
b7d3faa 
…rate tabs.
ledsoft added a commit that referenced this issue Aug 26, 2024
@ledsoft
[Enhancement #449] Add error messages for Excel import errors involvi…
26d4dee 
…ng duplicate data.
This was referenced Aug 26, 2024
Merged
Merged
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 26, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Set imported term state to configured initi…
2bb75b5 
…al if Excel does not specify it.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 26, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Modify Excel template download so that it (…
7d7509e 
…hopefully) works also in a Docker container.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 26, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Throw exception when sheet contains duplica…
8b1a07d 
…te term labels.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 26, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Throw exception when sheet contains duplica…
01c8be4 
…te term identifiers.
ledsoft added a commit that referenced this issue Aug 26, 2024
@ledsoft
[Enhancement #449] Split new vocabulary import into separate tabs for…
4dc121d 
… SKOS and Excel.
ledsoft added a commit that referenced this issue Aug 26, 2024
@ledsoft
[Enhancement #449] Adjust import vocabulary page style to better sepa…
56148f6 
…rate tabs.
ledsoft added a commit that referenced this issue Aug 26, 2024
@ledsoft
[Enhancement #449] Add error messages for Excel import errors involvi…
7aa48fe 
…ng duplicate data.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Use first state and type encountered for a …
a4e54d6 
…term.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Resolve imported term identifier before per…
e69a1a5 
…sisting it so that existing one can be removed.

If the template is used, it does not contain identifier column, so the id would be generated on persist. On repeated import, this leads to errors because the existing term is not removed before the new one is persisted.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Prevent import of term with existing label …
801d64f 
…and different identifier.

Existing identifier would be deleted and re-inserted again, but a different identifier would lead to two terms with the same label (and different identifiers).
@ledsoft ledsoft mentioned this issue Aug 29, 2024
Merged
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Add some explanatory javadoc.
2c2acba
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Use first state and type encountered for a …
9087621 
…term.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Resolve imported term identifier before per…
e65e256 
…sisting it so that existing one can be removed.

If the template is used, it does not contain identifier column, so the id would be generated on persist. On repeated import, this leads to errors because the existing term is not removed before the new one is persisted.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Prevent import of term with existing label …
dd376ba 
…and different identifier.

Existing identifier would be deleted and re-inserted again, but a different identifier would lead to two terms with the same label (and different identifiers).
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 29, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Add some explanatory javadoc.
2722583
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 30, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Add missing type and state selection lists …
9316518 
…to the Excel template English sheet.
ledsoft added a commit to kbss-cvut/termit that referenced this issue Aug 30, 2024
@ledsoft
[kbss-cvut/termit-ui#449] Support multiple types per term in Excel im…
c1bf874 
…port.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request IPR Initiated/requested by IPR
Projects
TermIt
Status: Deployed to development
Milestone
No milestone
Development

No branches or pull requests
1 participant
@lindatothova