Hi..
I Have an Excel File.
I want to import that excel file into FM and i want to create an Model.
I have installed FM on my Local Machine.
Does any one kindly Share the steps to create the Model using Excel File.
Thanks in Advacne.....
There is a search option on the upper right portion of the Cognoise site. If you search you'll find numerous posts that answer your question. I further suggest you look again at Chapter 3 of the FM user guide.
Hi Naresh,
if you want to import excel files into Frame workmanager first you have to create an ODBC connection.to achieve tis follow these steps
1)excel file into CSV
>first save all your excel files in CSV format
>to save an excel file as CSV open excel file from file menu select Saveas option
>under file type chnage to csv
2)creating ODBC connection
>open controlepanel> administrator tools>open Data source ODBC
>in Data source ODBC select SYS DSN tab
>under SYSDSN tab click on add
>create new data source window will open
>in that window select ''''''Microsoft textdriver (*txt'*'csv*),click finsh
>odbc text setup window will open
>in that UNCHECK the 'USE CURRENT DIRECTORY PROPERTY"
>select directory window will open
>in that browse your csv file physical path
>from left side select CSV files you want to add
>then click ok
3)
>open framework manger
>create data source connection and then import files
this is the process.hope it helps you.
thanks
bvk
Hi Bvk,
I am not able to select the .csv file in Select Directory tab.
The file which i have saved is not able to select... Please advice
Thanks
Naresh
Hi Naresh,
in in create new data source window which format you selected?
i think you may selected ''''''Microsoft Access textdriver (*txt'*'csv*)'''
make sure have you selected below format
Microsoft text driver (*txt'*'csv*) if it still not working please let me know .
thanks
bvk
Hi Naresh,
try this c
>opy all your CSV files into one folder
>>in Data source ODBC select SYS DSN tab
>under SYSDSN tab click on add
>create new data source window will open
>in that window select ''''''Microsoft textdriver (*txt'*'csv*),click finsh
>odbc text setup window will open
>first give source name
>in the same window UNCHECK the 'USE CURRENT DIRECTORY PROPERTY"
>select directory window will open
>in that browse your csv file physical path
>from left side select CSV files you want to add(as well as select the source folder right side)
>then click ok
thanks
bvk
Thanks BVK...Its working fine
Hi Naresh,
my strong suggestion is please dont use csv files directly for reporting .first you load those data into one server.for eg: sqlserver.
because if your using csv files directly some function wont work properly in report studio.
thanks
bvk