Hello. I want to create new module, but i can't create field to choose records from many modules. For example in Tasks i have field where i can choose Account, contact, lead, case and etc, but i don't know how to create that one.

I tried with upgrade and tried with a fresh 4.00 download but the result is the same "bas server response" when it came to this link {site_root}/api/v1/Portal/?maxSize=20&offset=0&sortBy=name&asc=true some errors occurs:

( ! ) Strict standards: Declaration of Espo\Repositories\Portal::afterSave() should be compatible with Espo\Core\ORM\Repositories\RDB::afterSave(Espo\ORM\Entity $entity, array $options = Array) in C:\wamp\www\crm\EspoCRM4\application\Espo\Repositories\Portal.php on line 37 Call Stack

Time Memory Function Location

1 0.0005 247088 {main}( ) ..\index.php:0 2 0.0056 603800 Espo\Core\Portal\Application->__construct( ) ..\index.php:38 3 0.0418 4824864 Espo\ORM\EntityManager->getEntity( ) ..\Application.php:48 4 0.0418 4824960 Espo\ORM\EntityManager->getRepository( ) ..\EntityManager.php:144 5 0.0418 4825072 Espo\Core\ORM\RepositoryFactory->create( ) ..\EntityManager.php:162 6 0.0418 4825176 Espo\ORM\RepositoryFactory->create( ) ..\RepositoryFactory.php:38 7 0.0421 4825984 class_exists ( ) ..\RepositoryFactory.php:50 8 0.0421 4826320 spl_autoload_call ( ) ..\RepositoryFactory.php:50 9 0.0421 4826368 Composer\Autoload\ClassLoader->loadClass( ) ..\RepositoryFactory.php:0 10 0.0423 4826504 Composer\Autoload\includeFile( ) ..\ClassLoader.php:301 11 0.0425 4838792 include( 'C:\wamp\www\crm\EspoCRM4\application\Espo\Repositories\Portal.php' ) ..\ClassLoader.php:412

( ! ) Fatal error: Uncaught exception 'Espo\Core\Exceptions\NotFound' in C:\wamp\www\crm\EspoCRM4\application\Espo\Core\Portal\Application.php on line 51 ( ! ) Espo\Core\Exceptions\NotFound: in C:\wamp\www\crm\EspoCRM4\application\Espo\Core\Portal\Application.php on line 51 Call Stack

Time Memory Function Location

1 0.0005 247088 {main}( ) ..\index.php:0 2 0.0056 603800 Espo\Core\Portal\Application->__construct( ) ..\index.php:38

Hello. From time to time we're observing problems with attaching files to tasks. We saved some logs.

[2018-03-20 16:44:36] Espo.ERROR: API [GET]:., Params:Array ( ) , InputData: - [] [] [2018-03-20 16:44:36] Espo.ERROR: Display Error: , Code: 404 URL: /?entryPoint=image&id=5aa1335341a674cda&size=medium [] [] [2018-03-20 16:44:36] Espo.ERROR: Uncaught Exception Slim\Exception\Stop: "" at /home/user/domains/example.com/public_html/vendor/slim/slim/Slim/Slim.php line 1022 {"exception":"[object] (Slim\Exception\Stop(code: 0): at /home/user/domains/example.com/public_html/vendor/slim/slim/Slim/Slim.php:1022)"} [] [2018-03-20 17:07:49] Espo.ERROR: API [GET]:., Params:Array ( ) , InputData: - [] [] [2018-03-20 17:07:49] Espo.ERROR: Display Error: , Code: 404 URL: /?entryPoint=image&id=5ab13d0b3759eb2bd&size=medium [] [] [2018-03-20 17:07:49] Espo.ERROR: Uncaught Exception Slim\Exception\Stop: "" at /home/user/domains/example.com/public_html/vendor/slim/slim/Slim/Slim.php line 1022 {"exception":"[object] (Slim\Exception\Stop(code: 0): at /home/user/domains/example.com/public_html/vendor/slim/slim/Slim/Slim.php:1022)"} []

