Widget History show everything for all users, ex if i send one mail, other person can see that email.

Hello,

when Adding a new Document, the folernames are not sorted by name.

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.

The E-Mail Converter doesn't save Folders in Database.
He is also not able to scan the folders as well.
When i add a Folder manually to database, he mainly grab the mails, but doesnt mark the e-mails as read.

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

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.

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

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.

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

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?

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,

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.

Drag images Upload success image but doesn´t display image with error
"HTTP error occurred during file upload (403: Forbidden)."

Check...

Hello,

when i set up for example 10% Rabatt for an Item it does not show up in overview of the quote

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}}

With the new Calendar Commits it will get Errors under shared Calendar in the Overview

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,

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

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

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,
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:

• http://blog.crm-now.de/doc/rest/REST_Tutorial.pdf
• https://blog.crm-now.de/doc/rest/berliCRM/berliCRM_REST_API_Specification.pdf

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!

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

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

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)

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

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.

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

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,

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.

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.

Example URL: https://crm.myinstance.com/index.php?module=Emails&view=ComposeEmail&selected_ids%5B%5D=48&record=23&mode=emailEdit&parentId=21&relatedLoad=true

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

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

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

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

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

HI I just realized a mismatch between the "saledate" field of the asset-management and the relating helptext (at least in German language).
The field is defined as "date entered must be today or before" the help-text is "should be today or before"

This should match to each other.

Hello all,

This is not a bug but a request!

Bring conditions calculations based on dates for listview filters like "more than x days", "in less than x days", "days ago",
that is already present in Workflows conditions.

Many thanks
Alba Marie

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

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

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

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?)

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.

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 the Module "Einkaufsbestellungen" there are some currency-fields where the decimal part is not always 2 digits.
In the Screenshot you can see 2 fields where "€ 141.3" is printed, but "€ 141.30" is expected.

Hi,
on the installation page there is a very small chapter at the end about updating the CRM:

• get a diff and update all berliCRM files which had been modified or added, this will apply all file changes

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.

This is the footer of my current installation:

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

Cannot read property 'message' of undefined.

In Step "Initialize Database"

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)