Blogs

B1DE 2.0.1 new version!
Maria Trinidad MARTINEZ GEA SAP Employee Active Contributor Bronze: 250-499 points
Business Card
Company: SAP
Posted on Oct. 26, 2009 01:33 AM in SAP Business One

URL: http://www.sdn.sap.com/irj/sdn/index?rid=/webcontent/uuid/a175fb62-0c01-0010-a8b5-fa58a13b1cf7

Subscribe.Subscribe
Print. Print
Permalink Permalink
Share


Do you know about B1DE and its tools?

A new version has been submitted in SDN, this version will fix some bugs existing on previous versions like:

  • Fix authorization problem for UDO classes generation on Code Generator Wizard.
    Version 2.0 exposed a new feature for UDOs giving you the possibility to autogenerate a class for a UDO. This feature had a limitation on version 2.0 due to authorizations needed to execute the generated class (cf blog Non Super Users and B1DE version 2.0 UDO classes).
  • Fix bug on UDO class generation for a UDO without child tables (an exception was thrown and the class was not generated)
  • Fix problem with User Defined Fields of type Float and Date creation through the Code Generator (an exception was raised as size was wrong, no size is needed)
  • A new format has been defined to provide the Db Changes between different SAP Business One versions. The DbBrowser now includes the new files provided for versions up to SAP Business one 2007 version and is able to read this new format.


Do you know more concretely about B1DbBrowser tool?
And its capability to read the DbChangesList files given per each SAP Business One release?

B1DbBrowser is a tool included in the B1DE (Development Environment) tools package. This tool visualizes the current status of a SAP Business One database in terms of the tables currently defined, their columns, and properties – such as name, type, default values and database constraints. It can be started from the B1 Code Generator Wizard or directly executed as a Windows application.

One of the specifc features of this tool is to be able to read the DbChangesList files given per each SAP Business One release and show the tables that are new or modified together with the specific fields or keys modified in each table.
In order to see the DbChangesList corresponding to a specific SAP Business One version just go to the ToolBar of the B1DbBrowser, select the DBChanges menu button in the top right part and finally select the version you want to see the differences regarding its previous version (ex: if you select 2007 you will see the differences between 2007 and 2005 SP01 databases versions). Please not the DbChanges are obtained from a fixed xml file and doesn't depend on the database you are connected to.

Just have a look to the following screen capture to see how the information is presented by B1DbBrowser:

image"

As the format of the DbChangesList files has changed to provide more accurate information B1DBrowser has been adapted to be able to read the new files for versions starting from SAP Business One 2007. Go and download the new version of the B1DE package (2.0.1) from the SDK Tools page and have a look at this tool.

 

 

Maria Trinidad MARTINEZ GEA  Active Contributor Bronze: 250-499 points is a member of the SAP Business One Solution Architects team. The Solution Architects team helps the Business One ISV global community to deliver best-in-class solutions based on the Business One core platform.


Comment on this articleAny comments on this tool (how useful is it for you, missing features, bugs, ...) please let us know in this blog or the B1DE blog.
Comment on this weblog
Showing messages 1 through 34 of 34.

