How to troubleshoot import of CSV files created by Espo ?

[tothewine]

Thanks, I applied the pathc. I'm testing

[tothewine]

I spotted two instances of this again:

[2020-05-27 15:30:02] Espo.ERROR: InboundEmail 5ec626e012afe5a27 (Import Message w/ MailMimeParser):...

[tothewine]

The original text of these email had emojis in the subject line, maybe that was it but I remember having emails with emoji in espo previously.
...

[tothewine]

After much time this was implemented.

[tothewine]

the link is malformed :\

[tothewine]

Looking forward to it!

[tothewine]

It was a typo :P

[tothewine]

After much digging I understood the php timeout limits were different between cron jobs and apache. This is now a bug report about having some logic for...

[tothewine]

It is very strange... the second CSV file imported without errors.... while the first is still "in progress".



...

[tothewine]

Normally I would use $this->getUser(), if it is defined. When in static context I get the username like this: $GLOBALS['app']->getContainer()-&...

[tothewine]

I had multiple problems (see the email thread) that spammed the log file so it is really big now (18GB). I am trying to trim duplicate lines in order...

[tothewine]

I see utf8mb4_unicode_ci everywhere... i took a screenshot to make as much info available

...

[tothewine]

I went to old espo (5.8) and exported all entities of a custom scope with all the fields. Then I started a cron import in the new espo instance (5.9)...

[tothewine]

no, it was installed fresh on a empty db. I only copied some parts of custom folder but nothing related to emails.
I did delete the log, done some...

[tothewine]

I am testing this apache settings in the /client/.htaccess as part of an effort to keep all client modifications in the /custom folder eventually....

[tothewine]

This is on freshly installed 5.9.0. I got a very big log file full of this errors:

[2020-05-21 07:32:05] Espo.ERROR: InboundEmail

...

[tothewine]

I would like to suggest a CLI command to check csv files for format errors that would otherwise hang the import. e.g. try to import but without saving...

[tothewine]

When exporting sql tables to csv the phpmyadmin software offers two CSV formats "CSV" and "CSV for Excel". Of these two what is the...

[tothewine]

it looks like one of those things that should be built-in to allow fast implementation of conditional business logic by role

[tothewine]

Thanks for the alternative approach! I also figured I was getting the 'system' account instead of mine when calling $this->getUser(); for some reason....