This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Use of CSVExport - LineScriptName Component

Hi All,

Could you please help me on the below issue.

I'm using a CSVExport component for generating csv files and i wanted to use the lineScriptname parameter instead of linedef in order to replace certain characters.

I used the below code snippet to achieve this but  "getting Object Reference not set to an instance of an object"

Public Function CSVExport() As String

Dim SB As New StringBuilder()

SB.Append(base("DisplayName").[New].String)

SB.Append(";")

Return SB.ToString()

End Function

Wanted to know if the above issue is because of  the ObjectType parameter- the tablename which I'm providing is different from the table name from where the csvexport process is getting triggered.

Thanks in advance

Parents
  • I assume the object specified in the ObjectType parameter contains the column "DisplayName". If so, you can write SB.Append($DisplayName$) in your code.

  • Thanks Markus for looking into this, yes  the column is present in the Table defined in the ObjectType paramater.

    but wanted to know if there is a possibility to pass the id of the record  as a parameter to the lineScriptName , here the record refers to the entry present in parent table where the process got triggered.

    As i wanted to use the data present in the parent table(not the table defined in ObjectType parm)  as well.

Reply
  • Thanks Markus for looking into this, yes  the column is present in the Table defined in the ObjectType paramater.

    but wanted to know if there is a possibility to pass the id of the record  as a parameter to the lineScriptName , here the record refers to the entry present in parent table where the process got triggered.

    As i wanted to use the data present in the parent table(not the table defined in ObjectType parm)  as well.

Children
  • First, what is the id of the record in your case?

    Secondly, you access parent table data using the object layer $-notation or by a foreign-key object, or by using an ObjectWalker, or by loading the parent data manually. To summarize, you access the data as you would do with any other object layer script in OneIM.