[oro_newbieParticipant]

Hi Yehven,

Thank you so much! It worked when I checked “Export Entity Records” permission under the role. I was thinking “Export Grid views” is the correct permission for this, not sure what it’s used for now.

Regarding the url, it happened that by mistake I emptied the email templates table (oro_email_template) and therefore used the templates from the old version, maybe that’s why the links are different? Do you know where I can find the email templates records? Another thing is, when I open the “oro_email_attachment” table, it’s empty, no export files records.

Thank you again.

[oro_newbieParticipant]

Hi Yevhen,

Sorry for the late reply. This is the URL: http://<web_site_hidden>/export/download/export_2019_01_17_12_31_18_5c4075968ccd4.xlsx

And below is the error message that I get:

Although, this works under Admin role.

Thank you!

[oro_newbieParticipant]

Where are you calling the activitymanager from? As far as I know, call is not the only activity.

Also, check an example where the activity manager has been used in Oro’s vendor directory.

[oro_newbieParticipant]

Are you sure your datagrid configuration is being picked up? Try removing a column or so to test if it makes some difference to the datagrid.

If it is picking up, the next thing I would do is to find a datagrid with no import/export option and check its configuration and see where’s the difference in the properties.

[oro_newbieParticipant]

Hi spyout,

Like I mentioned in my post, changing the 5000 to more quantity fixes the issue. You can override that particular file and do it. For now I just changed it in the vendor file which is a bad practice though.

Clear your cache completely once you do this and test, mentioned above how to as well.

[oro_newbieParticipant]

@Rachid: you can however create a provider that returns the array. Try Mike’s post here. In the place of query is where you will be adding your array.

[oro_newbieParticipant]

@spyout98: Try this link to hide from UI.

[oro_newbieParticipant]

Thanks Yuri. That helped a lot! This happened when I changed my supervisord.conf directory to /tmp/ and then switched it back. I think it was stuck to that folder.

[oro_newbieParticipant]

Sorry, this is my mistake. One of my join columns were “string” type. Changed to integer and all works fine now. Make sure you have indexes on your join columns and they are of type integer.

[oro_newbieParticipant]

Hi,

Figured the issue. It IS the line I mentioned previously. I removed cache this time

MS DOS

rm -rf var/cache

1	rm -rf var/cache

and tried, so now it’s working. It’s mentioned as size_of_batch so I’m guessing it’s not the limit of rows but rather the number of records to pull in 1 batch. Maybe somewhere the offset for the next set of batch isn’t happening?

Here’s my configuration anyway:

[oro_newbieParticipant]

Hi,

Anyone able to reproduce the issue?

Thanks,
A

[oro_newbieParticipant]

Hi,

I’m using version 3 and I still see this. It’s 5000 records this time. I found this:

YAML

oro_importexport.export.size_of_batch: 5000

1	oro_importexport.export.size_of_batch: 5000

in

ImportExportBundle/Resource/config/services.yml

but changing it doesn’t help. How do I debug why it’s repeating?

Thanks,
A

[oro_newbieParticipant]

Hi Andrew,

If you see the post that I referred to, the 3rd step is similar to what I have done (with SelectFilter and SelectLikeFilter). So I do not think that’s the issue?

When I run the commands, the js file is not going to the oro/filter bundles folder. I think this is the issue. I’m not sure why it’s not going there though. Is something wrong with my requirejs.yml? How do I define the path?

Thank you!

[oro_newbieParticipant]

@Vicheslav

Thank you so much! I did the below:

YAML

columns: followupDate: label: 'Follow up date' type: twig frontend_type: html template: OroCRMCaseBundle:Case:Datagrid/Column/followupDate.html.twig

1 2 3 4 5 6

columns:             followupDate:                 label: 'Follow up date'                 type: twig                 frontend_type: html                 template: OroCRMCaseBundle:Case:Datagrid/Column/followupDate.html.twig

And the twig template:

XHTML

{% set followupDate = record.getValue('followupDate') %} {% if "now"|date('Y-m-d') > followupDate|date('Y-m-d') %} <div class="text-error"><strong>{{ followupDate|date('Y-m-d H:i:s') }}</strong></div> {% else %} <div><strong>{{ followupDate|date('Y-m-d H:i:s') }}</strong></div> {% endif %}

1 2 3 4 5 6

{% set followupDate = record.getValue('followupDate') %} {% if "now"|date('Y-m-d') > followupDate|date('Y-m-d') %}       <div class="text-error"><strong>{{ followupDate|date('Y-m-d H:i:s') }}</strong></div> {% else %}     <div><strong>{{ followupDate|date('Y-m-d H:i:s') }}</strong></div> {% endif %}

It works! Although I can only color that column data not the whole row, but it’s okay for now :) Thank you!

[oro_newbieParticipant]

Not sure if this will work but try going to config_prod.yml or config_dev.yml depending on which log is being filled and remove the “monolog:” and everything under it. Keep a backup of this for later!

[Author]

Replies