Has anyone worked with Navision, either using an ODBC connection or with their .zup files? Searches on the internet have been remarkably fruitless.

The accounting department has recently asked the IT dept to support Navision, and one irritating factor is the .zup files, which need to be deleted and re-created on each machine when changing databases or servers. An edit program, particularly one that could automatically change certain values, would be useful. Has anyone looked at zup files and have an idea of how to approach them, either editing, reading, or creating according to Navision's requirements?

The other issue we're having is with Navision's ODBC module, which one of our consultants is trying to work use to run queries (actually accessing it through Excel and MSQuery!). His problem is that the queries are taking a very long time. He thinks the ODBC module is downloading the entire database; I suspect the technique might be flawed. Has anyone connected to Navision's database (note: it's not Sql Server) through perl?

Any help/pointers appreciated. . .sorry about the lack of specificity, but I don't really have any code yet.

2004-12-11 Edited by Arunbear: Changed title from 'Navision questions', as per Monastery guidelines

In reply to (OT) Navision questions by SamCG

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.