I’m attempting to produce a simple report of the Navision table schemas. Currently the report outputs details from the “Table Information (2000000028)” and “Field (2000000041)” tables. Does anybody know where I can get the key information from?
I would suggest that you export all the tables to a text file and use a text manipulation tool such as “awk” to create the schemas. Not very graceful but it gets the job done. Also when you have done this you could publish the awk script on this forum for the benefit of all.
Many thanks. (The awk script comes with no Guarantee or Warranty). BEGIN{ printIt = 0; myPos = 0; } /^OBJECT/ { printf("\n%s\n", $0); } { myPos = index($0, " KEYS"); if (myPos == 1) { printIt = 1; } if (printIt == 1) { print $0; } myPos = index($0, " }"); if (myPos == 1) { printIt = 0; } }
Hi! Because I was interessted in that problem, I tried to create a Dataport that does something similar like the awk-script: Search in an object-file (TXT) for the table-keys and import them to a table. Well, it’s NOT OPTIMIZED, but it works (with simple keys). For those who need this feature, it should be easy to make it work properly. The attached file contains the objects, NF 2.60, Table 50000 and Dataport 50000. Regards, Jörg Joerg A. Stryk Apollo-Optik, IT/ERP Hm …, the upload didn’t work!? So, if you want the objects please mail to me, i’ll send them to you, until the upload works. Edited by - stryk on 2001 May 03 09:34:08
quote:
Originally posted by stryk: Hm …, the upload didn’t work!? So, if you want the objects please mail to me, i’ll send them
The upload is fixed. Please try again… Best regards, Erik P. Ernst, webmaster Navision Online User Group
Here we go, again! download Joerg A. Stryk Apollo-Optik, IT/ERP
Nice little tool. Could you please put a copy of it with a short description to the NF Tools forum so that it’s available to future generations? ------- With best regards from Switzerland Marcus Fabian
Done! Joerg A. Stryk Apollo-Optik, IT/ERP