Importing Excel files

[James Hoare]

Hello,

I am new to using PowerDesigner and am having trouble importing excel
files in a useful way.

I am using version 15.2 which allows you to import excel files. I
really want to import a excel sheet into a physical diagram format. I
have the database name as the sheet name, and all the column names
that i want in the physical model database in a column in Excel.

Unfortunately when i try to import the sheet, it does not create a
diagram, but only has 'Excel import' which does not have all the
column names that i require. I have been on the Sybase website and
read the userguide and the guide for setting up excel sheets correctly
to be imported. Neither of these has really helped (I am not blaming
the material, its is probably my bad implementation of the
instructions) and if i don't find a way to do this i am going to be
manually copying and pasting in thousands of coulmn names into rows of
a Physical diagram database.

Please could anyone help, either with some dummies guide material or
advise on what i may be doing wrong. I realise this may be the most
noddy post to have been written in the groups history, but finding out
how to do this would save me weeks of mind numbing C&V action.

Thanks,

James

[Mark Brady]

Post by James Hoare
Hello,
I am new to using PowerDesigner and am having trouble importing excel
files in a useful way.
I am using version 15.2 which allows you to import excel files. I
really want to import a excel sheet into a physical diagram format. I
have the database name as the sheet name, and all the column names
that i want in the physical model database in a column in Excel.
Unfortunately when i try to import the sheet, it does not create a
diagram, but only has 'Excel import' which does not have all the
column names that i require. I have been on the Sybase website and
read the userguide and the guide for setting up excel sheets correctly
to be imported. Neither of these has really helped (I am not blaming
the material, its is probably my bad implementation of the
instructions) and if i don't find a way to do this i am going to be
manually copying and pasting in thousands of coulmn names into rows of
a Physical diagram database.
Please could anyone help, either with some dummies guide material or
advise on what i may be doing wrong. I realise this may be the most
noddy post to have been written in the groups history, but finding out
how to do this would save me weeks of mind numbing C&V action.
Thanks,
James

Did you ever get this worked out?

[stefan h.w.s]

Post by James Hoare
Hello,
I am new to using PowerDesigner and am having trouble importing excel
files in a useful way.
I am using version 15.2 which allows you to import excel files. I
really want to import a excel sheet into a physical diagram format. I
have the database name as the sheet name, and all the column names
that i want in the physical model database in a column in Excel.
Unfortunately when i try to import the sheet, it does not create a
diagram, but only has 'Excel import' which does not have all the
column names that i require. I have been on the Sybase website and
read the userguide and the guide for setting up excel sheets correctly
to be imported. Neither of these has really helped (I am not blaming
the material, its is probably my bad implementation of the
instructions) and if i don't find a way to do this i am going to be
manually copying and pasting in thousands of coulmn names into rows of
a Physical diagram database.
Please could anyone help, either with some dummies guide material or
advise on what i may be doing wrong. I realise this may be the most
noddy post to have been written in the groups history, but finding out
how to do this would save me weeks of mind numbing C&V action.
Thanks,
James

to get the tables created on a diagram you have to enable "Create
symbols in active diagram"
There is the button "Options" you have to click in the "Excel Import
Wizard"
to start this wizard use File-> Import -> Excel Import
If you for instance create a excel sheet and name it "mytable" and
then you define in this sheet columns like name, code,
description ....
as you can see it in documentation you can add the columns and when
you import the excel file you will get a table with all columns.
Core Features Guide > The PowerDesigner Interface > Objects >
Importing Objects from Excel Files.