mibuso.com

Microsoft Business Solutions online community
It is currently Sat Aug 30, 2014 2:12 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 331 posts ]  Go to page Previous  1 ... 11, 12, 13, 14, 15, 16, 17 ... 23  Next
Author Message
 Post subject: Re: Object Manager Advanced v7.02 (trial till 16-5-2011)
PostPosted: Tue May 17, 2011 3:17 pm 
Offline

Joined: Mon Apr 04, 2011 11:18 am
Posts: 31
Location: Essen
Country: Germany (de)
Yes, it's a sql database.
But I have noch acess to that part of the database. I could only do some changes from Navision.
Well than I will have to live with my tests :whistle:


Top
 Profile E-mail  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 16-5-2011)
PostPosted: Tue May 17, 2011 3:32 pm 
Offline

Joined: Fri Mar 30, 2007 12:50 pm
Posts: 215
Location: Nieuwe Niedorp
Country: Netherlands (nl)
You can also run T-SQL from the "Action Worksheet" in the Object Manager.
Create an action of type "Execute SQL Query" with the following "SQL Query":

Code: Select all
DBCC CHECKIDENT ([OM - Modification], RESEED, 0)

And press Start.

_________________
Reijer Molenaar
Freelance NAV Developer
Object Manager
TVblik


Top
 Profile E-mail  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 16-5-2011)
PostPosted: Tue May 17, 2011 4:01 pm 
Offline

Joined: Mon Apr 04, 2011 11:18 am
Posts: 31
Location: Essen
Country: Germany (de)
I should have known that OMA is that mighty :lol:
Thank's a lot. Everthing is fine now \:D/


Top
 Profile E-mail  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 16-5-2011)
PostPosted: Wed May 25, 2011 7:16 pm 
Offline

Joined: Thu Apr 05, 2007 12:15 pm
Posts: 964
Location: Bochum
Country: Germany (de)
Hi Reijer,

I just tested the new 7.02 trail and I see that every Object is editable but when you go to design mode the only thing you could see is the word "PROTECTED". How did you do that? I'm very interested in this solution because we have some "customers" that have their own developer license but they should not change anything on some objects.

_________________
"Money is likewise the greatest chance and the greatest scourge of mankind."


Top
 Profile  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 16-5-2011)
PostPosted: Wed May 25, 2011 7:28 pm 
Offline

Joined: Fri Mar 30, 2007 12:50 pm
Posts: 215
Location: Nieuwe Niedorp
Country: Netherlands (nl)
Hi,

We have used Object Squeeze to do this.

http://www.mibuso.com/dlinfo.asp?FileID=1162

_________________
Reijer Molenaar
Freelance NAV Developer
Object Manager
TVblik


Top
 Profile E-mail  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 16-5-2011)
PostPosted: Thu May 26, 2011 1:50 pm 
Offline

Joined: Thu Apr 05, 2007 12:15 pm
Posts: 964
Location: Bochum
Country: Germany (de)
Hi Reijer,

another question: You know in OMA there's an Action Worksheet where you could setup some actions that have to be performed after or before a transport. Now I tried to divert this Action Worksheet from its intended use to do something like a batch report. Unfortunately some of our countries do not have a developer license and when you want to lookup the No. of Records you'll receive an error message:
Quote:
You do not have permission to modify the 'Table' Form.

This happens because you try to write "! CHECK OBJECT VALID !" into the Version List of Form "OM - Show Table Data". What is the reason for this?

P.S. It's OMA6.01.

_________________
"Money is likewise the greatest chance and the greatest scourge of mankind."


Top
 Profile  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 16-5-2011)
PostPosted: Tue May 31, 2011 11:16 am 
Offline

Joined: Fri Mar 30, 2007 12:50 pm
Posts: 215
Location: Nieuwe Niedorp
Country: Netherlands (nl)
Hi einsTeIn,

When you drilldown on the “No. of Records” the OMA will create a new form to show the table.
The string "! CHECK OBJECT VALID !" will prevent that this object modification will be traced and saved to the modifications table.

_________________
Reijer Molenaar
Freelance NAV Developer
Object Manager
TVblik


Top
 Profile E-mail  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 16-5-2011)
PostPosted: Wed Jun 08, 2011 9:46 am 
Offline

Joined: Thu Apr 05, 2007 12:15 pm
Posts: 964
Location: Bochum
Country: Germany (de)
Ok, so that means in fact, if you don't have at least the form designer within your license you won't be able to use this functionality, right?
Why do you create a new form? Wouldn't it be better to use the standard Lookup form?

_________________
"Money is likewise the greatest chance and the greatest scourge of mankind."


Top
 Profile  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 16-5-2011)
PostPosted: Wed Jun 08, 2011 10:03 am 
Offline

Joined: Fri Mar 30, 2007 12:50 pm
Posts: 215
Location: Nieuwe Niedorp
Country: Netherlands (nl)
Quote:
Ok, so that means in fact, if you don't have at least the form designer within your license you won't be able to use this functionality, right?
The object will be created in text format and imported/compiled with the automation. I think you also need to be allowed to import objects in text format.

