K2 blackpearl

Hello,  I am trying to create a smart object to bulk upload a csv file to a database to allow users to upload and download multiple data points at once. Does anyone have any experience doing this? Do you know what method could be used? The sql code would hopefully follow BULK INSERT [ database_name . [ schema_name ] . | schema_name . ] [ table_name | view_name ] FROM 'data_file' [ WITH ( [ [ , ] BATCHSIZE = batch_size ] [ [ , ] CHECK_CONSTRAINTS ] [ [ , ] CODEPAGE = { 'ACP' | 'OEM' | 'RAW' | 'code_page' } ] [ [ , ] DATAFILETYPE = { 'char' | 'native'| 'widechar' | 'widenative' } ] [ [ , ] DATASOURCE = 'data_source_name' ] [ [ , ] ERRORFILE = 'file_name' ] [ [ , ] ERRORFILE_DATASOURCE = 'data_source_name' ] [ [ , ] FIRSTROW = first_row ] [ [ , ] FIRE_TRIGGERS ] [ [ , ] FORMATFILE_DATASOURCE = 'data_source_name' ] [ [ , ] KEEPIDENTITY ] [ [ , ] KEEPNULLS ] [ [ , ] KILOBYTES_PER_BATCH = kilobytes_per_batch ] [ [ , ] LASTROW = last_row ] [ [ , ] MAXERRORS = max_errors ] [ [ , ] ORDER ( { co

Hi, we are experiencing a strange issue whilst trying to deploy the K2 Smartforms application onto our SharePoint site. We run the AppDeployment.exe wizard to install the app, which completes successfully. However, the app does not show in the SharePoint add an app section. We are running SharePoint 2016 on Windows Server 2016. The K2 Blackpearl server is 2012. K2 Smartforms version 4.16060.2000.3. Im not sure what we are doing wrong? Thanks. 

If you have upgraded to K2 Five or installed it. Please share your experiences. What you like and what you don't like about it? I understand K2 put a signifcant amount of effort and resources on K2 Five. Personally, with any applications/tools, I tend to wait till a new release is stable. Do you consider K2 Five is stable enough for production systems?Thanks

 I am facing an issue in K2 package deployment to SharePoint list. I am getting below error message while deploying the package. I have created the target site using site template of source site. The schema of the site is exactly same as source. Error Message: "Form is referencing the 'Guid' property on the 'Field Name' Control that could not be found". Any suggestion is highly appreciated. NOTE: Using K2 Blackpearl 4.11 (Latest version) Thanks,Prafull

This is a heads up for all those in the middle of moving email to o365.    If you are running K2 BlackPearl in an on prem environment, the chances are your spam filter settings for smart actions in hostserver.exe.config is set to the default which is accept from local domain.     If this is the case and you move mail boxes to o365 this will break smart actions, this is because the filter is looking at the email headers sending server info and when your mail boxes where on prem this would have matched the spam filter rule. o365 sending servers contain no information about your local domain and you will find that smart action throws a spam error in your event logs.     Unfortunately and recently confimed by K2, turning the spam filter off and adding <AuhtorizedDomains> to the relevant section on hostserver.exe.config will not help. You may be able to re-establish your smart action functionlity by the adding authorized domains found in the message header, but as far as I can tell an

1) I have created a view "Comments" to get user comments 2) I have a form with Submit button. User clicks the Submit button to action the workflow In form rules > when Submit is clicked > I am performing following tasksa) Open "Comments" as subviewb) show a Message When I run the form and clik on Submit button, it opens the subview and immediately shows the Message (b) without submitting a comment in the subview. I want, when I Click Submit button on the form,1) Open the Comments as subview then stay until I submit a comment in that subview, Once comment is submitted, then2) show a Message How can I achieve this please?

Hi all, Anyone know if it's possible to put a reason in the Offline Approval process? Form is sent for approvalApprover gets k2 emails saying reply to email with "Approve" or "Decline". How do you get them to Decline and then put a reason in? Thanks

Hi, I have upgraded to 4.7. One user is constantly getting "Your Browser is not Supported " Message when he tried to access the task form.   Can anyone suggest any solution. this issue occurred for that user frequently. user is using latest IE version. Thanks. Regards,Hemant 

