LAE

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

Originally posted by: epetrou

Hello all ,

i made a new graph trying to import some exports from another system for my company.The import is working fine ,however every column with date and time is imported without the time ,completely discarding it.

I have attached the .xls file(sample for obvious reasons) im using as well as the csv file in its original format ( the format i get when im downloading my data from another source).If you are asking why im not importing it as scv ,i have ,and im getting an error that says : expecting 1 column and finding 2.So i just gave up csv(it seems to be a problem from where i get my data) and tried it as .xls.

In the attachments is also my graph ,however i have tried it in a blank worksheet with a new default xls node and im still getting the same error.The program im using is Lavastorm Desktop 4.5.2 build 334 ,newly installed with the default server.

Any input will be great.Perhaps its only a setting in preferences perhaps something more.
Thanx in advance
Attachments:
problem.zip
NPS lists 2012.brg

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

Originally posted by: Tim Meagher

Hi,

First, the problem with the Excel File node ignoring time information is an issue that will be resolved in the next LAE maintenance release (4.5.3).

Regarding the problem with the CSV File node, it appears that the data is semi-colon (';'), not comma delimited.

Therefore, you should use a Delimited File node.
Using the delimited file node, set the FieldDelimiter parameter to semi-colon (';'), and the RecordDelimiter parameter to carriage-return newline (\r\n) and the node will read the data correctly.

Regards,
Tim.

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

Originally posted by: epetrou

thank you very much it now imports the csv file correctly and solves my problem!!


really appreciate the fast response also .

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

Originally posted by: epetrou

Another sidequestion


Do you know how i can make the delimited node, import my file when it has greek characters on its headlines ? it seems not able to read them

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

Originally posted by: Tim Meagher

Hey,

Sorry about the delay,I haven't tried to use different character sets too often so I had to double check on a couple of things.


First, these steps require that the character set is a single-byte character set. The LAE only allows single-byte character sets in the metadata (although obviously, since there is unicode support for data, this restriction does not apply to the actual data values).

I think for Greek characters, on a windows machine, this would most likely be windows-1253, which is single-byte, so this should be fine.
However I could be wrong on the Greek charset.

Anyway, you need to ensure that under Tools->Preferences->Advanced in BRE, the Server Code Page setting is set correctly to the windows character set you are using (e.g. 1253).

You can then set the server character set via editing ls_brain.prop within your LAE installation directory, under conf/brain/
And add the line:

Then, within the brdViewer, go to Preferences->Set Codepage, and set this to:

Again - all of this assumes that the character set you are after is windows-1253.

You may also need to make sure that windows is running using the same character set to ensure that there are no display issues when viewing the data.

Anyway, let me know if this resolves the issue.

Tim.

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

Originally posted by: epetrou

That had a bit of looking yeah ,it turns out it is 1253.It works perfectly.

Thank you Tim ,much appreciated