Titles Only Main Topics Oldest First

  • SAP Business One AddOn Wizard
    2011-12-01 03:11:55 Gonzalo Gonzalez Business Card [Reply]

    Hi Trinidad.


    I have SAP B1 8.81 and Visual Studio 2008 but when installed B1DE2.2 don`t show the icons to create the installation project addon.


    What can be the cause?

    • SAP Business One AddOn Wizard
      2011-12-05 06:01:09 Maria Trinidad MARTINEZ GEA SAP Employee Business Card [Reply]

      Hi,
      Do you see the code generator wizard but not the installers?
      Pay attention the installers are only available for Vb.NET and not for C#.
      Regards,
      Trinidad.
  • work with B1 8.81?
    2011-02-24 18:37:23 Eun Seok Bang SAP Employee Business Card [Reply]

    Hi Trinidad


    Does B1DE 2.1 work for B1 8.81?


    I always meet the error "index out of array" when I launch code generator.


    I tested it in the following environments.
    1. B1 8.81 PL02 on Win 7 pro with VS 2010 express and SQL 2008 express
    2. B1 8.81 PL02 on Win XP pro with VS 2008 express and SQL 2005 express

    • work with B1 8.81?
      2011-06-16 07:27:45 Antonio José Infantes Carmona Business Card [Reply]

      Hi Trinidad,


      I have the same problem "index out error", I tested it with a diferent environment that our partner:


      1. b1 8.81 PL 05 on win 7 with vs 2010 and sql 2008 standard
      2. 1. b1 8.81 PL 05 on win 7 with vs 2008 and sql 2008 standard


      thanks for your reply

  • Release date for VS 2010?
    2010-10-11 07:03:17 Sebastian Kleiner Business Card [Reply]

    Hi,


    thanks for providing those great tools which make life really easier. I'd like to know if there is a release date in sight for VS2010? We wanted to build up a system with 2008 R2 which is not supported with VS2008.


    Thanks in advance
    Sebastian

  • B1Addon crashing
    2010-09-15 08:10:19 Eduardo dos Santos Gonçalves Business Card [Reply]

    Hi.
    I'm trying to create a simple addon for SBO using the B1DE.
    The steps for the creation of add-on and for the creation of the installer have been successfully concluded, following the scratching that is contained in the file TODO.txt. I can install it without problems, but when I go run the add-on, the following error occurs: "http://img651.imageshack.us/img651/3894/exception.jpg".
    Did you know what can be? I've tested in frameworks 2.0, 3.0 and 3.5. Thank you in advance for attention. Thank you.


    My system have:
    Windows XP SP3 x86
    Microsoft SQL Server 2005
    SAP Business One 8.8 PL 12
    B1DE 2.01

    • B1Addon crashing
      2011-04-27 05:04:54 Marc Roussel Business Card [Reply]

      Hi,


      It can be anything in your code. Did you test the addon on your own system ? I means in development mode, you can debug what's wrong.


      If there's nothing apparent then it can be a missing dll you need in your projet which isn't included in the installer. Sometimes if you hit the DEBUG button, it can use the JIT and show you a better message. Probably a missing file.


      Hope this helps.

    • B1Addon crashing
      2010-09-16 09:00:39 Maria Trinidad MARTINEZ GEA SAP Employee Business Card [Reply]

      Hi Eduardo,


      It seems a problem in your add-on, maybe you can try to have some logs from your add-on while running?
      Maybe some files needed by your add-on are missing after the installation?


      Regards,
      Trinidad.

      • B1Addon crashing
        2010-09-16 12:04:07 Eduardo dos Santos Gonçalves Business Card [Reply]

        Hi Trinidad! Thanks for the reply.


        Following your tips, I captured the following error:


        "Unhandled Exception: System.TypeLoadException: Method OnLanguageChanged B1AddOn1.B1AddOn1 the type of module (assembly) B1AddOn1, Version = 0.0.0.0, Culture = neutral, PublicKeyToken = null does not have an implementation".


        But the definition of this method cited above is not B1DE standard and points out errors or warnings in the build:


        public override void OnLanguageChanged (BoLanguages language) (
        // Throw new NotImplementedException ();
        )


        Regards,
        Eduardo.

  • Add-on excecution failed
    2010-08-26 17:21:46 Eduardo dos Santos Gonçalves Business Card [Reply]

    Hello!
    We made the whole process properly. We install the add-on successfully but when we try to start the add-on, the following message appears: "Add-on excution failed". If anyone can help us, we would be grateful. Below are links to download the source code and link the image with the error. Thanks in advance.


    Source codes:
    B1Addon http://www.box.net/shared/ev3ne32vg9
    B1Installer http://www.box.net/shared/806av2bij9
    Setup .ard http://www.box.net/shared/214rpjtri6


    Image Link:
    http://i.imgur.com/eDICD.jpg

  • Compile for Visual Studio 2010
    2010-08-10 04:21:51 Marc Roussel Business Card [Reply]

    Hi,


    Either you say it'll come soon or I'll compile the source.


    If I compile, Is there any documentation to how I do compile the source so I can get the Visual Studio template to prepare my addons ?


    This means, the B1DE Addon Generator Wizard.
    The one that gives a VB.NET project in which it does the .ARD and I just have to include my stuff and compile to generate the installer and the .ARD.


    Actually nothing works in Visual Studio 2010 and I have an urgent of it.


    When I unzip the source there's too much things in there for me to understand what must be done to compile the Addon Generator Wizard.


    Could you tell me if this will be done for Visual Studio 2010 or it's better to do it myself and if I have to do it myself, could you explain step by step ?


    Thank you for any help on this.

    • Compile for Visual Studio 2010
      2010-08-12 05:01:36 Marc Roussel Business Card [Reply]

      Ok I succeeded to compile the whole B1DESetup which I had to compile many other programs in a specific order to get the B1DESetup to fully compile in VS2010. Now the result is I've been able to successfuly install the Addon installer wizard templates and start to create the installer for my addon.


      Here's the problem I have.
      Once filling all the information like the Exec, the UI and DI and Extra files, I click ok and instead of making me the Installer project as normal the message pop :


      You can see it here : http://pages.videotron.com/gear/B1DE_Crash.jpg


      Please I need this to work as fast as possible.
      Could anyone help me on this ?

      • Compile for Visual Studio 2010
        2010-08-12 05:15:23 Marc Roussel Business Card [Reply]

        Ok I finally understood what was wrong. When installing the templates by the B1DESetup, it was asking the version of VS and this data is to get the template on the right folder and I was setting it to VS2010 because I thought it was juste some sort of tag but it's not just a tag it's where the templates are taken and since there's no template for VS2010, that's why the NOT FOUND error. So I uninstalled the the program and reinstalled it but this time pointing to VS2008 for the the first question and of course the VS2010 for the second one and this time it worked.


        All in all it's a lot of work to have the whole thing working for VS2010.

        • Compile for Visual Studio 2010
          2010-08-12 05:20:43 Marc Roussel Business Card [Reply]

          Now I have the other issue which the .ard isn't generated. If I double click the .bat file there's no .ard generated. I've looked into the xml and the .bat and everything seems all right in there. All the paths are all right. I'm still investigating as I don't really know
          • Compile for Visual Studio 2010
            2010-08-12 05:23:52 Maria Trinidad MARTINEZ GEA SAP Employee Business Card [Reply]

            Hi Marc,


            Regarding your last problem, have you checked that the exe generated by the Installer project (you can see it in the project properties) is the right name that is pointed out inside the .bat?
            Already in VS2008 there was a problem and the name of the output was the name of the template and didn't change to be the same as for the project name...


            Sorry for not answering before, but I'm quite busy this latest weeks.
            Hope it helps
            Trinidad.

            • Compile for Visual Studio 2010
              2010-08-12 05:28:53 Marc Roussel Business Card [Reply]

              Ok actually what I see is that the .bat is a real mess. I have it pointing to Bin and the compiled thing is in x86\Bin\Release


              Also I see it pointing 2 times on the Addon_Installer.exe in the .bat


              I'm just wondering if I will have to do it for every single addon I will have to prepare ?
              Where is the source I can fix so it is all right each time ?
              Is it in the source of B1DESetup project before installing it ?

              • Compile for Visual Studio 2010
                2010-08-12 05:32:37 Marc Roussel Business Card [Reply]

                If I remove the duplicate entry, now when I double click on the .bat it starts AddonRegDataGen and stay there with nothing in it.


                I start to be very confused

                • Compile for Visual Studio 2010
                  2010-08-12 05:40:16 Marc Roussel Business Card [Reply]

                  I tried to put everything in the same folder and edited the .bat to remove any path and still when I start the .BAT it starts the AddonRegDataGen with nothing in there. As if it would not even read the xml and of couse this doesn'T work anyway if I fill the data as I have the generate the .ard which is asking the file that doesn't exist yet.


                  Very very complicated things to date. I've bee on this since this morning 5:30am. It's actually 8:40am I don't know how much time I will still have to struggle on it to finnaly get my .ard

                  • Compile for Visual Studio 2010
                    2010-08-12 06:01:06 Marc Roussel Business Card [Reply]

                    Ouffff


                    Finally instead of using the .bat I started the AddonRegDataGen and entered all the information manually. I've been able to get the .ard at least


                    I would have liked to modify the source so the instaler is created in VS and generate the .ard as before but I again will have to go deep to find where in code of the B1DESetup project it is all made.


  • Download 2.1 version
    2010-08-10 02:41:00 Ana Silva Business Card [Reply]

    Hi,


    I'm trying for weeks now the download of 2.1 B1DE version for SAP B1 8.8 but I always get this error:


    Unfortunately we have trouble completing your download request. Please contact sdn@sap.com for further support.


    Is there any other way to download it?


    Best Regards,
    Ana Silva

    • Download 2.1 version
      2010-08-10 07:37:45 Vitor Vieira Business Card [Reply]

      Hi Ana,


      I've just downloaded B1DE 2.1 without a problem.
      If you which, please provide your e-mail and I'll send it to you.


      Regards,
      Vítor Vieira



      Olá Ana,


      Saquei agora mesmo, sem qualquer problema, o B1DE 2.1. Se quiseres disponibiliza-me o teu endereço de e-mail que eu envio-to.


      Cumprimentos,
      Vítor Vieira

  • .NET professional Installer crash on x64 machine
    2010-06-25 07:16:05 Vitor Vieira Business Card [Reply]

    Hi all,


    Dev System:
    VS2008 SP1
    Windows 7 Professional x64
    B1 2007A SP01 PL10


    Problem 1: As described in the first post, running the AddOnRegDataGen.bat does not create the .ard file.
    Solution: I had to change some info in the AddOnRegDataGen.bat file because some file paths were wrong.


    Problem 2: I'm able to create the .NET Professional Installer, create the .ard file and register the addon in Business One. When I open B1 and the Addon starts to install, I get the error "ADDONNAME has stopped working" (see print screen bellow)
    http://docs.google.com/uc?id=0B8apL48aXXNbOGUzMTBmMDAtMDI2Yi00MWZiLWJjMjEtYzc3YTA0Yzc1ZDQ4&export=download&hl=en


    I've tried running B1 as Administrator, turning off the UAC and still it crashes.
    I've compiled the installer as x86, x64 and Any PC and still it crashes...


    Can someone provide any solution to the problem??


    Thanks in advanced,
    Vítor Vieira

    • .NET professional Installer crash on x64 machine
      2010-06-29 01:37:22 Maria Trinidad MARTINEZ GEA SAP Employee Business Card [Reply]

      Hi Vitor,
      I haven't seen that error before and I cannot reproduce it. Please review all the installer steps in the TODO file to be sure there is not an step missing.
      Please post a message in the SDK forum, more people is having a look to the forum than the blog and you will have more chances to get it solved. You can add the link to the message inside this blog.
      Regards
      Trinidad.
  • Windows 7 + Vs2008 + B1DE 2.0.1
    2010-01-05 02:23:17 Pedro Magueija Business Card [Reply]

    Hello all,


    I have the following problem: When generating a .NET Wizard the .ard is not being generated as before. I tried manually running the batch file provided but it doesn't generate the file. If I run the AddOnRegDataGen.exe, fill the info and click generate it works.


    My account in W7 is an administrator, so I have write permissions.


    Anyone else has this problem?


    Thank you.

    • Windows 7 + Vs2008 + B1DE 2.0.1
      2010-01-05 02:33:47 Maria Trinidad MARTINEZ GEA SAP Employee Business Card [Reply]

      Hi Pedro,


      Have you tried to edit the .bat and .xml files inside the AddOnRegDataGen folder? Maybe there is a wrong path somewhere making the .bat to fail (the AddOnRegDataGen.exe location or your addon.exe location,...).
      The .bat file is doing nothing else that running the AddOnRegDataGen.exe with the given parameters.


      Hope it helps
      Trinidad.

      • Windows 7 + Vs2008 + B1DE 2.0.1
        2010-01-11 02:24:44 Pedro Magueija Business Card [Reply]

        Hi Trinidad,


        Checked the .bat and indeed it is a file that is named "B1AddonInstallerNET1.exe" in the .bat, but the file in the directory is "Installer.exe". I believe this has to do with some configuration of the VS2008.


        Thanks for your help Trinidad.
        All the best.

        • Windows 7 + Vs2008 + B1DE 2.0.1
          2010-07-15 07:49:47 Marc Roussel Business Card [Reply]

          In fact I saw that the B1DE installer project generated Customer_Installer.exe but in the folder I add Installer.exe instead. Also in the .bat, there was 2 time Customer_Installer with the full path. After modifying it and make all the fix, all it does is stating AddonRegDataGen.exe with nothing in it.


          What I need is the .ard. How can I generate it ?

        • Windows 7 + Vs2008 + B1DE 2.0.1
          2010-07-15 07:41:04 Marc Roussel Business Card [Reply]

          Will we have a fix or we'll have to edit the .bat and or the .xml each time ?


          I did look in my .bat and seems everything is fine to me. I tried every single path manually to see if they were all right and they were right


          Any other solution ?

          • Windows 7 + Vs2008 + B1DE 2.0.1
            2010-07-22 06:37:18 Maria Trinidad MARTINEZ GEA SAP Employee Business Card [Reply]

            Hi Marc,


            I cannot understand why the names are wrong in the .bat and .xml files regarding the installer name... As soon as I have some time I will try to search for a fix.


            After fixing the name of the installer.exe it should work fine. Please double check all the information in the .xml + .bat files. The ard should be generated ok if the datas are the right ones.


            Regards
            Trinidad.


Showing messages 1 through 34 of 34.