Technical Product Forums

0 Abonnenter

3 Emner

4868 Samtaler

An areas to discuss Networks/Systems administration type questions about SuperOffice products. Ask product configuration type questions in the Administrator Forums (not here in the technical area).

Emner

info

All conversations (4868)

push_pin lock

Host onsite SuperOffice on Linux-based server operating system?

In this documentation Operating system | SuperOffice Docs it is only Windows server operation systems mentioned. Is it possible to host onsite SuperOffice on any Linux-based server operating system? If yes, I would appreciate more details.
Laimonas Oberauskis
2
1
27. jan. 2025 | 12.35 PM
Emne:
CRM Web Application

Seneste svar

No. SuperOffice currently uses .NET Framework, which is Windows only. Maybe in SuperOffice 12 or further down the line when everything has been converted to .NET Core. See this blog post for some more details
by David Hollegien
27. jan. 2025 | 05.51 PM
push_pin lock

Understanding logic in SearchEngine

I'm trying to understand how the SearchEngine work. What is the difference between the 2 searchengines below? I get 2 different results. In case  In the second case I get a row, where y_eb_eval_koder.x_ft_heading == '82', which it shouldn't be allowed to.   Case 1: String null; SearchEngine se; se.addField('y_eb_eval_koder.id'); se.addField('y_eb_eval_koder.x_ft_heading'); se.addCriteria('y_eb_eval_koder.x_ft_heading', 'Equals', '80', 'And', 1); se.addCriteria('y_eb_eval_koder.x_eb_post', 'Is', null, 'Or', 2); se.addCriteria('y_eb_eval_koder.x_eb_post', 'Equals', '0', 'And', 2); se.buildSql() gives: select a0.id, a0.x_ft_heading from y_eb_eval_koder a0 where a0.x_ft_heading = ? and (a0.x_eb_post is NULL or a0.x_eb_post = ?) //reducing parantheses select a0.id, a0.x_ft_heading from y_eb_eval_koder a0 where a0.x_ft_heading = ? and (a0.x_eb_post is NULL or a0.x_eb_post = ?)   Case 2: String null; SearchEngine se; se.addField('y_eb_eval_koder.id'); se.addField('y_eb_eval_koder.x_ft_heading'); se.addCriteria('y_eb_eval_koder.x_eb_post', 'Is', null, 'Or', 1); se.addCriteria('y_eb_eval_koder.x_eb_post', 'Equals', '0', 'And', 1); se.addCriteria('y_eb_eval_koder.x_ft_heading', 'Equals', '80', 'And', 2); Using se.buildSql() and reducing parantheses again, I get this: select a0.id,a0.x_ft_heading from y_eb_eval_koder a0 where ((a0.x_eb_post is NULL or a0.x_eb_post = ?) and ((a0.x_ft_heading = ?))) //reducing parantheses select a0.id,a0.x_ft_heading from y_eb_eval_koder a0 where (a0.x_eb_post is NULL or a0.x_eb_post = ?) and a0.x_ft_heading = ?)   Trusting the printed SQL I end up with the following: Case 1 : select a0.id, a0.x_ft_heading from y_eb_eval_koder a0 where a0.x_ft_heading = ? and (a0.x_eb_post is NULL or a0.x_eb_post = ?) Case 2 : select a0.id, a0.x_ft_heading from y_eb_eval_koder a0 where (a0.x_eb_post is NULL or a0.x_eb_post = ?) and a0.x_ft_heading = ?   Isn¨t those the exact same expressions, just with the 2 where-statements switched?  

KR

Kasper Rosenlund
5
8
19. jun. 2024 | 01.51 PM
Emne:
CRM Web Application

Seneste svar

