Simple Data Toolkit - Tutorial - PHP - Convert File

September 03, 2023 at 2:55 PM PST

This post has no media.

Let's suppose you want to create a task that loads a CSV file into an HTML file on a daily basis. This task is meant to be part of a PHP script, but you are unfamiliar with PHP and are unsure of how to write the code. Good news, you can use the Sample Data Toolkit UI to figure out this code for you as follows:

1) Go to the app page for the Simple Data Toolkit UI, at the time of this writing it is here: https://www.vis-software.com/#sdtk

2) Click Choose Files.

3) Find the file you want to convert.

4) Click Open.

5) Select the output type you want, for this tutorial we will select HTMLTable.

6) Then for script, select PHP.

7) Then click Download Script.

You will now have a PHP script that uses SDTK to convert the file you selected to an HTML. You can now either run this script or integrate it with another one.

If you need to install SDTK for PHP, you can do it by downloading the latest version from SourceForge, unzipping it, and placing it in your include path. At the time of this writing, this can be found here: https://sourceforge.net/projects/simple-data-toolkit/files/0.1.3/sdtk-php.zip/download

The script will look something like this:

use comsdtktableConverter;

set_include_path(get_include_path().PATH_SEPARATOR.__DIR__.'/lib');
spl_autoload_register(
function() {
= stream_resolve_include_path(str_replace('\\', '/', ) .'.php');
if () {
include_once ;
}
}
);
phpBoot::__hx__init();

Converter::start()->readFile("ga_sample.csv")->csv()->textOnly()->output()->writeFile("ga_sample.htmltable")->htmlTable()->execute();

readfile("ga_sample.htmltable");
?>

Any thoughts on Franklin's post?

To comment or reply, you need an Ortingo account.

Here's what Ortingoers think of Franklin's post.

There are no comments on this post.

Check out these similar posts and Ortingos?

	from sdtk import com_sdtk_api_GitAPI

	def printer(data, reader):
	    print(reader.toArrayOfNativeMaps(None))

	com_sdtk_api_GitAPI.reposAPI().retrieveData({"owner": "Vis-LLC"}, printer)

To retrieve all branches a repo has using Simple Data Toolkit, we can do the following:

	from sdtk import com_sdtk_api_GitAPI

	def printer(data, reader):
	    print(reader.toArrayOfNativeMaps(None))

	com_sdtk_api_GitAPI.branchesAPI().retrieveData({"owner": "Vis-LLC", "repo": "Simple-Data-Toolkit"}, printer)

To retrieve all the files in a branch using Simple Data Toolkit, we can do the following:

	from sdtk import com_sdtk_api_GitAPI

	def printer(data, reader):
	    print(reader.toArrayOfNativeMaps(None))

	com_sdtk_api_GitAPI.filesAPI().retrieveData({"owner": "Vis-LLC", "repo": "Simple-Data-Toolkit", "branch": "main"}, printer)

To retrieve the data in a file using Simple Data Toolkit, we can do the following:

	from sdtk import com_sdtk_api_GitAPI

	def printerData(data, reader):
	    print(data)

	com_sdtk_api_GitAPI.retrieveAPI().retrieveData({"owner": "Vis-LLC", "repo": "Simple-Data-Toolkit-UI", "branch": "main", "path": "index.html"}, printerData)

We can also login using a personal access token (https://docs.github.com/en/authentication/keeping-your-account-and-data-secure/managing-your-personal-access-tokens)

	from sdtk import com_sdtk_api_GitAPI

	def printerData(data, reader):
	    print(data)

	com_sdtk_api_GitAPI.instance().setKey("Personal Access Token Here").retrieveAPI().retrieveData({"owner": "Vis-LLC", "repo": "Simple-Data-Toolkit-UI", "branch": "main", "path": "index.html"}, printerData)

from sdtk import com_sdtk_api_IEEEAPI,com_sdtk_calendar_IEEEEventFormat

def printer(data, reader):
    ieee = com_sdtk_calendar_IEEEEventFormat.instance
    for event in reader.toArrayOfNativeMaps(None):
        ci = ieee.read(event)
        print(ci.summary)


com_sdtk_api_IEEEAPI.eventsAPI().retrieveData({"limit": "2"}, printer)

We can search using the following parameters: - limit - The limit to the number of events to return - start - The start datetime to search - end - The end datetime to search The columns supported at the time of this writing are: - created-at mapped to created - start-time mapped to start - end-time mapped to end - title mapped to summary - uid mapped to uid Simple Data Toolkit - Tutorial - Ethereum via Etherscan - PythonSimple Data Toolkit provides an unofficial API for reading Ethereum transactions from the Etherscan API. (At the time of this writing, the release of this is pending for complete support, but it is coming soon) To retrieve all Ethereum transactions for a particular address we can do the following:

from sdtk import com_sdtk_api_EtherscanAPI

def printer(data, reader):
    print(reader.toArrayOfNativeMaps(None))

com_sdtk_api_EtherscanAPI.transactionsAPI().retrieveData({"address": "0xAddress"}, printer)

Replace 0xAddress with the address you wish to search on. Additionally, we can convert the transactions to our standard internal event interface like so:

from sdtk import com_sdtk_api_EtherscanAPI,com_sdtk_calendar_EtherscanFormat

def printerEvents(data, reader):
    etherScan = com_sdtk_calendar_EtherscanFormat.instance()
    for event in reader.toArrayOfNativeMaps(None):
        ci = etherScan.read(event)
        print(ci.start.toString())

com_sdtk_api_EtherscanAPI.transactionsAPI().retrieveData({"address": "0xAddress"}, printerEvents)

Replace 0xAddress with the address you wish to search on.

Simple Data Toolkit - Tutorial - PHP - Convert File

September 03, 2023 at 2:55 PM PST

This post has no media.

Any thoughts on Franklin's post?

Here's what Ortingoers think of Franklin's post.

Check out these similar posts and Ortingos?

Made with ❤️ + 💻 + ☕️ in Silicon Valley

© 2024 Ortingo

Report Abuse

Privacy Policy

User Agreement

API (Unofficial)

For Investors