Import Wizard v1.00 (Navision)

Administrator

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

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

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

jfrey

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

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

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

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

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

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

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

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

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

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

Hi.

is newer Version finished? Where can i find it?

Thanks very much