Import from an sql database

Comments

• Options

  Alex_Chow Member Posts: 5,063

  2007-11-19

  It's not a good idea to import straight into Navision from SQL. It's recommended that all data imports be done through Navision to ensure all business rules are checked.

  Confessions of a Dynamics NAV Consultant = my blog
  AP Commerce, Inc. = where I work
  
  Getting Started with Dynamics NAV 2013 Application Development = my book
  Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

  0
• Options

  kriki Member, Moderator Posts: 9,089

  2007-11-19

  And if you want to do it anyway, create a new table just for this purpose. Then use a NAS (or a client) to put in in the real Navision-tables.

  Regards,Alain Krikilion
  No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
  
  

  0
• Options

  Alex_Chow Member Posts: 5,063

  2007-11-19

  kriki wrote:

  And if you want to do it anyway, create a new table just for this purpose. Then use a NAS (or a client) to put in in the real Navision-tables.

  
  To a temporary table you mean. Then write a process to move them into production table.

  Confessions of a Dynamics NAV Consultant = my blog
  AP Commerce, Inc. = where I work
  
  Getting Started with Dynamics NAV 2013 Application Development = my book
  Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

  0
• Options

  nunomaia Member Posts: 1,153

  2007-11-19

  tiagofrancis wrote:

  Hi folks,
  
  Does anyone knows how to import data from an sql database to navision?
  
  
  Kind regards

  
  It's one time operation or is a periodically operation? Do you have direct access to SQL from Navision?

  Nuno Maia
  
  Freelance Dynamics AX
  Blog : http://axnmaia.wordpress.com/

  0
• Options

  kriki Member, Moderator Posts: 9,089

  2007-11-20

  Alex Chow wrote:

  kriki wrote:

  And if you want to do it anyway, create a new table just for this purpose. Then use a NAS (or a client) to put in in the real Navision-tables.

  
  To a temporary table you mean. Then write a process to move them into production table.

  That's what I mean.

  Regards,Alain Krikilion
  No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
  
  

  0
• Options

  tiagofrancis Member Posts: 48

  2007-11-20

  At the end of the day, i have to export DATA from Nav throughout a CU i've created. The next step is to import DATA, but i don't know what is the best way to do it...SAMPLE CODE?

  0
• Options

  tiagofrancis Member Posts: 48

  2007-11-20

  I've exported with success...

  0
• Options

  nunomaia Member Posts: 1,153

  2007-11-20

  you can use a dataport to achive that

  Nuno Maia
  
  Freelance Dynamics AX
  Blog : http://axnmaia.wordpress.com/

  0
• Options

  kriki Member, Moderator Posts: 9,089

  2007-11-20

  If you use a NAS, you have to create a codeunit to export/import data. Navision NAS cannot use dataports. Don't ask me why.

  Regards,Alain Krikilion
  No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
  
  

  0
• Options

  Alex_Chow Member Posts: 5,063

  2007-11-21

  kriki wrote:

  If you use a NAS, you have to create a codeunit to export/import data. Navision NAS cannot use dataports. Don't ask me why.

  
  You could write a process only report to read and import flat files.

  Confessions of a Dynamics NAV Consultant = my blog
  AP Commerce, Inc. = where I work
  
  Getting Started with Dynamics NAV 2013 Application Development = my book
  Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

  0