K2 blackpearl

I have a form with a smartbox SMO used in a claims process. How do I build in a validation in a text field to check whether the claim number you're trying to enter does not already exist in order to prevent duplicate from being captured in the db? ThanksCoenie

I am trying to setup K2 4.7 and post setup I am facing issue K2 Service not able to start.In K2 management console the error is coming as server N____:5555 does not exists.I tried to repair the entire setup, result still being same, also I found Hostserver.server is not having any entry which is strange as DB is also getting created during installation process only.  Please advise if anybody faced similar issue!! Thanks in advance!

Client event destination is set and assigned but unable to find in worklist.The assigned destination user on impersonation and fetching worklist ,not able to see the task.Have a simlar client event which works but only this seems to not work.Any assistance here is greatly appreciated

Hi, I have a list displaying attached files, but the filenames are tiny. So you would think that i could go into the column and change the BODY font of my choosing, but alas it is Greyed out? Why can't the font be changed on a File column? Thanks

Is it possible to make the event notification email to be dynamic, based on data in Sharepoint list ?For example:The data in Sharepoint list column EmailText is the following:Upload {DocumentName} document, and due date is {DueDate}. {DocumentName} and {DueDate} are from another Sharepoint list, and I also have them in the workflow's Data Fields (Data field DocumentName contains DocumentA, Data Field DueDate contains 10/1/17). I would like the event notification email to replace {DocumentName} and {DueDate} with the value in the Data Fields, for ex:Upload DocumentA document, and due date is 10/1/17.  {DocumentName}  and {DueDate} are just 2 examples, it can be any Data Field. Is that possible ? Thank you.

Hi Guys,I work aound the Email Event to send email notification about the status of the approval process whether it has been approved or declined. Step-1: Now, I would like to send email FOR Approval or Declining the worklist item. User gets an email with message body as 'To action your task via email, respond with one of the following actions:ApproveDecline Once the user type the Approve and reply to the email , the task action should action accordingly and advance the workflow.  Step-2: Approval Task should be two parallel task. First one is the smartform activity and another one in parallel is email approval task. User can approve either through email or smartform and either one will advance the workflow to next approval task. Concept of parallel activity. Please help me find the resources or any guidance will be greatful to work on this scenario. Thanks a lot.

I am updating some forms to be used by different browsers and I have a couple of questions. Firstly I have identifred the following User Agenrts. When  I am setting up the conditional formatting do I put in each or do I combine them. Chrome: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2228.0 Safari/537.36Edge: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.135 Safari/537.36 Edge/12.246Firefox: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:40.0) Gecko/20100101 Firefox/40.1Safari: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) AppleWebKit/537.75.14 (KHTML, like Gecko) Version/7.0.3 Safari/7046A194A And secondly if these are used on a mobile device do I need to add anything further. I would be graetful for any advice Mant thanks Andrew  

Hi, I have 2 workflows on a SharePoint list. 1 workflow is set to fire when an item is created and 1 workflow is set to fire when a list item is updated. However, the 'updated' workflow is also firing when an item is first created.  Is this expected behavoir or should it only fire when an actual update has been made to the original item? I have checked the rules on the form to ensure that when it is creating the original item it isn;t doing it in staggered steps that could be construed as an 'add' and simultaneous edit' I am using K2 5, any ideas?  Thanks.

Anybody knows how can i obtain the product K2 Designer for Visio because i want import Visio diagrams to K2 Studio.Than you

Hi, I'm seeing issues with our SmartObject tester in K2 5+, I want to install a FileService broker, but our PROD version is acting up. Environments:DEV - 4.7PROD - A Clean install of 4.7 then upgraded to 5+.  DEV - 4.7 No issues Any ideas? This SmartObject tester is on my local machine which was installed with 4.7 as a side note. Thanks, 

I have created a smart form. And dragged the item view and list view in there. I have linked the list view to my smart object (using the SQL). The requirement is I need to write a few numbers in my textbox and when I click on the Save button (these are in the item view), it should update the row of the list view and also update the SQL database table by adding a row in there.I am stuck at this point.  

I've been at this a while now, I'm reading a boolean colulmn from a list of records. With that, not all the records have a value, thus some contain "NULL" during a looping process. Items without a value are to be orphaned and pushed back into the prior task to again be addressed. Within the Split Rule I've attempted the following: IF (Bool != scnull (Plain text)) THEN...----IF (ToString(Bool) = Empty String (text) THEN...----IF (Bool = True (True/False) OR Bool = False (True/False))THEN IF (Bool = True(True/False)) THEN Approve (Path) ELSE Deny (Path)  ELSE Orphan (Path) ----IF (Length(ToString(Bool)) >= 0)THEN IF (Bool = True(True/False)) THEN Approve (Path) ELSE Deny (Path)  ELSE Orphan (Path)  A Few others, but in the end whenever I compare my Boolean against a "NULL" I get either: String was not recognized as a valid BooleanOR Unable to compare values that are not of the same type  Any suggestions? I also though of creating a reference before hand and filtering out thos items in

