Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming custom is required, the following 78 results were found.

  1. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    m_TranslateStatuses.put("SUBMITTED","Pending Approval"); m_TranslateStatuses.put("AUTHORISED","Sent to Customer"); m_TranslateStatuses.put("PAID","Paid in Full"); m_TranslateStatuses.put("DELETED","Cancelled");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    Statuses m_TranslateStatuses = Map(); m_TranslateStatuses.put("DRAFT","Draft"); m_TranslateStatuses.put("SENT","Sent to Customer"); m_TranslateStatuses.put("DECLINED","Cancelled / Rejected"); m_TranslateStatuses.put("ACCEPTED","Approved by Customer");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

    The reason I did this is because AEC is now a commercial package and it is somewhat limited in terms of good customer service. It only really manages the payment side and the complicated tasks of invoicing, but Community Builder provides more options...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    been doing this for years and still come across clients who have the one version of their website. They experiment on their customer-facing website and in most cases, they are paying for a hosting package which would allow them to have several copies of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    I'm making a custom component for Joomla CMS 2.5.x which is restricted to registered users only. On installation, and by default, the menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla Admin...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    that were usually branded or not free. These were awkward to configure a full screen button on the controls and do basic customization. Our screen recorder was also not displaying the captions of the video unless it was an AVI file that we converted to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  7. List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

    ID, Title, Content, Category, AccessLevel (note that AccessLevel is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  8. SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    In the data flow, click on the Excel datasource component so that it's selected. View the Properties panel for this. Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you specified as the datasource (eg. "Sheet1$")....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  9. URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    &rs:Snapshot=2004-03-30T15:45:02 Use a specific stylesheet (handy for customizing toolbars) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Stylesheet=Htmlviewer_copy.css Customize the Toolbar...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  10. Windows 7 Aero Featureshttps://www.joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

    of visual effects, some of which will be unchecked if you are not experiencing the full range of Aero features. Select the custom option and then select all the effects from the list below it. Hit apply and ok and you should have all the Aero effects...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  11. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS. How? You can search my site for how to do this in VB or C#. This version is entirely using T-SQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  12. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  13. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    Difficult? My hardest project was (still is) one created by a PhD student who graduated and left the institution. It was a custom-built site written from scratch, and it's purpose was to manage Staff and Students within the Additional Learning Needs...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  14. Advanced RokStories Stylinghttps://www.joellipman.com/articles/cms/joomla/advanced-rokstories-styling.html

    on your image size, so no need to manually create rounded corners on your images, RokStories will do the rest. The custom features are also available in the standalone version. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sit amet...

    • Type: Article
    • Author: Webmaster
    • Category: Joomla
    • Language: *
  15. Free Translator API using Googlehttps://www.joellipman.com/component/content/article/free-translator-api-using-google.html?catid=61&Itemid=165

    in using your Google APIs developer's account (FREE). Copy the JavaScript they give you (eg....) and paste this into a custom HTML module in your Joomla site. Add the meta tag they give you to your index.php file (under template folder in effect or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  16. SSIS: Add Reference Microsoft.SqlServer.TxScripthttps://www.joellipman.com/component/content/article/ssis-add-reference-microsoft-sqlserver-txscript.html?catid=74&Itemid=165

    This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  17. About 5 seconds worth of funhttps://www.joellipman.com/component/content/article/about-5-seconds-worth-of-fun.html?catid=77&Itemid=165

    Really not work related but if you know your sharepoint site: Custom Error http:///_layouts/MySite.aspx?Error=You%20are%20a%20jerk%20and%20SharePoint%20does%20not%20share%20with%20jerks. Installer? http:///userdisp.aspx=ID=1 Paying attention to the URL...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  18. Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

    was always going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format of [h]:mm:ss -- Aim / Objective: ColumnA ColumnB ColumnC ---------- ---------- ----------- Task 1 0.14 1:00:00 Task 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 61 - 78 of 78