Schematic reports - no data to display

[AidaM]

Just recently switched to ACADE2010. I get this "no data to display" when I try to do Schematic reports,
I know there is data in drawing like Loc, Inst, part# ...all attributes are filed.
I get this only on one desktop with vista windows.
I don't know what to do?

If anybody has any suggestions will be highly appreciated.
Thanks,
Aida

[Anonymous]

You might try existing AcadE, deleting the project's temporary database, and
restarting AcadE. The temporary database will then be regenerated
automatically. The temporary database is located in the user folder and has
the same name as the project but with a .mdb extension. Reports pull
information from this temporary database so if it isn't accurate for some
reason this could happen. You shouldn't normally have to delete this file
but it is something to try to resolve this.

Pat Murnen

wrote in message news:6225184@discussion.autodesk.com...
Just recently switched to ACADE2010. I get this "no data to display" when I
try to do Schematic reports,
I know there is data in drawing like Loc, Inst, part# ...all attributes are
filed.
I get this only on one desktop with vista windows.
I don't know what to do?

If anybody has any suggestions will be highly appreciated.
Thanks,
Aida

[AidaM]

I could not find this mdb file.
Due to some personal emergency I did not have time to look in this problem.
Soon as I can I will repair my AutoCAD E.
Thank you for you help.
If I find the reason/solution for "no data to display" will post it here.

Aida

[AidaM]

Another sweet victory.
My AutoCAD Electrical did not work properly because I did not have Microsoft Office with Vista, I got Microsoft Works.

So my ACADE could not read or write .mdb files

:)


Aida

[dougmcalexander]

AutoCAD Electrical does not need Microsoft Office in order to function. The MS Access engine is built into the installation routine of AcadE. You only need Office if you want to use Excel for editing via spreadsheet or Office Pro if you want to edit your database files directly. Autodesk pays a licensing fee to have an MS Access engine built in. That's why you are able to edit the catalog database, footprint lookup database, etc. from within AcadE. Those interface dialogs that come up for you to edit or select from the databases are actually Access forms that the developers of AcadE created, but they use the Access engine. Bill Gates makes money even when you don't realize it. Edited by: dougmcalexander on Aug 2, 2009 1:38 PM

[AidaM]

If AutoCad has Microsoft engine built in why can't I make any schematic reports or find any .mdb files on my computer?
Way to go Bill Gates!
Aida

[dougmcalexander]

If you have no .mdb files at all then you must have a failed installation. Look in your Catalogs folder under AeData. There should be files like default_cat.mdb, footprint_lookup.mdb, schematic_lookup.mdb, wd_lang1.mdb, etc. These are installed with the program. If you have no default_cat.mdb you cannot even look up part numbers to assign to components. I think your installation may not have completed properly.

[AidaM]

I do have the files you wrote. Can you open yours?
I could not find the file Pat was talking about earlier in User drive for every project it should make temporary mdb file. I don't know maybe I am wrong?
I have already repaired and reinstalled ARCADE. and no results.


I am missing Microsoft Office and that is reson I beleve. Now I have to buy It.

Thanks for your concern
Aida Edited by: AidaM on Aug 3, 2009 11:26 AM

[Anonymous]

You do not need Microsoft Office as Doug explained. Any functionality
required by AutoCAD Electrical is built in. Of course if you want to edit
the files outside of AcadE and the tools supplied then you would need it.
But it is not required for any AcadE functionality.

I want to make sure you are looking for the project database in the right
folder. It is not created in the same folder as the project .wdp file
itself. It is created in a user folder. You need to have read and write
privileges to this folder.

The default user folder is something like this -

C:/Documents and Settings/{username}/Application Data/Autodesk/AutoCAD
Electrical 20xx/{version}/enu/Support/user/


Can you find this folder? The Application Data level may be hidden. You
might need to turn on hidden folders in your explorer. There should be some
files in there supplied with AcadE, for example circ21.dwg (an example user
circuit). Maybe look for that file specifically to find the user folder.

Once you find the folder then you need to look for the project's temporary
database. It will have the same exact name as the project's .wdp file but
with the .mdb extension. Then (while AcadE is NOT open) delete the .mdb
file. Then restart AcadE and it will recreate the file.

Pat Murnen

wrote in message news:6230054@discussion.autodesk.com...
I do have the files you wrote. Can you open yours?
I could not find the file Pat was talking about earlier in User drive for
every project it should make temporary mdb file. I don't know maybe I am
wrong?
I have already repaired and reinstalled ARCADE. and no results.


I am missing Microsoft Office and that is reson I beleve. Now I have to buy
It.

Thanks for your concern
Aida

Edited by: AidaM on Aug 3, 2009 11:26 AM

[dougmcalexander]

When you insert or edit a component and you click Lookup to assign a part number, you are opening default_cat.mdb. When you Edit the footprint database from the panel layout menu, you are opening footprint_lookup.mdb. The Access engine and the forms are built into AcadE. It just so happens that I have MS Office Pro installed and I can open these databases with my copy of Access, but I don't need to.

