Data Transfer Wizard (Navision)

AdministratorAdministrator Posts: 2,438Member, Moderator, Administrator
edited 2010-08-06 in Download section
Data Transfer Wizard (Navision)
Allows to transfer the data from one to other company inside or outside of a database. The user can choose tables and the companies for transfer of the data. The difference in structure of tables will be fixed in the log file. At export /import of the data it is desirable to use a computer with high Data Transfer Rate.

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

Discuss this download here.

Comments

  • ajhvdbajhvdb Posts: 672Member
  • alberto.donealberto.done Posts: 2Member
    Copy fail and client crash if you have disable fields (Inside Database option, client version 4.00 to 4.00SP3). For Example Table Nr. 3. Simply skip not "Enable" field and this tool works G-R-E-A-T!!!!!!!!

    Before (Client Crash)
    REPEAT
                  Field_Ref := RecRef.FIELD(TabFields."No.");
                  Field_RefComp := RecRefComp.FIELD(TabFields."No.");
                  IF (TabFields.Type <> TabFields.Type::BLOB) AND (TabFields.Class = TabFields.Class::Normal) THEN
                    Field_RefComp.VALUE(Field_Ref.VALUE);
                UNTIL TabFields.NEXT=0;
    

    After (OK)
    REPEAT
                  Field_Ref := RecRef.FIELD(TabFields."No.");
                  Field_RefComp := RecRefComp.FIELD(TabFields."No.");
                  IF (TabFields.Type <> TabFields.Type::BLOB) AND 
                     (TabFields.Class = TabFields.Class::Normal) AND
                     (TabFields.Enabled)
                  THEN
                    Field_RefComp.VALUE(Field_Ref.VALUE);
                UNTIL TabFields.NEXT=0;
    
    
    =D>
  • lakshmivallurulakshmivalluru Posts: 168Member
    can this be used to transfer data between any version? like 3.7 to 4.0?
    LR
  • lakshmivallurulakshmivalluru Posts: 168Member
    also, what data needs to be set? and do you have any document how to setup the table data?
    LR
  • Cyber-JediCyber-Jedi Posts: 25Member
    Has anyone the problem of the export going slower and slower as the tables are being processed (selected all tables in a database)?
  • vyankuvyanku Posts: 791Member
    when trying to export or inside database it shows me error
    RECORDREF has not been closed. You must close RECORDREF with CLOSE before opening a new table.

    Please help [-o<
  • gianusgianus Posts: 22Member
    The same for me. I try to transfer two or more tabledata from a db to another.
    U know that must go through an export in .txt
    The FIRST table goes, at the second I get the same message "RECORDREF has not been closed. You must close RECORDREF with CLOSE before opening a new table".

    Pls Pls Pls help us, this is a GREAT tool!
    Gianni Capra
    www.exe.it
  • gianusgianus Posts: 22Member
    And, If You try to modify codeunit, at the recompilation, it comes a by-me-never-seen message, something like a form named "Error List" with a list of errors that says:
    Nr.     Tipo     ID      Nome               Tipo        Funzione        Nr. 
    errore	oggetto	 oggetto oggetto	    errore	/Trigger	riga	Descrizione
    1	Codeunit 80105	Data Transfer Mgt.  Avviso	AssignValue	67	Tipo "Binary" non supportato
    2	Codeunit 80105	Data Transfer Mgt.  Avviso	AssignValue	67	Tipo "Binary" non supportato
    3	Codeunit 80105	Data Transfer Mgt.  Avviso	AssignValue	67	Tipo "Binary" non supportato
    4	Codeunit 80105	Data Transfer Mgt.  Avviso	AssignValue	69	Tipo "Binary" non supportato
    5	Codeunit 80105	Data Transfer Mgt.  Avviso	AssignValue	70	Tipo "Binary" non supportato
    

    I think that translation from italian isn't necessary.

    I tried to modify codeunit adding a recordref.close before a recordref.open or at cycle end...
    Gianni Capra
    www.exe.it
  • gianusgianus Posts: 22Member
    SOLVED!

    Don't consider the form.

    I added this simple line:
    RecRef.CLOSE;
    in this point of the CODEUNIT: 80105, FUNCTION: DataExport
    DataExport(FileName : Text[250];CheckLicence : Boolean) 
    TextFile.CREATE(FileName);
    TextFile.TEXTMODE(TRUE);
    
    Wnd.OPEN(
      'Esportazione Dati \' +
      'Tabel               #1##############\' +
      'Regel               #2##############\' +
      '@[email protected]@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@\');
    
    TabSelection.SETRANGE(Selected,TRUE);
    TabSelection.FIND('-');
    REPEAT
      Wnd.UPDATE(1,TabSelection."Table No.");
      IF TabInfo.GET(TabSelection.Company,TabSelection."Table No.") AND
         (TabInfo."No. of Records" > 0 )
      THEN
      BEGIN
        RecRef.CLOSE;  <<<<<<<<<<<<<<<<<<<<<<<<<<<----------- THIS LINE ADDED ----------------------------
        RecRef.OPEN(TabInfo."Table No.");
    

    and everything's allright.
    Gianni Capra
    www.exe.it
Sign In or Register to comment.