Import from .csv
Theresa de Valence - February 4, 2009 - 20:50
| Project: | Table Manager |
| Version: | 6.x-1.x-dev |
| Component: | Documentation |
| Category: | task |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Description
Hello, I'm a new user of drupal and understand very *little* about HTML ;). I have an excel file with 2000 rows of data, approx 12 columns from which I have created pivot tables on 6 or so sheets. These sheets are what I propose to use tablemanager to display.
Can you point me somewhere (anywhere) with a link to show how I could accomplish this?
Thanks.
#1
Try this; http://drupal.org/project/tablemanager
Heh ;o) What I mean is - Tablemanager 6.x comes with a csv import function, just enable it on your modules screen, then import your file.
Pobster
#2
It turns out that only the super-user could see any of the Tablemanager functions and now, no matter what I do, I cannot get Administer/Tablemanager to show up for any user except the super-user. So now I'm logged in as super-user, which I'd rather not. Any way to change this?
On another issue, HOW do I make one column invisible?
http://www.reviewsbytdev.com/tables/7
Column 4 was created so that the table could be sorted into the order it was input, i.e. there is NO sorting on the table at all, I just need to show the data in blocked ways.
Now, I don't want the user to see column 4. This information was not presented in your documentation and I haven't a clue how to look it up on the ww3.schools site.
Also, I don't want users to be able to sort the data at all. Right now, I can't sort the data, but I'm also hanging Tablemanager.
http://www.reviewsbytdev.com/tables/9
Could it be that I MUST provide a column to sort on?
Thanks
#3
Pobster, is it expected that the csv import routinely doesn't work? A sample csv file (created from Excel export) is attached. Have we corrupted our Tablemanager database?
After the csv file is attached and submit is clicked, the whole screen goes white.
The tables exist in View Tables, and look correct, but it is no longer possible to access tablemanager here:
http://www.reviewsbytdev.com/admin/content/tablemanager/
We have tried this many times:
http://www.reviewsbytdev.com/admin/content/tablemanager/table_delete/tab...
The tables which cause Tablemanager to hang (give a white screen) can be seen in View Tables, but are not available in Add Content/Tables.
Sorry to call this critical, but I have a lot of people waiting for my published results :(
Thanks
#4
Ah and right there is (probably) your problem. It's another example of where Windows does things differently, it uses carriage returns instead of newlines (which are what splits the lines in csv files). You'll need to resave your csv as proper Unix output which I believe you can do through the output settings in Excel. Else... Just use Open Office, it's free and it works properly...
If you want... Host your csv file on your website, mail me a link to it and I'll check it out for you. This sounds exactly like what's going on though as PHP is thinking all your rows are one long row/ header therefore running out of memory.
Pobster
#5
Oops didn't notice your attachment as I'm writing this on my iPhone whilst coming home from work (on the train!) I'll take a look when I get home and give you my verdict.
Pobster
#6
What I also didn't tell you is that we are in version 6.x
#7
http://drupal.org/node/369986#comment-1244520
#8