latest posts

Hi,

I came across issue with generating xlsx file from item list. I created xlsx template having a table named Tabela1 consisting of 5 columns and item list with exacly same column names. I actualy exported the item list to xlsx and converted it to a template. After setting up a mapping on the 'Generate excel file' action and running it I keep getting 'Invlid cell name' error. Full error log below. When I use cell adress in mapping (A2) there is no error but only last row of item list is exported which is not what I'm trying to achieve. Am I missing something?

Log
Error code: 100
Invalid cell name
at Aspose.Cells.CellsHelper.CellNameToIndex(String cellName, Int32& row, Int32& column)
at WebCon.WorkFlow.Base.Actions.GenerateExcelWorksheet.InsertValueFromTag(ITagParser tagParser, String tag, TupleEx`2 address, Workbook workbook, ExcelDataTimeHelper excelDataTimeHelper)
at WebCon.WorkFlow.Base.Actions.GenerateExcelWorksheet.FillExcelFileOrReturnError(XmlActionsConfig config, WorkFlowObject wfObject, ITagParser tagParser, Workbook workbook, ExcelDataTimeHelper excelDataTimeHelper)
at WebCon.WorkFlow.Base.Actions.GenerateExcelWorksheet.FireAction(WorkFlowObject wfObject, IWFAction wfAction, ITagParser tagParser, IAutomationDataHelper automationDataHelper, String& message, String& logMessage)
at WebCon.WorkFlow.Base.Automations.Engine.Evaluators.ActionEvaluator.FireAction(ActionBase actionObject, String& userLogMessage, String& adminLogMessage)
at WebCon.WorkFlow.Base.Automations.Engine.Evaluators.ActionEvaluator.Evaluate()

After taking a look at how the field values are saved in the database, I've noticed that, WEBCON does not use any type of new line but rather a paragraph tag.
So the solution is to use </p><p> instead of <br> to split a single paragraph into two.

Hi Waldemar,
thank you for your reply! The result was the same as with Jacek's suggestion.
It works, but as soon as additional information is added the break dissappears again.
Do you have any other ideas?

Thank you & Best Regards,
Lena

Hi Jacek,
thank you for your answer. This works, but in this multiline field additional information can be added manually below. And when the information is added the break in the Word document doesn't work anymore. Do you have another idea on this?

Thank you & Best Regards,
Lena

Hi,
replace the <BR> with a lower case <br>. Seems to do the trick.

Hi,
if you want to add break line to the word document (and you concat two fields) you can use "Data row" and add CHAR(10) between your fields

Dear WEBCON Team,

this issue already occurred in 2022:
https://community.webcon.com/forum/thread/1986?messageid=1986

Is there any solution or workaround for this?

Thank you & Best Regards,
Lena Schmidbauer

I have a problem to establish a connection to sharepoint online.
I have chosen as connection type sharepoint online. When I enter the Url of the sitecollection and the user and password correctly, I get the Error message: "Unable to connect to the remote Server. The sign-in name or password does not match one in the Microsoft account system."
As the account that I use to connect has not MFA enabled the reason for the error must be, that webcon uses legacy authentication, which is not allowed on our tenant due to conditional access policies.
So my question is, if there isn't another authentication possibility at webcon?
We actually use Version 2023.1.2.99. Could it be, that the problem would be solved on a newer Version?

Thank you for the reply, Tomasz.

This is what I needed.

If you want to check if exists the same fullname in the form of the same type, you can use bellow SQL.
xxxx is the ID of the FullName field

SELECT CASE WHEN NOT EXISTS (
SELECT 1 FROM WFElements WHERE
WFD_DTYPEID = {DTYPE_ID}
AND WFD_ID != {WFD_ID}
AND {WFCONCOL:xxxx} = '{xxxx}') THEN 2 ELSE 0 END as flag