Group items tagged

Summary: Check Search whole cells and uncheck Regular expressions

Plug-in Details: CLOB Load Have you ever used a Rich Text Editor item type in APEX? Has the amount of text ever exceeded 32k? Choke! And so begins the search for a work around... While work arounds exists they can be a little difficult find and repeat each time you need them. We designed the Enkitec CLOB Load plug-in to simplify and standardize how large amounts of text are moved from the database to APEX page items and then back to the database.

.htaccess The .htaccess file is a simple text file placed in the directory you want the contents of the file to affect. The rules and configuration directives in the .htaccess file will be enforced on whatever directory it is in and all sub-directories as well. In order to password protect content, there are a few directives we must become familiar with. One of these directives in the .htaccess file ( the AuthUserFile directive ) tells the Apache web server where to look to find the username/password pairs. .htpasswd The .htpasswd file is the second part of the affair. The .htpasswd file is also a simple text file. Instead of directives, the .htpasswd file contains username/password pairs. The password will be stored in encrypted form and the username will be in plaintext.

There is a special program on a *nix machine that is designed to manipulate the .htpasswd file on your behalf. The name of this program is htpasswd.

The first way is to create a new .htpasswd file and add a username/password pair to the file. The second way is to add a username/password pair to an existing .htpasswd file.

Business intelligence is a data analysis process aimed at boosting business performance by helping corporate executives and other end users make more informed decisions.

Business intelligence (BI) is a technology-driven process for analyzing data and presenting actionable information to help corporate executives, business managers and other end users make more informed business decisions.

BI encompasses a variety of tools, applications and methodologies that enable organizations to collect data from internal systems and external sources, prepare it for analysis, develop and run queries against the data, and create reports, dashboards and data visualizations to make the analytical results available to corporate decision makers as well as operational workers.

For 64-bit users: wget -O jdk-64bit.tar.gz http://goo.gl/MSzBj wget -O jre-64bit.tar.gz http://goo.gl/yZgjI sudo -s cp -r jre-64bit.tar.gz /usr/local/java sudo -s cp -r jdk-64bit.tar.gz /usr/local/java cd /usr/local/java sudo -s chmod a+x jre-64bit.tar.gz sudo -s chmod a+x jdk-64bit.tar.gz sudo -s tar xvzf jre-64bit.tar.gz sudo -s tar xvzf jdk-64bit.tar.gz

sudo nano /etc/profile Add the following lines at the end of file: JAVA_HOME=/usr/local/java/jdk* PATH=$PATH:$HOME/bin:$JAVA_HOME/bin JRE_HOME=/usr/local/java/jre* PATH=$PATH:$HOME/bin:$JRE_HOME/bin export JAVA_HOME export JRE_HOME export PATH

Now enter following commands one by one in terminal: sudo update-alternatives --install "/usr/bin/java" "java" "/usr/local/java/jre1.7.0_12/bin/java" 1 sudo update-alternatives --install "/usr/bin/javac" "javac" "/usr/local/java/jdk1.7.0_12/bin/javac" 1 sudo update-alternatives --install "/usr/bin/javaws" "javaws" "/usr/local/java/jre1.7.0_12/bin/javaws" 1 sudo update-alternatives --set java /usr/local/java/jre1.7.0_12/bin/java sudo update-alternatives --set javac /usr/local/java/jdk1.7.0_12/bin/javac sudo update-alternatives --set javaws /usr/local/java/jre1.7.0_12/bin/javaws . /etc/profile

memory_limit - Recommended setting: 512M or higher. The memory_limit parameter mainly comes into play when executing large transactions such as mass update, export and import. If this setting is too low when trying to perform one of these actions, the end user will encounter a fatal error and the process will not complete. upload_max_filesize and post_max_size - Recommended setting: 30M or higher. Both of these settings work in conjunction with each other when uploading files through SugarCRM which includes future upgrades as well as document and note attachments. Please note that there is also a setting in the application which can limit file upload file size for end users so the settings in PHP should be high enough to allow any future upgrade files to be loaded without error. max_execution_time = Recommended setting: 300. This setting controls how long a PHP process will remain active. It is important to set this parameter to a value that will allow for large requests to complete if necessary but also will not hamper performance of the server if running too long.

In regards to PHP setup, the following parameters should be set with values as indicated:

Maximum upload size Admin > System Settings 30000000 (~30 MB) The 'Maximum upload size' controls the maximum file size your users can upload into Sugar. This setting should not exceed the post_max_size and upload_max_filesize parameters in your PHP configuration.

# cd /etc/yum.repos.d # wget http://public-yum.oracle.com/public-yum-el5.repo

Open the yum configuration file in a text editor Locate the section in the file for the repository you plan to update from, e.g. [el4_u6_base] Change enabled=0 to enabled=1

Tabular Tabular Column Validation Limit Length of Text Field Entry Tabular Form's Column Read-Only and No Duplication Tabular with Popup When Hovering Over Column Identify Column ID of Tabular Form Javascript News Ticker Popup Window Checkbox to toggle show/hide a region Tooltip APEX Built-in Tooltip Box Over Tooltip Page Page Load Time

Dezvoltarea afacerilor aduce cu sine întrebări din ce în ce mai complexe: care este cel mai profitabil produs pe care îl vând? Care este evoluţia marjei mele de profit pe produsul X de-a lungul ultimilor ani? Cum pot fi reduse eficient cheltuielile operaţionale fără a afecta performanţa afacerii? Cum pot fi reduse pierderile pe lanţul de aprovizionare sau pe circuitul de producţie? Care este volumul de afaceri pe care îl fac cu furnizorul Y şi ce discount aş putea solicita în perioada următoare? Care este cel mai performant vânzător al meu? etc…

Sigur, răspunsuri la întrebări complexe pot fi obţinute şi fără aportul soluţiilor de „business intelligence” insă de cele mai multe ori obţinerea rezultatelor dorite presupune cel puţin: personal specializat (analişti), inevitabila eroare umană şi mai ales timp. Timp petrecut cu activităţi repetitive de extragere a datelor, de formatare a acestora, de definire a diverselor formule şi calcule necesare etc. Mai mult decât atât, datele odată extrase din sistemul de gestiune şi „împrăştiate” la diverse nivele din organizaţie (sub forma de fişiere text, Excel sau DBF) îşi pierd proprietăţi precum integritate, acurateţe, confidenţialitate şi, poate cea mai importantă, credibilitate.

Alternativa? Un sistem ce poate gestiona în mod automat transformarea datelor în informaţie şi accesul la aceasta în funcţie de rolul utilizatorului în cadrul organizaţiei, în mod securizat, cu posibilitatea interacţiunii facile cu datele şi generarea de rapoarte şi analize complexe din câteva click-uri de mouse. Şi acestea sunt numai câteva din facilităţile oferite de furnizorii soluţiilor de „business intelligence”.