Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Extract Object and Field information from Text File
mik
Member Posts: 79
Hi,
I would need a smooth way to get a list of all nav objects and all table fields and store them in NAV.
I tried to spin up a docker and use the Table Type ExternalSQL for the Object table and the Object Metadata Table.
This works fine in general. But I can't read the Field Information from the Metadata Blob.
My second Option is to export all objects and read them to get the relevant information. Is there any Object textfile parser around which I can use from inside NAV without any conversion step in between?
I would need a smooth way to get a list of all nav objects and all table fields and store them in NAV.
I tried to spin up a docker and use the Table Type ExternalSQL for the Object table and the Object Metadata Table.
This works fine in general. But I can't read the Field Information from the Metadata Blob.
My second Option is to export all objects and read them to get the relevant information. Is there any Object textfile parser around which I can use from inside NAV without any conversion step in between?
With kind regards
mik
0
Answers
All fields in NAV is store in the tabel called Field.
Can you use Them?
as field is a virtual table there is no way to use it. That's the thing. I do not want to create some code in my "base" database where only standard objects should be in to export the needed information. That's why I try to directly to to SQL and try to read data remote. (nice thing when using docker and just wanting to have the object information)
And "yes" I'm already reading the information from the object table. But without the table fields it's quite useless for me.
With kind regards
mik
3 Ways to do this ..
1) Develop my own object textfile parser (hopefully, there is one out there .. )
2) Connect from 2018/BC to databases with ExternalSQL Table Type and Read that information and parse it in NAV (preferred but it seems not to be possible)
3) Import an Export Codeunit in my Base DB and Export the information which I need to import it in my 2018/BC.
At the moment I'm sticking to 3) because of the simplicity and the possibility to read the field table.
But 2) works really good except of the field information
With kind regards
mik