Description:

1. I attached photo to task
2. I saw thumbnail of photo in EspoCRM
3. I saved task
4. My coworker open that task and saw icon of broken file instead of photo.
5. After i reload website i saw that image disappeared

Currently, import uses saveEntity which creates single row insert at a time.

Problem

If I am importing say 100,000 lead, for example, which contains emailAddresses and phoneNumbers

• 100,000 insert queries to insert lead
• 100,000 insert queries to insert emailAddresses
• 100,000 insert queries to insert phoneNumbers
• 100,000 insert queries to insert entity_email_address
• 100,000 insert queries to insert entity_phone_numbers

Total of 500,000 insert queries are needed to be run ignoring the inserts for process history records, relations etc... This makes import painfully slow.

My research on speed on inserts is here: https://stackoverflow.com/a/57452308

Proposed: Use bulk insert with multiple rows

Example,

Insert into `lead` (first_name, last_name) values 
('a', 'b'),  -- row 1
('c', 'd'),  -- row 2
('e', 'f');  -- row 3

For bulk update use case keyword.

Example,

update `lead` set first_name = (
  CASE id
    WHEN '5f232342d' THEN 'a'
    WHEN '243242dsf' THEN 'b'
  END
  ) WHERE id IN ('5f232342d', '243242dsf');

FYI, you need to think about how beforeSave, afterSave and hooks will work also

Once we clone the repo we can work in the development environment and generate the build.

Once the build is deployed on the production, how do we deploy next changes to the server without breaking the code or losing the data?

I would like to set up the staging and the production and frequently would like to import the data from the production to the staging.

I could not find anything regarding this in the documentation or on the forum.

When selected all results (on the list view) and the total number of records is greater than a specific threshold value, then the export will be processed by cron/daemon.

It will allow to export very large numbers of records.

Describe the bug When I save a record that is type 'Event', the end time changes unexpectedly. It looks like the time is being recalculated based on the start time and the duration. The problem is intermittent - saving the same record over and over will produce both results: correct and incorrect. For example, setting an event from 0900 to 1200 and then changing the times to 0859 and 1200 will often result in the record storing 0859 and 1159, which is wrong by 1 minute. The duration was set to 3 hours, and it looks like Espo was trying to maintain a 3-hour event instead of allowing me to set it to 3 hours and 1 minute.

