Combination View Flat View Tree View
Threads [ Previous | Next ]
CSV project trouble
toggle
CSV project trouble
3/1/10 9:30 AM
Hello,

i'm having trouble with the sample Inforama project: CsvProject.

It seems the .csv file cannot be read.

if i delete "$F{csv.first_name} $F{csv.last_name} $F{csv.date_of_birth} " in the letter, the parameter "$P{csvFileName}" appears well on the preview ("myfile1" in this case).

When i use "$F{csv.first_name}" or a "$F{csv.[1]} " to retrieve data from the csv, i allways get an empty page as preview.

Is there a special configuration to do in the Inforama Studio?


Thank you

Etienne
RE: CSV project trouble
3/1/10 11:21 AM as a reply to Etienne Cantineau.
Hi Etienne,

I suspect that you need to modify the project configuration files in order to get this working.

Can you edit the datasets.xml file and change the setting 'filepath' from "csv_files\$P{csvFileName}.csv" to display the full path? For example... "C:\temp\CsvProject\csv_files\$P{csvFileName}.csv".

If you're still having problems try posting the project and I can take a look at it.

Regards
Val
RE: CSV project trouble
3/1/10 1:18 PM as a reply to Val Cassidy.
Hi Val,

Thank you, it works now when i use the full path.

I have another question, with a spreadsheet datasource, in the data window on the right, the list of the data is displayed if i click on the arrow "Load the selected dataset", this doesn't happen with the csv source. Is there a problem or the csv source can't just display them?

Regards
Etienne
RE: CSV project trouble
3/2/10 11:19 AM as a reply to Etienne Cantineau.
Hi Etienne,

We have not yet implemented the UI components for the csv datasource. The csv requirement was for an implementation we needed to do which didn't require the UI part. We do intend to complete it with the next version however.

Thanks
Val
RE: CSV project trouble
9/20/10 11:37 AM as a reply to Val Cassidy.
Hi,

I'm working on Etienne's project at the moment, but I'm a beginner.
I've got some trouble with CSV import and template processing.

These troubles are related to case sensitivity during the import :

1- The generated CSV is case sensitive (camel case compliant).
2- The template processing apprears to be case sensitive.

3- The list of fields imported from CSV File inside In4ama shows fields in lower case.
4- The fields used in template are shown in lower case.

5- After having edited the in4ama-generated template manually, it appears that fields returned to camel case compliance are processed correctly.

So my question is :
Is there a way (CSV import parameter, project config, ...) to preserve CSV case sensitivity during the import process ?

Thanks,
JCH
RE: CSV project trouble
9/21/10 7:36 PM as a reply to Jean-Christophe d'HULST.
Hi Jean-Christophe,

There shouldn't be any case sensitive limitations but if you want to send me your project I can take a look at it.

Regards
Val
Copyright © 2008 - 2010