berlicrm / berlicrm Goto Github PK
View Code? Open in Web Editor NEWFrom Berlin to Germany and Europe - an open source CRM Solution mainly for small and medium-sized businesses: Visit https://www.berlicrm.de/
License: Other
From Berlin to Germany and Europe - an open source CRM Solution mainly for small and medium-sized businesses: Visit https://www.berlicrm.de/
License: Other
When creating an Event (Ereignis) with E-Mail notification ,
the system fails and does not send HTML , instead the following errors are printed:
array (
0 =>
array (
'file' => '/var/www/berlicrm-1.0.24/include/database/PearDatabase.php',
'line' => 365,
'function' => 'checkError',
),
1 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Calendar/Activity.php',
'line' => 746,
'function' => 'pquery',
),
2 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Calendar/Activity.php',
'line' => 260,
'function' => 'activity_reminder',
),
3 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Calendar/Activity.php',
'line' => 172,
'function' => 'insertIntoReminderTable',
),
4 =>
array (
'file' => '/var/www/berlicrm-1.0.24/data/CRMEntity.php',
'line' => 92,
'function' => 'save_module',
),
5 =>
array (
'file' => '/var/www/berlicrm-1.0.24/data/CRMEntity.php',
'line' => 852,
'function' => 'saveentity',
),
6 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Vtiger/models/Module.php',
'line' => 143,
'function' => 'save',
),
7 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Events/models/Module.php',
'line' => 29,
'function' => 'saveRecord',
),
8 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Vtiger/models/Record.php',
'line' => 230,
'function' => 'saveRecord',
),
9 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Calendar/models/Record.php',
'line' => 99,
'function' => 'save',
),
10 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Events/actions/Save.php',
'line' => 21,
'function' => 'save',
),
11 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Calendar/actions/Save.php',
'line' => 23,
'function' => 'saveRecord',
),
12 =>
array (
'file' => '/var/www/berlicrm-1.0.24/includes/main/WebUI.php',
'line' => 228,
'function' => 'process',
),
13 =>
array (
'file' => '/var/www/berlicrm-1.0.24/index.php',
'line' => 18,
'function' => 'process',
),
)
Error in processing vtiger_table vtiger_activity_reminder Query Failed:INSERT INTO vtiger_activity_reminder VALUES (?,?,?,?)::ADODB error Error in processing vtiger_table vtiger_activity_reminder Query Failed:INSERT INTO vtiger_activity_reminder VALUES (?,?,?,?)::->Incorrect integer value: '' for column berlicrm.vtiger_activity_reminder.recurringid at row 1
If i create a Workflow that will send a E-mail to a Organisation or Person. The E-Mail will go out correctly when the Workflow is active, but it will not shown / linked in E-Mails of the Oransaiations or Person.
If i habe the Hisotry widget on Startpage i can see there was a Sending E-Mail and i can read it, but thats the only place where i can find the email after workflow has sending it
We just discovered that the system needs "php-xml" installed to work with the Outlook-plugin.
without this PHP-extension the Outlook-Plugin will just receive a http 500 error.
Hey,
in our BerliCRM we created a Email-Converter rule for incoming emails that's supposed to check if the Email is about an existing ticket and update this ticket's information accordingly.
We try to match the subject of an email with a regex matching our ticket numbering pattern.
We tried different versions of the regex, with and without capturing group(s) but none seemed to work. It does work when the ticket number is written at the end of the email's subject but not when its somewhere in the middle of the string.
I'd appreciate some insight on how a regex should look like that would work to update existing tickets. We verified all our expressions on regex101.com's php engine and they were valid.
I am not quite sure if it is our mistake or if it is a bug in the software.
Thank you in advance and kind regards,
NathanielBlack
In Berlicrm 1.0.24 sending an email with an attached BerliCRM Documents is copied correctly to the send folder in BerliCRM.
But the text is not seen by the recipient. If you watch the source code of the email, the text is there. But it is not shown to the recipient.
He just sees the attachment. You can check it with an imap server, that also copies the sent email to the sent folder.
Unfortunately, in Berlicrm, when you check the attached text to "Leads" is shows up correctly.
When I try to edit a lead, person or any other dataset, changes won't be saved. After clicking save, everything is like before. This also applies to documents. If I upload a new version of a document, it is still the old version.
My system:
OS: Ubuntu 18.04
Webserver: Apache2 with fcgi
PHP 7.3
Hi,
with the latest update we ran into the issue of not being able to input decimal numbers anymore.
I cannot input the decimal number separator into fields because it says it's an invalid input.
In this particular case we use it for tracking the hours of support tickets. All old tickets still have correct decimal hours like '0.5' or '1.75' however now I cannot input decimal numbers anymore.
Hello,
with the New PHP Mailer a little issue ocours on Ticket Creation. For Example when a variable from name is in in $contact_id | $parent_id.
We Have a Workflow that fire E-Mail and in the Topic of the E-Mail is the Name of the Ticket Issuer this name will be for a ö = ö
again this issue ocours only when we have a variable in E-Mail Topic $contact_id | $parent_id normal words in that E-Mail Topic with ö ä ü will work like a charme.
Also the Issue will shown up in widget section of renetly change items but only for entry of event not in the Mail text as well.
with the old mailer it works without issue
Hi,
on the installation page there is a very small chapter at the end about updating the CRM:
From where do I get that diff? I am running version 1.0.0.22 currently and I want to update to 1.0.27 now. I don't know why I have a four-numbered version number and the latest version has a three-numbered version number but however. I am looking for a better guide for updating berlicrm. In the official forum I never got an answer to my question. So I will try my luck here.
Hi,
when can we except a compatibility to PHP 7.4?
PHP 7.2 will reach its end of life with the end of this year. PHP 7.3 is not supported yet if the installation page is right:
PHP 7.4 is one of the latest versions, PHP 8.x has just become available.
It would be nice to be able to upgrade to the latest PHP 7.x branch.
When setting up a scheduled report there are the intervals: daily, weekly, at specific date, monthly on date, yearly.
AS daily will send out this reports even on weekends, there should be an option "work-daily" (Mo-Fr). Or according to the users preferences: the following 5 days after the day when the week starts.
When adding a Attachment to a E-Mail and send it with MailManager the E-Mail will not saved in the Send Items (Gesendete Elemente) Folder
Without an Atachment it works ad E-Mail was saved successfully in Send Items (Gesendete Elemente) Folder
Anyway E-mails will send out Correct in both cases to E-Mail receiver
Hey there :) i found a small thing In the File PhoneDetailView.tpl in layouts/vlayout/modules/Vtiger/uitiges
in the html part with <a class="phoneField" it should take the $PHONE_NUMBER instead of fieldvalue:
$FIELD_MODEL->get('fieldvalue')}">
Best regards, Ralph
Hi,
I have some serious problems by Uploading Files / Documents over your Api, Maybe you can help me.
I´ve worked along side your Api Specifications Doc and it seems working. At least i can post Documents.
string fileValue = System.Convert.ToBase64String(photo.Photo);
Documents doc = new Documents();
doc.Title = "testTitle";
doc.AssignedTo = "20x4";
doc.FileName = fileValue;
doc.Status = "1";
doc.FileLocation = "I";
var request = new RestRequest(Method.POST);
request.AddHeader("content-type", "application/x-www-form-urlencoded");
request.AddParameter("operation", "create", ParameterType.GetOrPost);
request.AddParameter("sessionName", sessionName, ParameterType.GetOrPost);
request.AddParameter("element", NewtonsoftJsonSerializer.Default.Serialize(doc), ParameterType.GetOrPost);
request.AddParameter("filename", "Testbild");
request.AddParameter("elementType", "Documents");
var response = Client.Execute(request, Method.POST);
With this code i can Post Documents, even with the right details.
But from where and how do I have to send the picture.
It would be nice if you could help me.
Have a nice Day
Hi,
I just tried out the demo site: https://berlicrm.co.crm-now.de
And I am not able to switch to the correct dateformat. There are only the three styles the original vTiger offers. But I need dd.mm.yyyy
and in the past I always had to change a lot of PHP and JS files and even had to write some new values into the SQL database. Actually, I assumed that berliCRM could also handle the German date format.
Please add that format to berliCRM. You can find a well written guide to add the format to vTiger 6.0 here: https://support.stefanwarnat.de/en:modifications:german-dateformat
Hello
i have issue with some RSS Feed ive added a source to you Demo same result please check
https://berlicrm.co.crm-now.de/index.php?module=Rss&view=List&id=9
Hi folks,
when i try to merge data (updating) with an import the field "zuständig" / "responsible" will be overwritten with "Administrator".
Can anyone help?
Best regrads
Hello,
if we send E-Mails with latest Commit https://github.com/berliCRM/berlicrm/blob/364e540e4aae57e58c6b5048c5124e27a93287d9/modules/Settings/MailConverter/handlers/MailBox.php
over MailManager the Attachment will not shown under send items but if i send the E-Mail without attachment it shows up in Outlook
When creating an Event (Ereignis) with E-Mail notification ,
the system fails and does not send HTML , instead the following errors are printed:
array (
0 =>
array (
'file' => '/var/www/berlicrm-1.0.24/include/database/PearDatabase.php',
'line' => 365,
'function' => 'checkError',
),
1 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Calendar/Activity.php',
'line' => 746,
'function' => 'pquery',
),
2 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Calendar/Activity.php',
'line' => 260,
'function' => 'activity_reminder',
),
3 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Calendar/Activity.php',
'line' => 172,
'function' => 'insertIntoReminderTable',
),
4 =>
array (
'file' => '/var/www/berlicrm-1.0.24/data/CRMEntity.php',
'line' => 92,
'function' => 'save_module',
),
5 =>
array (
'file' => '/var/www/berlicrm-1.0.24/data/CRMEntity.php',
'line' => 852,
'function' => 'saveentity',
),
6 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Vtiger/models/Module.php',
'line' => 143,
'function' => 'save',
),
7 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Events/models/Module.php',
'line' => 29,
'function' => 'saveRecord',
),
8 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Vtiger/models/Record.php',
'line' => 230,
'function' => 'saveRecord',
),
9 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Calendar/models/Record.php',
'line' => 99,
'function' => 'save',
),
10 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Events/actions/Save.php',
'line' => 21,
'function' => 'save',
),
11 =>
array (
'file' => '/var/www/berlicrm-1.0.24/modules/Calendar/actions/Save.php',
'line' => 23,
'function' => 'saveRecord',
),
12 =>
array (
'file' => '/var/www/berlicrm-1.0.24/includes/main/WebUI.php',
'line' => 228,
'function' => 'process',
),
13 =>
array (
'file' => '/var/www/berlicrm-1.0.24/index.php',
'line' => 18,
'function' => 'process',
),
)
Error in processing vtiger_table vtiger_activity_reminder Query Failed:INSERT INTO vtiger_activity_reminder VALUES (?,?,?,?)::ADODB error Error in processing vtiger_table vtiger_activity_reminder Query Failed:INSERT INTO vtiger_activity_reminder VALUES (?,?,?,?)::->Incorrect integer value: '' for column berlicrm.vtiger_activity_reminder.recurringid at row 1
I'd like to convert a vTigerCRM 6.5 installation to berliCRM. How can this be done? Do you have any instructions? (maybe a script?)
Hello all,
With this change #488 , cannot save state of calendar feed type.
It updates the feed but doesn't save state. (Active or Inactive)
Hello,
if you make a workflow with conditiuons changed and as example more than 10 hours later workflow is not working
please have a look at this issue
From the draft list , a user cannot see if a mail is in draft state or already sent.
[https://crm.myinstance.domain/index.php?module=Leads&relatedModule=Emails&view=Detail&record=666&mode=showRelatedList&orderby=date_start&sortorder=DESC&tab_label=Emails](Example URL)
Please add a icon to the Email-Overview Table
Hello somthing happend with ModComments in latest Code.
Normaly you can do a new comment and a reply to a comment but with latest code you can reply to a comment but i will not show anymore as tree everytime now it is a new comment can you fix that please?
In the past releasee it was tree view, this bug is present in all ModComments Modules
When user edits an unsent email draft, the browser is more or less freezing
when using long text ( like base64 signature ), since the default text field ( that is too small either way ) ,
when user clicks "E-Mail preview" , browser works quick.
Also the WYSIWIG loads after some times, but first the tab is frozen.
Suggestion: search the mail draft for HTML ( or data:base64 tags) and hide source preview by default.
The default non-html edit field has 2 lines , so user cannot see anything and is annoyed by freezing.
Widget History show everything for all users, ex if i send one mail, other person can see that email.
Hello All.
Quick create events in calendar not working for custom fields.
To reproduce:
In events module add a new field and set to QuickCreate.
Go to calendar and create an Event in QuickCreate Mode.
Set or fill the new field previously created and press save.
Result:
All fields will be filled but custom field will be empty
Would be nice if you can make it possible to add attachments on heldesk module that can be send with comment to customer
would also be cool when it is possible to send calendar invite to person outside of vtiger with ics file for calendar Import to schedule meeting at the moment it is only possible to invite staff member without ics
In mailmanager click in trash folder gives the next error:
Uncaught SyntaxError: Unexpected end of JSON input
at JSON.parse ()
at Object. (MailManager.js?v=berlicrm-1.0.0.21:530)
at n (jquery.min.js:2)
at Object.fireWith (jquery.min.js:2)
at Object.fire [as resolve] (jquery.min.js:2)
at Object.success (Connector.js:101)
at n (jquery.min.js:2)
at Object.fireWith [as resolveWith] (jquery.min.js:2)
at w (jquery.min.js:4)
at XMLHttpRequest.d (jquery.min.js:4)
Hi,
Version 1.0.23 - if you try to send sms to 2 or more receipts via list view it´s not working. when you select 1 contact in list view it works properly, but as soon as there are 2 it doesn´t work.
Further there is also an encoding issue if you send sms from workflows. ä, ö, ü - works properly if you send sms directly from detail / list view
For our organization I added a field to the Tickets-View where we can put a link for our bug-tracking-system.
They have the form http://bugtracker/issue/x
. This hostname will not be accepted by the CRM, I must change it to http://bugtracker.intern.my-company.de/issue/x
to get accepted.
Can the requirement for the FQDN in links be removed?
It is not possible to Create a Newservicecontract at the moment, the procedure will finisch and the number wil change but no entry in the list also in db will this entry not written
Hello,
we're trying to install berliCRM on a server in our company, we enter all the required credentials, everything is marked as fine and as soon as it's installing, nothing else happens. When we tried vtiger before we had a loading screw (or however it's called, i'm german) and now we don't have anything at all (marked with the arrow on the screenshot). He creates the database (if wanted) but nothing else happens.
I saw in the Index.php of the install routine, that the part, where they create all the tables and stuff, is marked as a comment but i guess it's intended.
Is it normal that i don't see any progress or is maybe something wrong with it? I'll also include the index.php (wth .txt on the end because of github) from modules/Install/views.
Index.php.txt
Greetings,
today I tried writing a small C# application making use of the 'webservice.php' API.
So far the Retrieval of objects worked flawlessly however now I want to programmatically update a ticket via the API and it always returns a 403 with the message 'Permission to perform the operation is denied for id'.
I tried doing it manually with Postman, which failed and now I tried it with C# Code (together with RestSharp) and it returns the same error.
Is it broken right now or is there something wrong with the approach written about in these documents:
I leave my POST-Request body empty and supply a whole JSON representation of the object in the 'element' query string parameter.
I would appreciate some help.
Best regards and thanks in advance!
When editing Leads , the edit field is only 2 lines tall.
Please make at least 10 lines visible
Example URL: berlicrmdomain.lan/index.php?module=Leads&view=Detail&record=24&mode=showDetailViewByMode&requestMode=full
Hello,
found a little Bug, the Birthdays from Contacts are not Showing up in Calendar anymore i know this was working in the past
best regards
Would be possible to add attachments to calendar activities? I'd like to add attachments to new and/or existing task in the calendar like I can already do it for organizations or contacts.
Hello all,
After commit #488 quick create on calendar view fail with message:
{"success":true,"result":{"subject":{"value":"","display_value":""},"assigned_user_id":{"value":"1","display_value":"<a onclick='return false;' href=index.php?module=Users&parent=Settings&view=Detail&record=1> Admin<\/a>"},"date_start":{"calendar_display_value":"2021-01-21 10:30:00","value":"2021-01-21 10:30:00","display_value":"21-01-2021 10:30:00"},"time_start":{"value":"10:30:00","display_value":"10:30:00"},"due_date":{"calendar_display_value":"2021-01-21 11:00:00","value":"2021-01-21 11:00:00","display_value":"21-01-2021 11:00:00"},"time_end":{"value":"11:00:00","display_value":"11:00:00"},"duration_hours":{"value":"0","display_value":"0"},"duration_minutes":{"value":"0","display_value":"0"},"eventstatus":{"value":"Planned","display_value":"Planed"},"sendnotification":{"value":"0","display_value":"no"},"activitytype":{"value":"Other Activity","display_value":"Other Activity"},"location":{"value":"","display_value":""},"createdtime":{"value":"","display_value":""},"modifiedtime":{"value":"","display_value":""},"taskpriority":{"value":"","display_value":""},"notime":{"value":"","display_value":"no"},"visibility":{"value":"Public","display_value":"Public"},"modifiedby":{"value":"","display_value":""},"created_user_id":{"value":"","display_value":""},"contact_id":{"value":"","display_value":""},"parent_id":{"value":"","display_value":""},"description":{"value":"","display_value":""},"cf_782":{"value":"","display_value":""},"_recordLabel":"","_recordId":3323}}
Hello,
we noticed that some "related to" fields are missing.
For Example it is possible to Create Tickets or Link Tickets with ServiceContracts or Assets but in Tickets Module it self is not related field for taht you have to go to assets or Conmtracts and link the Ticket to it.
Also same Beahavior for Invoices and Assets in Assets Modul is no related field to link an Invoice
Hello,
fetched the latest changes on BerlISoftphone i don't know what is the matter now but. With old Style URL i got the two error's
index.php?module=berliSoftphones&view=List&phonenumber=0049123456789
Permission to perform the operation is denied for name
withnew URL Style URL index.php?module=berliSoftphones&action=ListPhone&phone&phonenumber=0049123456789
i got {"success":false,"error":{"code":"Handler not found.","message":"Handler not found."}}
If i Manual added berlisoftphone to ws_entity again the first url style is working again.
I recently had a problem uploading a file of 3,5MB for attaching to a document. The file could be uploaded, but did not apprear in the document, without any notice.
changing the CRM-parameter upload_maxsize
to 10MB raised teh limit displayed in the documents-bottom to 10MB, but the problem persists. I found the PHP-option upload_max_filesize
was at 2MB and after changing to 10+MB the upload was successul.
I suggest to combine the "max filesize" displayed at the documents-bottom to a test of both parameters mentioned above,
Cannot read property 'message' of undefined.
In Step "Initialize Database"
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.