Critica y recopilación de contenidos(creación y consumo propio). nota:contiene informacion no apta para puristas del Ingles .
Reviews, personal contents and many grammar mistakes
Table=Table name. Check in Object, Attributes, "Database Table" column
* i.e for custom objects: odf_ca_cop_xxxxxx
Field=Attribute name.
For custom attributes, check in Object, Attributes, "Database Column" column
For default attributes, click on "Attribute" column, and use "Attribute ID" (in Object Attribute window)
For virtual attributes, check in Object, Attributes, "Database Column" column
-NSQL Query in a Lookup-Query:
Lookup-query supports works with a quite standar SQL syntaxis
i.e
SELECT @SELECT:my.code:code@,
@SELECT:P.PROJECT_CODE:PROJECT_CODE@,
FROM odf_ca_myobject my, PAC_MNT_PROJECTS P
WHERE @FILTER@
-NSQL query in QUERY
Requires the comple NQL syntaxis and at least one dimension definition (SELECT:DIM:)
i.e.
SELECT @SELECT:DIM:USER_DEF:IMPLIED:Mytest:my.code:code@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:Mytest:my.created_by:created_by@
FROM odf_ca_myobject my
WHERE @FILTER@
-Table Prefixes
Prefix, Table Topic
BIZ,Opportunities
CAL,Events
CAP,Capacity Planning
CLB,Collaboration
CMN,Common tables that span functionality
CMN_RPT,Reporting
CMN_SEC,Security
MR,Methodology
NBI,Datamart
NTD,Discussions
OBS,Organizational Breakdown Structure
PAC,Project Accounting
PPA,Project Billing
PR and PRJ,Projects
RSM,Resource management
SRM,Main objects table that crosses functionality modules
TAX,Tax
XDM,eXtensible Data Model (XDM) for user-defined fields and forms
(added tables)
COP, from PMO Accelerator (not tied to any specific industry)
CATS, from Best Practises Accelerator (old) (BPA)
ODF,
ODMD, CA Clarity PPM Essentials
PR2, Accelerator PRINCE2 (tied to PRINCE2 from Office of Government Commerce)
PBK, Accelerator PMBOK guide (tied to PMI PMBOK)
CSK, Accelerator Program Management Office (PMO)
TIPS for Naming in Clarity (objects, attributes,...)
qry query
q_ query
lkp lookup
l_ lookup
prt portlet
rpt report
prj project
proc process
res resource
tab tab
obj object
o_ object
pfl portafolio
Calculated attributes & Power Filters& Process conditions
Calculated attributes
result type: string
Concat(string1,string2,...)
Concat(attribute)
If a lookup attribute (ie. project.goal_code) are not listed in the pulldown try to write id in formula ;)
DateDiff(start,finish,"Day")
Be careful with syntax because some functions like DateDiff, internally the result can be negative but the attribute will displays with no minus symbol.!!
!!(If negative it will be displayed in red color and between bracket () symbols)
Calculated attribute+mappi>ng colors
DateDiff(Now(), prfinish,"Day")
-1 to -100 (red)
0 to 100 (green)
In views, Fields, configure field; Display Elements=Image
Power Filters
-Power filters are not SQL!
-The Power Filter is currently designed to search for values only. If you leave the field empty (NULL value) that field is not included in the filtering. There is no current functionality that allows the configuration of the power filter to search for NULL or NOT NULL values.
"wildcard" character in Oracle is a percentage "%", but Clarity handles that;
i.e. I enter a "*" in a Clarity LIKE condition and this is converted by Clarity to a "%" when the SQL hits the database.
note: on v7.5.3 on Oracle, both % and * worked as wildcards, since v8 only * has worked
Start conditions. to avoid to enter in the process. Include here the conditions required by steps.
To detect a change in on attribute:
I.e of formula created by manual writing or generated from forms.
Provide information in real time for CA Clarity PPM users, most suitable when your query data contains only one or two dimensions(metrics); from different objects
-Grid portlet. based in data from a dataprovider such as Object, System, Clarity Query (NSQL).
Real only when dataprovider is a Clarity Query (NSQL).
If your grid contains virtual columns, the source data for those columns
must be defined in the query that supplies data to the grid.
--A hierarchical grid portlet can be used to show the structure of data that has more than one level. A parent row can have multiple child rows, and the data that shows in the parent row can be an aggregate of the child data.
Lookups
Static List
Dynamic Query. NSQL is supported in Query.
Hidden key * : Lookup Code /Lookup Enum (type to use in database)
* Important to decide which type use before Save.
After choose hiddenkey
ID (enter once+unique): *
* will assigned to previously chosen field in hiddenkey
LOOKUP_CODE is character type on the database,(if chose "enum", it will contains same number)
LOOK_ENUM is numeric type on the database, use when values are numbers,(if chosen "code", it will contains 0)
"Object" not required for a Dynamic query
Parent Window tab
"Hidden Key" is associated to the field in the first SELECT sentence, (value will be stored in the destination attribute and database)
"Display Attribute":(Output field) will display the content of this field in the attribute, after lookup selection.
Notes:
Lookup configuration is reset. After changes in Query, configuration for Display Attribute and Browse window has to be reconfigured. (Avoid surprises with config documentation)
Attribute Lookup(string) and Hidden Key. Hidden key will pass the complete result to attribute but it is limited to 30chars, so a bigger string will give error "Error:Value is too large" (verified in v13.1)
Attribute "Data Type" takes its value when it is associated to a lookup for first time, so it will take the type of lookup output (Parent Window )
Be careful!!! because if you change the lookup output field and it has a different type then the attribute will display an error on the web.
Furthermore the "Data type" of a lookup attribute is read only the first association to a lookup, so you need to create a new attribute with the correct "Data type".
How to pass parameters to the query:
from attribute mapping
Put @WHERE:PARAM:USER_DEF:INTEGER:xxxx@ in the WHERE clause
Create an attribute and associate with previous lookup, press Save
Now, attribute showsin the bottom the section "Lookup Parameter Mappings"
Select an attribute to map to parameter; from the list of attributes available for this object.
*INTEGER or any other Data type.
from the web address (Xpath)
@where:param:xml:integer:/data/xxxx/@value@
xxxx=field in the address such as id, projectid, object_id, etc...
value=returns the value after symbol "="
Note: be careful with this pameters because the query could not work as expected with other views containg the lookup, since views can have different fields in the web address.
NSQL.
-Comments:
-- line comment
/* */ multiline comment
Must be after the first SQL Sentence, ie SELECT -- ver. 1.2 Diciembre2012 @SELECT:resources.id:prid@,
-Read only queries
-UPDATE, INSERT, and DELETE operations cannot be performed in NSQL.
-not recommend using NSQL for reporting or for stored procedures
- Data types: STRING, INTEGER, FLOAT, IMPLIED, FLOAT,DATE, MONEY (in SELECT)
New lookup
In "Source" select "Dynamic Query", Submit/Save
In "Query" tab, "Query" text box, enter NSQL query, Save
In "Browse Window" click on the "Preview" button
(a window popup with the query results will be showed).
admin.log
...
[echo] CA Clarity Accelerator: Program Management Office installation was successful and is complete.
[echo] Check the install.log for errors that might not have been handled.
[echo] Package Installation Successful - 08-April-2013 21:00:01
...
[exec] Content Pack csp version 13.0.1.0102 has been deployed
[exec] DBTools Log - Mon Apr 08 22:28:02 CEST 2013
[echo] Clarity Solution Pack installation was successful and is complete.
[echo] Check the install.log for errors that might not have been handled.
...
(admin) Following object(s) are invalid:
app-ca.log (application errors)
...
ERROR yyyy-mm-dd hh:mm:ss,mmm [http-bio-14001-exec-xxx] grid.EditListRowServiceImpl (clarity:username:sesionid:GetListContextByRow) Fatal error getting row metadata for project [projectid]
ERROR yyyy-mm-dd hh:mm:ss,mmm [http-bio-14001-exec-xxx] out.service (clarity:username:sesionid:GetListContextByRow) A RuntimeException encountered in Service. Converting to OSFApplicationException.
java.lang.RuntimeException: org.json.JSONException: JSONObject["column"] not found.
WARN yyyy-mm-dd hh:mm:ss,mmm [http-bio-14001-exec-xxx] web.WebSession (clarity:username:xxxxxxxx__SESSION_ID:odf.filter) A request has been denied as a potential CSRF attack. Request Information-
USER_ID=xxxxxxx
SESSION_ID=xxxxxxxxx
CLIENT_IP_ADDRESS=x.x.x.x
XFF_ADDRESSES=null
session id token: i.e. userdid__xxxxaxxe:xxxbaexxxax:-xxxxxxxxxxxxxxxxx
Userid is before the double underscore (__).
Finally, you can locate that user by selecting into the cmn_sessions table.
IP address of requestor
DateTime of the completed request
URL request
HTTP Status Code
Bytes sent back to the client (excluding the header)
Elapsed time of the request (in ms, can be subtracted from the DateTime to get the request startTime)
Clarity sessionId cookie (a distinct way to group requests, can be tied back to the sessions tables in Clarity to find the user)
- no results return to client for this field
aaa=code that the server sends back to the client
2xx= Successful
200= OK
3xx= Redirection
4xx= Error caused by the client
5xx= Error caused by the server
bbb= size of the object returned to the client, not including the response headers.
cc= elapsed time of the request
v12. https://servername.com/niku/app?action=xxxxxxxxxx&debug=1 XML output
XML Open Gateway (XOG)
web service interface that you can use to:
*Import data
*Export data
*Move configuration data from one system to another
to read data from or write data to CA Clarity using XML and web services
GEL tags that can be used with XML for more advanced custom integration tasks
CA Clarity web services use XML messages that follow the SOAP standard.
to know which version of Schedule connect is installed: java -cp "C:\Program Files (x86)\CA\Clarity\CA Clarity PPM Schedule Connect\lib\version.jar" com.niku.tools.VersionNumber
This software is an interface between web browser and
OpenWorkbench, so if our web browser cannot open project in OWB, you have to associate MIME type to SCHEDLINK.
/s (setup in silent mode)
it just associate NIKUSL object to Schedlink (Internet Explorer)
(Registry: HKCR\MIME\Database\Content Type\application/nikuscheduler\Extension=.nikusl) /d show output log to c:\SchedLink.log Openworkbench/MSP conection file (sched.nikusl)
A
project is associated to a specific Scheduler by attribute "Scheduler
Format"(Eng) or "Formato del programador" (Spa) (ID: prformat)
Available from UI, Schedule, Tracking
Depending of scheduler associated to a project, downloaded sched/sched.nikusl file will have one of following values:
Concept Draw Pro(Win, MacOS)
A good alternative to Ms Visio, advantages over Visio are
multiplatform and portable version for Windows.
Flowcharts, UML, Mockup resources, OS interface components, etc..
Import:Visio XML, Powerpoint
Export: CDD, CDX(xml from conceptdraw), Visio XML, SVG, SWF
MacOs version available for PPC and Intel CPU
Version 9.2.5 included in ConceptDraw Office 2
Conceptdraw 9.2.5, mockup
Omnigraffle (MacOS)
Nice and easy diagramming software
Available for PPC and Intel CPU Visio (Win)
A well know software but only available for Windows.
LibreOffice Draw (multiplatform)
LibreOffice Draw
It has a big name after it, is opensource and is portable. However, in terms of usability and features is quite bad.
-Freemind (Java multiplatform)(GPL)(abandoned but forked by freeplane)
Tested versions: 0.8, 1.0.1
Very stable and working correctly in MacOS.
-FreePlane (multiplatform)(GPL)
freeplan screenshot
Tested versions: 1.2.42b, 1.2.1, 1.3.12
(Win install/portable, Mac, Linux,..)
Export to: html, graphics,...
Fork of Freemind, and compatible with it. Many options but not a very clear interface
Note, a new node cannot be inserted from right button or toolbar but from
"Insert" key, or Edit, New node, New child node
Replace a platform is a hard decision, and too many times implies data loss. After spend sometime looking for methods find below how I moved from Palm OS to Android.
FROM PALMOS TO ANDROID:
**PalmOS**
General info.
PalmDesktop 4.1.4
Export
Contacts: aba, csv, tab (Export all)
excel, Word (select all, send to)
vcf (vcard) (Select all, export to vcf) *
Tasks: tda (Export all)
excel, Word (select all, send to)
Memo: mpa, csv, tab, txt (Export all)
Word (select all, send to)
Calendar: dba
* works in PalmDesktop 6
**Android**
General Info. Contacts
Import from SIM
Import from SD (vcf file in SD) *
Import from Google
* Classification category is lost
Procedures Palm contacts to Android contacts
Export from Palm Desktop as .vcf containing all contacts
Copy vcf file in Android SD
Import from SD in Android
Recreate categories in Phone or Kies manager
Palm Memos to Note Everything
Follow Note everything manual or
Export from Palm desktop to csv, import in excel and let the columns as
column1 =category
column2=memo content
Palm desktop to Android DejaOffice
DejaOffice has its own contacts, memos, tasks, so syncronization will not affect to default Android apps.
Requirements in Computer:
-Palm Desktop installed and previously synchronized with Palm Phone
-PC with Android Phone drivers (Install Kies for Samsung, connect phone and drivers will be installed)
-CompanionLink * installed (Checked with v 3.0.3089)
Steps:
1. Configure CompanionLink
1.1 PDA: Android USB
1.2 PIM: Palm desktop (Access)
1.3 Configuration: Palm desktop as primary
2 Connect phone by USB
3 Execute DejaOffice in Android,
3.1 Click "Syncronize" on DejaOffice menus
3.2 Wait
3.2 Disconnect Phone from PC
Now Contacts, task, calendar and memos will be available in Dejaoffice :)
Android Calendar to DejaOffice Calendar
Android calendar is a piece of crap,with poor on features and with a lack of usability in UI.
But if you have data en Calendar and you want to move to DejaCalendar without sync with google web (I don't like the cloud).
go to "Settings", "Sync settings" and activate "Sync with Android Calendar App"
Note. At least in the spanish translated version 2.1.9
"Sync with Android Calendar App"and "Sync with Android Contact App" are incorrectly exchaged.
After select you have to chose between alarms in Android Calendar or DejaCalendar.
Chose categories to sync.
In Home/ main menu chose "Read Android Data"
Now we have real calendar. ;)
Outlook Calendar to DejaOffice Calendar (using Sundbird -> no cloud, no shit in the middle)
From Outlook Calendar. Save Calendar as (as ICS) Date range: Specify dates Detail: Full detail Advanced: Include details of items marked private
From Sunbird (Mozilla Sunbird 1.0b1) Import ICS file and remove instance/occurrences
Select specific events and export Selection (to ics)
From Android
Open ICS file from Android (any file explorer)
DejaOffice will import the entries and even categories will be preserved.
Although many people thought Android came to save us from the darkness, I think this OS is not an step ahead but in my humble opinion it is more like reinventing the wheel, losing much time to create the same, and this new apps are not multiplatform..
Probably this is the best choice for a private company interested in doing the maximum of money but hardly it could be worse for users and progress
Anyway anyone said it were a perfect world....
Software:
Keepassdroid. 1.9.18 (GPL)
PIM:
-OmniNotes FOSS(Fdroid v5.5.2.sqlite db and android4)
from setting select the calendars previously syncronized with DavX/Davdroid
-DavX/Davdroid (Fdroid v1.9.2 android4)
add an internet CalDav service account
-DejaOffice 2.5.8
Features: Import from ics calendar(open ics file from explorer/fileexpert...)
sdcard\clusb\dbcompanionlink.db (sqlLite format; tables: Calendar, Memos,...)
(backup default path: sdcard\clusb\backup\companionlinkxxxxxxx.db
BB10 .\misc\android\clusb
)
Manual backup
-Opciones
-Configuracion de Registro y Soporte
-backup databases
-Note Everything 4.2.4
Info stored in file /noteeverything/backup/notes.db (sqlLite file; table Notes)
+proAddon 2.5.1 (includes internal backup/restore feature) ! (config location for automatic backup in external SD card)
Backup policy
v4.2.4 and 4.2.9 (without Pro addon)
Before install the apk, copy "backup" with contents in folder in SD folder "/noteeverything/"
Install apk v4.2.4, v4.2.9,..
Open, noteverything will detect the previous backup and will ask to restore it
* Preferences,advanced,"import/export db","backup base de datos"-,export internal sd
v4.2.8
* Preferences,advanced,"import/export db", Restore db (from SD)
* Base de datos,
v4.2.9b (Only with ver Pro addon)
* Preferences, Advanced, Database maintainer,"Backup database"/"Restore database"
it will update the file content of: /noteeverything/backup/notes.db (sqlLite format)
Multimedia
Folder player 3.1.2
BS player lite 1.3.126
VLC 0.2-git (APK) http://nightlies.videolan.org/build/armv7-android/
Minilyrics 1.0.8
Podax 5.9 +gpodder1.9
Rehearsal Assistant (Free)(a voice recorder with play function)
phone\urbanstew.RehearsalAssistant
Dictionaries/reference/Learning:
Colordict.
4.2.1 SD(internal) folder: \dictdata
Goldendict.1.5.6 SD
default folder: \goldendict (db will be indexed)
free version max 5 dictionaries at same time
an additional folder for dictionaries can be specified in preferences (i.e \dictdata)
Aard 1/2 (Free)
.slob files
inc wikipedia simple
Kiwix
offline wikis,etc ...
can get content from the app
AnkiDroid.(Free)
Default folder in internal but external can be configured
i.e /Storage/extSdCard/xx/AnkiDroid
OSMAnd 1.9.5
Settings,General, Storage directory: extSdCard
/extSdCard/osmand (map files are hidden to usb connection)
(removing or renaming file .nomedia, files will be visible to PC)
OSMAnd 3 (in BB10)
Settings,General Settings, Data Storage folder:
/data/data/net.osmand.plus/files/osmand
(work but data is using internal mem and also folder and files are not accessible by user)
Solution: change the folder and the app will move all the data
new folder: /mnt/sdcard/external_sd/SD_DATOS/osmand
To change language for place names:
Menu, Configure map, Map language ( English ; default: local names)
Metro 0.3.0 (data \GT-xxxx\Phone\metro)
HERE (ex Nokia Maps,Here) (on previous ver. rendering sometimes failed)
Internet browsers:
(app size)
Atlas 1.0.2.3
CMbrowser 5.1.80
Firefox 34.0.1
Lightning 3.1.1a
Opera v14.0.1 (last Opera engine)
palm game for android
Firefox/Fennec v23.0
(APK) http://ftp.mozilla.org/pub/mozilla.org/mobile/releases/latest/android/multi/
Opera Mini 8.0.1807
System/Tools:
Styletap. PalmOS emulator
Barcode Scanner (Free-Fdroid)
File Expert. 5.0.6 (files explorer, apps to apk, zip...
OI Filemanager 2.0.2 (Free-Fdroid)
All in One Toolbox (performance, sys info, files explorer, apps to apk, multiple files to zip...
Hacker's keyboard (includes function keys required for remote control of computers)(f-droid)
Galaxy Toolbox 1.22GA
APK Extractor (Free-Fdroid)
Disk Usage (Free-Fdroid)
Applications info (Free-Fdroid) (many info about installed apps)
F-Droid
Cache with APKS...
Phone\Android\data\org.fdroid.fdroid
rerware Mybackup Pro (\rerware\)
ROM toolbox 5.5.0 (some options requires root)
ROM management, App management, browser,autostart, Apps2SD, Terminal emulator, task manager,..
Autostarts (available at F-Droid) what starts and when
OS Monitor (available at F-Droid) shows linux processes, TCP/IP open connections,.. requires root
titanium backup
Index: 1.Iterative reboots during the charge which avoid a the charge process.(N8x0) 2.Screen jittering. (N800)
Iterative reboots during the charge which avoid a the charge process. (N810/N800)
Try with different Nokia chargers, even with the same external aspect the voltages/current differs in the Nokia chargers, furthermore nowadays electric devices and since batteries have a broad range of input voltages there is no risk in this action.
Batteries or device have internal IC (integrated circuits), to protect the device/battery, and the problem could be there instead of the N8xx input. For any reason the battery controller need more or maybe less voltage to continue charging.
You can use any mobile phone charger(the most of them are 5V-6V DC), you only need to change the output connector.
For N800 I used 5.2v and0.5mA (No nokia) instead of nokia (AC-3X) 5V and 350mA
Screen Jittering. (N800)
Device still working but it is very annoying to see how the windows are moving/jittering in the screen. I my opinion it is related with colour contrast in the screen because it happens more with dark screen than when we are working in a white/grey screen.
After opened the tablet I can see few components not covered by the metal shields but I saw two components which I think could be involved in the failures; battery(2) and capacitor?(2)
The capacitor is a bit dark in the lest side, looks like a bit burned, I hardly can read over it something like "G.MKT"
The battery looked bad but in theory should not affect to screen.
After disassembly the screen there some small components and two IC. the small one has written "VM66BS 92300SN" (2)
