Host Engineering Forum
General Category => General Discussion => Topic started by: YvesC on December 03, 2008, 04:11:22 PM
-
Hi,
I have a problem with the import of the "Element Documentation". When I import a batch of some comments in my program. All of them is writen on a single or twice line but some words are crop and it's not visible. This visualisation is from the documention editor (Ctrl d).
I thought to insert a "Carriage Return" control in my csv to resolve the problem. This way didn't resolve the problem.
Can you help me to understand wath is the problem because my customer didn't like this.It's unable to search a varible correctly
Thanks Yves
-
Please Help me to found a solution
Thks Yves
-
Import/Export of Element Documentation via the .CSV file format currently does not support embedded carriage returns, sorry.
You may try inserting leading and trailing spaces such that each row of characters has 16 characters, e.g. if you have the text
X0,MyNickName,MyWiringInfo,Row1 Row2 Row3
where there was a hard CR between Row1, Row2, and Row3, then tweak it to
X0,MyNickName,MyWiringInfo," Row1 Row2 Row3 "
-
I don't understand, but it isn't work my version of DirectSOFT
my version is 5.3
Do you understand wath is the problem?
Thanks
-
The Import/Export mechanism was developed so that you could get element documentation data into or out of a 3rd party application (like Excel or a database or word or notepad or ???)
The comma separated file format (.CSV) is an ASCII, human readable file, where one row of text represents one record in the element documentation database. CR/LF in the multi-line Descriptor field does not fit this file format well. CR/LF means a new RECORD in a .CSV file, not a new line in one of its comma separated fields.
So when you have a CR/LF in the descriptor field, those characters cannot be part of the export. Say you had the following in your element documentation database in DirectSOFT
Element:
X0
Nickname:
Pump1
WiringInfo:
ABC123XYZ
Descriptor:
Line1
the text in the exported .CSV file would be
X0,Pump1,ABC123XYZ,Line1
followed by other records in your documentation database:
X3,Pump10,XYZZY,Descriptor for X3
C11,MotorStarter5,,Descriptor for C11 that goes on and on for all 6 rows of 16 characters... the end
But say your descriptor for X0 was a multiline field with user entered CR
Descriptor:
Line1
Line2
Line3
.CSV can NOT do
X0,Pump1,ABC123XYZ,Line1
Line2
Line3
it must do
X0,Pump1,ABC123XYZ,Line1 Line2 Line3
where it replaces the CR/LF with a space on the same line in the .CSV file
Try adding spaces (instead of hard coded carriage-return) in the element documentation editor to cause the word to properly wrap at the right place so that the characters show up. Then, when you export, (hopefully) you'll get something like
X0,Pump1,ABC123XYZ,Line1 Line2 Line3
then when you import it, the text shows up properly.
-
Sorry but this solution don't resolve the problem.
Do you know if a post operation after the importation can resolve the problem.
Thks
-
Sorry, no. You would have to do it by hand in the Doc Editor.