Hi, I've encountered the issue Kasper is describing quite a bit, and it's a little annoying. 🙂 Also some clarification here would be great. Is Kasper right in that this: cred.addCriteria('y_eb_eval_koder.x_password', 'BeginsWith', 'mx', 'Or', 1); //Crit A cred.addCriteria('y_eb_eval_koder.x_password', 'BeginsWith', 'zw', 'And', 1); //Crit B cred.addCriteria('y_eb_eval_koder.x_ft_heading', 'Equals', '80', 'And', 2); //Crit C is supposed to correspond to: (A OR B) AND C , but it's not working correctly because of this bug: https://community.superoffice.com/en/product-releases/bugs-wishes/product-issue/?bid=25596&azure=1 ? I see that using "in" is proposed as a workaround, but that only works for Integers as Kasper also points out.  Any chance the bug will be corrected some time soon?
by Espen Steen
23. jan. 2025 | 01.25 PM
push_pin lock

SQL Server 2022 - Core(s)/mimimum for around 120 users

Not sure if this belongs in this forum, but: Consider a installation, planned for upgrade to V. 10 with about 120 users (on-premise). Currently running on a 2017 SQL. With it reaching EOL, customer is considering SQL 2022 (Standard) Considering lisensing per core. What are the mimimum/suggested # of cores that should be considered ?   regards      

ES

Eirik Simonsen
2
1
6. jan. 2025 | 12.16 AM
Emne:
CRM Web Application

Seneste svar

How many cores would greatly depend on the indivual core speed. No clear answer to give here. My general advice would be for a setup of 120 users: 2 servers/vm's, one database, one web/app Database server should have atleast 4 cores, 2,5 ghz (or greater), more importantly, make sure it has enough RAM, ideally enough to fit the whole database in RAM + some extra for Windows Application server with 4 cores, 2,5 ghz (or greater), 8 GB ram or greater, make sure that you configure to use the batch task service, so that background operations are not done by IIS. Seperate file server/drive for the SO ARC Use the build-in performance report of SSMS to look for optimizations opportunities. 
by David Hollegien
10. jan. 2025 | 10.04 AM
push_pin lock

SOProtocol: Open dialog and automatically add person, company and sale

Hi, We are working from a webpanel on the SuperOffice logo, and we need to open the dialog window to create a new appointment with pre-filled data. We can open up specific appointments just fine with: SuperOffice.ClientCrossMessaging.executeSoProtocol('appointment.main[refresh=false]?appointment_id='+id);   But, when running the following code, the Sale is not populated (but, it works when we are actually standing on the sale in the gui) SuperOffice.ClientCrossMessaging.executeSoProtocol('appointment.main[new=true]?appointment_id=0&sale_id=12345'); How can this be achived? Regards Pär Pettersson
Pär Pettersson
3
11
6. nov. 2024 | 03.35 PM
Emne:
CRM Web Application

Seneste svar

Got it working with: SuperOffice.ClientCrossMessaging.openDocument(id); The postMessage didnt do anything, i guess its because of Cors since the code is running from another domain in an webpanel on the superoffice logo. All good, thanks alot for your fast response! Regards Pär Pettersson
by Pär Pettersson
16. dec. 2024 | 08.33 AM
push_pin lock

Question regarding marketing module

Hi, When will the old SuperOffice marketing template stop working? I am quite sure I have seen som notice about that the old marketing template editor will stop shipping in some version? But I can not find that information again. Anyone having informatiion about this? I have developed 3 templates long ago to a customer and need to rebuild them if they will not work anymore (10.3.3) seems ok. Is it possible to convert them to new editor somehow or do I need to create them from scratch. //Anders
Anders Larsson
1
2
7. okt. 2024 | 03.08 PM
Emne:
CRM Web Application

Seneste svar

I guess the old maileditor will exist at least until SO 11 is shipped? Docs b4 had information about the old editor but can just find information about the new editor (10.3.5 +) SuperOffice Marketing | SuperOffice Docs So the questions remains unanswerd: When will old version dissapear? Will it be possible to convert from old template format into new format?
by Anders Larsson
29. nov. 2024 | 09.52 AM
push_pin lock