How can you use a value in a List View to look up information stored in another SmartObject?  Each row in a List View has a column value that we want to do a lookup on in order to get related information which we can then show in another column on the same row.    Specific information:  We are leveraging the 'Activity Instance Destination' SmO to show a list of tasks and statuses in a View.  The 'Destination' column (once trimmed) provides us with the Username of the person who has actioned a task.  We want to take that value and get the Display Name, etc. from an Active Directory SmO that we are already using in other Views.  For some reason we cannot set up a Rule that takes the 'Destination' value of each row, does a lookup, and sets an extra column on the row named 'Display Name'.  Has anyone been able to get this working with the same SmO or in a similar situation?     Thanks! 

Hi Everyone, My organization is using K2 Blackpearl which is installed on Sharepoint. I am wondering that how can I connect k2 with JIRA Cloud? My goal is to update a JIRA field when k2 updates: Eg, K2 status is Pending Author review -> Pending Content Review. Then the JIRA will automatically update the field. Anyone knows how to do this? I asked a k2support staff, he said one of his customers has achived this by using REST API. I am not sure what is the start point to do so.... Help Needed.... Thanks,Jennifer.

Hello guys, How can i be able to input the user task action(workflow) into the dropdown list that i have created in my smartform. Workflow Rule Note: I will require the smartform as the manager will have "Update Score" action Thanks. 

I have SmartObjects that I want to expose to an external party as an API. How is this done?

There was a form that I wanted use the submit button to execute a Smartobject create method, but only if a check box was checked. The submit button worked prior to adding the check box, with the data populated my Smartobject.  I'll show you what my issue is and how I solved it, I hope you can learn from my mistake.     I assumed the value of the check box was yes or no. Based on the icon next to the Data Type.       I created a rule that would execute the create method, when the button was clicked, if the value of the check box was Yes, like the icon.       The button did nothing, and it did not matter if the box was checked or unchecked.   It was suggested to me to check the value of the check box by adding a Data Label to transfer the check box data to.  That way I can see what the check box was evaluating to.      I added the Data Label to my view with rules to transfer data from the check box "Checked" to the data label.   When the view is initialized or check box changes, then tra

Everybody knows the site Gravatar : http://en.gravatar.com/ Basically with some email address is possible to upload a Picture which will be stored in multiple resolutions and generate a MD5 Hash that can be referenced to show/display with specific width and height. http://emn178.github.io/online-tools/sha256.html I wonder if there is a way to call a function to resize and uploaded JPG to be saved for example in High, Medium, Small , Very Small  and Icon resolution to be used to display the picture of lets said the authenticated user.  This will be used as Icon for all their Forms. or when they participate in some approval process, who knows like a Digital Sigature stamped when they click approve. Any ideas ???

This started happening last week for workflows that I try to build out of Visual Studio: Done building project "CSWinWF-21def8cc231f4db6a2fcd2c99fca4832.csproj".Build succeeded.Done executing task "WorkflowCompiler" -- FAILED.Done building target "ProjectCompilation" in project "TestVS.k2proj" -- FAILED. and finish up with this: Build succeeded.Time Elapsed 00:00:01.55========== Rebuild All: 1 succeeded, 1 failed, 0 skipped ========== and they are unable to be deployed.  Nothing in the Error List though. Even creating a new workflow with just one DataEvent activity has the same result. Don't recall anything changing since the last successful build, apart from Microsoft patching. Visual Studio Professional 2013, K2 4.7 with August 2017 CU FP4, SharePoint 2013

We have some forms which are failing to load occasionally for some users. Some of the fields display "NULL" instead of data stored in the database. When this happens, we usually get some of the fields to load, while others fail to load and instead display the NULL message. We've isolated the problem to users who are using Edge browser.  I work for a county agency and most of our users use Internet Explorer v11.x  and they do not seem to have this problem. Is there a know issue with Edge browsers? Are there any suggested workarounds? Thank you,-tomas

