Administrator forums

0 Abonnenter

5 Emner

151 Samtaler

Did you get stuck with the setup of SuperOffice CRM? Do you need inspiration on how to automate the work process or simply get more of your solution? Here is the place to post questions, share tips and workarounds and help others.

push_pin lock

Navigation button - Change url of current window

Is there any way for me to create a Web GUI that is visible as a navigator button, that changes the url of the current window? The default behaviour is to navigate to the specified url in a new window, but I would like to change my current one instead. 

BM

Beata Martinsson
1
0
0 m siden | 03.03 PM
Emne:
Settings and maintenance
push_pin lock

TAGS in tickets

Hi, I have created some TAGS for our tickets in SuperOffice (Service).  How can I delete old TAGS that are no longer needed?  How do I correct any errors in the TAGS that have been created for use? Is there a list somewhere that contains the TAGS that have been created? Thank you in advance.

BB

Betina Bruun
3
3
30. okt. 2024 | 10.49 AM
Emne:
Setting up and administrating Service

Seneste svar

Hi Betina, Also note that in the Admin client we have a setting for which user "Roles" are allowed to add new tags directly in the user interface, without using the Admin client (Settings & Maintenance). You may want to restrict access for standard users to be able to create new tags on their own directly in the user interface. Maybe users should only be able to suggest new types of Tags, and then an system administrator creates the new Tags directly in the list...
by Susan Laugaard Hansen
3 t, 4 m siden | 11.59 AM
push_pin lock

Adding a task via SQL

Working on getting some very custom intigrations working again after an upgrade from 8 to 10. I originally had some code that added Appointements to projects that worked using the old VBScript toolset. Now I wanted to switch this over and just add it using straight SQL  (Microsoft SQL) When I do this I create the record in the APPOINTMENT table with an ID of the MAX Current ID +1 Then Create the record for that ID in the TRAVELTRANSACTIONLOG  for that ID. I make a record in the VISIBLEFOR table and again the TRAVELTRANSACTIONLOG table according to the documentation. Everything is displayed correctly but I can not add a new Appointent in the UI till I delete it. Assuming because it is trying to add it with the ID I just added. Is there another table controling the IDs I need to update so the system will grab the next avalaible? The Table COUNTERVALUE is completly empty. FYI Thank You, Jeff
Jeff Bade
2
2
12. dec. 2024 | 06.43 PM
Emne:
Settings and maintenance

Seneste svar

I need to be able to access a SQL Table in another database which I was told I can not do in CRM-script. Which is why I was looking for alternative methods and was just going to go straight SQL instead. We will never migrate to SO online as we have way too many customizations and the SO database is tied very closely to another in house DB. So not worried about that ever. I think this solved it for me once I make these changes. Thank you, Jeff
by Jeff Bade
12. dec. 2024 | 08.45 PM
push_pin lock

UDEF-Tables: from ProgId to column name in DB

Hi there,   I was wondering where exactly in the database I can find the link between a custom field (ProgId) and the corresponding column name in the database. For example if I have a custom field "SuperOffice:45" for the person entity, how do find out the column name in the UDPERSONSMALL table (e.g. "long06")? Unfortunately, none of the system tables (sys.columns, sys.tables etc) seem to map directly to the info found in the UDEFFIELD table and I was unable to locate any dedicated mapping table. We do regular bulk updates of custom fields and for now the only way to find out the right column name is by changing the value in the UI and checking for differences in the UD-tables.   Any hint would be greatly appreciated!

HW

Holger Winkelsträter
3
5
9. okt. 2024 | 09.27 AM
Emne:
Settings and maintenance

Seneste svar

Hi Tony, sorry, just noticed there was another reply - that also comes in very handy, thank you very much!

HW

by Holger Winkelsträter
22. okt. 2024 | 09.50 AM
push_pin lock

Batches Online

Hello! I am trying to figure out how to write handle batches in CRMScript for the online version of SuperOffice. I am trying to update a custom field on all contacts in my database using a few if-statements, but the database is too large for me to be able to run it all at once. The problem is that I want this code to run once a week, without me having to go into the script, tell the code to run the first 100 companies, then the next 100 companies and so on. Is there any way for me to be able to create a shedueled task each week, and tell the schedule to run one script many times, and for the database to somehow know how many times the script has run, and therefore how many companies it has completed before, and how many times it should run again? Below is some pseudocode for how I wish for it to run, but I don't know how to actually write the code or if it is even possible: SearchEngine se; se.AddField(Information about all companies); se.setLimit(100); se.criteria(currentCustomerId > lastHandeledId) //This is where the problem lies se.execute(); and then some code for changing the custom fields based on the information Is this possible at all, and how? Thank you in advance.

