Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By halftone on
I have a need to construct a list of ~300 (editable) names, a 1 field table. Can't get simpler than that.
I imported a .csv file which went fine and created a table. This was a perfectly clean, vanille list already in alphabetic order, eg
Client names,
Automobile Assn.,
AA Magazine,
Arthritis Care,
Actinic Software,
Animal Health Trust,
Airways Housing Assn.,
Anglia University,
...
The import appeared to succeed. However the sort order viewed via Tablemanager is now bizarre.
The table starts at 'V', reverts to 'A' partway through, and ends with 'Z' Here's a segment that shows the confusion. Changing from ascending to descending makes no difference either - entries stay in exactly the same order!
...
Bella Magazine
Breast Cancer Care
BBC Music Magazine
BBC Enterprises
Barnet Arts Office
Robert Barlow Communications
AutoExpress
The Audit Commission
Attic Futura
ATL
ASRA
Artworkers
ARHAG Housing Assn.
Argyll PR
Michael Reed Design
Anderson Walker
Anglobangla
Anglia University
Airways Housing Assn.
Animal Health Trust
Actinic Software
Arthritis Care
AA Magazine
Automobile Assn.
VNU
Volvo Magazine
Volvo Car UK Ltd
Willesden & Brent Chron.
Wellington College
Which? Magazine
Which Bike?
...I can't make any sense of what's going on here, but it ain't expected behaviour. I have deleted and recreated the table and checked the CSV - but it's just straight ASCI with nothing weird about it. Version of Tablemanager is the current version for Drupal 4.6 in the Modules section, * Table Manager Module by Pobster - 2nd December 2005
Very likely I am doing something wrong, but what? All suggestions welcome. Oh, I had a look at the Tablemanager_data in PHPMyAdmin and all entries are along the lines of a:2:{i:0;s:17:"Vision Publishing";i:1;s:1:" - I don't know if that's correct or not.
Regards
Tony
Comments
Don't use 4.6 it shouldn't
Don't use 4.6 it shouldn't be there - I tried to remove it and for whatever reason you can't force it to stop being downloadable...
I don't support the 4.6 version any more as it works VERY differently to the 4.7 version and COMPLETELY differently to the 5.0 version which is currently in development.
Try the backport module with the 4.7 version perhaps? Don't know whether that'll work or not, let me know if it does.
Thanks
Pobster
Thanks, but no go
I tried it (with Backport) and it does not work. The SQL setup is, I think, aimed at MySQL 5? - the auto_integer parameter - so I guess the module would need additional code to compensate for usage on MySQL4.n. As it stands all that is produced is a blank page at www.mysite.com/tablemanager.
Regards
Tony Sleep http://tonysleep.co.uk
Sorry dude, I did once start
Sorry dude, I did once start doing a backport of tablemanager 4.7 and it was more or less finished... But... Then I had no need for Drupal 4.6 anymore and so... Everything in the folder got overwritten... It's not hard though, if you did want to backport it yourself - it's just time consuming. I'm afraid I'm too caught up in trying to get a 5.0 version up and running at the moment and I'm not having much luck with getting to look and work how I want it to :o( It may take me a while yet...
Pobster