Assuming level is required, the following 46 results were found.
-
Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than 100 products are modified in a day... We need to be able to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
for an employee either existing or that has been added to the system based on the business hours set at the organization level in ZohoCRM. How? Using an invokeURL, the key here is you'll find them in the settings; so check that your connection has the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0); m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong());...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
due to the API domain name change from https://books.zoho.com to https://www.zohoapis.com/books and changed the Top Level Domain (or Zoho DataCenter) from EU to COM as I was using this for a client on the US datacenter. I have a connection called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
a folder, I'm calling mine "Email Signature Images" Within that folder, create another folder called "_Global". At the same level, create another folder called "Profile Photos". Navigate into the "_Global" folder and note the last hash in the URL (after...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
there Note this down for later use Get the ZohoAnalytics Org ID: Login to ZohoAnalytics and ensure you are at the "Home" level Click on the cog icon in the top-right for "Settings" You should be in the "Organization Settings" Click on any page in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
like A few more things to configure Get the ZohoAnalytics Org ID: Login to ZohoAnalytics and ensure you are at the "Home" level Click on the cog icon in the top-right for "Settings" You should be in the "Organization Settings" Your Org ID is in the URL...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
my example, I'm returning some HTML but for security and stability, you will want this to use an XML file depending on the level of detail you want back. The biggy The following code is basically the least amount of code (or near enough) you will need...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
alias conflict: Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla Administration Panel (to check for and remove expired menu items) A good...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
40% ie. 12 steps of 30 is 40% progress eg. ($8 / $10) * 100 = 80% ie. $8 of $10 is 80% To determine the percent (adjustment level) given the RRP and the price you're selling at: ((Agreed Price - Usual Price) * 100) / Usual Price = % eg. ($10 - $8) * 100...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
but after two weeks of trying to find a solution, I would definitely recommend seeing if you can't check at the database level first. I will in future. Debug Method Fallback to debug methods; create a textbox that will be visible on the executed report...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We use a database account with read-only privileges to list all the details. On the last report,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
database will be able to tell you how many milliseconds it took for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located on a database...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
DMExtractEmployeeTable1 e1 LEFT JOIN DMExtractReferenceTable r1 ON e1.CodeType=r1.MapIn So why do I get the error: Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value 'B110' to data type int. I'm not using any of the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
FROM Event_XML.nodes('/*') AS r(c) ) AS RootParent FROM [dbo].[XML_EVENTS] -- to get name of immediate child node -- one level down SELECT ( SELECT c.value('local-name(.)', 'nvarchar(50)') FROM Event_XML.nodes('/*/*') AS r(c) ) AS RootChild FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
yesterdays up to the same hour. How? I used to use a lot more PHP but since becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
others which is probably why I made the generator in the first place but I do like to make people sign up so I can gauge the level of interest.
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
management system Review original deliverables and success criteria Satisfied? Can be quoted? Portfolio screenshots. Service Level Agreement Post-project support to be arranged prior to launch Discuss expectations for changes and support (response...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *