search

archimatetool / archi

Archi: ArchiMate Modelling Tool
https://www.archimatetool.com
MIT License
916 stars 267 forks source link

Input of CSV reports " Invalid character" in ID field #883

Closed Neil-Kemp closed 1 year ago

Neil-Kemp commented 1 year ago

Version of Archi

4.10.0 ### Archi Plug-ins Yes ### Operating System windows 11 ### Expected Behaviour [exportelements.csv](https://github.com/archimatetool/archi/files/9998372/exportelements.csv) Round trip export/input should work ### Actual Behaviour I exported a file as CSV. Ran spell checking *only* on the "Name" column and attempted to reimport only "exportelements.csv [exportelements.csv](https://github.com/archimatetool/archi/files/9998389/exportelements.csv) " ### Steps to Reproduce the Behaviour 1. Export and input with no change 2. 3.
Phillipus commented 1 year ago

Hi, I can import the attached CSV file without any errors. I did notice, though, that the fields are not surrounded with quote marks. Perhaps your external editor corrupted a field?

Neil-Kemp commented 1 year ago

Interesting. when I did the export the files did did not contain the quotes before I did any editing

From: Phil Beauvoir @.> Sent: November 14, 2022 3:50 AM To: archimatetool/archi @.> Cc: Neil Kemp @.>; Author @.> Subject: Re: [archimatetool/archi] Input of CSV reports " Invalid character" in ID field (Issue #883)

Hi, I can import the attached CSV file without any errors. I did notice, though, that the fields are not surrounded with quote marks. Perhaps your external editor corrupted a field?

— Reply to this email directly, view it on GitHub https://github.com/archimatetool/archi/issues/883#issuecomment-1313298432 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AH3V2YEGAWQS6NESNMDPFFLWIH4KJANCNFSM6AAAAAAR7H6XV4 . You are receiving this because you authored the thread. https://github.com/notifications/beacon/AH3V2YGG3UBYHIANHT35IE3WIH4KJA5CNFSM6AAAAAAR7H6XV6WGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTSOI5MAA.gif Message ID: @. @.> >

Phillipus commented 1 year ago

Interesting. when I did the export the files did did not contain the quotes before I did any editing

Archi's CSV exporter adds quotes to each field. Perhaps your editor removed them?

Neil-Kemp commented 1 year ago

I redid every just now. The problem is the way I am using Excel for the import

I am sure I can take it from here

Thx

From: Phil Beauvoir @.> Sent: November 14, 2022 8:32 AM To: archimatetool/archi @.> Cc: Neil Kemp @.>; Author @.> Subject: Re: [archimatetool/archi] Input of CSV reports " Invalid character" in ID field (Issue #883)

Interesting. when I did the export the files did did not contain the quotes before I did any editing

Archi's CSV exporter adds quotes to each field. Perhaps your editor removed them?

— Reply to this email directly, view it on GitHub https://github.com/archimatetool/archi/issues/883#issuecomment-1313718484 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AH3V2YBP2AHEWAVX3L4DNQ3WII5N5ANCNFSM6AAAAAAR7H6XV4 . You are receiving this because you authored the thread. https://github.com/notifications/beacon/AH3V2YHEH6BKZUNL7WYBNEDWII5N5A5CNFSM6AAAAAAR7H6XV6WGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTSOJXANI.gif Message ID: @. @.> >