How to Import Excel file into FM to create Modelling.....

[Naresh]

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.....

[Lynn]

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.

[bvk.cognoise]

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

[Naresh]

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

[bvk.cognoise]

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

[bvk.cognoise]

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

[Naresh]

Thanks BVK...Its working fine

[bvk.cognoise]

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