Learning EspoCRM and Design

[esforim]

Hi guys,

Just notice an "CRON not enable" message today in the Admin panel so I investigate and it seem that this error is related to it:

Espo.ERROR: Uncaught Exception PDOException: "could not find driver" at /home/public_html/crm/application/Espo/ORM/EntityManager.php line 272 {"exception":"[object] (PDOException(code: 0): could not find driver at /home/public_html/crm/application/Espo/ORM/EntityManager.php:272)"} []

Searching around it seem to be related to the extensions PDO; I had a look at my PHP options and it is enable (PDO_mysql). My host also have nd_pdo_mysql available as well, if you enable one the other get disable.

Anyway it seem that PDO_mysql does not work for me so I decided enable nd_pdo_mysql and my CRON get enable again.

Thinking about this, I have a feeling nd_pdo_mysql is what causing my email not to importable and I keep getting.

Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" at /home/public_html/crm/application/Espo/ORM/SqlExecutor.php line 72 {"exception":"[object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/public_html/crm/application/Espo/ORM/SqlExecutor.php:72)"}

[tothewine]

sure, i'll pm you

[esforim]

Hi tothewine ,

Did a quick search and it look like you can't do a Pull Request on it, and if you want to do that, it is quite a hassle to do so.

However, I can invite you as a Collaborator I believe, so you can have full access to it. I assume as a Collaborator/Admin that all your edit can be update instantly and directly in the page (I just need to find out how), what your Git username, PM it or Post it here.?

[tothewine]

any way to contribute directly on the wiki? if I fork i do not see the pages -_-

[tothewine]

For lead capture in Wordpress with WPForms this is working for me (put the code in /wp-content/plugins/espo-lead.php):

# =============== [ START CODE ] =================== #

/*
Plugin Name: Whatever
Description: Some description
Version: 1
Author: You
*/

function espo_wpf_dev_process( $fields, $entry, $form_data) {
if (absint( $form_data['id'] ) !== 5 ) return $fields; // activate only on form id 5
$endpoint = 'https://your-espocrm.instance/api/v1/LeadCapture/f7ca1234b347f448bafe4a58';
wp_remote_post($endpoint, [
'headers' => ['Content-Type' => 'application/json; charset=utf-8', 'Accept' => 'application/json'],
'body' => json_encode(['firstName' => $fields[1]['value'],'emailAddress' => $fields[2]['value']),
'method' => 'POST',
'data_format' => 'body',
]);
}

add_action('wpforms_process', 'espo_wpf_dev_process', 10, 3);

# =============== [ FINISH] =================== #

This uses wordpress hooks system. I hope it will be useful for people trying to do lead capture on wordpress with wpforms.

[esforim]

Just spotted this link hidden away at the top: https://github.com/o-data/EspoCRM-Le...oding/_history
Under "revision".

So Wiki does get logs of update and changes. That solve one issue. now the WYSIYWG like field toolbar, it might be hidden somewhere in setting to enable it to be Fixed.

[esforim]

Nice, thank you @sahlmaxb. Going to create a Wiki it is.

---
After shortly using it it does have some issue (that might be solvable and I just don't know how yet). The first is there is a "change logs", which is OK.
Second is I don't like how I have to keep scrolling up to use the editing "toolbars".

[shalmaxb]

Hi, I read, that there is a Wiki in Github (though did not find, perhaps only for logged in). Perhaps this helps: https://guides.github.com/features/w...ting-your-wiki

[esforim]

I see that the "readme" can be done quite well; but I'm not sure what the coding of it is:
Here is an example.

https://github.com/xceedsoftware/DocX#what-is-docx

The Table seem to be HTML though.

[esforim]

Hi guys, new changes to this thread and seeking any advise to make it better.

With the forum there is a 10,000 characters limit on it. This is why there is a bunch of "part 1, part 2, part 3", now that I need a "part 4" I decide to seek alternative solution to this to break away from the 10k chars limit.

I decide to go with Github (if there any other better suggestion do tell). I don't think there is any character restriction on it. As a bonus; perhaps someone might even Pull Request the page.

One issue I don't link it the Editing function of it; Github doesn't have a WYSWIG editor so it forced me to use a HTML converter. So if you have any idea on where I can continue adding information to the purpose of this thread, do tell.

Or would user of EspoCRM prefer to just keep it in this thread, even though navigation nightmare.

And here is the file for reference:

https://github.com/o-data/EspoCRM-Learning-and-Design/blob/main/docs/index.html

But it is better viewed here:

https://o-data.github.io/EspoCRM-Learning-and-Design/

I only added Part 2 as a test for now.

[tothewine]

I suppose somebody could do an edit to make this the default tooltip for default text fields

[esforim]

Good tips.

Adding your own tooltips have advantages such as formatting. More importantly it is visible during Quick Create/Edit. And I just notice that Tool-tips Markdown also work so I need to update my Tooltips to be some sort of Code format.

[Maximus]

Hi,
Also, you can get quick Markdown syntax tip in a Stream tooltip:

[esforim]

Hi guys, discovered Markdown today. Previously I just random guessed it but there is an actual documents about it.

It purpose it to style your writing in the Description/Text field. You can read about it here: https://docs.espocrm.com/user-guide/markdown/

However the purpose of this post is this, I created a Tool-tips in my Description. I use this tool tips to help remember these function (until one day it become second nature to type). You can copy/paste it or modify it based on the documents if you like to do the same.

To use (example);
Administration > Entity Manager > Meeting > Fields > Description > Tooltip Text

Example:
```
[Link Text Name](#Meeting/view/{ID})
~~strike out~~
> Block quote
* Bullet point
1. Number Item
**Bold Text**
*Italic Text*
```

[esforim]

SMS Sync

Hi guys, another try at SMS Gateway today. Made some new discovery, made some progress, still not fully functional but at least there is progress.

This tools act as a gateway, allowing you to send and receive SMS. I only manage to get it to Sync all my SMS to EspoCRM at this stage. Although there is error and there is improvement that I need to work out before it is functional. I'm making this post hopefully to bring more attention to this tools, and perhaps get some discussions in using it.

There is a few quirk I can't figure out, the first is the "date" formatting, the second is, how can I link or relationship it. Anyway here is the tools, feel free to ask if you have any questions or input to using it.

http://smssync.ushahidi.com/