In the database documentation there is a relation described: ticket - ej_message - ticket_attachment - attachment  Problem: I have a lot of tickets and attachments, but table ej_message is empty. But in the CS interface all data is shown the right way. I tried to join like below, but that seems to be the wrong relation. What is the right way? select  .... from crm7.ticket t1 left join crm7.TICKET_ATTACHMENT ta1 on t1.id = ta1.message_id left join crm7.ATTACHMENT at1 on ta1.attachment_id = at1.id   Thanks for some info

Hi,   I have create a HtmlElement table in Custom Screen linked to Sale Section Tab to list some special Documents of current Sale. It works fine. User select one Document and click Button to download this file in background. The Implementation to this Button for Download works also. The Problem is, after File downloaded it's  still running sth. in Background so that the Page keeps still endless inactive. Does someone has same Experience what's runnning here and How I can fix?   Many Thanks!

Hi fellas, Im looking for help from you old-school onsite folks with an extremy odd issue. An onsite (belive me, we are pushing for them to migrate..) have the issue that neighter them, or their customer can see some images using customer.fcgi, but, using rms.fcgi as an logged in agent works fine. It also seems very random, in the same ticket, some images works, and some does not. For example the logo from the customer works in one message, the exact same logo doesn´t in the next. Fetching the base64 from Attachment works just fine and is the correct image, as well as renaming the file from /attachments Scenario:  An external ticket, the message is external. Running: http*://XXXXXX/service/scripts/ customer.fcgi /getAttachment/2133444-c9lqX8IQjZNj7p8J0EMhq2g4xdhK8R9opUiaH7L8Sp0GMOeGTPd9njEpWyBJhiJP-0/image002.jpg returns a 401 But, running http*://XXXXXX/service/scripts/ rms.fcgi /getAttachment/2133444-c9lqX8IQjZNj7p8J0EMhq2g4xdhK8R9opUiaH7L8Sp0GMOeGTPd9njEpWyBJhiJP-0/image002.jpg works just fine. SuperOffice: 10.2.5 Pretty standard setup, SSO, Sales in the same site, no split attachments, old customer from around ~v.6.x Clues: The customer told me that they also have noticed that an image can work just fine, but, after some mails back and forth to the customer, the previous image(s) starts behaving this way. Can be reproduced in test enviroment. Database entries: Attachment_path: C:\SuperOffice\Service\attachments cgi_bin: /Service/scripts cgi_url: https://....se cgi_url_internal: https://....se Path or URL to www folder: /Service/ Big bag of swedish candy for anyone that have an idea, im loosing my mind here :) Edit: tried turning of SSO, users are promted with login, but, still customer.fcgi does throw a 401 Regards Pär Pettersson

Hi All, I am writing a script to create an appointment 15 mins from now when a SuperOffice form is processed.  However when I initialize a datetime variable it is setting it for 1 hour in the future.  I have written a test script below to show the issue. #setLanguageLevel 4; DateTime now; print (now.toString() + "<BR>"); TimeZone ltz = getLocalTimeZone(); print (ltz.getTimeZone() + "<BR>"); print (ltz.getTimeZoneSecs().toString()); If I run this script on my test on-premise environment, these are the results I get. If I run the same script on the customer's online environment, I get the following results. I originally thought it was because Timezones, were not enabled on the customer's environment, but I have enabled these, and the system default, and my personal default is  set to "United Kingdom", as it is in my test system, so I don't understand whilts I am getting different results.  It may be because my on premise server is hosted on a server configured for the UK, whereas the online environment would be, I assume, configured for Norway, and I guess British Summer Time is also causing part of the issue.  But how do I get the current datatime for the UK, that will work all year round, both in and out of BST. Many thanks, Trevor

Hi! I am trying to send a mail from trigger and would like to use the built in function ticket.sendMessages The documentation in that function lacks a complete example I think?  I am struggling with creating a correct StringMatrix of the recipients. It would be nice with an complete example actually showing how to create a stringMatrix and other parameters and code for actually using the sendMessages function. Does anyone having an example I have tried this: == String strSendMatrix ="To | Anders Larsson <anders.larsson@amesto.se>"; StringMatrix SendMatrix; SendMatrix.addCell(strSendMatrix); String MessagesId = m.getValue("messageId"); Bool SendTicketStatus = t.sendMessages(t.getValue("ticketId"),SendMatrix,true,MessagesId,-1,"TestHeader"); == But geting : Index out of range exception //Anders

Hi, We have a major problem regarding saving documents for a company, its a bit of a "come and go" issue that has escalated for the last few days. The problem is that NSDocumentAgent saves the wrong document, and directly after its saved, it says that the document has been checked out by another user, (that does not have anything to do with the sale, or customer, or even country) We have the exact same code in multiple enviroments, but, its only happening for this customer. They are using Webtools, and SO for documents. The code NSListAgent listAgent; Byte[] TheFileInByte = decodeBase64(getCgiVariable("base64")); NSDocumentTemplate documentTemplate = listAgent.GetDocumentTemplate(346); NSContact contactEntity; contactEntity.SetContactId(MyContact.toInteger()); NSPerson personEntity; if(personId != "") personEntity.SetPersonId(personId.toInteger()); NSSale saleEntity; DateTime now; NSDocumentAgent documentAgent; NSDocumentEntity documentEntity = documentAgent.CreateDefaultDocumentEntity(); documentEntity.SetName(saleName + '.docx'); //documentEntity.SetHeader('Abax-OrderProposal-v' + NewVersion.toString()); documentEntity.SetHeader(saleName); documentEntity.SetContact(contactEntity); documentEntity.SetPerson(personEntity); documentEntity.SetSale(saleEntity); documentEntity.SetDate(now); documentEntity.SetDocumentTemplate(documentTemplate); NSAssociateAgent associateAgent; documentEntity.SetAssociate(associateAgent.GetAssociate(assId.toInteger())); NSDocumentEntity FUSO = documentAgent.SaveDocumentEntity(documentEntity); DocId = FUSO.GetDocumentId(); NSStream stream; stream.SetStream(TheFileInByte); documentAgent.SetDocumentStreamFromId(DocId, stream); It crashes with the following message: NetServerException: NetServer exception: Service call Document.SetDocumentStreamFromId failed Document ID 2487527, extref is locked and not checked out to current user Checked out by <another user> But, the document is created, and, the content in the file is something else, in this specific case, a quote from 34 days ago, for another customer, another sale and has nothing in common with the document created, or hasnt been opened or modified since it was created. And, we have verified that the base64 that comes in is in fact the document we wanted to save. Anyone have any experience or ideas regarding this? Regards Pär Pettersson

I have a Custom button linked to a CRMscript/Edit Contact that pops up up a dialog box to select a name based on whatever was first typed in the Name field, this works however then updating the contact name does not work. There is no Trigger that can be used for this scenario, please help       I have tried: ed.setOutputValue("ContactEntity.Name", "TEST"); getHtmlElement('Name').setValue("TEST"); ed.setNavigateTo("javascript:document.getElementById('Name').value = 'TEST';"); setVariable("url", "javascript:document.getElementById('Name').value = 'TEST';");