Hiding and showing Custom Fields

Hi,   I would like to know if it is possible to Hide/Show custom Fierlds based on the value of the fields? If the field is empty, then hide it otherwise show it to the enduser.   Thanks   /Siavash
Siavash Taghizadeh
0
1
4. nov. 2024 | 01.54 PM
Emne:
CRM Windows Application

Seneste svar

Hi Siavash, You are asking this in the Windows Application form, which is a legacy product and not recommended anymore. The Windows product, and onsite web application, did support custom sentries in NetServer (the application server) which would provide the level of control you ask about.  There are no custom sentry capabilities to control the visibility of fields based on a field value in the online platform. It is a big wish from integration and customization audiences. The current and future of UI customization options are defined in the Screen Designer area of SuperOffice. Best regards.
by Tony Yates
5. nov. 2024 | 07.42 AM
push_pin lock

Using SSO login from Microsoft in web panels

Hello!  When I use a SSO login.microsoft.com I get an error saying " The loading of “ https://login.microsoftonline.com/common/oauth2/authorize? .... in a frame is denied by “X-Frame-Options“ directive set to “deny“. I understand that this is by design, but are there anyone that have solved this in some way, and they want to share it? Regards Martin
Martin Andersen
4
5
3. okt. 2024 | 10.17 AM
Emne:
CRM Web Application

Seneste svar

Neither Microsoft/Google allow SSO auth inside an iframe. Using a javascript library that opens a popup, as David stated, is the most common solution. I hoped we could provide such a library/solution, but haven't the resources. A potential community project would be nice? An alternative is to open the authentication process in a new browser tab and perform the authentication there, then somehow (websockets?) refresh the web panel.  Best regards.
by Tony Yates
7. okt. 2024 | 01.45 PM
push_pin lock

Error during integration of SO forms as plain HTML into CMS Drupal

Hello SuperOffice team, We are currently trying to integrate a SO form as plain HTML into our CMS Drupal.  However, our agency gets this error message when trying to integrate the form. Do you know why we get the error message and how we can solve the problem? Many thanks and best regards, Zornitsa Nenova

ZN

Zornitsa Nenova
2
5
26. aug. 2024 | 07.09 AM
Emne:
CRM Web Application

Seneste svar

Hi, No, the screenshots you provided show that the way that you are including the form is the correct way, only think that i can think of is that you have other javascript included on the page that interfere/override functions used in form processing.
by David Hollegien
25. sep. 2024 | 07.42 AM
push_pin lock

On Premise support from the new Outlook web app

Hi All, I have been advised by Guttorm to log this query on community, and it relates to the new Outlook web application, which users are getting prompted to move to.  Currently with this web app you can only archive emails to the online version of SuperOffice, however our on-premise customers are asking when this will be available for them.  Do we have any updates on where this is in the development roadmap? Many thanks, Trevor
Trevor Sharp
8
11
19. maj 2023 | 11.11 AM
Emne:
CRM Web Application

Seneste svar

I understand, maybe someone from product is reading along with us. 😄
by David Hollegien
20. sep. 2024 | 11.36 AM
push_pin lock

SuperOffice / Sharepoint using internationam M365 Tenants

Dear all, One of our customers has several international branches. Two of these countries work with SuperOffice using the same tenant. We are currently trying to move the documents to Sharepoint but are having problems with our colleagues from abroad. In the Microsoft world we have different tenants per country. The authorizations are set so that the AT colleagues can see and edit the documents on the GE Sharepoint. Unfortunately, SuperOffice does not seem to support this, ALL users with user plan must be in the same Microsoft Entra subscription . We made some tests to see what happens. Transfer to sharepoint worked fine. The AT users can open and edit the documents from SO. Our only problem is that the AT users cannot create new documents. They get a 400 error. Has anyone had this problem and solved it? Thanks in advanced Georg
Georg Diczig
1
0
24. jul. 2024 | 06.46 AM
Emne:
CRM Web Application