Quote:
Why do you create a new form? Wouldn't it be better to use the standard Lookup form?
No, that is not possible. It has to work for all tables. The Lookup form will only work in combination with a variable of type record. And beside of that, the form that is used has more options. You can e.g. im- and export blob fields. Export the data in xml format. And best of all, change data without validation!

_________________
Reijer Molenaar
Freelance NAV Developer
Object Manager
TVblik


Top
 Profile E-mail  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 16-5-2011)
PostPosted: Wed Jun 08, 2011 10:19 am 
Offline

Joined: Thu Apr 05, 2007 12:15 pm
Posts: 964
Location: Bochum
Country: Germany (de)
reijermolenaar wrote:
Quote:
Ok, so that means in fact, if you don't have at least the form designer within your license you won't be able to use this functionality, right?
The object will be created in text format and imported/compiled with the automation. I think you also need to be allowed to import objects in text format.
As far as I understand this form will be deleted afterwards. So, the normal user will not notice anything of these preparative things. Do you see any chance to let a normal user (maybe without a developer license) use this functionality? E.g. give some objects more permissions when you compile them? Or create this form within the customer's range of numbers? Or something else?


reijermolenaar wrote:
Quote:
Why do you create a new form? Wouldn't it be better to use the standard Lookup form?
No, that is not possible. It has to work for all tables. The Lookup form will only work in combination with a variable of type record. And beside of that, the form that is used has more options. You can e.g. im- and export blob fields. Export the data in xml format. And best of all, change data without validation!
Hmmm... I see the advantage of this form. You are right.

_________________
"Money is likewise the greatest chance and the greatest scourge of mankind."


Top
 Profile  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 15-6-2011)
PostPosted: Wed Jun 08, 2011 10:26 am 
Offline

Joined: Fri Mar 30, 2007 12:50 pm
Posts: 215
Location: Nieuwe Niedorp
Country: Netherlands (nl)
Quote:
Or create this form within the customer's range of numbers?
Yes, if you enable the setting “Import Transport with SQL Trigger” in the setup it should do this.

_________________
Reijer Molenaar
Freelance NAV Developer
Object Manager
TVblik


Top
 Profile E-mail  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 15-6-2011)
PostPosted: Mon Jun 20, 2011 12:41 pm 
Offline

Joined: Mon Apr 04, 2011 11:18 am
Posts: 31
Location: Essen
Country: Germany (de)
Hi Reijer,

after a couple of weeks I am just getting on doing setup and first steps with OMA.
I created a new transport, added a Project with 3 objects (Table 50028, Report 50073 and Dataport 50021).
When I try to create the transport files (button "Transport") I get a couple of confirms like this:

---------------------------
Microsoft Dynamics NAV
---------------------------
Exporting of object Table 51000 - Data Transfer Log failed.
Do you want to continue?
---------------------------
Yes No
---------------------------

What is OMA doing with those objects that shouldn't be included?

I already put table 51000 on known object export error - list.

What is going wrong? ](*,)


Top
 Profile E-mail  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 15-6-2011)
PostPosted: Mon Jun 20, 2011 12:54 pm 
Offline

Joined: Fri Mar 30, 2007 12:50 pm
Posts: 215
Location: Nieuwe Niedorp
Country: Netherlands (nl)
Hi Caillean,

Strange, it shouldn’t do anything with other objects when you transport.
Can you see with the debugger what the Call Stack looks like when you get this confirm?

_________________
Reijer Molenaar
Freelance NAV Developer
Object Manager
TVblik


Top
 Profile E-mail  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 15-6-2011)
PostPosted: Mon Jun 20, 2011 1:10 pm 
Offline

Joined: Mon Apr 04, 2011 11:18 am
Posts: 31
Location: Essen
Country: Germany (de)
The Confirm comes from

Codeunit 11102050 OM - Source Control\AddObject(Object,ActionType,OnlyIfOutdated,ErrorType)

... and has been promted from

Codeunit 11102062 OM - Modification Management\SaveModification(VarModification,NewModification)

At the first look it's tyring to get all objects modified = yes.


Top
 Profile E-mail  
 
 Post subject: Re: Object Manager Advanced v7.02 (trial till 15-6-2011)
PostPosted: Mon Jun 20, 2011 1:21 pm 
Offline

Joined: Fri Mar 30, 2007 12:50 pm
Posts: 215
Location: Nieuwe Niedorp
Country: Netherlands (nl)
Ah, before you can transport all pending modifications has to be assigned to a project or ignored.
You will have to open the “Assign Modifications” form and ignore or assign them.

_________________
Reijer Molenaar
Freelance NAV Developer
Object Manager
TVblik


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 331 posts ]  Go to page Previous  1 ... 11, 12, 13, 14, 15, 16, 17 ... 23  Next

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: