Cable catalog data

[galashkina]

The manufacturer of cable products has prepared the data for transfer to AutoCAD Electrical:
• Interface cables – 7372 types of cables
• Mounting cables – 5376 types of cables
• Control cables – 10785 types of cables
• Power cables - 7636 types of cables
There are 31169 types of cables in total.

I am using the "Transfer Utility" to import cables into default_cat.mdb.
Will there be enough AutoCAD Electrical resources to work with a database of this volume?
Are there limits on the number of records in the database?

[jallenDBQ7U]

MS Access is limited to 2 gigabytes per database.  I am not sure if you use SQL instead.  I am not sure of the impact on use of the catalog in AE either.

[jseefdrumr]

I'm not sure if ACADE has any kind of limit on database size. Since it's designed to work with Access, we can probably safely assume that if Access can open and work with a database, then so can ACADE. However, there are character limits, I'm just not certain what they are. I want to say 256 characters. There's an entry in HELP, 'Best Practices for Customizing the Catalog Database', but it doesn't really mention that specifically.

I think the real issue will be performance. As we're all aware, the larger a database is, the longer it takes to sort through entries to find what's needed. Perhaps, add the whole cable catalog to the database, and then create a secondary, smaller database for everyday use? I'm not sure how effective that would be, it depends on exactly how you do things, and whether or not your install of ACADE struggles with a huge db.

Also, if you pull this off, there could be quite a few people here who are interested in which cable manufacturer did this for you, and whether it's something any of the rest of us can also do.

[galashkina]

---

@jseefdrumr  написал (-а):

Also, if you pull this off, there could be quite a few people here who are interested in which cable manufacturer did this for you, and whether it's something any of the rest of us can also do.

---

We are preparing a database of the plant "Special Cable".

I post the prepared data on the Russian-language forum:

Импорт продукции завода «Спецкабель» в БД AutoCAD Electrical - Autodesk Community - International Fo...

[rhesusminus]

Well, There's 137142 Circuit Breakers and 247205 Motor starters/Contactors in the database, so I guess 31169 cables should be ok. Is all the cable wires number/color included also?

[galashkina]

Yes, the cable core cross section / color are included.

Moreover, different wires can have the same color, so we enter a color and a number, for example, black 1, black 2, black 3, etc.

Below is an example of a cable containing 52 cores.

[nicolas-v]

---

@galashkina wrote:

I am using the "Transfer Utility" to import cables into default_cat.mdb.

---

Hi,

I'm looking for a way to import cable data in Autocad Electrical 2022, so I don't need to type wire color for each core.

Is this transfert utility part of Autocad Electrical?

Is it possible to import such data to catalog database?

[rhesusminus]

It is the migration utility we're discussing here. It's part of Arcade.

But, for this to work, your cable data must be in MS Access format already.

All your cable data... What format are they in now?

[nicolas-v]

Our cable data is in Excel worksheet format. We're just starting using AcadE.

So, if I knew what format is expected by this migration utility, I could shape the data to match its format.

[rhesusminus]

If you open the default_cat.mdb in Microsoft Access, the W0 table specifically, you can see what field you have and what they're used for. You can easily copy/prate between Excel and this table.

For the conductors there's a different table. I'm not in front of my computer, but I believe it's named something like _CABLE_WIRES

Do the same here. Organize your Excel data and copy/paste.

[galashkina]

---

@nicolas-v  написал (-а):Hi,

I'm looking for a way to import cable data in Autocad Electrical 2022, so I don't need to type wire color for each core.

Is this transfert utility part of Autocad Electrical?

Is it possible to import such data to catalog database?

---

I used the " Migration Utility " to import cable data and core data into AutoCAD Electrical. There is an easier way to import only cable data:

1. Copy the default_cat.mdb database so that you can return to it if necessary.
2. Create cable data in Excel format (the format of the cable table must match the format of the default_cat.mdb database table W0).
3. Select the cable data and save it to the clipboard (CTRL+C).
4. Run the AutoCAD Electrical Catalog Browser.
5. Open the table "W0 (cables, multi-conductor cables)".
6. Click the "Edit Catalog Database" button (the background of the table will turn yellow).
7. Paste the cable data from the clipboard (CTRL+V) to the end of the table.
8.  Save the changes.

Please note that the values "manufacturer + catalog number" must be unique for each cable.

[nicolas-v]

Thank you very much. I could not reply earlier, sorry.

I could find the _W0_CBLWIRES in default database.

[nicolas-v]

Thank you for the explanation!

I needed to import core data easily.

[galashkina]

---

@nicolas-v  написал (-а):

I could find the _W0_CBLWIRES in default database.

---

You will find the _W0_CBLWIRES table, if you open the database in Access.

[nicolas-v]

Thank you very much.

I was able to import cable conductors.

[galashkina]

---

@nicolas-v  написал (-а):

I was able to import cable conductors.

---

Great!   👍