By kanted on

Hi,
We generate a excel sheet from our offline accounting package which has the following columns user ID and his balance amount. Now I need this to be displayed in respective user profile or in a node after the user logs in say you current out standing is

Eg:

UserID Amount
1 10000
2 5000
.
.
.
400 300

Now In drupal when user ID 1 logs in it should show his account balance preferable would be in block
Thanks in advance

⋅ Categories: Drupal 7.x

Comments

samwich’s picture

samwich commented

I implemented something similar to this in Drupal 6 using CCK, Content Profile and Views. But you would basically set up a new profile field for each user that is called 'Amount', then you can populate that field for each user, and set up a View to display on a page or node to display the user and the amount.

kanted’s picture

kanted commented

Thanks, After creation of the field. Would it be possible to populate the field via import.

samwich’s picture

samwich commented

I haven't tried it myself, but you might be able to use http://drupal.org/project/feeds to import data into your fields.