With Windows Vista your User folder will be in a slightly different path than with Windows XP but the contents will be the same. Each time you create a project, AcadE creates a temporary or scratch database named for whatever you chose to name the project and ending with .mdb. This file will be located in the User folder. AcadE uses it to expedite certain functions within itself, including report generation. You can exit AcadE and delete the scratch database file anytime you wish. If you open the project again, AcadE will create a fresh scratch database. All databases can become corrupted over time and use. If strange things are happening, exit AcadE and delete the scratch database for the project you were working on. This is why I am so glad that AcadE is not driven by the database but by the drawings themselves. Most competitors are database-driven and this can lead to loss of data when the database becomes corrupt. The AcadE project scratch database is only a reflection of the project data so AcadE doesn't have to open each drawing to generate a report or lookup the next available wire number, etc. You can delete the project scratch database and not lose any information.

[Anonymous]

Sorry, Vista path would be something like this to the user folder -

C:\Users\{username}\AppData\Roaming\Autodesk\AutoCAD Electrical
{version}\{release}\{country code}\Support\User\

Pat Murnen

"Pat Murnen (Autodesk)" wrote in message
news:6230065@discussion.autodesk.com...
You do not need Microsoft Office as Doug explained. Any functionality
required by AutoCAD Electrical is built in. Of course if you want to edit
the files outside of AcadE and the tools supplied then you would need it.
But it is not required for any AcadE functionality.

I want to make sure you are looking for the project database in the right
folder. It is not created in the same folder as the project .wdp file
itself. It is created in a user folder. You need to have read and write
privileges to this folder.

The default user folder is something like this -

C:/Documents and Settings/{username}/Application Data/Autodesk/AutoCAD
Electrical 20xx/{version}/enu/Support/user/


Can you find this folder? The Application Data level may be hidden. You
might need to turn on hidden folders in your explorer. There should be some
files in there supplied with AcadE, for example circ21.dwg (an example user
circuit). Maybe look for that file specifically to find the user folder.

Once you find the folder then you need to look for the project's temporary
database. It will have the same exact name as the project's .wdp file but
with the .mdb extension. Then (while AcadE is NOT open) delete the .mdb
file. Then restart AcadE and it will recreate the file.

Pat Murnen

wrote in message news:6230054@discussion.autodesk.com...
I do have the files you wrote. Can you open yours?
I could not find the file Pat was talking about earlier in User drive for
every project it should make temporary mdb file. I don't know maybe I am
wrong?
I have already repaired and reinstalled ARCADE. and no results.


I am missing Microsoft Office and that is reson I beleve. Now I have to buy
It.

Thanks for your concern
Aida

Edited by: AidaM on Aug 3, 2009 11:26 AM

[AidaM]

No wonder I could not find it.
Soon as I get home I will try again. Let you know tomorrow.
Thank you Pat and dougmcalexander.
Aida

[AidaM]

Hi, Pat & Doug

I have done everything you suggested. I found project .mdb file , deleted it, restarted AutoCAD 2010.
tried to do my Schematic reports and still got message on commend line "no data to display".

At home I have new HP smart touch with Vista and Microsoft Works. (work from home) we all do.
In office I have Dell with windows XP pro and Microsoft Office pro.

I believe Doug, that Access engine and the forms are built into AcadE.

I just don't know how to approach this.

Thank you very much.
Aida

[Anonymous]

Can you send me the .wdp file and one of the drawings that you beleive has
data? Also, include in the email what report and any options you are
selecting. My direct email is pat.murnen@autodesk.com. Maybe I will be able
to see what is going on.

Pat Murnen

wrote in message news:6230540@discussion.autodesk.com...
Hi, Pat & Doug

I have done everything you suggested. I found project .mdb file , deleted
it, restarted AutoCAD 2010.
tried to do my Schematic reports and still got message on commend line "no
data to display".

At home I have new HP smart touch with Vista and Microsoft Works. (work from
home) we all do.
In office I have Dell with windows XP pro and Microsoft Office pro.

I believe Doug, that Access engine and the forms are built into AcadE.

I just don't know how to approach this.

Thank you very much.
Aida

[briangallimore]

I have a similar problem.  I've tried deleting the database file, no change.  I've narrowed it down to this:

schematic reports - bill of material utility only picks up items added as schematic symbols, ignores footprints

I tested this by creating a new project.  I can add a schematic symbol, and the part shows up in the BOM, but if I add the footprint, it does not show up.  This was working fine, and starting yesterday, it stopped working.

I using AutoCAD Electrical 2008 SP2.

Brian

[PatMurnen_Adsk]

Brian,

the Schematic Bill of Materials report only lists scheamtic symbols (with catalog information on them). There is a Panel Bill of Materials report that lists footprints. The Panel Bill of Material report has an option to list schematic components that are not represented on the panels. This is a FULL bill of materials report.

Hope this helps,

Pat

[dougmcalexander]

I only use a Schematic BOM for a design review prior to doing the panel layout.  My final BOM always comes from the Panel Layout, so my BOM contains hardware items.  In my classes I simulate a design review with the Schematic BOM, but on the final day we generate automatic reports, including a Panel BOM.  If you choose Panel BOM and select only schematic pages to process there will be no data to display.  If you select Panel BOM and select to process all drawings the program is smart enough to only display footprint data in the report.

[briangallimore]

Thanks guys, I didn't realize there were two separate utilities.  In my frustration of trying to figure out why id 'didn't work' I can't remember all the details of how I was getting it done before.  

Looks like it will do what I need, thanks for the guidance!