#1562 online manual - CSV import documentation

[JAMES SAULNIER]

As a new user I ran into some difficulties getting CSV importing to work. There are some details missing about the importers interpretation of CSV file . I created CSV file from Excel and it didn't quote any fields and a column with string data.

The following could be inserted right after the first image.

Quick instructions
1. Data needs to be the right most column. Click the top cell of the data.
2. One or more "key" columns to left of data column.
3. Check Dimension checkbox for key columns to include. Column data turns blue.
4. Uncheck Dimension checkbox key data to exclude. Column data turns red.
5. Select Type for included key columns. Select one of three types:
String - string data must be in quotes, e.g "1", "2"
Value - value data is not quoted, e.g. 1, 2
Time data - [ i'm not sure I didn't need to import this type yet]
6. Click OK button.
7. Data is imported into the parameter.
8. You may now need to set units for the imported data field, which is located at Edit -> Dimensions.

Detailed Instructions
... existing instructions ...

[High Performance Coder]

Good idea!

On Fri, Feb 24, 2023 at 04:00:41PM -0000, JAMES SAULNIER wrote:

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

[tickets:#1562] online manual - CSV import documentation

Status: open
Milestone: StuartMill
Created: Fri Feb 24, 2023 04:00 PM UTC by JAMES SAULNIER
Last Updated: Fri Feb 24, 2023 04:00 PM UTC
Owner: nobody

As a new user I ran into some difficulties getting CSV importing to work. There
are some details missing about the importers interpretation of CSV file . I
created CSV file from Excel and it didn't quote any fields and a column with
string data.

The following could be inserted right after the first image.

Quick instructions
1. Data needs to be the right most column. Click the top cell of the data.
2. One or more "key" columns to left of data column.
3. Check Dimension checkbox for key columns to include. Column data turns blue.
4. Uncheck Dimension checkbox key data to exclude. Column data turns red.
5. Select Type for included key columns. Select one of three types:
String - string data must be in quotes, e.g "1", "2"
Value - value data is not quoted, e.g. 1, 2
Time data - [ i'm not sure I didn't need to import this type yet]
6. Click OK button.
7. Data is imported into the parameter.
8. You may now need to set units for the imported data field, which is located
at Edit -> Dimensions.

Detailed Instructions
... existing instructions ...

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Sent from sourceforge.net because you indicated interest in https://
sourceforge.net/p/minsky/tickets/1562/

To unsubscribe from further messages, please visit https://sourceforge.net/auth
/subscriptions/

--

---

Dr Russell Standish Phone 0425 253119 (mobile)
Principal, High Performance Coders hpcoder@hpcoders.com.au
http://www.hpcoders.com.au

---

[TomScat]

The separators sometimes make it hard to have this window working.

I mean: after "load" I see the data presented in a tabular form, so I thought that the top lines would be ok, else it wouldn't show this result. But that isn't the case, it throws errors back because the separators are different.

(For some annoying reason creating a csv file in excel uses ; instead of comma's as the name of csv implied.)

[High Performance Coder]

Thanks Tom. What you observe is captured by https://sourceforge.net/p/minsky/ravel/322/.

This used to work correctly in the TCL/Tk version, but got missed in the Javascript port.