All public logs

Combined display of all available logs of Data Islands. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 11:44, 21 October 2022 WikiSysopdi talk contribs created page Addregion (Created page with "'''Syntax''' : addregion <REGIONNAME> <PUBLIC/PRIVATE> "<DESCRIPTION>" <ENTER> Description : To add/checkout a container region which will contain our data islands. We can also give 'public' parameter to create region with public access.  If we wants to give description of new or existing region, then we need to enter text in double quotes. If we wants to make region private, then we can use 'private' parameter while checkout region.") Tag: Visual edit
• 11:44, 21 October 2022 WikiSysopdi talk contribs created page Deleteserver (Created page with "'''Syntax''' : deleteserver <INDEX> <ENTER> eg.deleteserver 1 Description : Delete a SQL/MYSQL/POSTGRESQL/CSV/XERO server from connection list. ----use the >servers command to get the index of the server connection") Tag: Visual edit
• 11:42, 21 October 2022 WikiSysopdi talk contribs created page Describe (Created page with "'''Syntax''' : describe <TABLENAME> <ENTER> Description : List of all column names of given table name.") Tag: Visual edit
• 11:42, 21 October 2022 WikiSysopdi talk contribs created page Dbtables (Created page with "'''Syntax''' : dbtables <ENTER> Description : Lists all of our database tables in the current server added through 'addserver'.") Tag: Visual edit
• 11:41, 21 October 2022 WikiSysopdi talk contribs created page Userdb (Created page with "'''Syntax''' : usedb <DATABASE> <ENTER> Description : To select and use any available database.") Tag: Visual edit
• 11:41, 21 October 2022 WikiSysopdi talk contribs created page Listdb (Created page with "'''Syntax''' : listdb <ENTER> Description : Lists all the available database list under current Server.") Tag: Visual edit
• 11:41, 21 October 2022 WikiSysopdi talk contribs created page Servers (Created page with "'''Syntax''' : logout <ENTER> Description :  To log out from current session as remove current local server detail.") Tag: Visual edit
• 11:40, 21 October 2022 WikiSysopdi talk contribs created page Help (Created page with "Syntax : help <command> <ENTER> Description : Displays the command help. Optional parameter of the command name to onlt see that specific command help text") Tag: Visual edit
• 11:38, 21 October 2022 WikiSysopdi talk contribs created page Islands (Created page with "'''Syntax''' : islands <ENTER> Description : Lists all of our islands in the current region added through 'push'.") Tag: Visual edit
• 11:38, 21 October 2022 WikiSysopdi talk contribs created page Regions (Created page with "'''Syntax''' : regions [PUBLIC] <ENTER> Description : Lists all of our regions.  We can also see public/shared regions by adding public optional parameter.") Tag: Visual edit
• 11:31, 21 October 2022 WikiSysopdi talk contribs created page Push (Created page with "'''Syntax''' : push <ISLANDNAME> [A/D/U] "<COLUMN LIST>" "<DESCRIPTION>" <ENTER> Description : Creates a data island in the current region and adds the data based on the previous run query.  For the FILES provider ONLY, please note that the files (which we get from querydb) will be uploaded to the server. We also have one optional parameter 'a' append or 'd' delete or 'u' update, so if user try to store data into existing island then application will ask whether we are...") Tag: Visual edit
• 11:30, 21 October 2022 WikiSysopdi talk contribs created page Querydb (Created page with "'''Syntax''' : For SQL/MySQL/PostgreSQL: querydb "<SQL QUERY>" <ENTER> For CSV: querydb "<CSV FILE NAME>" <ENTER> For Xero: querydb <ENTITY> <FILTER> <ENTER> For Files: querydb<PATTERN> <ENTER> Eg: For SQL/ MySQL / PostgreSQL: eg.querydb "select top 10 comp_name from company" For CSV: eg.querydb "test.csv" For Xero: eg.querydb contacts firstname = 'CRM' AND UpdatedDateUTC > DateTime(2022, 03, 24) FILES For Files: eg.querydb "*.csv" Description : Executes the gi...") Tag: Visual edit
• 11:28, 21 October 2022 WikiSysopdi talk contribs created page Connect (Created page with "'''Syntax''' : connect <ENTER> Description : Log in or Register with CRM Together.") Tag: Visual edit
• 11:22, 21 October 2022 WikiSysopdi talk contribs created page Addserver (Created page with " SQLite Example addserver sqlite "DataSource=C:\sqllite\sampledb.db;Version=3;"") Tag: Visual edit
• 11:31, 19 September 2022 WikiSysopdi talk contribs created page Pull (Created page with "Syntax pull island destinationname "<whereclause>"") Tag: Visual edit
• 21:20, 5 September 2022 WikiSysopdi talk contribs created page 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") Tag: Visual edit
• 12:15, 29 August 2022 WikiSysopdi talk contribs created page 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
• 16:30, 17 August 2022 WikiSysopdi talk contribs created page 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:42, 17 August 2022 WikiSysopdi talk contribs created page 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:46, 10 August 2022 WikiSysopdi talk contribs created page 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:12, 29 July 2022 WikiSysopdi talk contribs created page 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:03, 29 July 2022 WikiSysopdi talk contribs created page Datasources (data sources) Tag: Visual edit
• 11:59, 29 July 2022 WikiSysopdi talk contribs created page Jint (jint) Tag: Visual edit
• 10:47, 26 July 2022 WikiSysopdi talk contribs created page XERO addserver (sqlite example) Tag: Visual edit
• 12:45, 1 July 2022 WikiSysopdi talk contribs created page XERO querydb (Created page with " repeatinginvoices Fields: - Schedule -- StartDate (Schedule.StartDate) Date Fields in queries - DateTime(2022, 01, 01) Example querydb repeatinginvoices Schedule.StartDate >= DateTime(2022, 01, 01) AND Schedule.StartDate <= DateTime(2022, 12, 31)") Tag: Visual edit
• 13:21, 10 December 2021 WikiSysopdi talk contribs created page Scripting (initial write) Tag: Visual edit
• 12:12, 22 November 2021 WikiSysopdi talk contribs created page MediaWiki:Sidebar (Created page with "* welcome|Welcome ** getstarted|Get Started * navigation ** mainpage|mainpage-description ** recentchanges-url|recentchanges ** randompage-url|randompage ** helppage|help-mediawiki * SEARCH * TOOLBOX * LANGUAGES")
• 11:48, 22 November 2021 MediaWiki default talk contribs created page Main Page