To Reproduce I added debug statements to application/Espo/ORM/Repository/RDBRepository.php as follows:

 151     public function save(Entity $entity, array $options = []): void
 152     {
 153         $this->processCheckEntity($entity);
 154         $type = $entity->getEntityType();
 155
 156         if ($entity instanceof BaseEntity) {
 157             $entity->setAsBeingSaved();
 158         }
 159
 160         if($type == "Session")
 161           $GLOBALS['log']->debug("session save 1", [$entity->get('dateStart'), $entity->get('dateEnd')]);
 162         if (empty($options['skipBeforeSave']) && empty($options['skipAll'])) {
 163
 164
 165           $this->beforeSave($entity, $options);
 166
 167         }
 168
 169         if($type == "Session")
 170           $GLOBALS['log']->debug("session save 2", [$entity->get('dateStart'), $entity->get('dateEnd')]);
 171         $isSaved = false;

I also added debug statements to my beforeSave hook as follows:

 44   public function beforeSave(Entity $session, array $options = array()) {
 45     $GLOBALS['log']->debug('session beforeSave 1', [$session->get("dateStart"), $session->get("dateEnd")]);

This is what happened in the log when I tried to save a record with a start and end time of 1459 and 1930, respectively:

[2022-05-11 16:14:02] DEBUG: session save 1 ["2022-05-10 14:59:00","2022-05-10 19:30:00"] []
[2022-05-11 16:14:02] DEBUG: session beforeSave 1 ["2022-05-10 14:59:00","2022-05-10 19:29:00"] []
[2022-05-11 16:14:02] DEBUG: session save 2 ["2022-05-10 14:59:00","2022-05-10 19:29:00"] []

As you can see, the time changed by 1 minute before the code in my hook had a chance to execute. I thought my hook was causing the problem, but I have now seen that the record is entering the hook with the wrong value.

Expected behavior I expect the end time to be what I manually set instead of being tied to the duration. The duration should be calculated based only on the times, not the other way around.

EspoCRM version 7.1.3

Additional context I first noticed this issue in the GUI. My users would set times and then they would be wrong, which was shown in the stream as well. Also, the change can be more than 1 minute; sometimes it can be 10 or even 20 minutes, depending on the steps in the duration field. There appears to be a type of 'rounding' going on. After fighting with it in the GUI, I started setting the values programmatically through a Job, but that didn't fix the problem either. After adding debug statements, it seems that the field is being changed somewhere in the parent beforeSave hook for the entity, but I'm not really sure.

Hello guys I think Espo is great, but You should consider few things about security. 

1. Two steps verification for login screen (Google Authenticator, codes in e-mail, DUO security, anything)
2. Logs for bad logins - Espo should log every single request from login screen
3. Captcha for login screen - Without captcha, bots can attack using brute force method without any knowledge of espo administator
4. Blocking bad logins by IP - same thing like in point 3
5. Login tokens - even if i turn on notifications about new tokens, if anyone try to connect by API, i don't have any alert
6. Logs for API - I think there should be any logs who and when tried to connect using API
7. White list for API - I think also that before anyone try to connect by api to Espo, He should add his IP to white list in the first place

I see potential in Espo. Really, i can move all information about company to Espo, but we should have more security options. In few months in EU We'll be have new law regarding to data processing and security, those thing above should be good shield/firewall for our data.

I'm working on a quick prototype, extending the Formula functionality being able to process more hooks. See attached Formula.php hook.

See added functionality here:

• while functionality in formulas
• formulas that can handle multiple hooks instead of only 'beforeSave'

In my formula, I trigger the recalculation of a related record, using an update of the record:

begin:afterSave
$dt = datetime\now();
$s = datetime\format($dt, 'Europe/Amsterdam', 'MM/DD/YYYY hh:mm:ss');
$jr = jaar;
$rec_id = record\findOne('Nascholingstotaal', 
                             'createdAt', 'asc', 
                             'jaar=', $jr, 'contactId=', contactId);
record\update('Nascholingstotaal', $rec_id, 
              'description', string\concatenate("AFTER SAVE ", $s)
              );
end:afterSave

begin:afterRemove
$dt = datetime\now();
$s = datetime\format($dt, 'Europe/Amsterdam', 'MM/DD/YYYY hh:mm:ss');
$jr = jaar;
$rec_id = record\findOne('Nascholingstotaal', 
                             'createdAt', 'asc', 
                             'jaar=', $jr, 'contactId=', contactId);
record\update('Nascholingstotaal', $rec_id, 
              'description', string\concatenate("AFTER REMOVE ", $s)
              );
end:afterRemove

The related record 'Nascholingstotaal' is recalculated nicely. The following formula is being processed:

$ds = description;
$jr = jaar;
$contact_id = contactId;

$ids = record\findRelatedMany('Contact', contactId, 
                              'nascholingen', 1000, 
                              'createdAt', 'asc');
                              
$i = 0;
$n = array\length($ids);
$comma = "";

$totaal_dagen = 0;
while(
    $i < $n,
    $comma = ", ";
    $nascholing_id = array\at($ids, $i);
    $rec_jr = record\attribute('Nascholing', $nascholing_id, 'jaar');
    ifThen($rec_jr == $jr,
        $dagen = record\attribute('Nascholing', $nascholing_id, 'aantalDagen');
        $totaal_dagen = $totaal_dagen + $dagen;
    );
    $i = $i + 1;
);

dagen = $totaal_dagen;

However, the related entity is Nascholingstotaal is not refreshed on the screen. See image.

So, the blue record in 'Nascholing' has just been updated. All went well, all formulas have been calculated. Totals have been recalculated; however, it doesn't show. See the red rectangle.

When I manually refresh the screen, it does get the right result:

It is possible to trigger a refresh from the PHP backend code?

[2021-06-16 09:09:34] ALERT: Rebuild database fault: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'lead (id VARCHAR(24) NOT NULL COLLATEutf8mb4_unicode_ci, deleted TINYINT(...

Webserver: | Apache/2.4.38 (Debian) PHP-Version: | 7.4.20 MySQL-Server-Version: | 5.5.5-10.3.27-MariaDB-0+deb10u1

The emails from Gmail, that are already on the system, are being re-downloaded after some time, with a different Unique ID. We are having a lot of duplicated emails.

Is your feature request related to a problem? Please describe. Kanban records are shown based on Records Per Page (Small) which reference records of related entity (related records) therefore there is a limitation to how many records should be shown in the kanban view based on provided value in Records Per Page (Small).

Describe the solution you'd like I would love if in the User Interface an option could be added as **Records Per Kanban *** which would allow to set how many records to show in a kanban view. this way we have a better control on how many records should be listed on related entities (Records Per Page (Small) *) and also have an option to set how many records should be displayed on kanban view through the new option Records Per Kanban

Describe alternatives you've considered currently there is no option available to allow such control.

Additional context Add any other context or screenshots about the feature request here.

Is your feature request related to a problem? Please describe.

Running a fresh install does not provide entering specific DB params

Describe the solution you'd like

Allow these setting during install, possibly hidden in an "advanced" section.

$params['platform']
$params['sslCA']
$params['sslCert']
$params['sslKey']
$params['sslCAPath']
$params['sslCipher']
$params['sslVerifyDisabled']

Describe alternatives you've considered

Hardcoding in /resources/defaults/config.php

Additional context

Is your feature request related to a problem? Please describe. Currently formula works only before save, we often need to run formula after save, I have found workarounds but all are not like if we simply have after save formula, will be clearer for clients. Another point is the formatting of formula, I wonder if having them stored in files would be better than json as encoded strings, something like Call/afterSave.frml would be great, large projects will be managed their code using git, and it is very useful to track the formula changes in clear way.

Describe the solution you'd like I strongly hope this implemented into the core directly, I can help by contributing, if you dont like the idea then will think of making an extension, but will be more difficult.

Is your feature request related to a problem? Please describe. We are using multiple enum fields to track the progress on account entity (same goes for another two entities) we keep switching each time to a different field to show the Kanban view, e.g today we might be using Account state enum field to see progress of the state of each account and at the same day we might need to switch to see the Kanban view based on another enum field which would be Type. Because account goes through different states / types and statuses we need to be able to switch to a different enum field for the Kanban to be able to monitor where the account is at different states / stages / statuses etc

Describe the solution you'd like I would love if the Kanban configuration on the entity Manager would be available on the list view of the entity. when choosing which status field to show on the Kanban and what field to ignore on the Kanban if these two field could be controlled and used on the entity list view when switching to the Kanban view.

Describe alternatives you've considered Currently as administrator i need to keep changing the status field of the Kanban based on what field we use to show the Kanban view. Please see attached a screenshot of what i expect this feature to look like. i am sure the Developer could make it more elegant.

Additional context Add any other context or screenshots about the feature request here.

https://github.com/espocrm/espocrm/blob/99670c7b3de4d253110b840f3834d170f5148307/client/src/email-helper.js#L515

Could we get an enum/varchar option to choose the external client separator? Depending on your computer/outlook regional settings Outlook uses ";" as a separator and doesn't accept ",".

Thanks