Hi All, I'm wondering if any have experienced the same problem, and found a solution.  We use List SmartObjects to write to SharePoint lists.  We use two URL columns.  One to open the original smart form and load the date from the list.  One to open the ViewFlow link.  When using the Create method from within the smartform rules, there is no way to utilize the additional field "Display"..  What we then end up having to do, is to make a separte call to the SharePoint list in the WorkFlow, calling the List Events activity, which then provides with two options, the URL and the Display.  Even in the SmartObject tester, there is an "Add" button next the the URL fileds, in which we can add the URL and Display. Is there a way to access the Display option from SmartForm Rules.   We are using 4.7 Thanks,Dean 

Hi I am designing a workflow using K2 Designer. In this, I am using "User Task" Activity. within the "<User Task Name> - Participants" wizard, I have specified the participants and also checked/ticked"Notify Participants when they receive a work list"Still I do not receive a notification email from a user task activity.  However, Send Email Activity successfully sends email. How to send email notification from a User Task activity? Thanks

Hello! How it is possible to set te K2 server as pre-confiured when the K2 app is rolled out to the users on the company phones? Under https://help.k2.com/kb001718 (Distributing the mobile K2 app with device management software)or https://help.k2.com/kb001789 (Modifying the K2 app for IOS)I found some hints.On our side it is not intended to to a re-branding of the K2 app so I think the process desctibed there goes too much into detail. The only thing that should be pre-configured is the hostname of the K2 PROD server. The collegues can deploy the K2 mobile app to a BES container.There they have the possibility to upload a "preconfigured template".Does anyone know somwthing about that and is this a way to go? Kr,Erich Lind

I'm trying to create an advanced SmartObject Method that can read data from one SmartObject, and combine that information with input parameters to create a new record in another SmartObject: Table1 -> (transform) -> Table 2. I can sucessfully read the information from Table1, and this data is set in the smart object properties, however the write method in table 2 writes null values for every field.  I need this to be able to record the State of Table 1 at the time of certain transactions for reporting purposes. Is this going to be possible without writing a custom service broker? 

Hi, Anyone able to help with this... I have a view on a Form with a Data Label on it as follows:  This Data label is using an expression as follows: <div id="makemeblink"><font face="arial"><font size="3"> Please wait, generating PDF... </font></div> <script> function blinkMe(divToBlink){ if (document.getElementById("makemeblink").style.color == "black"){ document.getElementById("makemeblink").style.color="white"; }else{ document.getElementById("makemeblink").style.color="black"; } } window.setInterval("blinkMe('makemeblink')",1500); </script> The above code was provided by one of the K2ers on here, however it's not working correctly. 1) As you can see in the label, there is a big gap (almost as if there is a second line) underneath the text, how do i remove that?2) The flashing is inconsistant, the coloured text alternating between black and white is not smooth, sometimes quicker, sometimes slow. I tried changing theblinkrate to other numbers,

Hi All, With the incoming EU General Data Protection Regulations coming in to force as of May 2018 we're looking at what this entails for our K2 applications especially when considering the "right to be forgotten". (https://en.wikipedia.org/wiki/General_Data_Protection_Regulation) Most of our application data we're in full control of however when a user interacts with K2 a cached identity is created (I think this is the correct terminology) and stored in the table [K2].[Identity].[Identity].  As we use the user's email address as their identity when interacting with our systems, we're tasked with scrubbing this from the database as it's personally identifiable information.  Can anyone advise on what the right process for doing this is? One particular scenario is that the user, whilst interacting a Smartmorm, may request their account deletion.  We had considered doing this in immediately in real-time (logical deletion of app data and masking of personal information before confirming an

I have a For Each step that pulls list item's ID (defined as integer in SP and SMO) from a SP list Smartobject. When i try to access this Reference in Context Browser, it's shown it of type "Text". Please see attached. Am I reading it incorrect or I am missing something? Thanks

Hi all, Im sure this is a simple query for some but I cant seem to get my head around it.  I have a list view and in each row in the list I need to add an 'approver'. I want my workflow to start and send a task to the first approver in the list, once this is approved I want the next task to be sent to the approver in the second row and so on. I only want the second task to be sent once the first is completed. How would this look in a workflow? Thanks!

Hi All, I am getting access denied error while activating the K2 for SharePoint on SharePoint site. The acount has Site Collection admin access.Any help will be appreciated. Thanks,Prafull