Creation of tables via txt file

arcullarcull Member Posts: 191
Hi guys, I wonder if anyone has some experience with creating tables through text file. What I would like to do some kind of wizzard, that would create a table in txt file on basis of field definitions. This in txt created table will then be import to navision and compiled in order to be applicable. Any suggestions welcome. Thanx

Comments

  • tinoruijstinoruijs Member Posts: 1,226
    You want to create a text-file like when you export a object using File, Export as .txt? Then just use File, Export as .txt. :wink:

    But I guess you're looking for something else. Why would you want to create a table through a text file?

    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • leugimleugim Member Posts: 93
    hi

    as long as I understand, you are looking for some wizard to create a structure for example in Excel or Access, then export this structure to a txt file and then Import it to Navision, right?

    use the file,export function with a table to see what Navision exports and what structures use. then you must develop some process which can create the same structures Navision uses to import from text files.

    be careful...
    _______________
    so far, so good
  • arcullarcull Member Posts: 191
    leugim you are almost right, the problem is that I have to write my own algorithm that would create the table the same way navision does when exporting to txt file. I thought maybe someone has similar algorithm written and would like to share it with me. Thanx again.
  • tinoruijstinoruijs Member Posts: 1,226
    Can you explain why you want to do that?
    Why not create the table in NAV?

    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • arcullarcull Member Posts: 191
    I am working on a add-on modul that will server business inteligence purposes and will be fully impelmented in native db, thus I need to be able to create tables on runtime as the OLAP database structure depends on user definitions of cubes and can not be predifined.
  • tinoruijstinoruijs Member Posts: 1,226
    arcull wrote:
    I am working on a add-on modul that will server business inteligence purposes and will be fully impelmented in native db, thus I need to be able to create tables on runtime as the OLAP database structure depends on user definitions of cubes and can not be predifined.

    8) . Thanks for explaning!

    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • AlbertvhAlbertvh Member Posts: 516
    Hi,
    If I'm not mistaken there is an object in the Downloads section that you could use. I think it's called table creator.

    Albert
  • arcullarcull Member Posts: 191
    Thanx a lot Albertvh, thats what I need :)
  • AlbertvhAlbertvh Member Posts: 516
    Hi,

    Found the download here Dynamics NAV Table Generator v1.0


    Albert
Sign In or Register to comment.