can I populate data in my form from Excel or CSV file?

 
2
1
0

Hi Everyone

I would like to know about importing data from an excel sheet/csv file in community edition. For instance, if I selects User from a drop down menu, User's corespoding detail will populate in the text fields from excel file.

Please let me know if it is doable

Thank you

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      i did not realise there are ready feature for ur use case in community nor enterprise edition.

      In enterprise version, there is a Import Tool and Import Menu allowed u to upload a csv/excel file and import data based on the form and it form store binder.

      for ur use case, u want to load additional detail based on a field's value change. this is doable by using a enterprise AJAX Subform. then, by using Bean Shell Form Binder in the ajax subform, u are able to read data from a file or any other source to populate the form.

      i can't think of anyway to do it in community edition. 

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi,

        For the enterprise edition you can use the Import Tool and Import Menu. As these are not available in the community edition you can develop your own plugins to add this functionality Extending Functionality - Developing Plugins

        1. abdul Fattah

          How about i am using beanshell to grab the csv file and run as import tool ? any help?


        CommentAdd your comment...