mibuso.com

Microsoft Business Solutions online community
It is currently Sat Oct 25, 2014 11:09 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 14 posts ] 
Author Message
 Post subject: Import Wizard v1.00 (Navision)
PostPosted: Mon Apr 24, 2006 10:51 am 
Offline
Site Admin

Joined: Sun Nov 07, 1999 8:01 am
Posts: 2070
Location: Wilrijk, Belgium
Country: Belgium (be)
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.


Top
 Profile  
 
 Post subject: Using Import Wizard
PostPosted: Mon May 01, 2006 2:46 pm 
Offline

Joined: Fri Oct 31, 2003 4:23 pm
Posts: 29
Location: Bülach
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


Top
 Profile  
 
 Post subject:
PostPosted: Mon May 01, 2006 3:28 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 9060
Location: 3rd rock from sun
Country: United States (us)
Take the txt file open it, and change the object range to your range. Then import it.

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
 Post subject:
PostPosted: Mon May 01, 2006 4:31 pm 
Offline

Joined: Fri Oct 31, 2003 4:23 pm
Posts: 29
Location: Bülach
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


Top
 Profile  
 
 Post subject: Re: Import Wizard v1.00 (Navision)
PostPosted: Tue May 02, 2006 1:08 pm 
Offline

Joined: Thu Aug 26, 2004 1:50 pm
Posts: 479
Location: Kent
Country: United Kingdom (uk)
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?

_________________
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


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Wed May 03, 2006 10:00 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 7069
Location: L.I., New York
Country: United States (us)
Is it Version sensitive? It's not working on 3.6 :?

I'm having trouble with


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


Table 99001521 does not exist

_________________
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Tue May 09, 2006 2:15 pm 
Offline

Joined: Thu Jan 13, 2000 8:01 am
Posts: 16
Location: Reykjavík
Country: Iceland (is)
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

_________________
Bjarni Thor
bjarnib@dagurgroup.is


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Wed May 10, 2006 6:33 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 7069
Location: L.I., New York
Country: United States (us)
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?

_________________
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Form99001629
PostPosted: Wed May 17, 2006 3:31 pm 
Offline

Joined: Wed Oct 22, 2003 6:40 pm
Posts: 37
Location: Melbourne
Country: Australia (au)
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.");

_________________
Joao Jesus
jpjesus@netcabo.pt


Top
 Profile E-mail  
 
 Post subject: Form99001629
PostPosted: Thu May 18, 2006 12:10 pm 
Offline

Joined: Thu Jan 13, 2000 8:01 am
Posts: 16
Location: Reykjavík
Country: Iceland (is)
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.

_________________
Bjarni Thor
bjarnib@dagurgroup.is


Last edited by bthor on Thu May 18, 2006 12:11 pm, edited 1 time in total.

Top
 Profile E-mail WWW  
 
 Post subject: Form99001629
PostPosted: Thu May 18, 2006 12:11 pm 
Offline

Joined: Thu Jan 13, 2000 8:01 am
Posts: 16
Location: Reykjavík
Country: Iceland (is)
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.


Code: Select all
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.
  }
}

_________________
Bjarni Thor
bjarnib@dagurgroup.is


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Thu May 18, 2006 12:56 pm 
Offline

Joined: Wed Oct 22, 2003 6:40 pm
Posts: 37
Location: Melbourne
Country: Australia (au)
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.

_________________
Joao Jesus
jpjesus@netcabo.pt


Top
 Profile E-mail  
 
 Post subject: Import Buffer
PostPosted: Mon May 22, 2006 2:21 pm 
Offline

Joined: Thu Jan 13, 2000 8:01 am
Posts: 16
Location: Reykjavík
Country: Iceland (is)
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.

_________________
Bjarni Thor
bjarnib@dagurgroup.is


Top
 Profile E-mail WWW  
 
 Post subject:
PostPosted: Tue Oct 31, 2006 12:37 pm 
Offline

Joined: Wed Jun 16, 2004 5:50 pm
Posts: 188
Location: Germany
Country: Germany (de)
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 14 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: