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?
Unfortunately I still get this error after installing 1.0.0.13
Hello Tom,
ok, tried it first on a computer without NAV2016. In this case the program hides the option of the "direct" import.
After setting the NAV login information the "import" starts, but I got an error message from NAV Development Environment: "Die Wahlmöglichkeit 'yes' ist nicht vorhanden. Die Wahlmöglichkeiten sind: Nein, Ja" Are there any problems known with german localizations?
Hello Ryden, LeAchim!
if we understand correctly their are two issues.
First: It is possible to select not supported finsql Versions. (2013 or lower)
Second: ntauthentification = yes produces a localization error in German.
We provided a new test version: www.g-d-t.de/Test/setupGDTWhereUsed.zip
Please test it and let us know.
GDT Where Used Tool v1.0.0.14
Update to 1.0.0.14 (9/06/2016):
fixed: (ntauthentification = yes) produces a localization error in the German version
Error Message, when using finsql direct import with NAV2013 or lower
Hi there.
I am trying to see where table 7330 "Bin Content Buffer" is used, and tool does not show me anything.. For sure this table is used in Report 7315 "Calculate Whse. Adjustment" and codeunit 7304 probably somewhere else. In Addition if I look where table's fields are used, there is nothing about report 7315 "Calculate Whse. Adjustment" again, though for sure fields are used in this report..
If you take a look on this issue It would much appreciated.
Thanks,
Regards,
Ricardas
Hi Jonathan,
SQL direct import is only possible for NAV8 or NAV9.
GDTwhereused tool looks for the finsql.exe file in the NAV installation directory.
IF there is a finsql.exe file, direct import is available.
If you work remote (rdp) with a server farm, maybe this could be a problem, because the finsql.exe is installed only on the main server.
It would be nice to have a browse for/search facility in order to jump more easy to a certain object, instead of having to scroll through hundreds of objects.
For example search for <Object type> and <Number> or <Name>
Hi, GDT team!
Could you, please, take a look on one more issue?
If there is a function in a subpage - let's call it SubpageFunction. And this function is call from a page action like CurrPage.subpage.PAGE.SubpageFunction GDT don't see SubpageFunction as used.
In addition..
Table has field References text 250 (not sure if field name is relevant). Then code looks like:
....
With Table do
function(References);
....
In this instance field references is not shown as used in this bit of code. Probably because it is used as parameter in function.
Hi Ryckutis,
thank you for reporting.
The issue with the SubpageFunction is solved. See our new Version 1.0.0.17.
Your second issue with field references we can not follow. Maybe explain it a little bit more detailed.
See also our attached code.
OBJECT Table 50000 Test
{
OBJECT-PROPERTIES
{
Date=07.10.16;
Time=15:52:51;
Modified=Yes;
Version List=;
}
PROPERTIES
{
}
FIELDS
{
{ 10 ; ;code ;Code20 }
{ 20 ; ;Test It ;Text250 }
}
KEYS
{
{ ;code ;Clustered=Yes }
}
FIELDGROUPS
{
}
CODE
{
PROCEDURE sayHello@1000000000(Greeting@1000000000 : Text[250]);
BEGIN
MESSAGE(Greeting);
END;
BEGIN
END.
}
}
OBJECT Codeunit 50000 Test
{
OBJECT-PROPERTIES
{
Date=07.10.16;
Time=15:52:58;
Modified=Yes;
Version List=;
}
PROPERTIES
{
OnRun=VAR
Test@1000000000 : Record 50000;
BEGIN
Test."Test It" := 'Hello';
WITH Test DO sayHello("Test It");
WITH Test DO
BEGIN
sayHello("Test It");
END;
END;
}
CODE
{
BEGIN
END.
}
}
We are happy to launch our advanced Version GDT Where Used PLUS.
Additional features:
- Networkable
- multiple projects (Customers) possible
- unlimited Versions per project
- Object compare between Versions
- Code Guard
Comments
Unfortunately I still get this error after installing 1.0.0.13
www.nabsolutions.se
ok, tried it first on a computer without NAV2016. In this case the program hides the option of the "direct" import.
After setting the NAV login information the "import" starts, but I got an error message from NAV Development Environment: "Die Wahlmöglichkeit 'yes' ist nicht vorhanden. Die Wahlmöglichkeiten sind: Nein, Ja" Are there any problems known with german localizations?
Is this a response to my problem?
I didn't find such a file, only "Import Settings.xml".
if we understand correctly their are two issues.
First: It is possible to select not supported finsql Versions. (2013 or lower)
Second: ntauthentification = yes produces a localization error in German.
We provided a new test version: www.g-d-t.de/Test/setupGDTWhereUsed.zip
Please test it and let us know.
regards
tom
thank you for the fast solution. Import resp. export from NAV works now. But the analyzer deletes sicherung.txt and the result is empty.
sorry, I was to unpatient. The OK-Button of the analyzer is enabled to early. You have to wait until "save nav fob" is finished.
wirth regards,
Michael
Update to 1.0.0.14 (9/06/2016):
fixed: (ntauthentification = yes) produces a localization error in the German version
Error Message, when using finsql direct import with NAV2013 or lower
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
Update to 1.0.0.15 (5/07/2016):
Save window position, when close and open the window
displays source code of an selected object
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
I am trying to see where table 7330 "Bin Content Buffer" is used, and tool does not show me anything.. For sure this table is used in Report 7315 "Calculate Whse. Adjustment" and codeunit 7304 probably somewhere else. In Addition if I look where table's fields are used, there is nothing about report 7315 "Calculate Whse. Adjustment" again, though for sure fields are used in this report..
If you take a look on this issue It would much appreciated.
Thanks,
Regards,
Ricardas
we looked into it. Table 7330 is a temporary Table. That was a problem.
We fixed it. See new version.
Thanks for reporting.
Tom
Update to 1.0.0.16 (3/08/2016):
Temporary Tables are available
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
Franz Kalchmair, MVP
Alias: Jonathan Archer
please like / agree / verify my answer, if it was helpful for you. thx.
Blog: http://moxie4nav.wordpress.com/
SQL direct import is only possible for NAV8 or NAV9.
GDTwhereused tool looks for the finsql.exe file in the NAV installation directory.
IF there is a finsql.exe file, direct import is available.
If you work remote (rdp) with a server farm, maybe this could be a problem, because the finsql.exe is installed only on the main server.
Best regards
tom
For example search for <Object type> and <Number> or <Name>
this is on our wishlist.
We are working on our upcoming GDTWhereUsed PLUS.
Best regards
tom
Could you, please, take a look on one more issue?
If there is a function in a subpage - let's call it SubpageFunction. And this function is call from a page action like CurrPage.subpage.PAGE.SubpageFunction GDT don't see SubpageFunction as used.
Table has field References text 250 (not sure if field name is relevant). Then code looks like:
....
With Table do
function(References);
....
In this instance field references is not shown as used in this bit of code. Probably because it is used as parameter in function.
thank you!
thank you for reporting.
The issue with the SubpageFunction is solved. See our new Version 1.0.0.17.
Your second issue with field references we can not follow. Maybe explain it a little bit more detailed.
See also our attached code.
This works fine!
Update to 1.0.0.17 (10/10/2016):
Solves the Problem with CurrForm.Control.FORM.Function and CurrPage.Control.PAGE.Function
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
NAV 5.0 (platform upgrade 2009R2). Textfile export from NAV.
Using GDT 1.0.0.17
Issue is when"Test it" is used like:
WITH Test DO
BEGIN
CASE TRUE OF
'A' = 'B': BEGIN
END;
END;
sayHello("Test It");
END;
END;
thank you for your example.
Problem was a "case" command inside "with do".
Fixed it.
See new version 1.0.0.18
Best regards
tom
Update to 1.0.0.18 (12/10/2016):
Solves the Problem: "case" command inside "with do".
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
I tried to reproduce your issue. See my code example.
This works fine. Could you give me more details. Best regards
tom
Update to 1.0.0.19 (2/11/2016):
Fixed "Missing fields in the DataItemTableView(where Condition)
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
Update to 1.0.0.20 (18/01/2017):
new Option Disable Finsql.exe detection
In case you have copied your NAV Installation and GDT Where Used cannot find Finsql
http://mibuso.com/downloads/gdt-where-used-tool
Discuss this download here.
Additional features:
- Networkable
- multiple projects (Customers) possible
- unlimited Versions per project
- Object compare between Versions
- Code Guard
Commercial Download: http://mibuso.com/downloads/gdt-where-used-plus