WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for import

OK, be my guest. :] But you did not answer the essence of the question :/? Is there any workaround or not for this specific case?

Unfortunately I don't have one which could really work. Only one idea which may work, but only with simple workflows. Even if I had one which could work, I would not disclose this. This would be similar to assisting in a robbery in my point of view. The feature has been explicitly implemented to prevent this. I tried ones to "compare" the exported application package from two environment so th

(...) Sure, got it. I thought it didn't matter much, especially when it was in the Ent. versions there are separate environments (test, dev) and somehow the import is magically possible with an option to overwrite it, and it is not limited to the 1st attempt only. anyway.... I give up. I did a new clean install * .41. I detached the old databases. Installation went through without a problem. The system w (...)

(...) found that if I update: update [WEBCON_BPS_Config].[dbo].[ServiceActivityInfos] set [SAI_IsInSafeMode] = 0 and then restart service Now Module is Active and others without warning. Now import is working as well but the question is WHY safe mode was active by default? What caused this configuration.? Even though this is a workaround (unauthorized at own risk), I don't know the cause (...)

(...) Dear Webcon Community! Problem: with import excel action you can import excel tables only if you have a table container already added. Sometimes it is difficult if we want to process data in excel table coming from third party. Proposal: there is a way to define column mapping for itemlist file importing. It would be nice to have a feature in import action to take into account that one, instea (...)

(...) Hi. When I import data from an external data source and the content of a field doesn't match the data type of the target field (e.g. target field is "Date", but the source delivers a "text") I get an error and the import is aborted. Is ther a chance to "catch" that and set the value e.g. "empty"? Kind regards, Klaus

(...) Hi Klaus, maybe I missed something but I didn't understand which action/method you are using for the data import. Are you using some external tool which uses the REST API, a start workflow (sql) action, import using excel in a dictionary or item list? Or is it something else? A screenshot could help too. :) Best regards, Daniel

Hi Daniel, sorry for the incomplete scenario description. The actual case is a SQL Database connection where I have defined a data source as a SQL table with that connection. So I'm talking about "pure SQL". That Data source is used as data source for a choice field. Via the advanced configuration of the Autocomplete behaviour I set other fields with column values of that data source.

Hi Klaus, in this case I would convert the origin data to a value which is excepted using sql. For example select Inserted, case when Inserted = '' then null when Inserted = null then null else convert(datetime,Inserted) end as InsertedDate from ( select '2022-01-01' as Inserted union select null as Inserted union select '' as Inserted union select '2022-12-01' as Ins

(...) Hi Guys, just wonder if there is any option to import data into Webcon not into the item list, but as a separate workflow elements. I want to implement Asset Management workflow, but need to enter into the system few thousand items (PC's, servers etc.), which are currently stored in another SQL database.

Hi Patryk! This should be an easy task ;-) Have a look at the 'Start a subworkflow (SQL)' action. You have to create a DB connection first to your assets DB, then you should be able to implement the specific SQL statement for this action. Best regards, Nik

Hi Nik, so simple... I just have been always using this function to kick off subworkflows connected to the current instance, forgot that you can start urelated workflow as well. Regards, Patryk

Hi Patryk! Yes, they should be unrelated ;-) Best regards, Nik

(...) it takes to start a workflow, which depends on the actions you execute on your path. You might have to try and error a bit. When using batches you have to keep track, which records you've already imported. You can to this either by adding a new boolean field, which you then set in the Filter Query. See attached image. Or you could store the external id in the workflow you started and then use a (...)

@Jenni thanks for this tip, I will do it in the batches. It is going to be roughly 1,5-2k records I believe, so then even doing 50 at once will not take that long, taking into account that we are talking about switching from one system to the other for probably next 20 years or so.

(...) Hi everyone, have you ever imported a process and thought, damn I forgot to tick this or untick the other field? In my case this has happened more than I want to admit. Most times everything works fine but know and then you get disturbed and you make a mistake in the selection. Of course one could have a check list to verify everything, but even this will fail. So I'm wondering whether one or b (...)

(...) ival field". Not sure whether this is good practice or not. However i would appreciate a built-in handling for field type changes. This could be as you suggested, some sort of a download after the import. We should then be able to define kind of a migration scenario.

Same problem here. Did you finally find a solution? And are you still using Webcon? I am bit annoyed with the safe mode issue, not willing to reinstall a whole day long. However, when I update the setting in the database on the next service restart it overwrites to safe mode = 1 :)

Nope. No new solution/workaround.

(...) Hi all! We upgraded to newest version 2022.1.4.177 In this version the export and import button is missing in UI (Document templates report). Export and import via application does not work either. Am I missing something or is this a bug? Any ideas on how to import document templates on new environment having the same GUID? Thanks in advance & best regards, Nik