Archi Forum

Archi => General Archi Discussion => Topic started by: chdessus on February 14, 2019, 09:11:05 AM

Title: CSV import
Post by: chdessus on February 14, 2019, 09:11:05 AM
Hello

I get some troubles with importing data with é è ô à.
The export with the UTF-8 option is okay. The import goes well but ARCHI replaces the expected characters by a ?
How can I solve it ? I try to check the Preferences menu and the Import description in the Archi user manual but I found nothing on that issue.

Thanks in advance.  ;)
Christine
Title: Re: CSV import
Post by: Phil Beauvoir on February 14, 2019, 09:17:28 AM
Hi, the imported file needs to be UTF-8 encoded. That attached file is not UTF-8.

Phil
Title: Re: CSV import
Post by: chdessus on February 14, 2019, 10:40:09 AM
Got it.. extension is now .txt and the file is correctly imported
8)  ;D
Title: Re: CSV import
Post by: Phil Beauvoir on February 14, 2019, 10:41:41 AM
> I try to check the Preferences menu and the Import description in the Archi user manual but I found nothing on that issue.

I've added a note to the help file to say that UTF-8 is needed on import. Will be in the next release.
Title: Re: CSV import
Post by: chdessus on February 14, 2019, 11:24:20 AM
Great ! and thanks.
Title: Re: CSV import
Post by: nemethy on November 05, 2023, 14:47:54 PM
Hi, I developed some utility scripts, and an example script for importing data from an excel .xlsx file, using Apache POI Java.
It consists of 4 helper subscripts and a main example script.
What is the best way to share it with the community?
Title: Re: CSV import
Post by: Jean-Baptiste Sarrodie on November 05, 2023, 18:40:18 PM
Hi,

Quote from: nemethy on November 05, 2023, 14:47:54 PMWhat is the best way to share it with the community?

Usually, people share scripts through GitHub Gist (https://gist.github.com/), make sure your description contains '#jArchi'. See this page for a bit more information: https://github.com/archimatetool/archi-scripting-plugin/wiki/Community-shared-scripts

Regards,

JB