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).

• 16:51, 28 February 2023 WikiSysopdi talk contribs created page File:Sage 100 providex 1.png
• 16:51, 28 February 2023 WikiSysopdi talk contribs uploaded File:Sage 100 providex 1.png
• 16:51, 28 February 2023 WikiSysopdi talk contribs created page File:Sage100 providex system dsn.png
• 16:51, 28 February 2023 WikiSysopdi talk contribs uploaded File:Sage100 providex system dsn.png
• 16:49, 28 February 2023 WikiSysopdi talk contribs created page Sage 100 ProvideX (Created page with "With ProvideX you must have a 64 bit ODBC driver. Within ODBC add in your connection as a system DSN Example command to add in the connection to the Data Islands console app >addserver odbc "DSN=DIMAS100;UID=USERNAME;PWD=PASSWORD;Company=ABX; Directory=C:\Sage\Sage 100 Standard\MAS90; Prefix=C:\Sage\Sage 100 Standard\MAS90\SY\, C:\Sage\Sage 100 Standard\MAS90\==\; ViewDLL=C:\Sage\Sage 100 Standard\MAS90\HOME; LogFile=\PVXODBC.LOG; SERVER=NotTheServer"") Tag: Visual edit
• 15:48, 13 February 2023 WikiSysopdi talk contribs created page Releases (Created page with "This page will contain notes on any releases / updates to the system.") Tag: Visual edit
• 11:55, 1 February 2023 WikiSysopdi talk contribs created page NotifyTeam (Created page with "NotifyTeam <nowiki>==========</nowiki> Syntax : notifyteam "<MAIL SUBJECT>" "<MAIL BODY>" <ENTER> Description : Send email with Subject and Body parameters to all team who has access of current region.") Tag: Visual edit
• 11:55, 1 February 2023 WikiSysopdi talk contribs created page NotifyMe (Created page with "NotifyTeam <nowiki>==========</nowiki> Syntax : notifyteam "<MAIL SUBJECT>" "<MAIL BODY>" <ENTER> Description : Send email with Subject and Body parameters to all team who has access of current region.") Tag: Visual edit
• 12:36, 19 January 2023 WikiSysopdi talk contribs created page Script Files (Created page with "You can put scripts into files. Typically they are names in the format NAME..tsd To call these from the console app Script <nowiki>======</nowiki> Syntax : script "<SCRIPT FILE PATH>" <ENTER> Description : Execute a batch of commands from a script file. You can also pass in the script file as an application argument E.G pathtoexe\TSDataIslands.exe "<SCRIPT FILE PATH>"") Tag: Visual edit
• 11:36, 19 January 2023 WikiSysopdi talk contribs created page XERO files (Created page with "Experimental feature that will get the invoice PDF files Example >querydb invoices "Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)" FILES") Tag: Visual edit
• 10:49, 14 January 2023 WikiSysopdi talk contribs created page RunExe (Created page with "RunExe <nowiki>======</nowiki> Syntax : runexe "<EXE PATH>" <ENTER> Description : User can launch the given exe path.") Tag: Visual edit
• 12:20, 21 October 2022 WikiSysopdi talk contribs created page Web App (Created page with "The web application is available at https://data.crmtogether.com/ Register here or log on with your credentials") Tag: Visual edit
• 12:18, 21 October 2022 WikiSysopdi talk contribs created page Get Started (Created page with "<b>Welcome to the Data Islands Help</b> ''-What is Data Islands?'' Data Islands is an online service that allows you to securely create Micro Data Warehouses and manage access to that Data. ''-What is a Micro Data Warehouses?'' A Micro Data Warehouses is a collection of datasets that contain small amounts of data fed from your "Data Silos" EG: databses (MSSQL, MySQL,Postgres), CSV and XERO api. -''Why would I need a Micro Data Warehouses?'' Its a great way to prote...") Tag: Visual edit
• 11:47, 21 October 2022 WikiSysopdi talk contribs created page Update (Created page with "'''Syntax''' : update <ENTER> Description : Check and Download new version (if available).") Tag: Visual edit
• 11:47, 21 October 2022 WikiSysopdi talk contribs created page Version (Created page with "Syntax : version <ENTER> Description : Get the application version.") Tag: Visual edit
• 11:47, 21 October 2022 WikiSysopdi talk contribs created page Clear (Created page with "'''Syntax''' : clear <ENTER> Description : Clears the command prompt screen.") Tag: Visual edit
• 11:47, 21 October 2022 WikiSysopdi talk contribs created page Removeuser (Created page with "'''Syntax''' : removeuser <USERNAME> <ENTER> Description : Remove a user's access from current region.") Tag: Visual edit
• 11:46, 21 October 2022 WikiSysopdi talk contribs created page Adduser (Created page with "'''Syntax''' : adduser <USERNAME> <ACCESS SCOPE> <ENTER> Description : Add a user to allow access the current region. Premissions are controlled by passing access scope as "read" or "readwrite".") Tag: Visual edit
• 11:46, 21 October 2022 WikiSysopdi talk contribs created page Access (Created page with "'''Syntax''' : access <ENTER> Description : List of user list with their level of access (read or readwrite).") Tag: Visual edit
• 11:45, 21 October 2022 WikiSysopdi talk contribs created page Deleteisland (Created page with "'''Syntax''' : deleteisland <ISLANDNAME> <ENTER> Description : Deletes a given island.") Tag: Visual edit
• 11:45, 21 October 2022 WikiSysopdi talk contribs created page Clearisland (Created page with "'''Syntax''' : clearisland <ISLANDNAME> <ENTER> Description : Clear the given island data.") Tag: Visual edit
• 11:45, 21 October 2022 WikiSysopdi talk contribs created page Deleteregion (Created page with "'''Syntax''' : deleteregion <ENTER> Description : Deletes the current region. The will only work when then region has no data islands.") Tag: Visual edit
• 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