RSD: Importing Global Properties using .csv file

[ScottPearson]

THE SITUATION First off, I create my .csv files in Excel (doing a SaveAs to the .csv format). Second, I frequently have 100+ values in my Value List (which is used for Signal Names). This high number of values seems to cause a problem when importing the .csv into RSD's Global Properties. Actually, I believe the problem is the number of characters; not the number of Values. During import, I receive this error: IMPORT READ ERROR Import error:Error at line 3 in stdin: No terminating quote in field 6 It seems to me that my very long list of Values is getting truncated during importation and thus the "terminating quote" (which is the "]" character, I believe) does not get read and thus appears to be missing -- though it is indeed in my .cvs file. When I shorten my list of Values (for example, to less than 50 Values), the import error does not occur. That's what leads me to believe the problem is due to the number of Values/characters in the .csv file. Can anyone confirm this apparent limitation in .csv files when importing into RSD's Global Properties? MY WORKAROUND (sort of...) To work around this apparent limitatin, I create two different .csv files for importation. The first .csv file contains, for example, my first 50 Values. The second .csv file contains the second 50 Values. Then I import the two different .csv files and create two different Globabl Properties. The only problem with that is that I do end up with two different Global Properties when I'd prefer just one. A WISHFUL WORKAROUND I wish that I could import the first .csv file to create a Global Property, then import the second .csv file to APPEND the Value List of the same Global Property. In case you've ever tried this, it doesn't work. Instead of APPENDING the Value List, importing a second .csv with the same Property Name REPLACES the Value List of the Global Property with the new Values contained in the second .csv file. Bummer. Does anyone know of a working method for APPENDING the Value List of an existing Global Property? Mucho thanks.
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.

[CBenner]

Have you posted this on the user forums at PTCUser? There is a tab there for Routed Systems, that several gurus read. You might get some good responses there. http://portal.ptcuser.org/index.php?mo=fo&op=sc&catid=17 You do need an account.

[ScottPearson]

I have now. Thanks for the suggestion. I had already posted to the forums at RSDesigner.net and MCADcentral.com.

[CBenner]

RSDesigner is a good one, but you may get a slow response. However, if you get a reply it will be from the man who knows. He's one of the developers. He also checks out PTCUser.

[sschroeder]

Why are you importing so many values into the global properties? Have you tried importing the values to the data table explorer and using data tables to set the appropiate values? A membermap could be used to apply properties at a connector level and then map all the signal names into ports on the connector.

[ScottPearson]

The Global Property for which I am importing 100+ Values is called signal_name. I use that Global Property for my fibers (wires). I often use 100-pin connectors with a different signal name on each fiber (wire). The signal names are provided to me in an Excel spreadsheet so the handiest way to get 100+ signal names assigned to a Value List of a Global Property assigned to a fiber (wire) is to manipulate the .xls info to the proper .csv format. Having a Value List from which to choose the signal name eliminates the chance of typos. Though I will give some thought to your suggestion of using Data Tables and Membermaps, do you have an answer for the original questions of: 1. Is the truncation of a Value List in a .csv file the cause of my error? (I suspect it is, but I'm looking for someone to confirm based on their personal experience.) 2. If the answer to #1 is "Yes", is the truncation due to a limitation of the .csv file itself or of how RSD handles the importation? (If there is a character limit to what RSD can import then that limitation should be a known value, e.g. 512 characters, 1024 characters, etc.) 3. Is there a way to APPEND a Value List (using an imported .csv) of an existing Global Variable? Thanks for the feedback.