Import Wizard v1.00 (Navision)

AdministratorAdministrator Posts: 2,259Member, Moderator, Administrator
edited 2006-10-31 in Download section
Import Wizard v1.00 (Navision)
Utility to import data from a file into Navision without any programming.

Choose file, field separator and destination table in Navision, and field mapping. Then run the wizard and data is imported.

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

Discuss this download here.

Comments

  • jfreyjfrey Posts: 43Member
    Hey
    I downloaded and import Import Wizard, because it sounds very good for me, because I have to import often datas from a excel sheet. Now all the forms and tables are in the range af 60000 and I get a message, you do not have permission......
    We have a license for programing and we are enduser. Is there a easy way to use this wizard?
    Regards
    Joerg
    Navision 3.70, SQL Server 2000, Citrix Metaframe
  • ara3nara3n Posts: 9,147Member
    Take the txt file open it, and change the object range to your range. Then import it.
  • jfreyjfrey Posts: 43Member
    ara3n wrote:
    Take the txt file open it, and change the object range to your range. Then import it.

    Thanks, was very helpfull.

    Regards

    Joerg
    Navision 3.70, SQL Server 2000, Citrix Metaframe
  • David_CoxDavid_Cox Posts: 509Member
    Import Wizard v1.00 (Navision)
    Utility to import data from a file into Navision without any programming.

    Choose file, field separator and destination table in Navision, and field mapping. Then run the wizard and data is imported.

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

    Discuss this download here.

    Thats cool, But should it only be used for static data, I havent looked at it yet ,can you choose to Validate the fields?

    And run the INSERT(TRUE) option?
    Analyst Developer with over 17 years Navision, Contract Status - Busy
    Mobile: +44(0)7854 842801
    Email: david.cox@adeptris.com
    Twitter: https://twitter.com/Adeptris
    Website: http://www.adeptris.com
  • SavatageSavatage Posts: 7,134Member
    Is it Version sensitive? It's not working on 3.6 :?

    I'm having trouble with

    IF AllObj.GET(AllObj."Object Type"::Table,TableNo) THEN
      EXIT(AllObj."Object Name");
    

    Table 99001521 does not exist
  • bthorbthor Posts: 16Member
    To David Cox:

    Yes you can run the Onvalidate trigger for each field and the OnModify and OnInsert trigger for the tables.

    To Savatage:

    I did write this in v 3.7 and did not try this to any earlier versions. The AllObj table is table no 2000000038, and I belive that is also in earlier verions.
    The problem might be the local variable 99001521 in the Table.Object Name - OnValidate. This variable should be removed.

    Bjarni Thor
    bjarnason_bjarni@hotmail.com
  • SavatageSavatage Posts: 7,134Member
    bthor wrote:
    The AllObj table is table no 2000000038, and I belive that is also in earlier verions.

    It's not in 3.10b - anyone know when this table started?
  • jpjesusjpjesus Posts: 45Member
    Does anyone know what form is this? Form99001629?

    In the portuguese database this form doesn't exist (3.60, 3.70, 4.00).

    It's used in codeunit 60000 on the function:

    LookupFieldNo(TableNo : Integer;ToFieldNo : Integer) : Integer
    Fields.SETRANGE(TableNo,TableNo);
    IF Fields.GET(TableNo,ToFieldNo) THEN;
    IF FORM.RUNMODAL(FORM::Form99001629,Fields) = ACTION::LookupOK THEN
    EXIT(Fields."No.");
  • bthorbthor Posts: 16Member
    edited 2006-05-18
    Hello jpjesus

    This should not be link to this form. This is a form I have in my system. You should import following code and change the form no to 60005 in the LookupFieldNo funtion.
  • bthorbthor Posts: 16Member
    Hello jpjesus

    This should not be link to this form. This is a form I have in my system. You should import following code and change the form no to 60005 in the LookupFieldNo funtion.

    OBJECT Form 60005 Table Field
    {
      OBJECT-PROPERTIES
      {
        Date=18.05.06;
        Time=10:05:24;
        Modified=Yes;
        Version List=IB1.00;
      }
      PROPERTIES
      {
        Width=16500;
        Height=6710;
        Editable=No;
        TableBoxID=1;
        SourceTable=Table2000000041;
        DataCaptionExpr=Caption;
      }
      CONTROLS
      {
        { 1   ;TableBox     ;220  ;220  ;16060;5500 ;HorzGlue=Both;
                                                     VertGlue=Both }
        { 2   ;TextBox      ;0    ;0    ;1650 ;0    ;ParentControl=1;
                                                     InColumn=Yes;
                                                     SourceExpr="No." }
        { 3   ;Label        ;0    ;0    ;0    ;0    ;ParentControl=2;
                                                     InColumnHeading=Yes }
        { 4   ;TextBox      ;0    ;0    ;4400 ;0    ;HorzGlue=Both;
                                                     ParentControl=1;
                                                     InColumn=Yes;
                                                     SourceExpr=FieldName }
        { 5   ;Label        ;0    ;0    ;0    ;0    ;ParentControl=4;
                                                     InColumnHeading=Yes }
        { 6   ;TextBox      ;0    ;0    ;550  ;0    ;ParentControl=1;
                                                     InColumn=Yes;
                                                     SourceExpr=Type }
        { 7   ;Label        ;0    ;0    ;0    ;0    ;ParentControl=6;
                                                     InColumnHeading=Yes }
        { 14  ;TextBox      ;0    ;0    ;4400 ;0    ;ParentControl=1;
                                                     InColumn=Yes;
                                                     SourceExpr="Type Name" }
        { 15  ;Label        ;0    ;0    ;0    ;0    ;ParentControl=14;
                                                     InColumnHeading=Yes }
        { 8   ;TextBox      ;0    ;0    ;1650 ;0    ;ParentControl=1;
                                                     InColumn=Yes;
                                                     SourceExpr=Len }
        { 9   ;Label        ;0    ;0    ;0    ;0    ;ParentControl=8;
                                                     InColumnHeading=Yes }
        { 16  ;CommandButton;9240 ;5940 ;2200 ;550  ;HorzGlue=Right;
                                                     VertGlue=Bottom;
                                                     Default=Yes;
                                                     PushAction=LookupOK;
                                                     InvalidActionAppearance=Hide }
        { 17  ;CommandButton;11660;5940 ;2200 ;550  ;HorzGlue=Right;
                                                     VertGlue=Bottom;
                                                     Cancel=Yes;
                                                     PushAction=LookupCancel;
                                                     InvalidActionAppearance=Hide }
        { 18  ;CommandButton;14080;5940 ;2200 ;550  ;HorzGlue=Right;
                                                     VertGlue=Bottom;
                                                     PushAction=FormHelp }
      }
      CODE
      {
        VAR
          AllObj@1000 : Record 2000000038;
    
        PROCEDURE Caption@1() : Text[50];
        BEGIN
          IF AllObj.GET(AllObj."Object Type"::Table,TableNo) THEN
            EXIT(AllObj."Object Name");
        END;
    
        BEGIN
        END.
      }
    }
    
  • jpjesusjpjesus Posts: 45Member
    Ok, thanks,

    I've imported the file and it's ok now.

    Meanwhile, while exploring your application I tried to import a <TAB> delimited file with <None> as a field separator into table 348 (Dimension). This is the usual format I use when importing/exporting data using dataports.
    It doens't seem to be importing well because all columns endup in field 1.
    I haven't had the chance to do more tests but as soon as possible I'll get back to you.
    Also something that I will try improve and send you after is the translation of ANSI to ASCII bc of the portuguese characters.

    Once again, thank you. I think this is a very nice tool, well designed so congratulations and thanks for sharing it.
  • bthorbthor Posts: 16Member
    Hello Jpjesus

    I’m currently working on version 1.01 of this tool. I will take a look at the TAB option and find out why it is not working.

    I would be happy to add the portuguese characters to the tool. Can you please send me the convertion.

    Examples of things I'm adding to the new version:

    1. Multiple files import (select directory and fields prefix or sub fix)
    2. Move files after import to a backup folder
    3. Added Batch Templates
    3. Add Records to Incremental tables. (Today the incremental always start at 1)

    If there are any suggestions, I would appreciate it.
  • elToritoelTorito Posts: 261Member
    Hi.

    is newer Version finished? Where can i find it?

    Thanks very much :D :D
    www.lovebenz.de - Forum for the Mercedes C-Class W203
Sign In or Register to comment.