LAE

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

Originally posted by: sto

Hello all,

my imput file contains employee ID.
All employees' ID are 4 letters + 4 digits, like 'DHRF4526' or 'HJES4491'.

But some of them are like 'JUNE1216' or 'DECE2324' and Lavastorm are transforming these values into dates : Jun-16 and Dec-24

I tried to change the field type (from string to unicode) with the "changes field" node. No success

Any ideas ?

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

Originally posted by: gmullin

It sounds like something Excel might do depending on the format of the cells. Is this an Excel input file? When you click on the entire row for Employee ID in Excel is the format set to date or custom? If so try putting it back to General or Text.

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

Originally posted by: sto

Thanks gmullin for your swift feedback.

Yes it is an Excel input file.

Cell Format are G (General).
More precisely, S (Standart) on my french computer.

I would like to avoid modifying anything in the input excel files. There are too many...

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

Originally posted by: gmullin

Can you also try setting IgnoreCellFormatting to true in the Excel node (Optional tab)?

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

Originally posted by: sto

As the Excel node wasn't importing the data I used the 'Delimited File' node. Import is well working with that node.

I just tried to use the Excel Node with IgnoreCellFormatting to true, and it is not working.

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

Originally posted by: sto

oups sorry.

My files are CSV files.

and here is the error message when I try to import the file(s) with the 'CSV file" node:

Error while starting execution of node 'CSV+File'
Error executing node: Node :'CSV+File' (handle: 5ac647af7c210918) encountered error during initialization
WARN: Property ls.brain.node.convert.filenameExpr not set
Error Code: brain.node.ConvertNodeControl.cpp.127

ERROR: Node execution terminated while reading settings by error:
Property ls.brain.node.convert.filenameExpr not set
Error Code: lae.node.executionTerminated

----------------
The import with Delimited file works well.

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

Originally posted by: gmullin

That error looks like you have an input pin on your CSV node that you possibly need to delete. If you have an input pin you need to use FilenameExpr instead of File. If you have no input pin you can use File to specify the full path of the file.