K2 blackpearl

Hi, Is it possible to use PowerBI with an OData service instance connection in K2 Blackpearl 4.7? I cannot seem to make it work or find an OData URL as I am missing the API option under Integration in K2 Management. Thanks!

Hi All We have built a smart form which has several rich text boxes. The issue we are facing is when we convert this form into a PDF - any of the text boxes which have more text which is not visible onscreen (the scrollbar needs to be used to view the full text) - the PDF is missing all of the text - so taking a snapshot of what is onscreen rather that bringing back all of the text. Does anyone know how to configure the PDF to bring back to show all of the text within each field rather than taking a snapshot of what is viewed onscreen? We have tried to configure using URL method as well as generating a PDF when a button is clicked! Thanks in advance, 

I have a list created by a smartobject which is integrated with SP on prem. Once an item has been approved, I want t take certain data elements from that smartobject and added it to a SharePoint Calendar. I have no idea where to start for this last part. I am running version 4.7 at the moment and my SP is 2013

I have a list view to which I have added buttons using code from another discussion within the K2 forum. The user wants the button to display something different if the values in the List View have been transferred to a different table/view (hidden). However, the problem I am having is how to check the data in that table after it has been transferred for all records in the List View. It seems like it should be a For Loop, but I'm not getting that to work or make the connection to retrieve for each record the update date in the other table. Hope this make sense, any help is greatly appreciated. Thanks!

Hello EveryoneI have a k2 form whiche make the employee able to order PCso let say that an employee want to order a PC , after he send the requesthis manger can't click OK until the form make sure that the warhouse is empty and there is no PC sothe manger can esculate the order to the main warhouse.so if there is PC's in the local warhouse the Order does not pass the manger  as you see in the picture the first view is what the employee want to order .Laptop and DEsktopthe second view is what the local warhouse has right nowso the order can not be accepted unless the Item balance is 0i hope it's clearbest regards 

Hi All, I want to transfer the Data from a Subview to Main Form. I tried with 'Transfer Data' and fails. Please note that, this subview is not a member of Main Form.   

Hi, i am new in K2 Workflow. I have a requirement where i have specify the destination user based on some criteria. I have a table having a column named 'Gender'. Once the workflow is initiated and on 'Approval' i want set the destination user based on the Gender. If Gender is 'M' then set one user, if 'F' then set another.Is it possible to implement this?Thanks in advance.Regards,JD

I am setting up a TimeOut action as part of a request workflow. The bit I a struggling with is how to set the a rule that triggers the Timeout action, Updates the request status to TimedOut and send the email to the originator notiftying to this effect 120 hours (5days) after the initial request was submitted.  below is screen shot of the workflow        Andy advice would be welcomedRegardsAndrew

In my quest to give the best user experience, a thought occured to me regarding Approvals... At the moment, I use offline approval for forms which require authorisation.The Authorisers get an email, which they reply with the word approve or decline for example. While this works great and does the job, I was wondering if there was any way of replacing that Approve / Decline with Buttons inside the email, is this even possible? I know you can use an alternate way of approving requests via a Link to the workitem, then approve it, but that to me is more time consuming and a 2-step process. In an ideal world, I'v want buttons in a email which the user clicks and that acts as a reply to the email and send the word "Approved" to pass back to K2 andcloses the email as well..... I know you can have voting buttons in Outlook, but was wondering if that could be done within the body of the email.....Can you use HTML/Javascript to create buttons within the email message? Is this possible, or pie in

Hi All Does anybody have any code which could be used to de-select an item(s)  from a smartform list viewIn the project I'm building a user will select an item or items from a list view but then I need to be able to delect those items if some conditions are not met. I cant see any out of the box options in K2 to do this so wondering if some script could be used? Any help much appreciated Paul

Hello Community, I have a problem with a E-Mail event and the following error message"The specified string is not in the form required for a subject". The error occures when the users use a line break in the textfield for the Subject of the E-Mail. Is there a way to delete those line breaks for the E-Mail subject?In the form the line breaks are okay but for the E-Mail Subject it's bad. I know there are a couple of solutions in the forum but those doesn't solved my problem. Thank you for your help in advanced. Kind regardsAlexander 

Hi Everybody, I want to export k2 workflow items's document/files/zip files to a json file or any other format. How could I do it? I don't want to export the reviewers info, Just want to export the workflow item name and the document insides it. Thanks.Jennifer.

Hi, what exactly does the parameter "Database Maximum Decimal Value"?In which cases the parameter has to be adjusted? Andi

i was having this error on k2workflow "SmartObject Property ID is a required property for selected method Execute", the worflow was build in K2 studio.please kindly help with thisthanks

Hi All,I am new in K2.I have developed one K2 Smartform which will allow to add multiple records/ rows in to a table. for this i did followings:1. Created one advance smartobject for the table, where data will be stored.2. Designed an editable list view with a button (save). On click the button data will be saved to the table It will be nice if you let me know what rule i should define against the button, along with others seeting (if any is required) to save records. Thanks with Regards,JD

Hi guys, I am going to start my first project integrate with SAP. Would like to seek for some advice regarding service object creation. I have 2 SAP BAPI:1. BAPI_GOODSMVT_CREATE2. BAPI_TRANSACTION_COMMIT After the data entry using bapi 1, i need to execute the bapi 2 to commit the posting. It had been tested in SAP se37 with test sequence. How can i translate this activity into service object? 1 service object contain 2 bapi? will it execute following the sequence? Thank you.

