Hi all, can someone tell me -How to create the master file from a flat file or excel or csv.
Thanks.This message has been edited. Last edited by: Kerry,
WF 7610, WINDOWS EXCEL/PDF/HTML
February 28, 2011, 03:04 PM
Enigma006
Go to the app folder in which you want to create the master file. Go to master files folder and right click and select upload data file. Upload your excel or flat file (select respective option) and changes any field formats if needed and you can create master file.
8.1.05 HTML,PDF,EXL2K, Active, All
February 28, 2011, 04:29 PM
craig01
Hi enigma, i know the data upload file option. But i want to accomplish How to create a master and Query against the master,if the excel or flat file is located on the C drive or any other drive in you machine.
WF 7610, WINDOWS EXCEL/PDF/HTML
February 28, 2011, 05:07 PM
Enigma006
Generally I copy the flat file onto app folder and then will create metadata. I never created metadata directly from local drive. That would be the same creating using Upload data file where you select file from local drive. I am not sure what you are trying to accomplish. Will that file be changed regularly or something?
8.1.05 HTML,PDF,EXL2K, Active, All
February 28, 2011, 05:49 PM
craig01
yes,the file will be changed regularly on a Daily basis. the developer gets the file on to the local drive(C:\) every day.so need to create the master from the flat file from the local drive daily rather than copying it into the APP Folder and creating.
WF 7610, WINDOWS EXCEL/PDF/HTML
March 02, 2011, 06:39 AM
GamP
If it's a flat file or csv file, you can just create the master and store it somewhere in your apps folders. When you need to access it, all you need is a filedef that points to the correct location. This will of course only work if the server that is accessing the file is on the same machine as where the file is stored. If it is an excel file, then it is a bit more complicated. You can create a masterf ile for an excel file, but you will need to have: - a named range within the excel sheet that defines the range of cells available to webfocus - a system dsn odbc connector which points to the name defined in the sheet - a configured odbc adapter in your reporting server that points to the odbc connector If that's all in place, then you can create your master file and use it. Again, this all needs to be on the smae machine.
