Creation of tables via txt file

arcull

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

tinoruijs

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.

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

leugim

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...

arcull

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.

tinoruijs

Can you explain why you want to do that?
Why not create the table in NAV?

arcull

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.

tinoruijs

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!

Albertvh

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

arcull

Thanx a lot Albertvh, thats what I need

Albertvh

Hi,

Found the download here Dynamics NAV Table Generator v1.0


Albert