Assuming against is required, the following 37 results were found.
-
Our use-case is that we retrieve the 100 most recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
The incoming webhook You now need to receive the Stripe webhook when it comes back into ZohoBooks to record it against the invoice. Note how we added the invoice reference and Zoho ID in the description of the payment capture in our previous bit of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
products from a WooCommerce instance on a client's Wordpress website. Why? A client of ours wants the information entered against products in their WooCommerce to display on their estimates in Zoho Books; such as product image, product name, product...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
purchased from a supplier, sent to another supplier for grading, and then sent on to the end user/customer. A custom field against the item record has been added which is a lookup to the Sales Order module. This means that on a purchase order, and per...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html
be repaired The Quick Fix I managed to fix this with this SQL command . Note: you need to be able to run SQL commands against your database. My client had phpMyAdmin installed so I click on "jos_k2_items" table and then click on the "SQL" tab Type the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
the database names to match your setup Change the table name prefixes to match your setup Run the modified SQL script against your database. Note: It is not advisable to run this on a production website! --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
www.joellipman.com. This article assumes you are familiar with upgrading a Joomla! CMS and running MySQL statements against your database. For the purposes of this article, we will refer to the live/current/production website running Joomla v2.5 as...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
2011-03-23 08:00:00.000 Test2 Room 08:00:00 09:30:00 2 Note that [Test1 Room] will appear as a row but have no slots booked against it. [Test2 Room] will both appear as a row and have 3 slots taken up (if you left the above to 30 minute slots). Tweaks...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases and you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance of the previous version of this query was pretty abysmal and worse if...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
and a PHP script. As well as a CSV file equivalent. How to use: Download from my site: «Download» Run the SQL script against a test database, Modify the table name to use if necessary. Uncomment the drop statement if running for the second time. Modify...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
and permitted IP address. If the end-user were to make the request, then their own IP address would be the one checked against, and it just wouldn't be manageable to add every new user's IP address to their service. The request has to come from a...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
from Sheet2 in this screenshot are from the cells B1:B4... This is because I already had values in A1:A4 and wanted to test against a set of different words.
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
between where it says +1 more) Type the word "value" and press Now type the string of words/phrases that you want to store against this custom parameter then press So to use these now, simply append 2 hyphens/dashes and the name of your custom...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages and VS2010 for database solutions running against SQL Server 2008 R2. We can use VS2012 for both but this requires upgrading all the packages and then making them suitable for our...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
environment, have you? Commented out lines that you suspect might be the problem? Able to run the SQL queries directly against the database? Matched the datatypes received/returned by functions, classes and procedures? Confirmed any ACL/permissions on...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB