Export users in liferay

-

Sometimes it may require to export the users into CSV file to look into the depth of users details.

To make life easier, liferay has given such functionality to us, just by clicking the button. 

Navigate to the controlPanel and click on the users and Organization , there you will see a button "Export users". Click on the button to export the users. It will download a file called "User.csv"



But that csv file contains only 2 columns 

1. FullName
2. Email Id




But we require more fields to export like(screenName, jobTitle etc) so what to do?

Check the following entry in the portal.properties.

#
# Input a list of user attributes that will be included when exporting users
# to a CSV file. You can include custom fields by adding the prefix
# "expando:" to the attribute name.
#
users.export.csv.fields=fullName,emailAddress




Add the required entries by comma separated, If you want to know the what are the fields to be added look into the UserModelImpl.java class of the "TABLE_COLUMNS " field.

So we need additional screenName and jobTitle to export to CSV, so here we are adding to the property.

users.export.csv.fields=fullName,emailAddress,screenName,jobTitle

If you created the custom field/expando for user entity we can also export that entry also as like this "expando:<expando/custom name>"

Comments

  1. AnonymousApril 24, 2015 at 8:09 PM

    Hello!

    I'm trying to get this to work, however I cannot find the portal.properties file. Could you direct me a little to where I could find it?

    Thank You!

    ReplyDelete
  2. VenkaApril 27, 2015 at 12:13 PM

    Portal.properties is found in "portal-impl.jar" in the path of src/portal.properties.

    Don't modify the portal.properties file directly.

    Create the "portal-ext.properties" file in the "tomcat-7.0.42\webapps\ROOT\WEB-INF\classes" path and override the properties required.

    ReplyDelete
  3. UnknownSeptember 1, 2016 at 12:50 PM

    In the downloaded CSV Files, we need to give user credentials as well? how we will come to know which column is been referred for which data? Can i get a clarity on this pls? Also please let me know what has to be added in the portal-exe.properties.

    ReplyDelete
  4. UnknownSeptember 1, 2016 at 12:56 PM

    In the downloaded CSV Files, we need to give user credentials as well? how we will come to know which column is been referred for which data? Can i get a clarity on this pls? Also please let me know what has to be added in the portal-exe.properties.

    ReplyDelete
    Replies
    1. VenkaSeptember 1, 2016 at 4:22 PM

      This one,

      #
      # Input a list of user attributes that will be included when exporting users
      # to a CSV file. You can include custom fields by adding the prefix
      # "expando:" to the attribute name.
      #
      users.export.csv.fields=fullName,emailAddress

      For paasword

      It should be as

      users.export.csv.fields=fullName,emailAddress,password


      Hopes this helps.

      Delete

Post a Comment

Popular posts from this blog

Theme display in javascript

-
We know that we can access the themedisplay in java as ThemeDisplay themeDisplay = (ThemeDisplay) request.getAttribute(WebKeys.THEME_DISPLAY) But how can we access in javascript? Here we go Liferay.ThemeDisplay.getScopeGroupId() Liferay.ThemeDisplay.getCompanyId() Liferay.ThemeDisplay.getPlid() Liferay.ThemeDisplay.getLayoutId() By this we can access the groupId, companyid ... etc
Read more

How to know which liferay version we are using

-
Image
Sometimes we have to know which liferay version we are using, so how can we know? We can know the liferay version in different ways. 1. Liferay has provided some utility methods to know the which liferay version we are using , Here is the utility method ReleaseInfo.getReleaseInfo() It prints this statement " Liferay Portal Community Edition 6.2 CE GA2 (Newton / Build 6201 / March 20, 2014) " as i am using community version it shoes as CE. 2. Also we can also identify by response headers as below screenshot. If your using the chrome, right click on the browser and click inscept element , and navigate to the network  . you will see the URLS , click on the any url. 3. Also we can see during server startup as below statement Liferay Portal Community Edition 6.2 CE GA2 (Newton / Build 6201 / March 20, 2014)
Read more

Viewing the SQL Query in liferay : debugging the SQL Query in Hibernate

-
Sometimes we have to know SQL query hiting in DB to retrieve the list. Suppose When we are writing the DynamicQuery , Some times we have to know SQL query it is generating to hit DB. So generally it is useful when we are debugging the Query it is generated. In hibernate we used the write the property in XML file as hibernate.show.sql to view the query. In Liferay also we can also set the below property to true in the portal-ext.properties to view the SQL query at the console. hibernate.show_sql=true. By adding the above property it will just reterive the parameters. What if we want to display the parameters. Add the below properties in log4j.properties it will display the paramters also. # logs the SQL statements #log4j.logger.org.hibernate.SQL=debug # Logs the JDBC parameters passed to a query #log4j.logger.org.hibernate.type=trace In Liferay log4j is located in the below location tomcat-7.0.42\webapps\ROOT\WEB-INF\classes Also we want to see hibernate ses
Read more