User contributions for WikiSysopdi
From Data Islands
20 September 2022
- 12:1612:16, 20 September 2022 diff hist +517 Pull LIKE operator Replaced with ILIKE Tag: Visual edit
19 September 2022
- 12:4512:45, 19 September 2022 diff hist +86 MediaWiki:Sidebar No edit summary
- 12:4312:43, 19 September 2022 diff hist +74 MediaWiki:Sidebar No edit summary
- 11:3111:31, 19 September 2022 diff hist +51 N Pull Created page with "Syntax pull island destinationname "<whereclause>"" Tag: Visual edit
- 11:3111:31, 19 September 2022 diff hist +13 MediaWiki:Sidebar No edit summary
5 September 2022
- 21:2021:20, 5 September 2022 diff hist +428 N Embed Created page with "You can embed lists and dashboards from the web app (data.crmtogether.com) into your own app (ERP or CRM system for example) without having to pull down the code. You do this by embedding an iframe with a src url that has the structure https://data.crmtogether.com/iframe/REGION/ISLAND/?FIELD=fieldvaluetomatch For example <nowiki>https://data.crmtogether.com/iframe/tsxerodata/xeroinvoices/?Contact_Name=Acme</nowiki> Inc" current Tag: Visual edit
- 21:1621:16, 5 September 2022 diff hist +15 MediaWiki:Sidebar No edit summary
4 September 2022
- 22:5322:53, 4 September 2022 diff hist +306 Sage 300 Queries No edit summary current Tag: Visual edit
1 September 2022
- 12:0912:09, 1 September 2022 diff hist +677 Charts querydb in web app current Tag: Visual edit
29 August 2022
- 16:1016:10, 29 August 2022 diff hist +307 Sage 300 Queries No edit summary Tag: Visual edit
- 16:0016:00, 29 August 2022 diff hist +218 Sage 300 Queries No edit summary Tag: Visual edit
- 15:4515:45, 29 August 2022 diff hist +602 Sage 300 Queries No edit summary Tag: Visual edit
- 15:3515:35, 29 August 2022 diff hist +250 Sage 300 Queries No edit summary Tag: Visual edit
- 14:4714:47, 29 August 2022 diff hist +56 Sage 300 Queries No edit summary Tag: Visual edit
- 14:4114:41, 29 August 2022 diff hist +997 Sage 300 Queries No edit summary Tag: Visual edit
- 12:1512:15, 29 August 2022 diff hist +151 N Sage 300 Queries Created page with " Contained here are some recommended queries for Sage 300 to get only the data needed for Owners and customers. Owners: Single Customer queries:" Tag: Visual edit
- 12:1412:14, 29 August 2022 diff hist −9 MediaWiki:Sidebar No edit summary
- 12:1412:14, 29 August 2022 diff hist +1 MediaWiki:Sidebar No edit summary
- 12:1312:13, 29 August 2022 diff hist +49 MediaWiki:Sidebar No edit summary
17 August 2022
- 21:0221:02, 17 August 2022 diff hist +7 XERO Xero Support No edit summary Tag: Visual edit
- 16:4116:41, 17 August 2022 diff hist +546 XERO Xero Support No edit summary Tag: Visual edit
- 16:3016:30, 17 August 2022 diff hist +171 N XERO Xero Support Created page with " Note: The xero "invoices" table holds both invoices sent and received. So you should filter this on the "Type" column which contains 1 of 2 values # ACCREC # ACCPAY" Tag: Visual edit
- 12:4212:42, 17 August 2022 diff hist +394 N Task Scheduler Created page with "You can use windows Task Scheduler to run tasks at a specified time In the Task item you set the action to be "Start a Program" and set the "Program/Script" value to be the path to the console exe file. EG "C:\Users\YOURUSER\AppData\Roaming\CRM Together\TSDataIslands\TSDataIslands.exe" and then set the "Add Arguement" to be the path to the script file EG "C:\DIScripts\pushERPdata.tsd"" Tag: Visual edit
- 12:3812:38, 17 August 2022 diff hist +76 MediaWiki:Sidebar No edit summary
16 August 2022
- 16:0516:05, 16 August 2022 diff hist +30 XERO querydb No edit summary Tag: Visual edit
11 August 2022
- 16:1216:12, 11 August 2022 diff hist +215 XERO querydb No edit summary Tag: Visual edit
- 14:5714:57, 11 August 2022 diff hist +3,314 Charts chart js examples put in Tag: Visual edit
10 August 2022
- 12:4612:46, 10 August 2022 diff hist +366 N Charts Created page with " Examples: # Northwind Orders table SQL select EXTRACT(month from TO_DATE("OrderDate",'MM')) AS "MON", TO_CHAR(TO_DATE("OrderDate",'MM/DD/YYYY'), 'Month') AS "Month", SUM(1) from orders group by EXTRACT(month from TO_DATE("OrderDate",'MM')) , TO_CHAR(TO_DATE("OrderDate",'MM/DD/YYYY'), 'Month') order by EXTRACT(month from TO_DATE("OrderDate",'MM'))" Tag: Visual edit
- 12:4512:45, 10 August 2022 diff hist +27 MediaWiki:Sidebar No edit summary
4 August 2022
- 13:4813:48, 4 August 2022 diff hist +22 m Datasources No edit summary current Tag: Visual edit
- 13:4713:47, 4 August 2022 diff hist +581 m Datasources No edit summary Tag: Visual edit
- 13:4413:44, 4 August 2022 diff hist +75 m Jint No edit summary Tag: Visual edit
3 August 2022
- 15:0715:07, 3 August 2022 diff hist +12 m Jint No edit summary Tag: Visual edit
- 13:4113:41, 3 August 2022 diff hist +34 MediaWiki:Sidebar No edit summary
- 13:4113:41, 3 August 2022 diff hist +41 Scripting No edit summary Tag: Visual edit
- 13:3513:35, 3 August 2022 diff hist +484 Jint No edit summary Tag: Visual edit
- 13:3213:32, 3 August 2022 diff hist +314 Jint example scripts Tag: Visual edit
29 July 2022
- 12:1212:12, 29 July 2022 diff hist +125 N Status Created page with "Command >status This shows all details of the local and remote status. It combines commands to show regions and status etc." Tag: Visual edit
- 12:0912:09, 29 July 2022 diff hist −14 MediaWiki:Sidebar No edit summary
- 12:0912:09, 29 July 2022 diff hist 0 Main Page No edit summary Tag: Visual edit
- 12:0712:07, 29 July 2022 diff hist +1 MediaWiki:Sidebar No edit summary
- 12:0712:07, 29 July 2022 diff hist −1 MediaWiki:Sidebar No edit summary
- 12:0712:07, 29 July 2022 diff hist +11 MediaWiki:Sidebar No edit summary
- 12:0312:03, 29 July 2022 diff hist +118 N Datasources data sources Tag: Visual edit
- 12:0212:02, 29 July 2022 diff hist +28 MediaWiki:Sidebar No edit summary
- 11:5911:59, 29 July 2022 diff hist +894 N Jint jint Tag: Visual edit
- 11:5411:54, 29 July 2022 diff hist 0 MediaWiki:Sidebar No edit summary Tag: Manual revert
- 11:5311:53, 29 July 2022 diff hist 0 MediaWiki:Sidebar No edit summary Tags: Manual revert Reverted
- 11:5311:53, 29 July 2022 diff hist 0 MediaWiki:Sidebar No edit summary Tag: Reverted
- 11:5311:53, 29 July 2022 diff hist +13 MediaWiki:Sidebar No edit summary
