mibuso.com
Home› Download section

Xml Export 1.3i

AdministratorAdministrator Member, Moderator, Administrator Posts: 2,500
edited 2007-02-07 in Download section
Xml Export 1.1i
With Xml Export 1.1i for Navision 3.70 you can export anything to xml from Navision.

http://www.mibuso.com/dlinfo.asp?FileID=285

Discuss this download here.
«1

Comments

  • AnonymousAnonymous Guest Posts: 137
    Great work! Just a few minor remarks:

    - The field "Filter" in table "Export Data Item" should not be editable;
    - I have tried to use your objects in a newly created, empty database. Exporting an XML file did not work because of a dependency on base application objects. Would you please consider including all the objects required in your own application (even if they are copies of base app objects), so that it can be run from a database that does not contain (all of) the base objects?
  • AnonymousAnonymous Guest Posts: 137
    It good to see you, of all people, only got 2 minor comments. The first one will be fixed in the next release. This release is planned on… well, a day in the future would be the best estimation I can give at this moment. I do not agree on the second comment you made (well maybe a bit), course what would you like to export as xml if you import the objects in a empty database?
  • AnonymousAnonymous Guest Posts: 137
    Know issues in this beta version:

    - Template node name is not automaticly filled. This will cause a error.
    - You can not use any spaces or any other non alphanumeric charaters in a node or element name.
    - You can not start a node or element name with a digit.
    - You can not start a node or element name with the characters “xml”.

    * These rules are xml. The tools should convert all non-allowed charaters, which it doen't. This is sheduled for next release.

    - Boolean field "Filter" in dataitem list should not be editable.
    - No header information in xml file.
  • ajhvdbajhvdb Member Posts: 672
    Excellent work, learning a lot from this. Tried it first in 3.60 (duh).
    Create dynamic Excel or Word documents, ReportX
  • ajhvdbajhvdb Member Posts: 672
    In function -IncreaseIndentDataItem

    DataItem2 := DataItem;
    DataItem2.SETRANGE("Template Name",DataItem2."Template Name");
    DataItem2.SETRANGE(Indent,DataItem2.Indent);
    The red part was missing :shock:

    I couldn't figure out why subrecords were not added to the xml file until I checked the indention.
    Create dynamic Excel or Word documents, ReportX
  • eromeineromein Member Posts: 589
    You don't say, thank m8... I'll change it!
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,500
    Xml Export 1.1.01i
    With Xml Export 1.1.01i for Navision 3.70 you can export anything to xml from Navision.

    http://www.mibuso.com/dlinfo.asp?FileID=285

    Discuss this download here.
  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,500
    Xml Export 1.2i
    With Xml Export for Navision 3.70 you can export anything to xml from Navision.

    http://www.mibuso.com/dlinfo.asp?FileID=285

    Discuss this download here.
  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,500
    Xml Export 1.3i
    With Xml Export for Navision 3.70 you can export anything to xml from Navision.

    http://www.mibuso.com/dlinfo.asp?FileID=285

    Discuss this download here.
  • eromeineromein Member Posts: 589
    Scheduled in next release.

    1.) Variable xml version tag
    2.) Variable schema tags
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • ChristophChristoph Member Posts: 9
    thank your for your work - it helped me a lot.

    But I got a little problem.. please have a look at the following thread..

    http://www.mibuso.com/forum/viewtopic.php?t=3278

    any suggestions??

    Thank you Christoph
  • dsatriadsatria Member Posts: 80
    Why can I use FlowField field as dataitem filter?
  • dsatriadsatria Member Posts: 80
    My previous question should be:
    Why can I NOT use FlowField field as dataitem filter?
  • BrokenhopeBrokenhope Member Posts: 5
    How can I use this ?

    I have never developed anything within Navision and this is the only thing I need, "Export a table in a XML format"

    Could someone tell me how I can start this excellent unit?

    Thanks in advance,
    John
  • eromeineromein Member Posts: 589
    Hello, I have just download your XML Export Tool, and discovered that the

    fob and the txt file is missing a Referenced Table (Header) Table 51025 is not included.

    Could you please mail me the Table.

    Thanking you,

    Wayne Forrest.

    You are quite right but this table is not needed... You can delete the variable and everything should be working just fine.

    Please make sure your node and element names are not containing spaces or any other weird charaters, and they can not start with a number.
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • themavethemave Member Posts: 1,058
    How do I delete all these object from my database, can't use them it says I don't have premission to read the tables, ect. appearantly this is directed at developers not end users, wish it had stated that somewhere before I downloaded and imported into my database.

    but anyways, I can not delete the objects either because of the premission error.
  • ara3nara3n Member Posts: 9,256
    Did you load this into production?
    If it's a local export all objects exept the ones you don't want. create a new db and import the objects you've exported. Then do a backup from the old db and restore only the company and data shared accross company.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • themavethemave Member Posts: 1,058
    It is in a test database, I will use this method to clear out the files.

    I am emailing the creator to see if there is a version with permissions that I could try out.
  • ara3nara3n Member Posts: 9,256
    usually they include txt file that you can modify and import in the range you want to.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • themavethemave Member Posts: 1,058
    ara3n wrote:
    usually they include txt file that you can modify and import in the range you want to.
    There is a text file, but without developer license you can't import text file, only FOB
  • SavatageSavatage Member Posts: 7,142
    edited 2006-07-06
    If i get some time I'll modify the fob for you - unless someone beats me to it.

    What # range would you like 50000 to 50099?

    he has it set in the 51000 range
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • ara3nara3n Member Posts: 9,256
    themave wrote:
    ara3n wrote:
    usually they include txt file that you can modify and import in the range you want to.
    There is a text file, but without developer license you can't import text file, only FOB

    By customer license I meant the license that allows you develop, the granual costs is around $ 8K. I don't know how much it costs now.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • trennerttrennert Member Posts: 22
    Hello,
    We are interested to develope some electronical exchange with our vendors and clients. At this beginning state of the project, I am looking at the different possibilities to export and import xml data.
    Migration to a newer version of Navision will be in a far futur.
    This XML export tool seems to be fine, but it seems to work only from version 3.70 on.
    I tried it out and after some problems it seems to work.
    Whta are your suggestions ?
  • ara3nara3n Member Posts: 9,256
    in 4.0 they've added xmlports, which are new object types and dataports should not be used for xml ports. You cannot use dataports in NAS.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • trennerttrennert Member Posts: 22
    I know that in 4.0 there are new xml features - but as I said : migration will not be done this soon.
    For the NAS comment - I did not know this - thank you - We must try to find another way to automatise.
    Or perhaps I should go for a solution in SQL Server, with the into xml option ?
  • ara3nara3n Member Posts: 9,256
    In 3.7 you can use MSxml dom COM to load the xml document. It works fine. Navision uses it in several of it's codeunits filter on XML in Codeunit and see the examples.

    If you are on sql, then you can create new tables in Navision, and they can write directly into those tables. From Navision you can process those tables. This I've found is one of the simplest integration.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • trennerttrennert Member Posts: 22
    Yes we are on SQL Server.
    I really would like to understand what is this simple solution about. If you can, could you please go a little more in details. We are in Navision version 3.01.
  • ara3nara3n Member Posts: 9,256
    A few questions.
    Could you tell me a little about what you are trying to integrate?
    Is it a two way or one way integration?
    Can the other system write the data into your sql system?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • trennerttrennert Member Posts: 22
    We plan in a first time to make up an exchange with one of our vendors.
    It will be a 2 directional exchange :
    we will send our purchase orders, and we will receive feedback if the products are available and when they can be sent to the customer.
  • ara3nara3n Member Posts: 9,256
    I see. So it looks like you can't give them access to the a staging table.

    going the xml route is fine. How much development experience do you have outside of navision? If you can parse the xml outside of navision, then do that and put them in staging tables.


    My guess this won't be real time communcation. You'll send the xml doc and you'll receive a reply later in the day.


    There are so many things to consider. It's hard to do it over the web. See if you can contact your NCS and ask them for a design.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.