Hi Guys,I'm having a long running battle trying to successfully integrate SmartForms with an On-Prem SharePoint 2016 install. K2 and a dedicated SQL 2014 Server are all up and runnign fine, one of oru staf fis already busily creating very simple workflows, forms etc in K2 Designer and all appears to be working well. I have Sharepoint 2016 up and runnign and followed various guides to get the On-Prem verison ofthe App store up and running but something is not quite right.I run the SmartForms Sharepoint installer and it runs through the entire process with all Green ticks everywhere.Going into SharePoint App Catalogue and its site I can see K2 blackpearl for Sharepoint lsited under Apps for Sharepoint and in Site Contents. In Site Contents I click the pretty K2 Blackpearl Icon and it launches the Registration Wizard and asks me to login again, I do and get the next screen:Anyone got any ideas how I can get the registration wizard to complete here? I have to say - this K2 integration with

Hello, We have an activity which creates PDF static copy of form and saves it to sharepoint list. But the problem is, sharepoint does not allow all the users to upload the document. Due to security reasons, we do not want to give access to sharepoint list to all the users.Is there any way we can start workflow/activity as k2 Admin ? We tried the following method:1.Going to service tester2.Edit the service instance.3. Using different authentication mode. But this change will reflect in all the workflow. And we do not want to start all the workflows with same user. Appriciate any help, thank you. 

Hi ALL, Currently have an issue around starting a workflow from a form. Each time I try to trigger the "Start a Workflow" Event, i keep getting the error below; " Value was either too large or too small for an Int32 " I have checked the values that I am passing into the workflow datafield, and ensured that the datatype is same. Still have the same issue. Not quite about what the issue may be. Will really appreciate an answer Pronto. Thanks all...

Hi All, I am stuck at the moment with a requirement at a client. They are using the SharePoint content service to access document libraries to store and retrieve documents.This current requirement is to retrieve a list of documents, display it in a listview and then to have a button on the listview that will download all the documents displayed. I have yet to find a way to do this as the SmartObject doesnt  allow you to specifically download files as a batch. Can anyone please shed some light on this ? Kind regards, Helgard Wagener

I am attempting to emulate this: http://community.k2.com/t5/K2-blackpearl/Can-smartobject-events-in-a-process-be-sorted-by-a-particular/td-p/77946but my Steps change a little bit:Add a Default Activity to your workflow.  Select the Destination Rule and run in advanced mode Select "Plan Per Slot (No Destinations)"  Select the option "Select a list field to determine how many slots should be created" Drop your SmartObject list event in the box. Add your inputs and filter. In the return property select the ID for the SmartObject. In the List Options select the "Order Results By" and choose  Descending and theSort Order field property. I wish to return all results that match the filter, I have attempted this, but the workflow returns an error on the step when I try to return all the results. If I return just the first result, it will work. Any ideas how to return all results to a datafield? I was hoping it would come out something along the lines of Datafield = 1;3;6;7;

So let's say I have a SharePoint list.  One of the fields is a choice field.  I do the thing that turns my list into a K2 application and creates all the smart objects and forms and views.  Great.  Now I decide I want to add an additional property to the smartobject that holds my choice fields so that when the user selects an option from the choice field, I can return something more useful to my application. How do I add new values for this new property? In order to make this a little more clear, my original choice field is a set of cell service carriers:Verizon Sprint T-Mobile etc.I've added a new property to the automatically created smartobject intended to hold the SMS gateway for that carrier.  So, for example, I'd like to add @vtext.com as the value for Verizon.  How?  Where?  Why in the world are things not easier to find in this insane application?

Hi, Which is the best way to clear out all completed Process Instances for a PROCESS in Workspace? I've done a tonne of testing on a form and have all the completed process instances showing in the Process Overview->Process Instances. How do i clear them all out? I deleted all previous "Versions" of the process, so just have the default current one, but it still shows all these completed instances. i want to start afresh for the form going live, so what's the best way to clear them? Thanks,

Although I've used stored procedures for execute commands against the database, this is the first time I'm using one for a list method.   Basically, I want it to query the data slightly based on whether or not they're searching for completed records (<> 1) or incomple records (=1).   When I try to create the Smart Object, however, it gives me two sets of properties UnitID, GroupID, UnitID(1), GroupID(1).  That doesn't work... Anyway, my SPROC is as follows.  Anyone have any thoughts? Rob    ALTER PROCEDURE [dbo].[Group_aggregated_sproc_2]@Searchtype intASBEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON;-- Insert statements for procedure hereif @searchtype = 1 beginselect UnitID, GroupID from recon_work_itemswhere (currentstatus = 1 or currentstatus > 20)group by UnitID, GroupIDend elseif @searchtype <> 1beginselect UnitID, GroupID from recon_work_itemswhere currentstatus between 2 and 20group by UnitID, Gr

When using the connection string editor, is it possible to have more than one WebServicesConnection and WebServicesDestination defined on a single K2 Server instance?  We wanted to route From Address mail from multiple sources on our K2 instance depending on the workflow, when I added a second pair with a different email address to use on some of our workflows, I could no longer restart the K2 blackpearl service.  Is there a hard limit on this where we can only define a single email address to use in the From Address field? Also, if I just attempt to hard code the alternative email address into the workflow, I get an error on that indicating that the exchange server "send on behalf of permissions" are not set.  The email address that is presently working does not have any such permissions set on it as was confirmed by our exchange server administrator.