MxLoader is a Microsoft® Excel® spreadsheet that allows to quickly and easily query and load data into IBM Maximo, IBM SmartCloud Control Desk (SCCD) and other TPAE based applications.
It brings together the power of the Maximo Integration Framework and the flexibility of Excel allowing to quickly manipulate and import data into any Maximo database.
MxLoader runs on Microsoft Excel 2007/2010. It also requires Microsoft XML Core Services 6.0.
5/10/2014
Deleting user-created applications
- Only applications created with Application Designer can be deleted (new or duplicated).
- You must use a database editor to delete an appli cation.
- Deleting an application does not remove a ny custom tables, fields, or domains created to support the application.
- The application server must be shut down before the application is deleted.
To delete an application, log in to a database editor. Type the following commands in the database editor. Replace the variable <APPLICATION NAME> with the name of the application that you want to delete. The application name must be all uppercase.
delete from maxapps where app='APPLICATION NAME';
delete from maxpresentation where app='APPLICATION NAME';
delete from sigoption where app='APPLICATION NAME';
delete from applicationauth where app=''APPLICATION NAME';
delete from maxlabels where app=''APPLICATION NAME';
delete from maxmenu where moduleapp='APPLICATION NAME' and menutype !='MODULE';
delete from maxmenu where moduleapp='APPLICATION NAME' and elementtype='APP' and keyvalue='APPLICATION NAME';
delete from appdoctype where app='APPLICATION NAME'';
The application is deleted from the database. Log out of the database editor.
delete from maxpresentation where app='APPLICATION NAME';
delete from sigoption where app='APPLICATION NAME';
delete from applicationauth where app=''APPLICATION NAME';
delete from maxlabels where app=''APPLICATION NAME';
delete from maxmenu where moduleapp='APPLICATION NAME' and menutype !='MODULE';
delete from maxmenu where moduleapp='APPLICATION NAME' and elementtype='APP' and keyvalue='APPLICATION NAME';
delete from appdoctype where app='APPLICATION NAME'';
The application is deleted from the database. Log out of the database editor.
How to hide a button in a application using Signature Options?
In Condition Expression Manager, create a new condition
Condition=1001, description=Always false (you should replace 1001 with a more distinguished name)
Type = Expression
Expression: 1=0
In Application Designer app, open WoTrack app Action menu - Add/Modify Signature Options - New Row -
option name = HIDENEWROW
Description = Hide New Row in Work Order Task
use default values for all other fields
OK out of dialog
Still in Application Designer app, WoTrack app, open Control Properties of the "New Row" button you want to change. Enter "HIDENEWROW" for Signature Option for this button.
In Security Groups app, find all the groups that you'd like to have the New Row button hidden, and do the following:
- Go to application Work Order Tracking
- Filter out option "Hide New Row in Work Order Task"
- In the condition num field, enter "1001" (the new condition you created)
- check Grant access
- save
Sign out, and sign in as a user whose security groups have this setup. Go to Work Order app, Plans tab, and the New Row button in the Task section is hidden.
Type = Expression
Expression: 1=0
In Application Designer app, open WoTrack app Action menu - Add/Modify Signature Options - New Row -
option name = HIDENEWROW
Description = Hide New Row in Work Order Task
use default values for all other fields
OK out of dialog
Still in Application Designer app, WoTrack app, open Control Properties of the "New Row" button you want to change. Enter "HIDENEWROW" for Signature Option for this button.
In Security Groups app, find all the groups that you'd like to have the New Row button hidden, and do the following:
- Go to application Work Order Tracking
- Filter out option "Hide New Row in Work Order Task"
- In the condition num field, enter "1001" (the new condition you created)
- check Grant access
- save
Sign out, and sign in as a user whose security groups have this setup. Go to Work Order app, Plans tab, and the New Row button in the Task section is hidden.
Manually configuring Microsoft SQL Server for use with Maximo® Asset Management.
You can manually configure Microsoft SQL Server for use with Maximo® Asset Management.
Before you begin
Because Microsoft SQL Server does not support UTF-8, Maximo Asset Management does not have multilingual support when deployed with Microsoft SQL Server.
Microsoft SQL Server Database Collation settings must be set to the following options:
- Dictionary order
- Case-insensitive
- For use with 1252 Character set
About this task
To configure an existing Microsoft SQL Server for use with Maximo Asset Management, perform the following steps before starting the Maximo Asset Management installation program:
5/07/2014
Restricting Synonym domain lookup values in List tab
This can be done by using Security Group data restrictions.
1) Create a condition as below:
Condition Name : TESTSTATUS
Condition expression is VALUE IN ('APPR','WAPPR','DRAFT') <Make sure there is no colon (:) in the expression and also no validation required>
2) Apply condition in Security group :
Select require security group and go to data restrictions tab.
Enter new row :
Object : SYNONYMDOMAIN
Application : <Application name>
Type : Qualified
Condition : TESTSTATUS
Reevaluate : Checked
Save the security group and signout & signin again.
Now you can able to see the only require statuses in List and Advanced Search Tab.
Note :
1. In condition, make sure there will be no COLON ':' in condition expression. No validation require at condition.
2. By applying condition to SYNONYMDOMAIN at security group data restrictions, it will be applicable all synonymdomains for that application. Usually for any application, synonym domains values (not maxvalue) will be unique.
1) Create a condition as below:
Condition Name : TESTSTATUS
Condition expression is VALUE IN ('APPR','WAPPR','DRAFT') <Make sure there is no colon (:) in the expression and also no validation required>
2) Apply condition in Security group :
Select require security group and go to data restrictions tab.
Enter new row :
Object : SYNONYMDOMAIN
Application : <Application name>
Type : Qualified
Condition : TESTSTATUS
Reevaluate : Checked
Save the security group and signout & signin again.
Now you can able to see the only require statuses in List and Advanced Search Tab.
Note :
1. In condition, make sure there will be no COLON ':' in condition expression. No validation require at condition.
2. By applying condition to SYNONYMDOMAIN at security group data restrictions, it will be applicable all synonymdomains for that application. Usually for any application, synonym domains values (not maxvalue) will be unique.
Defining Default Values for Fields
You can specify a default value for a field by entering that value in the Default Value field of the attribute to which the field is bound. You specify a default value in the Details section for the attribute in the Database Configuration application.
Alternatively, you can define a field default value that is local to an application by using the Default Value control.
To define a field default value using the Default Value control:
1) In the Application Designer, open an application in the Workspace tab.
2) Open the Control Palette.
3) Drag the Default Value control into the section that contains the field for which you want to assign a default value. If you do not see the Default Value control in the section, click Select Action > Toggle Show All Controls.
4) Open Control Properties for the control, and perform the following actions:
5) Click Save
Alternatively, you can define a field default value that is local to an application by using the Default Value control.
To define a field default value using the Default Value control:
1) In the Application Designer, open an application in the Workspace tab.
2) Open the Control Palette.
3) Drag the Default Value control into the section that contains the field for which you want to assign a default value. If you do not see the Default Value control in the section, click Select Action > Toggle Show All Controls.
4) Open Control Properties for the control, and perform the following actions:
- Enter the name of the attribute bound to the field to which you are assigning the default value.
- Enter the desired default value in the Value field.
- Select Insert for the Default Type
5) Click Save
Subscribe to:
Posts (Atom)