LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  LAE Error Code: ls.brain.node.changeMetadata.outputError

    Employee
    Posted 11-26-2014 10:29

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: lae_errors

    This post has been created for discussion of error code ls.brain.node.changeMetadata.outputError.

    Please reply to this thread with any description of error conditions, diagnostic information, and recommended resolutions.


  • 2.  RE: LAE Error Code: ls.brain.node.changeMetadata.outputError

    Employee
    Posted 11-26-2014 10:58

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    It turns out one of my fieldnames contained an apostrophe ('). I removed it and everything worked fine.


  • 3.  RE: LAE Error Code: ls.brain.node.changeMetadata.outputError

    Employee
    Posted 04-05-2018 07:33

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: sto

    Originally posted by: ryeh
					

    It turns out one of my fieldnames contained an apostrophe (').  I removed it and everything worked fine.
    Hello,

    how to remove the apostrophe (') in all Fields directly in Lavastorm?

    Thanks


  • 4.  RE: LAE Error Code: ls.brain.node.changeMetadata.outputError

    Employee
    Posted 04-05-2018 07:43

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: gmullin

    You want to remove the apostrophe from the field value or the fieldname? For the field value you can do:

    emit Field1.replace("'","") as "Field1"

    If it's at the start or end of the data in a lot of fields you could also use the Trim node and put ' for TrimCharacters.


  • 5.  RE: LAE Error Code: ls.brain.node.changeMetadata.outputError

    Employee
    Posted 04-05-2018 07:57

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: sto

    hi gmullin,

    I would like to remove the ' in the Field Name.


  • 6.  RE: LAE Error Code: ls.brain.node.changeMetadata.outputError

    Employee
    Posted 04-05-2018 08:39

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: gmullin

    I can't read in an Excel file that has ' in the field name without setting the parameter SubstitueInvalidCharacters to true (Exception behaviour tab). That might help you.

    Also you can try this node. It will get the Metadata of the node and replace a character in the field name. I have to confess I've done this with success for " character but its not working for ' for me. Maybe you can try and copy and paste the character you have in your field name?


    node:Remove_character_from_Fieldname
bretype:core::Composite
editor:Label=Remove character from Fieldname
editor:sortkey=5ac6417e47b94571
input:5ac641962bf15704/=Static_Data.40fe6c55598828e5
inputxy:0=170,110
inputrotation:0=0
output:5ac6418f7d611a77/=
outlink:0=/=Change_Metadata.51778acf012c236e
outputxy:0=550,110
outputrotation:0=0
prop:Character='
prop:DefaultAction=Edit
editor:XY=340,150
editor:propdef=Character|string|Input||None
node:Replace_any_occurance_of_Character
bretype:core::Filter
editor:Label=Replace any occurance of Character
editor:sortkey=5ac63e786b1d70e3
input:@40fd2c74167f1ca2/=Get_Metadata.40fd2c7420761db6
output:@40fd2c7420761db6/=
prop:Script=<<EOX

emit 'FieldName',
'FieldName'.replace("\{{^Character^}}","") as "NewFieldName",
'FieldType' as "FieldType"

EOX
editor:XY=340,170
end:Replace_any_occurance_of_Character

node:Change_Metadata
bretype:lal1::Change Metadata
editor:sortkey=5ac63ecd6c4d144d
input:@516511412c32051f/=^.5ac641962bf15704
input:@5162dc5f486743e5/=Replace_any_occurance_of_Character.40fd2c7420761db6
output:@51778acf012c236e/=
output:@5163cf7b3f3e218f/=
prop:NewNameField=NewFieldName
prop:NewTypeField=FieldType
prop:OldNameField=FieldName
editor:XY=430,110
end:Change_Metadata

node:Get_Metadata
bretype:lal1::Get Metadata
editor:sortkey=5ac64102044b146d
input:@40fd2c74167f1ca2/=^.5ac641962bf15704
output:@40fd2c7420761db6/=
editor:XY=260,170
end:Get_Metadata

end:Remove_character_from_Fieldname


  • 7.  RE: LAE Error Code: ls.brain.node.changeMetadata.outputError

    Employee
    Posted 04-06-2018 01:05

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: sto

    Thanks gmullin,

    my input files are CSV files.
    Import with CSV node failed. So I used the 'Delimited File' node

    I used the node you've created.
    I copied and pasted the character '
    The "Replace any occurance of Character" node worked perfectly. It well removed the '
    But the 'Change Metadata' node failed:

    ERROR: [IOException] Error opening output.
    Error Code: ls.brain.node.changeMetadata.outputError