 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] A place to store XLSX data files end users can access & upd and rpt from?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] A place to store XLSX data files end users can access & upd and rpt from? Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] A place to store XLSX data files end users can access & upd and rpt from? | Login/Join |
| Virtuoso |
Hi all, It's been a while. I apologize for that. I've been super busy with various things. Hoping to show my face a lot more here soon enough. Anyways, we have a need for storing Excel data sheets in a location where end users can get to to update them, but where we can tie to them within WebFOCUS to report from via a synonym description of them from the Data Servers apps directory. Has anyone here on the forums come up with a good solution for this type of scenario? How did you go about it? Ideally this would be like a secured spot in that this would be the only place the end users could get to once they do have access to where ever it needs to be. We've got a userfiles directory share on the reporting server already. Would we be able to place an Excel sheet therein maybe? Then, utilize ReportCaster to run a job to refresh a synonym from an Excel file from there? Any thoughts/solutions are welcome. Thanks!This message has been edited. Last edited by: FP Mod Chuck, 8.2.02M (production), 8.2.02M (test), Windows 10, all outputs. | ||
|
| Virtuoso |
Hi CoolGuy You have the right idea. A secured shared drive on the reporting server is the easiest way to accomplish this. If it is not under the \ibi\apps folder you can put an APP MAP to the location in the server profile. Since reporting against these is a big requirement having them on the reporting server is the best place. Let me know if you need more details Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Virtuoso |
Hi Chuck, Thanks for the information on APP MAP and the server profile! Tested that out and it works great! Now, the only missing piece is whether there's a way to schedule a refresh of a synonym generated from these Excel sources? I looked at creating a RC job, but there isn't a task option for such a thing. Do you know of a way we can schedule a synonym to refresh itself? Thanks so much for chiming in! 8.2.02M (production), 8.2.02M (test), Windows 10, all outputs. | |||
|
| Virtuoso |
Here is the syntax for creating an excel synonym via a fex You should be able to schedule this fex to run. Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Virtuoso |
Chuck, you rock. Do you know where I can find some documentation on the syntax you gave me? Not seeing it in the 8201M docs, so I'm guessing I'll have to jump back a few versions of documentation before I actually find it if it is documented? haha Trying to get an understanding of what the last bit does and what options are available for PARMS, etc. ... PARMS ? WORKSHEET <worksheetName?> HROWS <-- specifies to use first row as header row? 1 RECORDS 0' DBMS DIREEXCEL <-- says we're getting data from Excel? CHECKNAMES <-- ?? UNIQUENAMES <-- ?? Thanks again! 8.2.02M (production), 8.2.02M (test), Windows 10, all outputs. | |||
|
| Virtuoso |
CoolGuy I could not find documentation either. I turned on traces on the reporting server and did a create synonym for a direct excel adapter and found what it generated. The worksheet parm is the actual worksheet name, HROWS is the number of rows of header information and RECORDS should be 0 so it scans the entire worksheet to get the field attributes Hope that helps! Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Virtuoso |
Okay, thanks for the insight! Will have to try that then. Which trace did you enable by chance? Any particular one? 8.2.02M (production), 8.2.02M (test), Windows 10, all outputs. | |||
|
| Virtuoso |
Hi On the reporting server under Workspace / Traces I used the option enable trace. You should time this based on having the create synonym ready to run from a separate browser session. Then once you run the create synonym disable the traces as you will get a bunch of them and may be hard to find the trace. They are located under the edatemp directory and begin with ts. Look for the syntax CREATE SYNONYM in the trace file. Regards Thank you for using Focal Point! Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] A place to store XLSX data files end users can access & upd and rpt from?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] A place to store XLSX data files end users can access & upd and rpt from?Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |