Databases
StackOverflow2013
Postsdbo
PORails export xls error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORails export xls error
    primarykey
    data
    text
    <p>Hello everybody who likes RAILS, i have a problem i'm trying to export by "ejecutive_id" to XLS but i'm not doing the correct code, </p> <pre><code> -I created a select box where i can select all my ejecutives. -I created another select box where i can select by status_id. -I selected 1 ejecutive for example "Mogan" (ejecutive_id = 1) -I selected 1 status form example "active" (status_id = 0 ) -After selecting both select boxes i click on "SEARCH" -After doing SEARCH i'm getting my results (@list_policies this value in my code is before respond format) </code></pre> <p>Here is my controller</p> <pre><code> ****PROJECT/APP/CONTROLLER/policy_managment/policy.rb******** class PolicyManagement::PolicyController &lt; ApplicationController def generate_print_ejecutive_comercial @search_ejecutive = params[:search_ejecutive] @search_status = params[:status_id] @list_ejecutives_comision = Ejecutive.find(:all) @list_policies_search = Policy.deleted_is(0) if params[:search_ejecutive].to_i!=0 @list_policies_search = @list_policies_search.ejecutive_id_is(@search_ejecutive) end if !params[:status_id].blank? if params[:status_id].to_i != 3 @list_policies_search = @list_policies_search.state_is(params[:status_id]) end else @list_policies_search = @list_policies_search.state_is(0) end @status_id = params[:status_id] if !@search_dependent_dni.blank? if @list_dependents.blank? @list_dependents = Dependent.id_gt(0) end @list_dependents = @list_dependents.num_document_is(@search_dependent_dni) list_dependencies = [] @list_dependents.each do |dependent| list_dependency_dependents = Dependency.find(:all, :conditions =&gt; { :dependent_id =&gt; dependent.id }) list_dependency_dependents.each do |dependency| list_dependencies &lt;&lt; dependency end end policy_ids = [] list_dependencies.each do |dependency| policy_ids &lt;&lt; dependency.policy_id.to_i end end @list_policies_search = @list_policies_search.deleted_is(0) @list_policies = @list_policies_search.paginate(:page =&gt; params[:page], :per_page =&gt; 10) respond_to do |format| format.html format.xls format.js { render :update do |page| page.replace_html 'table', :partial =&gt; 'table2' end } end end end </code></pre> <p>Here maybe could be the problem,also those are my links where i can export</p> <pre><code> *********HERE IS MY VIEW*********** &lt;% form_remote_tag :url=&gt;{:action=&gt;"generate_print_ejecutive_comercial"},:before=&gt;"load_close('loading_search')",:success=&gt;"load_off('loading_search')" do -%&gt; &lt;label&gt;Ejecutive:&lt;/label&gt; &lt;%= select_tag 'search_ejecutive',"&lt;option value=\"\"&gt;Seleccione&lt;/option&gt;"+options_for_select(@list_ejecutives_comision.collect {|t| [t.name.to_s+" "+t.lastname1.to_s,t.id]})%&gt; &lt;/span&gt; &lt;%= hidden_field_tag :order,@order %&gt; &lt;%= hidden_field_tag :page,1 %&gt; &lt;input name="Buscar" value="SEARCH" type="submit" /&gt;&lt;span id="loading_search"&gt;&lt;/span&gt; &lt;% end %&gt; #HERE WITH THOSE LINKS I'M EXPORTING ONLY MY FIRST 10 VALUES &lt;%= link_to("Export Excel","http://localhost:3000/policy_management/policy/generate_print_ejecutive/generate_print_ejecutive_comercial.xls")%&gt; &lt;%= link_to "Export XLS",:controller=&gt;"policy_management/policy",:action=&gt;"generate_print_ejecutive_comercial",:format=&gt;"xls" %&gt; &lt;%= link_to 'PRINT PDF', :controller=&gt;"policy_management/policy",:action=&gt;"generate_print_ejecutive_comercial", :format=&gt;"pdf" %&gt; </code></pre> <p>I'm exporting my partial view and it depends of this </p> <pre><code> @list_policies = @list_policies_search.paginate(:page =&gt; params[:page], :per_page =&gt; 10) </code></pre> <p>Here is my partial view and i'm using @list_policies</p> <pre><code> ********************PARTIAL VIEW THAT I WANT TO EXPORT********* &lt;table&gt; &lt;% @list_policies.each do |policy| %&gt; &lt;tr&gt; &lt;td&gt;&lt;div class="nobreak"&gt;&lt;%= policy.num_policy%&gt;&lt;/div&gt;&lt;/td&gt; &lt;td&gt;&lt;div class="nobreak"&gt; &lt;% if !policy.ejecutive.blank? %&gt; &lt;%= policy.ejecutive.name %&gt;&lt;%= policy.ejecutive.lastname1 %&gt;&lt;%= policy.ejecutive.lastname2 %&gt; &lt;% end %&gt;&lt;/div&gt; &lt;/td&gt; &lt;td&gt;&lt;div class="nobreak"&gt;&lt;%= policy.str_state%&gt;&lt;/div&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre> <p>When i added this @results and i replaced it in my partial view i'm getting everything but i don't want everything , i only want by ejecutive_id</p> <pre><code>@list_policies = @list_policies_search.paginate(:page =&gt; params[:page], :per_page =&gt; 10) @results = @list_policies_search.find(:all) </code></pre> <p>Can someone help me with this please? i will really appreciate all help</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCharlie Brown
    1. USCharlie Brown
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PORails export xls error
      1. USCharlie Brown
      1. VTFavorite
    1. COPlease take the time to reformat your code sample so it's readable. Doing so will encourage people to try to help answer your question. Hard to read questions discourage people by making them take extra time to make sense of it; We're all volunteers and we're trying to help many people, so the more you help us, the more we can help you.
      singulars
      1. PORails export xls error
      1. USthe Tin Man
    2. CO"i have a problem i'm trying to export XLS but i'm getting all my results" doesn't make sense. Are you *NOT* getting all your results?
      singulars
      1. PORails export xls error
      1. USthe Tin Man
    3. COzorry my bad, i want to export by ejecutive_id ,but i'm not using the correct param that is my problem, instead of searching by ejecutive_id i'm getting all values except using my condition
      singulars
      1. PORails export xls error
      1. USCharlie Brown
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload