SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 simple: SELECT [sequenceID], [student_reference], [student_title_code], [student_name], [student_gender_code], [student_country_birth_code], [student_country_domicile_code], [student_nationality_code], [student_ethnicity_code] FROM...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 available to download for FREE from this site. Why? It's useful to have a CSV list of all the IP ranges and their allocated country. Our use here was to create a refreshable country by IP address list that we can use when parsing our website logs to...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Zoho Deluge - Get User Timezone, Country and Locationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

03 June 2019 A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 Google Services as they are more likely to find locations that openweathermap.org cannot. Add a comma and the two letter country code (preferably "iso-3166-1 alpha-2") to the name if the location of the same name exists in multiple countries of the...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 "Test Street", "street2": "Test Street 2", "city": "Test City", "state": "Test State", "zip": "Test Postal Code", "country": "Test Country" } } However, if you try forcing the billing or shipping address in you should get the following error: Please...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 ${CONTACT.CONTACT_ADDRESS} ${CONTACT.CONTACT_CITY} ${CONTACT.CONTACT_CODE} ${CONTACT.CONTACT_STATE} ${CONTACT.CONTACT_COUNTRY} and in my Sales Order: BILLING ADDRESS SHIPPING ADDRESS ------------------- ------------------- Test Company Joels PO Box 1...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 A seller claims that there are brokerage fees, import duties or similar fees required to get an item into the country. Don’t pay these fees. You’ll most likely never get the product and will lose any money you paid. Always remember, «CompanyName» is...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 “Knowingly relying” means you have actual knowledge that, but for the patent license, your conveying the covered work in a country, or your recipient's use of the covered work in a country, would infringe one or more identifiable patents in that country...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 So they had something like: ${Organization.Organization Name} ${Organization.Street} ${Organization.City} ${Organization.Country} ${Organization.Postal Code} 11 My Street, My City, My State, My Zip, My Country They wanted to get rid of the "11 My...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 = Map(); l_CrmBillingAddress = {"Billing_Street","Billing_Street_2","Billing_City","Billing_State","Billing_Code","Billing_Country"}; l_CrmShippingAddress =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 `id`='1'); INSERT INTO `my_new_database`.my_prefix_contact_details ( `name`, alias, con_position, address, suburb, state, country, postcode, telephone, fax, misc, image, email_to, default_con, published, checked_out, checked_out_time, ordering, params,...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 we wanted to bring back both the code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter &S is not workable....

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 v_AddressState = r_ContactDetails.get("State"); v_AddressZip = r_ContactDetails.get("Zip"); v_AddressCountry = r_ContactDetails.get("Country"); } // // get line items from source and populate this subform l_QuotedItems =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 { l_LeadAddress.add(r_LeadDetails.get("Zip_Code")); } if(!isnull(r_LeadDetails.get("Country"))) { l_LeadAddress.add(r_LeadDetails.get("Country")); } // // use Zoho built-in GeoCode function to return latitude and longitude r_GeoCode =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Prices get rounded up in Virtuemarthttps://www.joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

27 September 2009 any of these things! After modifying tax rates and ensuring these were all the same, we also found that this was due to a country not being specified under the Store configuration within VirtueMart.

• Type: Article
• Author: Joel Lipman
• Category: Virtuemart
• Language: *

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 the funny question marks in diamond symbols and how I solved it in my case. Why? My company has started using international country and region names which include foreign characters. When we copy and paste their content into our website, our webpages...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 Time Zones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: List of tz database time zones

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: List of tz database time zones Zoho Deluge: Supported Time Zones

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

07 December 2021 List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: List of tz database time zones

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Regular Expressions in SQLhttps://www.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 does not contain apostrophes -- eg. O'Brien will NOT be returned -- Other REGEXP Functions for Oracle: -- -- REGEXP_REPLACE(country_name, '(.)', '\1 ') -- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0 -- -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1,...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *