Is there a clean way to export a CSV file of the fibers I now have in my catalog?
I have dozens of different wires to get into the catalog. If I could edit a CSV of the exisitng entries, i could complete this job in a fraction of the time required to enter each wire type into the catalog using the Catalog Explorer.
I also want to be able to look over the entries for previously entered fibers, to make sure they all have the same format and parameter names.
you should only really have one fiber in the catalog which has a dataset. Every fiber must have a dataset in order to drive cabling design.
So create a fiber.
Create your dataset
Import your dataset
Apply the dataset to the catalog fiber
I guess what I really need is a way of seeing what the dataset I already have looks like, so I can modify it to add the different wires I need.
I have the standard ten colors for several AWG wires now - I need to add multiple color wires and some additional AWG sizes. If I could do this in Excel and import the CSV file rather than use the catalog explorer to create every new wire, I would be very happy.
So - how do I get into the dataset?
Open the dataset explorer, select the dataset of interest and choose save to disk.
Edit the CSV and then using the Dataaset explorer re-import back into Creo Schematics.
OK. Opened Creo Schematics, loaded my project. Went into the Admin tab, opened the Datatable Explorer.
This is, I hope, where the wire data is hiding. Selected the CSV button and tried to save the dataset so I could look at it.
My projects are saved in "C:\Documents and Settings\All Users\Documents". When I try to navigate to that directory, I see this:
I can't navigate to the unnamed directory, and I can't see the directory where I want to save the CSV file.
When you save the dataset the message area will tell you where the file was saved e.g.
[wires, <215098618-2188>, Datatable] (and associated objects) has been successfully saved to directory d:\Temp\wires
I think I see the issue - the "type" selection at the bottom of the window only allows "directories". I cannot enter a CSV file name.
Why the project directories don't show up is another issue - here's a screenshot of my computer:
I do note that the project directories are read-only...
So, I now have a saved CSV file. Thanks, Jim.
Could the file selection window be looked at by your programmers? It seems awfully clumsy and obtuse the way it works. When I see a window like that, I expect to be able to tell the computer what to call the file and where to put it. Simply clicking "save" is totally unobvious.
And I now have a new dilemma. The dataset CSV file "spool_params.csv" appears to be something totally at odds with what I have been painstakingly entering in Schematics for my catalog.
I have entries for many different AWG sizes that do not appear in the CSV. Some of the colors I have entered also don't show up.
I am back to my original question - how can I enter wire data simply without going through the catalog explorer interface again and again for each new color or size?
The fiber looks at the information in the dataset to apply the information. So whatever you have parameters you have appended to the fiber in the catalog will have zero impact on CSV file.
So as above, edit the CSV, Import into Dataset explorer, select fiber in catalog, edit the parameters, click choose dataset, select the imported dataset.
Instance a fiber on the sheet, edit the parameters and apply dataset of choice