Export data in Navision 2009

fabrizioc
fabrizioc Member Posts: 31
in NAV/Navision Classic Client
Dear all, I'm a new developer with Navision 2009 and I need to modify an existing export function that export data in a txt file.
This function exports all data but, as separator, inserts a <NONE> tag that I'd like to remove or at least customize with a comma or a blank space.

Debugging the function I can't see a part where this tag is added so it's seems something configured as default.
Can someone help me to identify how to perform this modification?

Thank you in advance for your help.
Best regards
Fabrizio

Best Answer

Answers

  • postsaurav
    postsaurav Member Posts: 708
    Hi,
    1. Design The Dataport.
    2. Select Properties of Dataport ( Go to Properties by Placing cursor on a Blank line) Shortcut - Shift + F4
    3. Have a Look on Property - FieldSeparator and Change it as you want. IF you want Comma(,) seprated then delete the value against this property.
    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • fabrizioc
    fabrizioc Member Posts: 31
    Thank you postsaurav, your answer is very useful, I've located the configuration, the <NONE> tag is in FieldStartDelimiter and FieldEndDelimiter, is it possible to completely remove both ? If I try to remove them navision replace with a <">. Thank you again for your precious help.
    Best regards
    Fabrizio
  • Juha
    Juha Member Posts: 39
    <"> is the default value for delimiter. Use <None> if you don't want any delimiter.

    /Juha
  • postsaurav
    postsaurav Member Posts: 708
    IF you Replace it with Blank Space then how you plan to use this file. Then it will be a single Line of Text.
    Just Curious -
    I Actually Don't understand what you will be do with a string of text?
    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • fabrizioc
    fabrizioc Member Posts: 31
    Thank you postsaurav and Juha, perhaps I'm doing something wrong but if I use <None> as Field delimiter the output file contains a <NONE> tag for each field. I'd like to have a TAB as field delimiter is it possible?
    Thank you again for your help.
    Best regards
    Fabrizio

Categories