BM

Beata Martinsson
2
1
1. okt. 2024 | 02.38 PM
Emne:
Settings and maintenance

Seneste svar

Hi Beata, if a customer has development tools so you can actually write CRMScript, it also means they also have the subscription needed to create  custom apps  and you can use the WebAPI directly:  https://docs.superoffice.com/en/api/netserver/bulk-operations/index.html https://docs.superoffice.com/en/api/netserver/search/odata/index.html It's a lot faster since the CRMScript code actually gets translated into the same archives behind these API calls when executed https://docs.superoffice.com/en/api/netserver/search/odata/index.html Other benefits of using the APIs instead of the CRMScripts: If it fails you will see the exceptions linked to your apps credentials inside the developer portal: https://docs.superoffice.com/en/developer-portal/analytics/failures.html You are not limited by the 2 min timeout we have on CRMScripts running in our Online environment. More info on what you can do with CRMScript and its limitations:  https://docs.superoffice.com/en/automation/crmscript/overview/crmscript-usage.html
by Margrethe Romnes
2. okt. 2024 | 07.50 AM
push_pin lock

Appointments alarm keep showing.

Hi (On Premise 8.3) I have a single user that has the alarms windows popping up all the time. If I remove the applointment from Outlook and wait for sync, the next appointment will do the same.  Has anyone seen this behaviour?
Jens Skov
2
9
19. okt. 2020 | 12.00 AM
Emne:
SuperOffice add-ons

Seneste svar

Hi Samuel, Thank you for your suggestion. This works smoothly - all SuperOffice reminders are now without sound on my PC.
by Susan Laugaard Hansen
26. sep. 2024 | 10.45 AM
push_pin lock

Quote template for Assemblies

Some companies sell products that are assemblies.  In context assembly means that you have a main component, (always), and, that you on top of that, have several optional parts (some that are mutually exclusive - but set that aside for the moment). when entering products in the quote calculator itself, these parts have a price, and the combined assembly will then have a total price. However, the quote document should ideally have the main component as item one, ideally with a larger font, and the parts should be listed below in a separate section, possibly with a smaller font/colour, or some other type of visual to separate the parts from the main assembly,  and the price should be a total (turn key) price. Is the only way to do this, only possible using conditional formatting in word in the template itself, ie IF product type = MainComponent, then: etc or is there something in SO that can be used.  Are there some examples that anyone can share.?  

ES

Eirik Simonsen
2
0
5. sep. 2024 | 02.40 PM
Emne:
Settings and maintenance
push_pin lock

Is screen designer for the document dialogue on its way?

Hi, Is the document dialogue by any chance to be added to the screen designer? Best regards, Jan
Jan Bonde
4
6
2. jul. 2024 | 10.52 AM
Emne:
Settings and maintenance

Seneste svar

Thanks!
by Jan Bonde
14. aug. 2024 | 08.31 AM
push_pin lock

Service user attendance schedule

Hello, Does somebody know if it's possible to create an attendance schedule in de the service module? For example: We have only part-timers, so every week on the same day we need to manually change the status from "normal" to "away". And often they forget it, so the requests are also distributed to employees whom aren't available. The goal is to let the system automatically set the availability of the users per their working days.

NG

Nikki Galis
1
0
31. jul. 2024 | 07.02 AM
Emne:
Users and user right management
push_pin lock

Udefs on Sale missing/invisible in Settings

this is a SuperOffice CRM OnSite 10.2 Release_OnSite_10.2.1_2023.01.31-02 I received a call after quite a long time since last that my contact wanted to add/edit some udefs on a sale card. Note below for current page in regular program:   However; switching to settings, there are no visiblle fields:     Thre are however visible fields as it concerns the company udef page:     suggestions welcome.

ES

Eirik Simonsen
2
9
4. jun. 2024 | 05.43 PM
Emne:
Settings and maintenance

Seneste svar

Most likely, to be able to add any other field you will need to remove 1 number field.
by David Hollegien
7. jun. 2024 | 09.36 PM