I have a DateOfBirth field, on the form load I am fetching DOB of Customer and based on some check hididng and showing some fileds on the form.My Requirenment is to calculate the age based on DOB on form initializing and show/hide some fields. Please suggest me proper a way to calulate the age from DOB ?ThanksShubh

I am tryng to create a nested if statement for a form that will allow me to have a top level IF statment with a bunch of sub level IF statements within it. For example: IF(viewcontrol = 0){    IF(param = "a")    {        Do Something    }    ELSE IF (param = "b")    {       Do Something    }    ELSE IF (param = "c")    {       Do Something    }} That is what i am trying to achieve but the best I can do is something like this:IF (viewcontrol = 0)  AND IF (param = "a"){     Do Something}IF (viewcontrol = 0)  AND IF (param = "b"){     Do Something}IF (viewcontrol = 0)  AND IF (param = "c"){     Do Something} Is it possible to create a nested if like the first example i have listed?

 Has anyone found a clever way (via javascript etc) of hiding the approval actions from the drop down options selector on the Worklist webpart? We show users their list of tasks to action but we want them 'Always' to open the form to view it first before selecting 'approval etc' but users keep accidentally selecting the approval options from the dropdown 'before' opening the form and that closes the worklist item and so thisis causing a major issue in us being able to use tasks inside a workflow. I have out the webpart into a view so that I can customise it but there are no options for deselcting these options :-(      

Hi, Just curious, is there a specific way to backup the K2 DB (on local Server K2 DB) using SQL Management Studio, if so what are the steps and what options should be ticked? I am about to install a Fixpack and just want an extra safety net (already have other safety nets), but backing up the DB locally is something i wanna try as well. A step by step guide to create the backup via SQL Management Studio and which options to tick would be great. Thanks

Hi,Does anyone know how to uploat to k2 smartforms large (over 300MB) attachements and save them on shared network drive?I would be gratefull for any hints because i cannot find solution to this one.I'm affraid that saving bigger files using standard way would slow down server too much GreetingsWojtek Franczyk

Me, again. Looking around, I see plenty of references to doing this in Sharepoint, but we don't have K2 integrated with Sharepoint. I'd love to be able to use workflow to move a file from one network location folder to another. So, for example, if a file gets dropped into Folder A, as part of the workflow I'd like it to be moved to Folder B.   It seems as though this should be possible ... but I'm not imagining how to do it. Thoughts on the hypothetical? Rob   

Hi all, Anyone else have any problems installing the May update? When trying to update, it fails on this error: 1:0: ExecuteSqlScript.Execute: >> Logged Error: Script execute failed: System.Exception: Script execution exception: Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: 'TRY_CONVERT' is not a recognized built-in function name. 1:0: Component.ExecuteTarget: >> Logged Error: Target did not complete successfully: DataPatches693317 + 693502.sql Any ideas?

I would like the drop down to have a static value as the first choice and then populate the rest of the drop down dynamically from a smart object.   Ex. first entry is Other Check Number followed by all Check Numbers associated with a specific sub-account

1.Is it possible to show files that are stored file system on Windows on Smartform using "Content" control?2. Is it possible to store attachment files in a directory on file syste? Requirement is, scanned PDFs will be stored on a windows server. I need to show them on Smartform. Another requirement is, user will attach file on Smartform and they should be saved in file system in same directory.Thanks

Hello, i'm trying to execute the following line of code on a k2 blackbearl 4.6.11. SourceCode.SmartObjects.Client.SmartObjectList oSmOList = serverName.ExecuteList(smartObject)This is executing proberly on the Development machine. But, when attempting to execute the same function on production (which is running k2 blackbearl 4.6.11 as well) it returns System.Exception: Invalid archive type. Any suggestions on why this is happening? Thanks you.

Hey Folks! We had a very disturbing issue on our Production server which killed our business systems for a fixed interval everyday. Business was unable to compile thier work during this time and every user was complaining. The Server CPU utilization would spike to 80% and more and remain constant the entire interval of almost an hour. We investigatied on what was causing all this by using performance monitors and SQL Profilers . And finally the culprit was a group policy which would clear the cache and browsing history on every users machine exactly at a ascheduled time, which would trigger enourmous number of request on the DB Servers for SharePoint and K2 applications. This in turn choked the servers CPU utilization. Thanks 

HI in K2 designer I would like to refresh a view list based on a value from a different view that is in the form.my example when man days = 5 then show approver x in the views approvers list. if man days <= 4 then show all. What I need is a change event but am seeing it in designer, is this possible? this is a sharepoint list btw

I am developing a user form (version 4.7 ) which has the following requirements: Auto saving the data as the form is being completed; Time out after 20 minutes if there is no activity on the form;and save the ID as a 4 digit number i.e. 1 would be saved as 0001, then 0002, 0003 and so onCould anybody offer any advice on how I could achieve the above on my form Many thanks Andrew