Preprocessor vlookup macro

Question

I am loving PlantUML and have many lines of script.. As the number of lines of script grows, the overall effort to keep the diagrams consistent and standard gets difficult.

To assist, I am attempting to write a simple macro which works along the lines of a excel vlookup where you pass in a search string, a file name of what is to be searched and an offset value to be returned.

However i am struggling on my first attempt with a parsing error. I am hoping some fresh eyes can help.. or even better if someone in the plantuml community has already done something along these lines.  

thank you,

David.

@startuml vlookup test

!preprocessorV2

!unquoted function $vlookup( $id, $range, $offset)

   !log vlookup on $id

   '!log vlookup on %get_variable_value("$id")

   !$row1 = "cm|customer master|manages customers"

   !$row2 = "tm|transaction manager|manages transactions"

   !$row3 = "am|account manager|manages accounts"

    '%set_variable_value("$row1", "cm|customer master|manages customers" )

    '%set_variable_value("$row2", "tm|transaction manager|manages transactions" )

    '%set_variable_value("$row3", "am|account master|manages accounts" )

    !if ($id == "cm")

      '!return %get_variable_value("$row1")

      !return $row1

    !endif

    !if ($id == "tm")  

      '!return %get_variable_value("$row2")

      !return $row2

    !endif

    !if ($id == "am")  

      '!return %get_variable_value("$row3")

       !return $row3

   !else

        !return "error"

    !endif

 !endfunction

!$note = $vlookup("cm", "system.iuml", 1)

component comp1 [

$note

]

@enduml

Answer 1

Hello,

Your example seems to work on the online server :

http://www.plantuml.com/plantuml/uml/bPFHYl8m48MlpLDCGqM5yeFjjU1x_2nBjavBsIJZ9XENXJxy9jMwhbr5hvAUdFDr9aEsdfNZOBJ8Wlq8nBY39jYQExAG7pJHUzWl8Uzs1UHEsHRZIatZaLS2039DBPniG3OPaxourkSjykj1kKwzQOmR7N0feraUARcZppLiGDQchuDdCkZ0AC_eUgEiQj73g7jvZfGfmgRdM9bNnw87-qNiukmYMQMaChsgQmgM9wcJ7XEpnTp_LNkgM1OFLWohUvnI5i-rSHzNoUAgDy_JrewKh6jW6US0c-7oPPJIz1noS6bgDpiVZADla28CxQvhhg0SeG2FOSifjho1LKzWgm7xcrk99A3sA6QpyK2YS-Ja-PUGrl4vY2otn0YRdtUHRgm0wRyye_dN1QFZvtebQZ9xicWPqcuD_yKG5IzY6u7HzWq0

Maybe you are using a too old version ?

You can doublecheck it with:

@startuml
version
@enduml

Comments

I still cannot get the script to run.. even on the plantuml test server.

In this sample I have attempted to use the various variable functions, removed blank lines and superfluous spaces.

http://www.plantuml.com/plantuml/png/TKzTQiCm37xtAMIJGWjXa0C4UeynXfV8mSoMEblg6FJmKyhANZQ_ICZVp_UTkyGcMelpIX_AWYiafKKo4mpNmlokb-EGrn665cb3cvnIHpavNtY37mWO_B2Xl5vZo_6je2r5yHYC6axkqF_wQlmvXJ4izRPe5wxOeCOks6urKjomm-FUJSFd17iIc6SmZbt0dcyesdRpVnsCYhJcT1-FSiuFP6rX_crfefQcVrc2-fIrbZ32T78BrmiJai2-JV3ixaptuiwcPx1l

---

Yet another bug :-)

This should be fixed in last beta http://beta.plantuml.net/plantuml.jar and on the online server

http://www.plantuml.com/plantuml/uml/TO_1QiCm38RlVWhPfD1066JtGDzZZE4bSZ2phSwMCWPz-2bbOPVL5mbPt__hlpJsbIKdOwLy2Z4k4AJC7Ab0joMY3xcUkxWCq5LVLjHA8JJatjX4A_okRC-Wm6b5VjjyZVuzeJP9yEmKThqvjV--AdsDRd1plitIc39MoBunrblsnQ_Ou9WtrR0nm7uBJ1CeenFGPokorDtyeOEYM9OOxkM8PsnNY16clvoxwE3QTsFCJr5oSWEClPafNwbWOTYx4LxCdJIlvg9wklO3

Feel free to post again when you'll find issues :-)

---

@plantuml You just beat me when I was analysing the problem.

Am I corect that the problem lies in the "1" of "row1"

---

thanks again.. the numeric variable name, assuming @albert is correct, is going to be important for the script as I introduce the looping thru each of the rows to find the matching $id..

---

As far as I can see on the online server the version wit the numeric value is working.