Nintex Automation K2

Hello,Our business has an old database table which stores/contains files using VARBINARY(MAX) as the datatype.  It is my understanding that this datatype is not supported in K2 Five and thus I cannot create a SmartObject on this table and display these files using a SmartForm.  The goal is to somehow migrate these files out of the current database table, and upload them into a different table in the format that K2 recognizes.  Which, from a DB perspective using VARCHAR(MAX) as the datatype, looks something like this - <file><name>NameOfFile.pdf</name><content>iVBORKh.….</content></file>My question is….what is the best approach to achieve this objective?  Can .NET code we written to somehow cycle through these old DB records/files and upload them into our existing table via a K2 API? Or even call the existing table’s own SmartObject from .NET code in order to upload the files?Thanks,Kyle

Hi All, I have an SDA connection into our network and i'm attempting to access the CRM. I am able to telnet to the CRM server and the actual connection is working but I am now getting an error message of "The authentication endpoint Username was not found on the configured Secure Token Service." I've searched the web for information and I am not getting much help for the articles. My crm version is 20*personal details removed*.1.1.1005. Can anyone provide some direction on making the connection given the specific error? Thanks,Ben

Hi All,I have several dropdown lists as shown below. so my question is, what rule is used so that dropdown2 and dropdown3 are automatically empty when dropdownlist1 is changed? Thanks, 

I have a workflow where I save the workflow ID_TaskID so that I can complete the task via a separate form.However sometimes the TaskID isn't the correct ID and when the end users are trying to complete the task via the separate form they do not get the proper serial number and can't complete the task.I have this TaskID saved in a multi step running before the task.Attached are screenshots of the workflow.Is there potentially a better way to save a task ID/serial number?

I realize docusign integrates with K2/Smartforms, however I dont have access to the product at this time and I need to have some way of approximating or indicating approval on a SF that will, at the end of the process be converted into a PDF and sent to an outside email recipient. I also realize that every person that has the approval task only has access to that task through K2 process rights/roles etc. I just need a visual way to indicate it was "Signed" like a digital stamp or watermark or something. Anyone come up with anything like that other than using Docusign? Thanks Dave

Hi. I have multiple approvers in one of my application process. I would like to know the best practise to have a task form. creating different task form for each approver or having one task form with different states. which is the best one?. Regards,Thriveni

Hi All,I am getting below error while refreshing sharepoint instance. This was working fine and suddenly started giving error. I am able to browse the sharepoint list using browser with the same service account, but not through K2 Smartobject service tester tool.Error screenshot 

Please see snapshot.I am trying to configure my workflow in my smartform using the command but failed. Error: There are no items to display. Either the process has been deletedor yo do not have the required process rights to view. I have admin process in the workflow.In v4.7 it is working, in k2 five I am having a lot of issues. 

Hi, I looking for a automated way to deploy K2 Five package. Is there possible I configure the SharePoint artifacts with PowerShell? e.g. configure SharePoint reference to select the site library. Regards,Eric

Brand new instance of K2 Five (5.2),I was testing the smartstarter applications a bit just to see how much modification they would require to apply to my environment. I installed the "Change Management" SmartStarter, and the "IT Asset Request" smartstarter. I then tried to delete them (through the workspace, same place where I installed them), and it removed them from the Apps list, however in designer, all of the components are still there, the smartobjects, the forms, the views, the workflows, they are all there. On top of that if I try to re-add the apps from the catalog, it tells me they are installed. Is there any way to fully remove the apps? I don't want to manually delete all the components. They seem to be in deep folder structures and I thought removing them would delete the components. I have attached some screenshots in case they help. Thank you

Hi all I'm trying to expose some data in an Advanced Smart Object. The SmartObject has multiple list methods. Is there a way to select the right list method when connecting to the OData feed from, say, PowerBI? Thanks

Hi.I need to display a confirmation when users are closing the browser. I have large form with multiple views,can I prompt a message that leaving browser will not save the data.Is there any way that i can control on closing browser window. Regards,Thriveni 

Hi K2 guru, I got a form consists of two views,  top one is item view with proj details,  2nd one is List view allow user to add some suggestion (can be multiple line),  at the end of the form there is a Submit button to save all the fields from view 1 and view 2Note :-   View 1 and View 2 have their own smart objects Trying to pass one of the field data Proj_ID to View 2 so that the two smartobjects are linked,  that is SMO1 is parent and SMO2 is child We were trying to put all the rules - when Form is clicked  item on View1  view, execute the Create methond (configure)  item on View 2  view, excecute the Create method for all the items that have been added (configure) I create a Sugg_ID in view 2 SMO,  mapped to Proj IDwhen run somehow the Proj_ID that input was not passed to View 2 Sugg_ID Is my method correct ?  or is there any other better method Thank you in advance   

