Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] DIREXCEL of XLSX
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] DIREXCEL of XLSX
 Login/Join
 
Member
posted
Hi, i'have an issue to create a synonym of an xlsx file that contains more of 70000 rows.

with this code i create a synonym of the file.
   CREATE SYNONYM ads_focus_data/PROV_XLSX 
   FOR 'directory\Prov.xlsx'
   DBMS DIREXCEL 
   DROP
   PARMS 'WORKSHEET Prov HROWS 6 RECORDS 3000 DBMS DIREXCEL CHECKNAMES UNIQUENAMES'


If i use a file with 10000 rows, everything works fine, but when there are too many rows webfocus return this:
FOC31049) Synonym PROV_XLSX created with default field names pattern FIELD_nn

and the TABLE FILE of PROV_XLSX extract 0 line

there is some workaround of this?

Thanks

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS Version 8.2.0.1
Windows Server 2012

WebFOCUS Version 5.3.3
Windows 2000
Oracle 8i

 
Posts: 15 | Registered: June 23, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
My create syn syntax is rusty but if you're sampling only the first 3000 records, it's possible that you have a non conforming value in the field after record 3000. Your master file assumes every record after 3000 is no bigger than the largest it's sampled. So, if you have a field that gets a bigger value or a longer string in record 11000 it won't match the master file you have at hand and it'll error out. As a test, try the TABLE FILE PROV_XLSX with a WHERE READLIMIT EQ 10000 and WHERE RECORDLIMIT EQ 10000. Keep increasing this number till you hit the problem row. Alternatively, don't limit the sampling to 3000 and let it sample the entire table so it doesn't make any assumptions about the data beyond 3000 records.


WebFOCUS 8203, Unix, Windows
 
Posts: 1333 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Exor

I agree with what Babak says.. I think if you substitute 0 for the 3000 it will look at all 70K records. Hopefully that will get you going.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1206 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Thank you for your answers, i've done all of what you say, but without success.

i've split the file in 3 files of 30000 records each,
created the synonym of the first, and changed the DATASET in the master data with the name of the splitted file.
For each splitted file i've done a simple print, and it works.

I've done a stupid test, i've opened the original xlsx file, saved it... and webfocus it's able to read the full file at once.

so the problem is in the xlsx file format maybe, it is originated in another system and WF cannot open it and save it automatically to "clean" the format of the file.

i've to find another way.

thank you all.


WebFOCUS Version 8.2.0.1
Windows Server 2012

WebFOCUS Version 5.3.3
Windows 2000
Oracle 8i

 
Posts: 15 | Registered: June 23, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Does the original xlsx file open in Excel without warnings?

As a test, can you try uploading it in WebFOCUS to see if you get any more insight into what the problem is? Upload will try to do the same thing you're doing but you'll see more meaningful warnings.


WebFOCUS 8203, Unix, Windows
 
Posts: 1333 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
i've to find another way.

What is the other way (that worked for you)?
 
Posts: 2709 | Location: Nashville TN Area [Test:8204Mg48/Prod:8202Mg60] | Registered: February 23, 2005Reply With QuoteReport This Post
Member
posted Hide Post
yes it is opened without warnings by excel

i've uploaded via Web Console and i receive the same message:
FOC31049) Synonym PROV_XLSX created with default field names pattern FIELD_nn


WebFOCUS Version 8.2.0.1
Windows Server 2012

WebFOCUS Version 5.3.3
Windows 2000
Oracle 8i

 
Posts: 15 | Registered: June 23, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Exor

If this is still an issue please open a case with techsupport if you already haven't.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1206 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] DIREXCEL of XLSX

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.