Skip to main content
C
catipash1-Visitor
1-Visitor
September 23, 2014
Question

.xml file is not getting imported into Cabling

  • September 23, 2014
  • 1 reply
  • 7106 views

I created .xml file with the help of excel data, but when I am trying to import it in cabling window, it is saying error .xml is not exported from Routed System Designer.

I am attaching Excel data and xml file which i created out of the excel, please check and help me where is the defect.


This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

1 reply

M
msonnathi1-Visitor
1-Visitor
September 23, 2014

your xml file doesnot have proper info.need to have some basic info of where to where the spools are connected for cabling. It will not read.

C
catipash1-VisitorAuthor
1-Visitor
September 24, 2014

Madhu I am really thankful for that quick response, In my post above I have also attached the Excel file from which the xml file is created.

My Excel defines

1) spool as w1 & w2,

2) Colors of wires,

3) Size,

4) From and To is Ep1 and Ep2 (that is Entry port 1 & 2) co-ordinate systems

5) Item no. A,B,C,D are connector part names.

I think this excel data is enough to create basic routing.

May be the xml file created out of the excel is not correct, as i used some converter from google to create it.

Can you please try to create xml file out of my excel and call that in creo cabling through rsd, and let me know if it is reading successfully.

B
BrianMartin13-Aquamarine
13-Aquamarine
September 24, 2014

Hi Syed...

I am working on a translation tool to generate XML files for Creo Cabling but unfortunately I don't have a working demonstration available yet.

From what I can see, you may have enough for a basic routing but this assumes your spools, connectors, and entry ports are all designated in advance. Part of the benefit of having an NWF file (or XML) is not having to manually import spools or designate connectors.

The problem with your XML file is absolutely the format. Your formatting is incorrect. The best way for you to learn the proper format is to have Creo give you the format. Then, after you understand what Creo is looking for, you can plug in your own values and generate XMLs easily.

Here's what you should do:

  1. Generate your spools (or import them manually)
  2. Designate your connectors including entry ports
  3. Route your wires using the appropriate spools
  4. From inside the Cabling application, go to the Logical Data group and select the drop-down arrow. Choose Export from the listing and select RS Designer as the output format. Save the file in a location you can easily access.
  5. Download and install a credible tool capable of editing XML such as Notepad++. This is a freely available tool without adware or spyware... and it color codes the XML statements so they're easier to see. Open your XML file in a tool such as Notepad++ and examine it.

This will help you understand the format Creo is expecting. With this information in hand, you can now create your own XML files from Excel in the proper format. Creo will read the file correctly and create spools, designate connectors, and route wires using the XML logical data.

I hope that helps get you going in the right direction.

Thanks!

-Brian

PS: I've attached my own XML file for you to see a demonstration of the proper format the file should have. My XML contains spools, connectors (with entry ports) and wire connection (From/To) information. As you can see, this format is much more intricate that the one Google generated.

    Terms & ConditionsAccessibility statement