Forums › Forums › OroCRM › OroCRM – How do I? Questions › export custom datagrid problem
This topic contains 11 replies, has 2 voices, and was last updated by fred33 6 years, 4 months ago.
Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.
- CreatorTopic
- November 13, 2017 at 10:59 pm #29432
Hi,
The export of my custom datagrid doesn’t work yet i put this optionPHP1234options:entityHint: analyseVisiteexport: trueentity_pagination: truewhen i click on the export grid button to xlsx i have this message in the bottom of the page
‘Export started successfully. You will receive email notification upon completion.’But nothing happen….
i do this
PHP1php app/console oro:message-queue:consume -vvvno change
what is the problem and how can i solve it ???
Thanks
- CreatorTopic
- AuthorReplies
- November 14, 2017 at 6:27 am #29433
Hi fred33,
After you see that message you should receive the export via email if the consumer was running. But please note that by default, the CSV writer is implemented. For other formats you can check this page.
Also, please make sure your email settings are correct, do you receive other emails from the application?
What application/version are you using ?Adrian
November 14, 2017 at 6:34 am #29434hi,
I didn’t receive any mail. I’m login with admin and i’ve configured email settings with my own email. effectively i didn’t receive any notification or email from the applicationi’m using oro/crm 2.4.1
Thanks
November 14, 2017 at 7:22 am #29435If you haven’t received email from the application, the issue seems to be caused by the email settings, not necessarily by the export settings.
You can check instructions on how to setup your email here.
And if your own email is Gmail based, take into account the last tip on the bottom of this page about Gmail account settings.
Adrian
November 14, 2017 at 8:16 am #29436Ok
I tested nothing happens. I am good with gmail
config.ymlPHP123456789# Swiftmailer Configurationswiftmailer:transport: smtphost: smtp.gmail.comport: 465encryption: sslusername: frederic.portaries@corep.compassword:spool: { type: memory }parameters.yml
PHP123456mailer_transport: gmailmailer_host: ~mailer_port: nullmailer_encryption: nullmailer_user: frederic.portaries@corep.commailer_password: *********Synchronization work well
Thanks
November 15, 2017 at 2:51 am #29437I modify in config.yml transport : gmail
i didn’t receive any mail
is there another way to export data from a grid?
November 15, 2017 at 4:05 am #29438This is the recommended way.
To confirm that the email connection is successful, you can go to System > Configuration > General Setup > Email Configuration and press “Check SMTP Connection” button. If everything is ok, you should
receive a flash message underneath the button saying “Connection established successfully”.If email settings are ok but you are still not receiving the export file check the output of the consumer or the application/system logs for any info regarding a possible failure.
Adrian
November 15, 2017 at 4:55 am #29439Connection is OK
but how can i debug thatNovember 17, 2017 at 12:18 am #29440I’ve this message when i run
PHP1php app/console oro:message-queue:consume -vvvPHP1234567891011121314151617181920212223242526272829[Symfony\Component\Debug\Exception\ContextErrorException]Notice: Undefined index: labelException trace:() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Bundle/DataGridBundle/ImportExport/DatagridDataConverter.php:85Symfony\Component\Debug\ErrorHandler->handleError() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Bundle/DataGridBundle/ImportExport/DatagridDataConverter.php:85Oro\Bundle\DataGridBundle\ImportExport\DatagridDataConverter->convertToExportFormat() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Processor/ExportProcessor.php:56Oro\Bundle\ImportExportBundle\Processor\ExportProcessor->process() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Bundle/BatchBundle/Step/StepExecutor.php:189Oro\Bundle\BatchBundle\Step\StepExecutor->process() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Bundle/BatchBundle/Step/StepExecutor.php:158Oro\Bundle\BatchBundle\Step\StepExecutor->execute() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Bundle/DataGridBundle/Handler/ExportHandler.php:94Oro\Bundle\DataGridBundle\Handler\ExportHandler->handle() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Bundle/DataGridBundle/Async/Export/ExportMessageProcessor.php:99Oro\Bundle\DataGridBundle\Async\Export\ExportMessageProcessor->handleExport() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Async/Export/ExportMessageProcessorAbstract.php:90Oro\Bundle\ImportExportBundle\Async\Export\ExportMessageProcessorAbstract->Oro\Bundle\ImportExportBundle\Async\Export\{closure}() at n/a:n/acall_user_func() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Component/MessageQueue/Job/JobRunner.php:162Oro\Component\MessageQueue\Job\JobRunner->callbackResult() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Component/MessageQueue/Job/JobRunner.php:117Oro\Component\MessageQueue\Job\JobRunner->runDelayed() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Bundle/ImportExportBundle/Async/Export/ExportMessageProcessorAbstract.php:76Oro\Bundle\ImportExportBundle\Async\Export\ExportMessageProcessorAbstract->process() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Component/MessageQueue/Client/DelegateMessageProcessor.php:36Oro\Component\MessageQueue\Client\DelegateMessageProcessor->process() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Component/MessageQueue/Consumption/QueueConsumer.php:174Oro\Component\MessageQueue\Consumption\QueueConsumer->doConsume() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Component/MessageQueue/Consumption/QueueConsumer.php:114Oro\Component\MessageQueue\Consumption\QueueConsumer->consume() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Component/MessageQueue/Client/ConsumeMessagesCommand.php:75Oro\Component\MessageQueue\Client\ConsumeMessagesCommand->consume() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Bundle/MessageQueueBundle/Command/ClientConsumeMessagesCommand.php:26Oro\Bundle\MessageQueueBundle\Command\ClientConsumeMessagesCommand->consume() at /opt/CRM/crmcrp3/vendor/oro/platform/src/Oro/Component/MessageQueue/Client/ConsumeMessagesCommand.php:65Oro\Component\MessageQueue\Client\ConsumeMessagesCommand->execute() at /opt/CRM/crmcrp3/vendor/symfony/symfony/src/Symfony/Component/Console/Command/Command.php:259Symfony\Component\Console\Command\Command->run() at /opt/CRM/crmcrp3/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:866Symfony\Component\Console\Application->doRunCommand() at /opt/CRM/crmcrp3/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:193Symfony\Component\Console\Application->doRun() at /opt/CRM/crmcrp3/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:92Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /opt/CRM/crmcrp3/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:124Symfony\Component\Console\Application->run() at /opt/CRM/crmcrp3/app/console:22Can someone help me
thanks
November 21, 2017 at 6:04 am #29441I come back my problem is still not resolved, I’m looking for the error I could not find
November 21, 2017 at 6:22 am #29442this is my entity
PHP123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652namespace CL\Bundle\AnalyseVisiteBundle\Entity;use Doctrine\ORM\Mapping as ORM;use Oro\Bundle\EntityConfigBundle\Metadata\Annotation\Config;use Oro\Bundle\EntityConfigBundle\Metadata\Annotation\ConfigField;/**** analyseVisite** @ORM\Table(name="analyseVisite")** @ORM\Entity()** @Config(* defaultValues={* "entity"={* "icon"="icon-ok-circle",* "label"="analyseVisite",* "plural_label"="analyseVisites",* "description"="Analyse Visites"* }* }* )**/class analyseVisite{/*** @var int** @ORM\Column(name="id", type="integer")* @ORM\Id* @ORM\GeneratedValue(strategy="AUTO")** @ConfigField(* defaultValues={* "importexport"={* "order"=10* }* }* )*/protected $id;/*** @ORM\ManyToOne(targetEntity="Oro\Bundle\AccountBundle\Entity\Account")* @ORM\JoinColumn(name="account_id", referencedColumnName="id", onDelete="SET NULL")** @ConfigField(* defaultValues={* "importexport"={* "order"=20* }* }* )*/protected $account;/*** @var float** @ORM\Column(name="Janvier", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=30* }* }* )*/protected $Janvier;/*** @var float** @ORM\Column(name="Fevrier", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=40* }* }* )*/protected $Fevrier;/*** @var float** @ORM\Column(name="Mars", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=50* }* }* )*/protected $Mars;/*** @var float** @ORM\Column(name="Avril", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=60* }* }* )*/protected $Avril;/*** @var float** @ORM\Column(name="Mai", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=70* }* }* )*/protected $Mai;/*** @var float** @ORM\Column(name="Juin", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=80* }* }* )*/protected $Juin;/*** @var float** @ORM\Column(name="Juillet", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=90* }* }* )*/protected $Juillet;/*** @var float** @ORM\Column(name="Aout", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=100* }* }* )*/protected $Aout;/*** @var float** @ORM\Column(name="Septembre", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=110* }* }* )*/protected $Septembre;/*** @var float** @ORM\Column(name="Octobre", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=120* }* }* )*/protected $Octobre;/*** @var float** @ORM\Column(name="Novembre", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=130* }* }* )*/protected $Novembre;/*** @var float** @ORM\Column(name="Decembre", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=140* }* }* )*/protected $Decembre;/*** @var float** @ORM\Column(name="Total", type="float", nullable=true)** @ConfigField(* defaultValues={* "importexport"={* "order"=150* }* }* )*/protected $Total;/*** @ORM\ManyToOne(targetEntity="Oro\Bundle\UserBundle\Entity\User")* @ORM\JoinColumn(name="user_id", referencedColumnName="id", onDelete="SET NULL")** @ConfigField(* defaultValues={* "importexport"={* "order"=160* }* }* )*/protected $user;/*** @var integer** @ORM\Column(name="resp", type="integer", nullable=false)** @ConfigField(* defaultValues={* "importexport"={* "order"=170* }* }* )*/protected $resp;/*** @var string** @ORM\Column(name="codeAna", type="string", nullable=false)** @ConfigField(* defaultValues={* "importexport"={* "order"=180* }* }* )*/protected $codeAna;/*** Get id** @return int*/public function getid(){return $this->id;}/*** Get account** @return account*/public function getaccount(){return $this->account;}/*** Get Janvier** @return Janvier*/public function getJanvier(){return $this->Janvier;}/*** Get Fevrier** @return Fevrier*/public function getFevrier(){return $this->Fevrier;}/*** Get Mars** @return Mars*/public function getMars(){return $this->Mars;}/*** Get Avril** @return Avril*/public function getAvril(){return $this->Avril;}/*** Get Mai** @return Mai*/public function getMai(){return $this->Mai;}/*** Get Juin** @return Juin*/public function getJuin(){return $this->Juin;}/*** Get Juillet** @return Juillet*/public function getJuillet(){return $this->Juillet;}/*** Get Aout** @return Aout*/public function getAout(){return $this->Aout;}/*** Get Septembre** @return Septembre*/public function getSeptembre(){return $this->Septembre;}/*** Get Octobre** @return Octobre*/public function getOctobre(){return $this->Octobre;}/*** Get Novembre** @return Novembre*/public function getNovembre(){return $this->Novembre;}/*** Get Decembre** @return Decembre*/public function getDecembre(){return $this->Decembre;}/*** Get Total** @return Total*/public function getTotal(){return $this->Total;}/*** Get user** @return user*/public function getuser(){return $this->user;}/*** Get resp** @return resp*/public function getresp(){return $this->resp;}/*** Get codeAna** @return codeAna*/public function getcodeAna(){return $this->codeAna;}/*** Set account** @param account $account*/public function setaccount($account){$this->account = $account;}/*** Set Janvier** @param Janvier $Janvier*/public function setJanvier($Janvier){$this->Janvier = $Janvier;}/*** Set Fevrier** @param Fevrier $Fevrier*/public function setFevrier($Fevrier){$this->Fevrier = $Fevrier;}/*** Set Mars** @param Mars $Mars*/public function setMars($Mars){$this->Mars = $Mars;}/*** Set Avril** @param Avril $Avril*/public function setAvril($Avril){$this->Avril = $Avril;}/*** Set Mai** @param Mai $Mai*/public function setMai($Mai){$this->Mai = $Mai;}/*** Set Juin** @param Juin $Juin*/public function setJuin($Juin){$this->Juin = $Juin;}/*** Set Juillet** @param Juillet $Juillet*/public function setJuillet($Juillet){$this->Juillet = $Juillet;}/*** Set Aout** @param Aout $Aout*/public function setAout($Aout){$this->Aout = $Aout;}/*** Set Septembre** @param Septembre $Septembre*/public function setSeptembre($Septembre){$this->Septembre = $Septembre;}/*** Set Octobre** @param Octobre $Octobre*/public function setOctobre($Octobre){$this->Octobre = $Octobre;}/*** Set Novembre** @param Novembre $Novembre*/public function setNovembre($Novembre){$this->Novembre = $Novembre;}/*** Set Decembre** @param Decembre $Decembre*/public function setDecembre($Decembre){$this->Decembre = $Decembre;}/*** Set Total** @param Total $Total*/public function setTotal($Total){$this->Total = $Total;}/*** Set user** @param user $user*/public function setuser($user){$this->user = $user;}/*** Set resp** @param resp $resp*/public function setresp($resp){$this->resp = $resp;}/*** Set codeAna** @param codeAna $codeAna*/public function setcodeAna($codeAna){$this->codeAna = $codeAna;}}November 23, 2017 at 2:55 am #29443the problem was in the definition of a label column was written with a capital L
- AuthorReplies
The forum ‘OroCRM – How do I? Questions’ is closed to new topics and replies.