By superwormy on

I'm looking for a Drupal module that will display user profile information as a big spreadsheet of information of sorts.

All I want is a page that looks like this:

User List
----------
Username | First Name | Last Name | My Custom Profile Field 1 | My Custom Profile Field 2
-----------------------------------------------------------------------------------------------------------------
user1 | Keith | Palmer | Yes | 42
user2 | Shannon | Daniels | No | 18

etc. etc. etc.

The ability to export this to .XLS or .CSV would be a great addition. Does something like this exist? I thought I could do it with the Views module, but it appears not (or at least I can't find any information on how to do it and the obvious results in repeated data problems...).

I'd even be willing to pay a small sum of money to someone who can develop something like this... or tell me how.

⋅ Categories: Drupal 5.x

Comments

mkalbere’s picture

mkalbere commented

You can do this with http://drupal.org/project/views
And this should allow you to export in csv http://drupal.org/project/views_bonus

superwormy’s picture

superwormy commented

Did you actually read my question? I *tried* to do it with Views, but I've been unable to. Your post is useless unless you can tell me how to do this.

The problems I've had with doing it with Views are:
- In the drop-down box of 'Fields', there isn't any option for the user's username, date created, or e-mail address
- When I create a view with 3 of the custom profile fields, I get pages and pages of repeated data, one record per page, instead of an actual list of users

dnewkerk’s picture

dnewkerk commented

Views can do this, but only with Drupal 6 (Views version 2 was fully rewritten as of Drupal 6, and can interface with not only nodes, but also users/profiles, comments, taxonomy, and if you write a plugin actually "any" database table you want).

So the answer is... upgrade to Drupal 6. Or you can alternately switch to a "node profile" solution such as Bio module or Node Profile module. You can search the modules section for "profile" and find any modules that mention any connection with profiles, and see if anything comes up that meets your need. Other than those options, you can pay a developer to write custom mysql queries for you to pull data out of the Profile tables (it is a bit tricky due to Profile module's unideal method of storage, which will be gone in D7, but is still an issue in previous versions).

That said, please don't be rude. Many people will be glad to help you out here, but not if you snap at anyone. The other poster simply didn't notice your post tagged as Drupal 5, but his information is otherwise correct.
Best of luck.