Import table from CSV?

[alan_sh]

I'm trying to create a table and import data from a CSV file. I've created my table. I right click and select import... I select my CSV file and then nothing happens. Nothing imports, no further dialog box. I'm using the 64 bit version.

This is the contents of my CSV: - what am I missing?

Group Name,Postcode,Beavers meeting night,Cubs meeting night,Scouts meeting night
First Rochdale,OL16 2DA,Thursdays,Mondays,Mondays
1st Heywood,OL10 2NN,Mon-Tues,Mon-Wed,Tues-Wed
1st Middleton,M24 5DL,Thursday,Thursday,Thursday
1st Milnrow,OL16 3HB,Wednesdays,Thursdays,Mondays
2nd Middleton,M24 1BT,Tues-Thurs,Tues-Thurs,
3rd/4th Heywood,OL10 3DD,Wednesdays,,Thursdays
5th Pennine,OL11 1DS,Fridays,Fridays,
6th Rochdale,OL11 5PQ,Fridays,Fridays,Fridays
7thA Rochdale,OL12 7AG,Wednesdays,Wednesdays,Thursdays
8th Heywood,OL10 4JH,Thursdays,Mondays,Mondays
8th Middleton,M24 1PP,Wednesdays,Wednesdays,
9th Heywood,Ol11 5PP,Tuesdays,Mondays,Wednesdays
10th Rochdale,OL12 7SJ,Thursdays,Mondays,Tuesdays
12th Heywood,OL10 3PD,Wednesdays,Wednesdays,Tuesdays
12thA Rochdale,OL15 0DY,Mondays,Mondays,
17th Middleton,M24 2RE,Thursdays,Thursdays,
17th Rochdale,OL12 9PG,Tues-Wed,Wed-Fri,Thursday
27th Rochdale,OL16 4UJ,Thursday,,
29thA Rochdale,OL15 8NL,Wednesdays,Mondays,Thursdays
37th Rochdale,OL11 3EY,Fridays,Wednesdays,Fridays
40th Rochdale,OL12 9TF,,Thursdays,
41st Rochdale,OL12 8DP,Wednesdays,Tuesdays,Thursdays

[kibble]

alan_sh
I use Pablos Responsive Data Table (in a layout grid) and that works fine, I can set a breakpoint for the layout to change to fit phones.
You can only see the table populated when published or previewed.

[WWBman]

The table import option from the standard menu works for me.
Try specifying just 1 row when you create the table.

[alan_sh]

Weird - it does absolutely nothing. Whether I create a 1x1 table or a 23x5 table - import does nothing once I have selected my file.

Alan

[alan_sh]

OK. I loaded my file into notepad and saved it as a different name. That worked.

Ah - I know what it is. The file, although saved as a CSV, was still open in Excel.

Pablo, can you consider changing the import so it will import a file even if it's locked for editing? [Notepad was able to read it OK] or at least put up an error message with some information as to why it failed?

Alan

[Pablo]

I will investigate if this is possible.

[alan_sh]

Thank you

Alan

[alex4orly]

Looks an interesting object, works fine first time, but:

1) I have columns with $values, how can I make them right justified?
2) Is there a way to remove the heading sorting option, all table data needs to be loading as it is in the CSV file

Iused just Notepad, not Excel which add some extra size to the file

Cheers

[Pablo]

Are you referring to the "Responsive Data Table" extension?
- you can set the alignment in the 'Alignment' property. Each column can have its own alignment.
- The "Responsive Data Table" extension does not have support for sorting headers.

[alex4orly]

No, I am using the Data Viewer Version 1.5
This Responsive Data Viewer says it is a DEMO and says that setting wil not be saved...
Or do I have an old version? If so, how do I update what I have?

Thanks

[alex4orly]

OK, I purchased the extension but can't see how to control each column alignment

[kibble]

alex4orly
In the help (from object properties) under Alignment it explains that you can align each column as you wish.
So in the alignment box in the appearance tab just type what alignment you want (left, right, center) for each column separated by a comma.

[Pablo]

From the documentation:

Alignment
Specifies the alignment of columns. By default all columns have the same alignment, but you can also configure a different alignment for each column. To do this simple add multiple values separated by a comma: left,right,right,left

[alex4orly]

I can't install the new extension.
I removed the DEMO I had, unpacked the zip content and when trying to install it it comes up with an error:
The process cannot access the file because it is being used by another process

I do NOT have it in use on any page in the project, so - what should I do now?
I closed WB and restarted it, but no go

[alex4orly]

Ok, installed it.
Can't figure the alignment, please give an example.
Thanks

[Pablo]

From the documentation:

Alignment
Specifies the alignment of columns. By default all columns have the same alignment, but you can also configure a different alignment for each column. To do this simple add multiple values separated by a comma: left,right,right,left

[alex4orly]

Very good, works just fine.
And, to help the user use Notepad instead of Excel, I called the file .txt instead of .csv and it works fine.

Thanks for your help

[alex4orly]

Well, it is doing something strange...
The data file is not showing the line brakes and the table flows out of the intended place inside the Layout grid.

Please see this URL : http://www.nmaa-rc.org.au/renewal.jpg

[Pablo]

A HTML table cannot be smaller then the sum of all columns.
To make the content fit you will have to reduce the number of columns.

[alex4orly]

Hello again,

The Responsive data object is placed inside a 3 column layout grid, it was set to be 3 columns : 2-8-2
I changed it following your suggestion to be : 1-10-1 , that didn't fix it.
I found out that the problem is this - extra line, once I manually remove it after uploading, it works fine:

Senior,$60.00,$54.00,$110.00,$224.00,$110.00

Pensioner,$60.00,$54.00,$80.00,$194.00,$80.00

Junior,$30.00,$27.00,$20.00,$77.00,$20.00

Non-Flying,,,,$20.00,xxxxxxx

My custom code is irrelevant here, it changes the file name, but the uploaded file content is the problem, not sure why does it do it

Thanks anyway