[resolved] [R] Unab t wk with paticua xc mtaata

One Star

[resolved] [R] Unab t wk with paticua xc mtaata

Hi,
I've got a pb in using an Excel metadata.
I don't understand because :
- I can make the metadata
- I can use its data structure when I work on an extract of the sheet
- I can't use the metadata directly in job (the way I look for)
- I can't use the tInputExcel targeting these particular sheet.
I use Excel 2003, the document contains many sheet and I can work with another lighter. The sheet is auto-generated with macro, when I extract the sheet it makes 4.7Mo, and the metadata generation takes 2-3 minutes, maybe it's a buffer limitation?
As example, I take the excel metada and try to write in tlogrow.
Here, the error report :
Démarrage du job sgsd a 16:49 17/03/2010.
connecting to socket on port 3942
connected
Warning: Cannot read name
...
Warning: Usage of a local non-builtin name
..
Debug: format string is 0.0
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
Warning: Shared template formula is null - trying most recent formula template
common.AssertionFailed
at common.Assert.verify(Assert.java:37)
at jxl.read.biff.WorkbookParser.getName(WorkbookParser.java:1117)
at jxl.biff.formula.NameRange.read(NameRange.java:88)
at jxl.biff.formula.TokenFormulaParser.parseSubExpression(TokenFormulaParser.java:214)
at jxl.biff.formula.TokenFormulaParser.parse(TokenFormulaParser.java:111)
at jxl.biff.formula.FormulaParser.parse(FormulaParser.java:110)
at jxl.biff.DVParser.<init>(DVParser.java:428)
at jxl.biff.DataValiditySettingsRecord.initialize(DataValiditySettingsRecord.java:140)
at jxl.biff.DataValiditySettingsRecord.getFirstColumn(DataValiditySettingsRecord.java:234)
at jxl.read.biff.SheetReader.read(SheetReader.java:994)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:676)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:252)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:285)
at recoupement_board_ess.sgsd_0_1.sgsd$1RegexUtil_tFileInputExcel_1.getSheets(sgsd.java:1032)
at recoupement_board_ess.sgsd_0_1.sgsd.tFileInputExcel_1Process(sgsd.java:1082)
at recoupement_board_ess.sgsd_0_1.sgsd.runJobInTOS(sgsd.java:1747)
at recoupement_board_ess.sgsd_0_1.sgsd.main(sgsd.java:1623)
Exception in component tFileInputExcel_1
common.AssertionFailed
at common.Assert.verify(Assert.java:37)
at jxl.read.biff.WorkbookParser.getName(WorkbookParser.java:1117)
at jxl.biff.formula.NameRange.read(NameRange.java:88)
at jxl.biff.formula.TokenFormulaParser.parseSubExpression(TokenFormulaParser.java:214)
at jxl.biff.formula.TokenFormulaParser.parse(TokenFormulaParser.java:111)
at jxl.biff.formula.FormulaParser.parse(FormulaParser.java:110)
at jxl.biff.DVParser.<init>(DVParser.java:428)
at jxl.biff.DataValiditySettingsRecord.initialize(DataValiditySettingsRecord.java:140)
at jxl.biff.DataValiditySettingsRecord.getFirstColumn(DataValiditySettingsRecord.java:234)
at jxl.read.biff.SheetReader.read(SheetReader.java:994)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:676)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:252)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:285)
at recoupement_board_ess.sgsd_0_1.sgsd$1RegexUtil_tFileInputExcel_1.getSheets(sgsd.java:1032)
at recoupement_board_ess.sgsd_0_1.sgsd.tFileInputExcel_1Process(sgsd.java:1082)
at recoupement_board_ess.sgsd_0_1.sgsd.runJobInTOS(sgsd.java:1747)
at recoupement_board_ess.sgsd_0_1.sgsd.main(sgsd.java:1623)
disconnected

I've got the 1st warning on another usage of Excel metadata and I see it's linked with Excel but the other warnings are particular with this job.
I'm french, so I use ISO-8859-1 because of the data but my columns don't use typical characters.
Best regard.

Accepted Solutions
Community Manager

Re: [resolved] [R] Unab t wk with paticua xc mtaata

Hello
It looks you have the same problem as 6580. So, try to check the 'Don't validate the cells' box.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] [R] Unab t wk with paticua xc mtaata

Hello
It looks you have the same problem as 6580. So, try to check the 'Don't validate the cells' box.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] [R] Unab t wk with paticua xc mtaata

OK, I don't understand why, how but now it seems work, I shout all validation in Excel and I can read my file..
THX
One Star

Re: [resolved] [R] Unab t wk with paticua xc mtaata

Hi everybody!
I try to extract some information from an excel file but i have this message :
connecting to socket on port 3596
connected
Debug: format string is 0.0%
disconnected
Job testAccess terminé à 14:58 06/08/2010.
can any one help me please?