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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
Auto-import a fob with SQL
Claude
Member Posts: 4
Hello,
This is my first post here.
Here is our problem :
We have several salespersons (30 and going up) with a Navision Database, so this is 30 databases to maintain.
The problem is that deployment of new objects on their databases using the tool recObject."BLOB Reference".EXPORT generates files which are too big (4 times bigger than a fob file, 50+ mb), and thus these files cannot be downloaded by the salespersons because of their bad 3G internet connection.
We intend to migrate to SQL, will this bring us a possibility to make these deployments more easily ? If so, how can it be done ?
In short, is this possible to auto-import a fob file in Navision with SQL.
Thank you.
Claude DELILLE
This is my first post here.
Here is our problem :
We have several salespersons (30 and going up) with a Navision Database, so this is 30 databases to maintain.
The problem is that deployment of new objects on their databases using the tool recObject."BLOB Reference".EXPORT generates files which are too big (4 times bigger than a fob file, 50+ mb), and thus these files cannot be downloaded by the salespersons because of their bad 3G internet connection.
We intend to migrate to SQL, will this bring us a possibility to make these deployments more easily ? If so, how can it be done ?
In short, is this possible to auto-import a fob file in Navision with SQL.
Thank you.
Claude DELILLE
0
Answers
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Thanks for your answer.
The size-related gain with 7-zip compared to the compressor we were using is indeed very interesting (from 50+ MB to 4MB).
It seems that this may be a solution to our problem.
However we can't find the 7-zip ocx in order to pilot 7-zip within Navision. Do you know if the ocx exist and where to find it ?
Thanks again.
Claude DELILLE
I searched for an automation,but I don't find it.
But you don't need an automation. You can use 7-zip from the commandprompt. Run 7z.exe and the help to see the parameters you can use. I have done this and it works just fine.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
We made it with the 7-Zip command-line executable as you suggested and it works great !
Claude DELILLE