Forums

Covering OroCommerce, OroCRM, OroPlatform topics, including community updates and company announcements.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 36 total)
  • Author
    Replies

  • shreyas
    Participant

    Hi Andrey,

    Thanks a lot for sharing this information.

    Thanks & Regards,
    Shreyas S


    shreyas
    Participant

    Hi Andrey,

    Thanks a lot for such a quick response.
    I checked at the link you shared it is working as expected.Is there any way where in the column headers will get translated based on how datagrid columns displayed in UI because as observed translation of headers is missing in export file.

    Thanks & Regards,
    Shreyas S


    shreyas
    Participant

    Thanks Andrey for the guidance.

    Thanks & Regards,
    Shreyas S


    shreyas
    Participant

    Thanks a lot Andrey for quick response.
    I will look at the guidance suggested by you.

    Thanks & Regards,
    Shreyas S

    in reply to: Date Filters not properly working for Datagrids #35427

    shreyas
    Participant

    Hi Yurii Muratov,

    Thanks a lot for your quick reply. Sorry for delayed response .I had few doubts which i would like to clear from it.

    My concern in this Date filter issue is that irrespective of the timezone we have selected , at last it gets saved in UTC format & retrieves in whatever timezone we have selected. So, for example i created some opportunities in Application which contains Expected close Date.Thus once i created an opportunity in Application & checked for Dates in DB . The Dates saved in DB & that created in Application the same.

    Please find the observation below ( i have chosen for EN locale now):
    List of all opportunities below:

    List of Opportunities

    Now i use Date filter Between option for Expected close time filtering from Oct 19, 2017 till Oct 21, 2017 to be as follows:

    Filter for Expected Close Date 19-oct till 21 oct

    Now if you notice the above filtered results , it does not contain result related to Oct 21,2017 . which i feel should have been listed in these filtered results. Please let me know if i am wrong about it.

    Please find the DB related information for these data:

    DB information for Opportunity Data

    Locale Information is as follows:
    Localization Info

    Also logs just for reference:

    This is similar issue which we faced with French locale being selected also (explained in above post). Please let me know if this is an issue or not. other doubt was that when the field used for filtering is of Date type why is it Date Time being taken into consideration here.

    Thanks & Regards,
    Shreyas S


    shreyas
    Participant

    Hi Team,

    i was able to restrict the Entity access with some modifications in Code as shown below:

    In vendor\oro\platform\src\Oro\Bundle\SearchBundle\Provider\ResultStatisticsProvider.php

    In function getGroupedResults() done some modification to check for Entity Access with help of securityProvider.

    Also done respective changes in services.yml for oro_search.provider.result_statistics_provider as below:

    Now the Custom entity Search result is not shown other than for ADMIN Role.

    But i am facing similar issue related to Entity’s Record level Access, where in ACL might not be working properly.
    Ex:
    i have a User who has created an Account record. This account’s record should not be visible to other user other than created user as the ownership is also registered in ACL of Account Entity.But this is not working fine with Search Result wherein it is listing many records that are not applicable to him or Business Units
    under him whereas on the Account Entity index page it displays only records applicable to that user. When i try clicking on some of those search result’s records it says no permission to view record.

    i observed that SearchAclHelper is being used in vendor\oro\platform\src\Oro\Bundle\SearchBundle\Engine\Indexer.php in prepareQuery() method but not working as expected.Please find code snippet for reference:

    I tried commenting $this->searchAclHelper->apply($query); from above function. Then when i searched for particular search text under Account Entity from Different Users . Then number of records fetched were the same. So once after uncommenting it under each User the search result is varying but there are some Records which user does not have access to also being displayed.This is the same problem for other entities search result also.
    Kindly need help in how to solve this Record Level Access Restriction of Entities to users.

    in reply to: How to use Translation labels in Workflows #30504

    shreyas
    Participant

    Hi Michael,

    I guess we are using OroCRM 1.10.x Version. i tried looking at My_Application/platform/information for Oro Package details.Please find the given version details below :

    Oro Package Version Details

    How can i find which version of OroCRM are we using? Since as per platform/information both oro/platform & oro/crm version is shown as dev-master
    .

    Also, Is there any way that can be used for Workflow Translations for versions prior to 2.0.0.

    Thanks & Regards,
    Shreyas S

    in reply to: Date Error – French Language – Urgent Issue #25325

    shreyas
    Participant

    Thanks Hryhorii,

    Its working fine now after deleting the js.

    Thanks & Regards,
    Shreyas S

    in reply to: Date Error – French Language – Urgent Issue #25321

    shreyas
    Participant

    Hi Hryhorii,

    Thanks for the suggestion.i tried following the steps of deleting the oro.min.js file from web/js & using the command: app/console oro:requirejs:build . But this throws me runtime exception as given below:

    Please find screenshot for the same:
    Runtime Exception in RequireJs Build

    So, when i go back to the web/js i cannot find the generated oro.min.js due to the exception that is occured. I tried placing back oro.min.js which was taken back up before removing in web/js. And then try executing this command but it gives same error.

    Kindly need help in how to fix this issue.

    Thanks & Regards,
    Shreyas S

    in reply to: Issue occured in Running Cron Command #30493

    shreyas
    Participant

    Hi Mike,
    Thanks a lot for Suggestion. I tried removing part of code which had DB activities (i.e removed getRepository & also DB code present in getDefaultDefinition(). And kept only a single statement inside execute() function i.e: $output->writeln(“Execution Started”);. It gave the same error. There was some problem in my instance’s Database i think since when i used my instance code connect to different copy of Database with same tables & entities configuration by changing Database name in parameters.yml it worked perfectly fine without any issues.So i think my Database Tables had some issue now it is working fine after changing the Database.

    Thanks,
    Shreyas S

    in reply to: Date Error – French Language – Urgent Issue #25318

    shreyas
    Participant

    Hi Team,

    I am also facing the same issue when language is French. it works fine in previous OroCRM version but in the new version facing this issue. I guess the issue is in oro.min.js present in web/js.Because when i tried replacing this js file with previous version’s js file it worked for Dates & also gets saved to DB successfully(My_application_PATH/task/create) but gives some js errors when loading any other pages. I tried looking at changes from previous version of js with this new js but could not get much idea in how to resolve this Datepicker validation issue.Please need help in knowing what changes need to be done in new oro.min.js as i cannot use older version of js since many other functionalities would not work.

    The problem faced here is most of Months in DatePicker would have special characters in it. Ex: D`ec . So OROCRM gives that error saying that not a valid date. For other months which does not involve any special characters it does not throw any errors & works fine.

    Kindly need help in this problem.

    Thanks & Regards,
    Shreyas S

    in reply to: How to use Stored Procedures in Controller #36335

    shreyas
    Participant

    HI Mike,
    Thanks a lot for sharing the link . It worked. From the link both Solution 1 & Solution 4 were suitable for our Stored Procedure. i.e 1) using of closeCursor() (or) 2) using of unset() .

    Please find the working code snippet shared for the same:

    From the code above any of the two solutions(using unset / using closeCursor) can be used to deal with the exception occured.
    Thanks a lot for the help again!

    Thanks & Regards,
    Shreyas S


    shreyas
    Participant

    Thanks a lot Mike for the solution.It Worked as expected!!!

    Thanks & Regards,
    Shreyas S


    shreyas
    Participant

    Hi Team,

    I was able to get Lead Id to get lead emails with the help of Curl using the Hardcoded Url set in code which is not best way to get this working. So i am trying to get lead/Account Id based on API name instead of Url since the Url can change but not API Name given by OroCRM.

    Please find the Code Below wherein i have written a php class under Location:
    Proj_Dir\src\Custom\Bundle\CalendarBundle\Service\GetContext.php

    Here in above code i am able to get data through CURL with the help Url with the API defined i.e:
    http://shreyas.demosite.com/api/rest/latest/activities/calendarevents/$calendarId/context.json?_format=json
    Where in CalendarId is passed through Process.yml. Here i don’t want to use Curl & the URL of API to get Data instead need to Call the API through its name which is working fine when i tested it in an controller function . Please find the code given below for tested Data obtained from API (Loc: Proj_Dir\src\Custom\Bundle\CalendarBundle\Controller\CalendarEventController.php):

    With this Code Snippet above i am able to fetch data . i.e .. LeadId / Account Id through the Call to this function.But if the same function if i have used in GetContext.php file , then in Process.yml i am unable to get the leads & process job fails.

    Please find the partially working Process.yml that is able to fetch Lead Id from GetContext.php (implemented using Curl shown above) & get Lead/Account emails & send mail to them.

    Here in above Process.yml i am calling getLeadAccount from GetContext.php to get Lead Id/Account Id & passing it to respective entities to fetch their mail Id & sending it to send_email_template.

    Now using the Above Codes for Process.yml & GetContext.php i am able to get lead’s emails & process to send auto emails once appointment is created. But i would slightly need to change the GetContext.php file to not use Curl & API URL instead use the code i have tested in CalendarEventController shown above (i.e function getLeadAccount which contains logic written which used API Name to retrieve data)

    Please find the Code for GetContext.php i am trying now to eliminate the use of Curl Logic shown above:

    Here i am trying to use the API ‘oro_activity.manager.activity_context.api’ to get result. I have used $GLOBALS[‘kernel’] since i would not have access to get() method to call.This Code is working fine when i am trying to write service to this Code & call it in a Controller as shown below:

    Please find the Service for GetContext.php Called in Controller which is working fine to get the result id shown below:

    Now with these Code Changes when i try to use in process.yml , it does not work & process Job fails.

    I also tried different ways to get it working in Process.yml but i am stuck on how to solve this issue.
    Some of things tried were implementing ContainerAwareInterface in GetContext Class & adding a setContainer Method which would initialize container which would be used further in code. This setContainer would be called through service once this class object is created.

    Please find the code for GetContext.php file given below:

    In Services.yml changed the previous configuration of service custom_association.service.getcontext to given below:

    This is working again when called from controller but is not working in Process.yml i.e in process job shows failed status with no further errors nor any log.

    Please need help on how to go about with this issue.
    Thanks & Regards,
    Shreyas S


    shreyas
    Participant

    Hi Team ,

    I was able to access Guests selected during Calendar Event Appointment Creation in Process.yml to send them auto mails once appointment is set to them using $calendar.owner.email . But the issue faced here is even if i am able to send mails to Guests who are set for that appointment, the process jobs are failing as shown below:
    Error in Process Jobs

    But when i donot select any guest & process job , i get a successfully finished Status & mail triggers to the one who has set the appointment (i.e User Logged In). i Dont know how to go about to solve with this issue. i guess there is a different way in accessing the emails through process.yml since there would be multiple mails to be sent for a calendar event created.
    Please find below the Process.yml code:

    In the above code i am able to access Guests using $calendar.owner.email

    In the Calendar_reminder template i have used in process.yml above , i am unable to get proper link processed when a mail is received that is More Details link used to accept/Reject/tentatively attend meeting. Please find the screenshot given below:

    Calendar Template Issue

    Please find the source code slightly modified from existing Calendar_reminder template since process Job failed with existing Calendar_reminder template due to <style> issue for Entity :Calendar.

    Please need help in knowing how to resolve the above issues occured & Also in getting access to Contexts selected during Calendar Event Creation to send them automatic mails once an appointment is set.

    Thanks & Regards,
    Shreyas S

Viewing 15 replies - 1 through 15 (of 36 total)
Back to top

You will be redirected to [title]. Would you like to continue?

Yes No

You will be redirected to [title]. Would you like to continue?

Yes No