Import Wizard v1.00 (Navision)

Administrator · 2006-04-24

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.

jfrey · 2006-05-01

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

ara3n · 2006-05-01

Take the txt file open it, and change the object range to your range. Then import it.

jfrey · 2006-05-01

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

David_Cox · 2006-05-02

Administrator wrote:

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?

Savatage · 2006-05-03

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

bthor · 2006-05-09

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

Savatage · 2006-05-10

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?

jpjesus · 2006-05-17

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.");

bthor · 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.

bthor · 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.

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.
  }
}

jpjesus · 2006-05-18

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.

bthor · 2006-05-22

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.

elTorito · 2006-10-31

Hi.

is newer Version finished? Where can i find it?

Thanks very much

Import Wizard v1.00 (Navision)

Comments

Categories