Constants (and Nav Standard functions) are recognized but so far
ignored and not used.
The reason is:
The search for internal Navision functions like GET, Round, Today etc.
is not part of the program.
Nor search for constants . (But is your wish (mdPartnerNL))
The program is interested in:
Objects, functions, table fields and properties (including XML definition etc.)
< Variable > .Run is supported,
Codeunit.Run(<constant>) will be supported (wishlist).
GDT Where Used Tool v1.0.0.9
Analyze your NAV objects NAV 5, NAV2009, NAV2013
All objects, functions and fields will be listed.
See connection by "where used"
Update to 1.0.0.9:
Fieldnumbers for Tablefields
visual Upgrade(Analyzer)
supporting run with call by constants
Very nice tool. Especialy the new feature to download soucecode directly from af particular database.
But ...
I miss a posibility to jump over object in the database that my license does not permit me to export in txt-format. For now I get a runtimeerror when impor find an object that I not have permission for. Perhaps a import-option how to handle object without readpermission.
Font size behaves weird. It does not always display the size entered in the dialog e.g. I choose 10pt and it shows 9,75 back in the option dialog. And more troublesome: size 10 (or 9.75) is too large, but size 9 is tiny. I found that size 12 is about what I want, about the same size as 9 in WordPad, and smaller than size 10 in GDT Where Used Tool.
When I finally figured out a setting that worked I found some Code it missed out. Where Used missed the following line of code in the OnPush trigger of a MenuItem on a Form when inspecting Report 7053 Implement Price Change:
Why don't I get any form of line endings when copying several lines of code from the code listing to some editor using the clipboard? Is there something wrong with my setup? Can this be changed?
PROCEDURE Send@3();
VAR
Result@1000 : Text[1024];
BEGIN
WITH SMTPMailSetup DO
Result :=
Mail.Send(
"SMTP Server",Authentication SMTPMailSetup.Authentication::Anonymous,"User ID", Password);
CLEAR(Mail);
IF Result '' THEN
ERROR(Text003,Result);
END;
The fields of table 409 are used here but in GDT in the table 409, the "where used" for example "USER ID" is not found.
Please add an option to skip the auto update feature.
We are running this tool on a Terminal Server, so users does not have permissions to install updates them selves. I keep an eye on this thread for updates, but sometimes a user needs to run the tool before I had the time to update.
Hello, Thanks for constantly updating this beautiful tool.
I have encountered another small issue. I am investigating where Table 17 G/L entry is used and for some reason it brings me line:
CRE."Data Entry Type" := CRE."Data Entry Type"::GL
Where CRE is completely different table. I suspect it has something with option value GL maybe..
Hi!
I tried the Finsql direct import on a 2013 R2 and got the following error:
Microsoft Dynamics NAV Development Environment
The program property 'ExportTxtSkipUnlicensed' is unknown.
The manual Installation and System Management contains a list of the correct program properties.
OK
I thought that is was supported?
The search for internal Navision functions like GET, Round, Today etc.
is not part of the program.
Nor search for constants . (But is your wish (mdPartnerNL))
The program is interested in:
Objects, functions, table fields and properties (including XML definition etc.)
Would it be possible to also see Record.INSERT and Record.MODIFY?
I'd like to be able to find every line where a record's data is changed
to your Question: The path where the settings are saved is ../documents/GDT IT Consult/Where Used Settings.xml.
You can edit this file.
We are sorry, but up to now we don't support network installations.
We plan an extended version with network support and other extensions in the future.
Best regards
Hello, Thanks for constantly updating this beautiful tool.
I have encountered another small issue. I am investigating where Table 17 G/L entry is used and for some reason it brings me line:
CRE."Data Entry Type" := CRE."Data Entry Type"::GL
Where CRE is completely different table. I suspect it has something with option value GL maybe..
Thank you!
Regards,
Ricardas.
Hi Ricardas,
we checked out your issue. There was a problem when an option string and a Fieldname have the same value. We fixed it. Check out our new Version 1.0.0.13.
Thx for reporting. Well done!
Regards
tom
Hello,
I discovered this tool in the last days and seems very useful.
But how can I export all objects without the unlicensed ones? Is there any trick how to do this? And what is this "finsql direct" import?
Thank you in advance.
Hi LeAchim,
for NAV2015 and NAV2016 you can use the finsql "direct" import to export all licensed objects out of Dynamics and automatic import to GDT Where Used.
If you export out of Dynamics NAV by using a *.txt file you have to select your licensed objects manually in advance.
Comments
Constants (and Nav Standard functions) are recognized but so far
ignored and not used.
The reason is:
The search for internal Navision functions like GET, Round, Today etc.
is not part of the program.
Nor search for constants . (But is your wish (mdPartnerNL))
The program is interested in:
Objects, functions, table fields and properties (including XML definition etc.)
< Variable > .Run is supported,
Codeunit.Run(<constant>) will be supported (wishlist).
Working on a new version!
regards
tom
Analyze your NAV objects NAV 5, NAV2009, NAV2013
All objects, functions and fields will be listed.
See connection by "where used"
Update to 1.0.0.9:
Fieldnumbers for Tablefields
visual Upgrade(Analyzer)
supporting run with call by constants
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
Thanks.
But ...
I miss a posibility to jump over object in the database that my license does not permit me to export in txt-format. For now I get a runtimeerror when impor find an object that I not have permission for. Perhaps a import-option how to handle object without readpermission.
Mikael Hansen
thank you for reporting. We fixed this issue. See our next version on Wednesday.
Best regards
tom
Update to 1.0.0.10:
direct import with finsql, includes all licensed Objects
new Option (select your Texttype and size for the textbox)
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
Font size behaves weird. It does not always display the size entered in the dialog e.g. I choose 10pt and it shows 9,75 back in the option dialog. And more troublesome: size 10 (or 9.75) is too large, but size 9 is tiny. I found that size 12 is about what I want, about the same size as 9 in WordPad, and smaller than size 10 in GDT Where Used Tool.
When I finally figured out a setting that worked I found some Code it missed out. Where Used missed the following line of code in the OnPush trigger of a MenuItem on a Form when inspecting Report 7053 Implement Price Change: This code resides in NAV 5.0 Form 7023 MenuButton Functions.
Update to 1.0.0.11:
copy text with STRG-C to clipboard optimized
runmodal is recognized
font size corrected, due to the change you must reselect the font and size
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
The fields of table 409 are used here but in GDT in the table 409, the "where used" for example "USER ID" is not found.
thank you for reporting this issue.
The mistake was, that we only analyzed
With <Record> DO BEGIN ... END
In your example it was:
With <Record> DO
Fixed it.
Look for new version 1.0.0.12
Best regards
Update to 1.0.0.12:
analyzer optimized
With <Record> DO is recognized
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
Please add an option to skip the auto update feature.
We are running this tool on a Terminal Server, so users does not have permissions to install updates them selves. I keep an eye on this thread for updates, but sometimes a user needs to run the tool before I had the time to update.
Thanks!
see enable automatic update under option.
regards
Where are those setting saved?
The situation was that the users couldn't even start the application, without getting stuck on the update screen. So they couldn't check that option.
A command line switch for skipping auto update would be great!
Thanks
Johannes
I have encountered another small issue. I am investigating where Table 17 G/L entry is used and for some reason it brings me line:
CRE."Data Entry Type" := CRE."Data Entry Type"::GL
Where CRE is completely different table. I suspect it has something with option value GL maybe..
Thank you!
Regards,
Ricardas.
I tried the Finsql direct import on a 2013 R2 and got the following error:
Microsoft Dynamics NAV Development Environment
The program property 'ExportTxtSkipUnlicensed' is unknown.
The manual Installation and System Management contains a list of the correct program properties.
OK
I thought that is was supported?
www.nabsolutions.se
Would it be possible to also see Record.INSERT and Record.MODIFY?
I'd like to be able to find every line where a record's data is changed
Thanks!
www.nabsolutions.se
to your Question: The path where the settings are saved is ../documents/GDT IT Consult/Where Used Settings.xml.
You can edit this file.
We are sorry, but up to now we don't support network installations.
We plan an extended version with network support and other extensions in the future.
Best regards
we will look into this very soon, but apologize for some delays, because we are in vacation now.
regards
Thanks for the update.
Then we at least can workaround this by editing that file, if the users gets blocked again.
Hi Ricardas,
we checked out your issue. There was a problem when an option string and a Fieldname have the same value. We fixed it. Check out our new Version 1.0.0.13.
Thx for reporting. Well done!
Regards
tom
Update to 1.0.0.13:
NAV analyzer ignores options
Error Message when using finsql direct import with NAV2013
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
www.nabsolutions.se
I discovered this tool in the last days and seems very useful.
But how can I export all objects without the unlicensed ones? Is there any trick how to do this? And what is this "finsql direct" import?
Thank you in advance.
for NAV2015 and NAV2016 you can use the finsql "direct" import to export all licensed objects out of Dynamics and automatic import to GDT Where Used.
If you export out of Dynamics NAV by using a *.txt file you have to select your licensed objects manually in advance.
best regards
tom