Hi, How to embed an image when sending email using k2 five?I found a different way to send an email with an image embedded on ittried but failed using v4.7 I tried below code to send but failed. As base64 image, it works on outlook but not on gmail. And some recipients too complained to there is no logo. <table><tr><td><img src="data:image/jpg;base64,Data Label Logo Header"/></td></tr></table> Thanks

I installed k2 8.1 core lite on PC, so I went to package a process on k2 5.1 while deploying it to k2 8.1 core lite the error shown on my screen "This package was created on a version that is no longer supported on this target environment. In order to deploy this solution to this target environment, upgrade the source environment to align with the same version as the target and repackage the solution. Then reattempt deploying this package.".Kindly help with thisThanks

I have one scenario pls help me how to achieve that : I have 2 Grids 'Delete Roles' & 'Request for Delete' , if I select any row in Delete Role and click on delete then selected record should move to 'Request for Delete' grid and Vice Versa should also work means if user select any row in 'Request for Delete' and click delete it should move back to 'Delete Role' Grid. Kindly refer attached screenshot. Thanks    

Hi Simple question.   I want to know if I can write a SQL script to assign rights against a workflow, rather than entering manually. Which SQL table contains the users that have been assigned rights to workflows (so that they can do actions such as start, view etc.)? Ideally, I don't want to create active directory groups to mass assign users. To provide context, I am doing this on our development environment for testing purposes.  Thanks.  

I have built a status report view   using my user list, activity instance destination and process instance smart objects . I added an export to excel button because the user required to be export to excel the status report.Now I want them access this view from Workspace and be able to export the report  to excel. The users comes throught workspace and then they  go my forms How can I make the view accessible for user from Workspace? Do I have to create a form drop this view(I have only one view)? If I do need to create form for the view. Can I be able to export the form to excel like the view? I attached workfspace screenshot Thank you for

hi,I'm absolutely new to k2 and playing around on our dev server. I want to create a REST service instance. I already created swagger definition but now I'm stuck.While creating the instance I have to pass Descriptor Location. But I don't know how I can upload my swagger def file? Very basic, but it puzzels me.

Hi, I have my first solution that I have succesfully deployed to live, basically a new form that starts an approval process when the save button is clicked. However, only myself as workflow author can succesfully submit the form, everyone else either gets a message saying the user does not have rights to to start the workflow or they get no message, but it just 'whirrs' and doesn;t progress (ie hangs). I have set the workflow rights via the manament tool and everyone has the correct rights, but I have set this on our test server and have deployed the package from test to live. Am I also supposed to add these rights to the workflow on the live server (if so this could be the problem), or should the packaged solution include the workflow rights I have applied on the test server? Any thoughts, bit pointless if only I can use it lol

Hi, When we upload a document to a Sharepoint Library (with major versions active) with custom metadata it always creates two versions: - 1.0 Upload Document- 2.0 Set Metadata This produces that if we enable some restore versions functionallity, users can restore v.1.0 (version without custom metadata fields filled). Is this the normal functionallity? Is there any way to avoid that and create only the first version? Thanks in advance.

We have a list view that items get added to by a feature on another, populated list view. Any number of item can be added to the first list view. I need to validate whether the first list view is empty. The list view has items like name, category and administrator. I tried setting a rule  on the list view that the Name Data Label did not containe a value then show a message that nothing was selected. This works half way correctly. If nothing is selected the message shows.  But then I seleccted and item and the name data lable definitly was populated but the message still popped up. How can you structure the condition that if just on item is populated in the first list view don't show the message.

We have our K2 Five installation separated into a web server and an app server. When we try to load saved workflows, the workflow designer halts at 80%. I can see a browser console error showing that K2 is trying to connect to the K2 database using our web server service account, not our app server service account. Do I have to give our web server service account access to the database? I had the understanding that everything goes through the app server. Maybe that's not true for the designer? It seems to be only workflows. SmartForms seem to save and run fine. I'm attaching a screenshot of the console error.

I've spent the last 3 days getting a form wrapped up and finally when to go check it in and not thinking I clicked yes to delete it thinking it was the yes to checking in associated views. Is there anyway to restore this form?  I'm not immediately seeing a way when I look through the mgmt screen.

Hello,I would like to ask, if it is possible to format date and time showing in the SmartForm (configured via Use a SmartObject as data source -> Configure Item Display)?I have a data source in SharePoint Online list and the date column is displayed as 20*personal details removed*.23. I would neet to convert it into date only format (08.02.2019) Thanks a lotJan