Extract entity without empty rows and pattern problems

Carlotta Fabris

Hi!

I am trying to extract an entity to check if there are duplicates. When I sort the .csv file, I have some descriptions without code at the beginning of the file. In Board all members of the entity have a code and a description, so I checked it better and I found that some descriptions are wrapped up. Thus the descriptions without codes that I find in my .csv are the result of this wrapping of the description. Naturally before this there is an empty line that causes several problems when reloading all entities and cubes (after the migration for example).

 

This could maybe cause another problem: when I try to make data entry based on a pattern, it saves data on another code. For example, data entry on code xxxx -> saves on code yyyy.
Could this be the reason why I have this problem and how could I fix this and also the empty lines on the extracted file?

 

Thank you!

Carlotta.

Previous Member

Hi Carlotta,

 

i am not sure about the data entry part of your question.

 

The misaligned export happens if you have either a tab stop or a line break within your Entities. Best way to fix this is to alter the affected elements in your source system. If you open your Board exports using a program which allows you to see those characters (e.g.: Notepad++) you should be able to see which elements contain any of those characters.

 

If you load data per SQL you can also use the "Replace" command to replace those characters importing data.

Replace(Column A, Char(9), " "), for example, will replace all tab stops in Column A with a space symbol.

 

Hope this will fix your export problem.

 

Mark

Carlotta Fabris

Hi Mark!

 

Thanks for your answer. I tried using Replace in the data reader but I obtained the same result, so the descrption still has the same problem.
Maybe I should remove the line breaks in the SQL View and then execute the data reader?

 

Thank you again,

Carlotta.