Tables - CSV Data import

[Acorn]

Dear Xara...

Really!?

No guidance whatsoever.
Is this to cover up the mess the CSV Import is presenting?

I tried with this and Table 02 and the following clean CSV data from MS Excel:

Ser, Date, Tuition Fees, Lodgings, Bursary, Transfer, Repay, Available
1, Wed 29 Aug 2018, , , , " £1,000.00 ", , "£1,000.00"
2, Mon 03 Sep 2018, , , , " £1,000.00 ", , "£2, 000.00"
3, Mon 01 Oct 2018, , , , " £1,737.05 ", , "£3,737.05"
4, Wed 17 Oct 2018, "-£1,156.25 ", -£580.77 , , , , "£2,000.03"
5, Fri 26 Oct 2018, , , £300.00 , , , "£2,300.03"
6, Thu 01 Nov 2018, , , , " £1, 737.05 ", , "£4,037.08"
7, Wed 14 Nov 2018, "-£1,156.25 ", -£580.80 , , , , "£2,300.03"
8, Fri 30 Nov 2018, , , £300.00 , , , "£2,600.03"
9, Sat 01 Dec 2018, , , , " £1,737.05 ", , "£4,337.08"

To get even this far was a miracle!

Can we please have some guidance.

Acorn

[Egg Bramhill]

Yes, a lot of guidance here would help!

[Acorn]

Dear Xara...

It works better with Tab Separated Data!
I think even here blank cells have to be quoted.
How can you make such a fundamental error? CSV vs. TSV.

I am not going to check further until you advise what is going on.

Acorn

[Acorn]

Dear Xara...
It works better with Tab Separated Data!
I think even here blank cells have to be quoted.
How can you make such a fundamental error? CSV vs. TSV.
I am not going to check further until you advise what is going on.
Acorn

No notiification but the Release Notes > "Table Improvements", http://releasenotes.xara.hosting/designer-pro-x16/, now suggest it is Tab Separated Variables (TSV).

@Xara, So you have let the developers produce a TSV Import for Tables yet keep CSV for Charts!
I want to render data as both chart and table and now I have to maintain two datasets.

Still guessing how to make it work though.

Acorn

[Egg Bramhill]

Yes, it's currently a proper dogs dinner

[Alan Sh]

So, is there still no way to import a CSV file?

I have a table I want to periodically refresh (once a week) from an Excel spreadsheet. If this can't be done, then we have a non-starter.

Alan