Functions in ITO reports

[Bram 0]

@JSN I would also like to be able to access the link

[Bram 0]

@JSN said in Functions in ITO reports:

I gues you could also try to use Power Query with the template as a crutch for now to at least automate the splitting.

The problem is that the office works with google sheets, and in this case the Querry function is used. What I would like is to do it from the same file or template

[Wing Mang]

@JSN

I’d also like to get access to the link too.

It’s something new to me.

[Matti]

@Bram-0

The split can be done in the Excel template of Solibri ITO.
Use following functions in additional columns

=LEFT(B12;FIND(" : ";B12))
=RIGHT(B12; LEN(B12) - FIND(" : ";B12) - 2)

and the result:

[Bram 0]

Hello @Matti-Kannala , very grateful for your answer, I see that it helps me so that everything comes out from the template, but the only details are that if there are blank cells, the value “#VALUE!” remains, on the other hand, it does not recognize the “IFERROR” formula. since all the boxes remain in value “=0”. I’m going to try the “IF” formula to see if I get something. Greetings

[JSN]

@Matti-Kannala

We had issues in the past that some formulas or formatings of the report templates are not properly supported. So in some cases there is just nothing happening on a report export. It’s not doing anything until you delete such columns. No errors, no hints, no logs (?), just nothing.

[Bram 0]

@JSN Sometimes that happens to me when I save in google sheets, I don’t know why, but when I export it from Numbers (mac) it accepts the template and exports from Solibri without problems…

[JSN]

@Bram-0

Just using excel and sometimes it feels like a bit hit and miss if it’s working or not. Regarding IFERROR() on the other hand I am pretty sure it works so maybe check your formula again.

[EloyRD]

@JSN said in Functions in ITO reports:

You are right the getting started guides could be better, but there are some ressources which can be found here. Anyhow in this specific case I was not refering to the Java API but I menat the JavaScript support for the ITOs which has quite a good quickstart tutorial - check if you have access.

https://society.solibri.com/topic/620/javascript-api-documentation-solibri-version-9-10-8

@Solibrians Could you point me towards the current tutorial? Sorry for commenting on a quite old post.

[tonigyllenberg]

@Solibrians Could you point me towards the current tutorial? Sorry for commenting on a quite old post.

Hello!

For JavaScript API the latest documentation is here:

https://society.solibri.com/topic/3368/solibri-api-solibri-javascript-api

Kind regards,

Toni