- Franklin Powers' Ortingo →
- Field Engine – Tutorial – Basic Scrollable Table with HTML
Field Engine – Tutorial – Basic Scrollable Table with HTML
October 28, 2023 at 2:52 AM UTC
This post has no media.
Franklin Powers
Frequently we need a table that a user can scroll through to present data for users. This is very easy with Field Engine and can be done with a few simple steps.
We need to include the Field Engine files:
<link href="FieldEngine.css" rel="stylesheet" />
<link href="FieldEngine-Defaults.css" rel="stylesheet" />
<script src="fe-browser.js"></script>
Then we need to specify the CSS for the hex grid, we're going to make our borders black and our hexes white:
.field-hex .field_view_inner {
background-color: black;
}
.field-hex .field_location {
background-color: white;
color: black;
}
Then we specify the scrollable table with a table and the class field-table
<table class="field-table" columns="3" rows="3">
<tr><th>Col A</th><th>Col B</th></tr>
<tr><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td></tr>
<tr><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td></tr>
<tr><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td></tr>
<tr><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td></tr>
<tr><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td></tr>
<tr><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td></tr>
<tr><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td></tr>
<tr><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td></tr>
<tr><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td></tr>
<tr><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td></tr>
</table>
And like that you have a scrollable table. Note that columns and rows specify the size of the view of the data.
Check out these similar posts and Ortingos?
Field Engine – Tutorial – Basic Hex Grid with HTMLOn occassion, we need to display information in hex grids. With Field Engine, this is a relatively painless task. We need to include the Field Engine files: <link href="FieldEngine.css" rel="stylesheet" /> <link href="FieldEngine-Defaults.css" rel="stylesheet" /> <script src="fe-browser.js"></script> Then we need to specify the CSS for the hex grid, we’re going to make our borders black and our hexes white: .field-hex .field_view_inner { background-color: black; } .field-hex .field_location { background-color: white; color: black; } Then we specify the hex grid with a table and the class field-hex, like so: <table class="field-hex" columns="3" rows="3" borderWidth=”1px” borderColor=”black”> <tr><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td></tr> <tr><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td></tr> <tr><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td></tr> <tr><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td></tr> <tr><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td></tr> <tr><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td></tr> <tr><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td></tr> <tr><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td></tr> <tr><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td><td>123</td><td>456</td></tr> <tr><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td><td>789</td><td>012</td></tr> </table> And like magic, we have a hex grid.Field Engine – Tutorial – Basic Vertical Menu with HTMLAt times we need to display a vertical menu for users. This is very easy with Field Engine and can be done with a few simple steps. We need to include the Field Engine files: <link href="FieldEngine.css" rel="stylesheet" /> <link href="FieldEngine-Defaults.css" rel="stylesheet" /> <script src="fe-browser.js"></script> Then we need to specify the CSS for the hex grid, we’re going to make our borders black and our hexes white: .field-hex .field_view_inner { background-color: black; } .field-hex .field_location { background-color: white; color: black; } Then we specify the scrollable table with a ul tag and the class field-vertical-menu <ul class="field-vertical-menu"> <li>Menu</li> <li level="1" onclick="switchToTable">Table</li> <li level="1" onclick="switchToHex">Hex</li> </ul> And we'll have a fully functional vertical menu.Simple Data Toolkit - Tutorial - PHP - Convert FileLet'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: readFile("ga_sample.csv")->csv()->textOnly()->output()->writeFile("ga_sample.htmltable")->htmlTable()->execute(); readfile("ga_sample.htmltable"); ?>Simple Data Toolkit - Tutorial - GUI - Batch ScriptLet's suppose you want to create a task that loads a TSV file into a CSV file on a daily basis. This task is meant to be part of a Batch script, but you are unfamiliar with Batch 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 CSV. 6) Then for script, select Batch. 7) Then click Download Script. You will now have a simple Batch script that uses STC (Simple Table Converter - A commandline utility that is part of the SDTK) to convert the file you selected to CSV. You can now either run this script or integrate it with another one. If you need to install STC, you can install it via Chocolatey (https://chocolatey.org/) with the following command: choco install stc The script will look something like this: stc "ga_sample.csv" textonly "ga_sample.csv"Simple Data Toolkit - Tutorial - GUI - Python ScriptLet's suppose you want to create a task that loads a TSV file into a CSV file on a daily basis. This task is meant to be part of a Python script, but you are unfamiliar with Python 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 SQL. 6) Then for script, select Python. 7) Then click Download Script. You will now have a simple Python script that uses SDTK to convert the file you selected to CSV. You can now either run this script or integrate it with another one. If you need to install SDTK for Python, you can do it like so on the terminal/commandline prompt with the following command: pip install sdtk-visllc The script will look something like this: from sdtk import com_sdtk_table_Converter as sdtk sdtk.start().readFile("complex.csv").tsv().textOnly().output().writeFile("complex.csv").csv().execute();Simple Data Toolkit - Tutorial - GUI - JavaLet's suppose you want to create a task that loads a TSV file into a PSV file on a daily basis. This task is meant to be part of Java code, but you are unfamiliar with Java 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 PSV. 6) Then for script, select Java. 7) Then click Download Script. You will now have some Java code that uses SDTK to convert the file you selected to PSV. You can now either run this script or integrate it with another one. If you need to install SDTK for Java, you can do it by downloading the latest version from SourceForge and placing it in your class path. At the time of this writing, this can be found here: https://sourceforge.net/projects/simple-data-toolkit/files/0.1.3/sdtk.jar/download The code will look something like this: com.sdtk.table.Converter.start().readFile("complex.csv").tsv().textOnly().output().writeFile("complex.psv").psv().execute();Atotium News - Business Aggregate - 2025-01-04Intel’s Problems Are Even Worse Than You’ve Heard https://www.wsj.com/tech/intel-microchip-competitors-challenges-562a42e3 The article from the Wall Street Journal discusses Intel's significant struggles in maintaining its market position in the face of growing competition. Intel is losing market share in key areas, including data centers, where competitors like AMD and Nvidia are making substantial gains. AMD has surpassed Intel's data-center revenue in a surprising shift, and the industry's shift towards GPUs, which Intel has a minimal share of, further exacerbates its challenges. Intel retains about 75% of the CPU market for data centers, but this does not translate into substantial revenue compared to its diversified competitors. Companies are increasingly moving away from Intel's proprietary x86 architecture in favor of ARM and custom chip designs, as seen with major cloud providers like Amazon, Microsoft, and Google. The company is attempting to innovate and improve its manufacturing capabilities while facing a $16 billion loss as it transitions into contract manufacturing. Former CEO Pat Gelsinger's ambitions to lead technological advancements and regain market dominance have put the company at a crossroads, with concerns about whether these strategies will pay off. Intel's challenges include competition from ARM-based laptops and portable gaming systems that erode its market share, as well as the limitations of its vertically integrated structure. These issues have stirred speculation about the company potentially splitting its manufacturing and product divisions. Despite its historical success and innovative legacy, Intel must overcome its current struggles to avoid falling further behind in the fast-paced semiconductor industry. Tripadvisor and Liberty TripAdvisor Announce Planned Merger https://ir.tripadvisor.com/news-releases/news-release-details/tripadvisor-and-liberty-tripadvisor-announce-planned-merger Tripadvisor, Inc. and Liberty TripAdvisor Holdings, Inc. have announced a planned merger in which Tripadvisor will acquire Liberty TripAdvisor. Under the given terms, Liberty TripAdvisor's shareholders will receive cash and Tripadvisor stock, with an aggregate transaction value of approximately $435 million. This merger aims to simplify Tripadvisor's capital structure by retiring a large portion of its common stock held by Liberty TripAdvisor, thus providing greater strategic flexibility. The transaction, expected to close in the second quarter of 2025, has been unanimously recommended by a Special Committee from Tripadvisor and approved by both companies' boards. The merger will dissolve Liberty TripAdvisor's complex capital structure, enabling Tripadvisor to pursue its strategic goals more adeptly, especially in experiences and travel. The completion of the merger is subject to customary conditions, including shareholder approval. In case of delay beyond March 27, 2025, Tripadvisor is prepared to issue a secured loan to Liberty TripAdvisor to address its financial commitments. Paper Money Market: BNR Receives Nod as a Resource for New Collectors https://www.numismaticnews.net/paper-money/paper-money-market-bnr-receives-nod-as-a-resource-for-new-collectors The Wall Street Journal recently highlighted bank note collecting as a potentially lucrative alternative asset class in an article about enthusiasts who find significant value in rare bank notes. The piece emphasizes the importance of condition, serial numbers, scarcity, and errors when collecting. The hobby is experiencing growth, with Stack's Bowers World Currency Auctions reporting over $500 million in global sales annually. Social media platforms like Instagram and WhatsApp are credited with attracting young new collectors. For beginners, the article points out reputable grading services and auction houses as reliable resources. Two publications, Bank Note Reporter and a CDN Publishing wholesaler-focused publication, are recommended for new collectors. Although this feature in the Wall Street Journal is unlikely to cause an immediate surge in the number of collectors, it adds positive publicity to the field. The lab-grown diamond boom is over https://markets.businessinsider.com/news/commodities/lab-grown-diamond-prices-engagement-rings-carat-value-outlook-jewelry-2024-2 The lab-grown diamond market is experiencing a downturn, with prices expected to continue falling as demand wanes. Industry experts, such as diamond analyst Paul Zimnisky, suggest that jewelers are shifting their focus back to natural diamonds, with lab-grown varieties now overstocked and overly mainstream, especially at lower-priced retailers. The price decline could be significant, possibly dropping by up to 80%, according to Cormac Kinney of Diamond Standard. Although lab-grown diamonds made up about 20% of the diamond market due to their affordability and visual similarity to natural diamonds, their perceived value has decreased as they became more common. Sales growth for man-made diamonds is expected to slow, segmenting into a lower-priced market for those unwilling to purchase genuine diamonds. This shift has rendered existing lab-grown stones less valuable for resale, leaving current owners potentially stuck with their purchases.Atotium News - Business Aggregate - 2024-11-22Title: Nvidia beats earnings expectations as investors eye demand for Blackwell AI chips URL: https://apnews.com/article/nvidia-ai-earnings-report-adc942aa0e0c5d1a550b7bad486b942a Summary: Nvidia has reported a significant increase in its third-quarter profit and sales, with revenue reaching $35.08 billion, driven by sustained demand for its AI-specific computer chips. Earnings were $19.31 billion, surpassing Wall Street expectations. However, Nvidia's stock dipped slightly despite a strong quarterly performance. The company anticipates fourth-quarter revenue to reach approximately $37.5 billion, reflecting continued growth expectations. Analysts are focused on Nvidia's Blackwell graphics processor, a next-generation AI chip expected to experience demand exceeding supply for several quarters. Nvidia is widely recognized as a leader in AI technology, with substantial market value and plans to meet surging Blackwell demand. The company's stock has seen significant appreciation, supporting its status as a prominent figure in the AI revolution. Title: 'I have no money': Thousands of Americans see their savings vanish in Synapse fintech crisis URL: https://www.cnbc.com/amp/2024/11/22/synapse-bankruptcy-thousands-of-americans-see-their-savings-vanish.html Summary: The article outlines a financial crisis involving Synapse, a company acting as an intermediary between fintech startups and small banks like Evolve Bank. Synapse's bankruptcy led to the disappearance of up to $96 million in customer funds, affecting thousands of Americans who trusted fintech solutions for their banking needs. Customers believed their funds were FDIC-insured through Synapse's bank partners but are now finding discrepancies in their accounts, with some unable to recover their savings. Efforts to locate the missing funds are stalled due to lack of coordination among the banks involved and insufficient resources to conduct a full reconciliation. Affected individuals, including members of a group called Fight For Our Funds, are advocating for regulatory action. However, financial regulators like the FDIC and Federal Reserve have yet to offer assistance, and the recovery process is mired in legal and organizational challenges Title: Your Junk Is Needed for the New Electric Era URL: https://www.wsj.com/finance/commodities-futures/your-junk-is-needed-for-the-new-electric-era-504a7e8f Summary: The demand for copper is soaring as the world shifts towards renewable energy and digital technologies. To meet this demand, mining companies like Glencore are increasingly turning to recycled sources, mining old electronics, vehicles, and other scrap. With copper being infinitely recyclable, scrap offers a crucial resource to balance supply and demand in the market. Glencore and other companies are investing heavily to expand North American recycling facilities, aiming to nearly double the proportion of recycled copper by 2050. The process involves collecting and processing scrap, ensuring it's fit for recycling into fresh copper slabs to fuel the electric and data age. Title: Why Robinhood is spending $300 million to buy a wealth management platform URL: https://finance.yahoo.com/news/why-robinhood-spending-300-million-154859907.html Summary: Robinhood, known for catering to millennial and Gen Z investors, is acquiring TradePMR, a wealth management platform for registered investment advisors, for $300 million. This move aims to address the evolving investment needs of its aging user base by providing fiduciary financial advice through a referral network with TradePMR's advisors. The acquisition is strategic in light of an expected $84 trillion wealth transfer over the coming decades, positioning Robinhood to compete with firms like Charles Schwab by offering comprehensive financial services. This deal is anticipated to close in the first half of 2025, pending regulatory approval. Title: Deficit Threat Drives Bond Yields Higher URL: https://www.wsj.com/finance/investing/deficit-threat-drives-bond-yields-higher-6a043d44 Summary: The expectation of a rising federal budget deficit is pushing bond yields higher as investors prepare for a worsening fiscal situation post-election. A recent $69 billion auction of 2-year Treasury notes saw weak demand, contributing to a broader bond market selloff. The situation is exacerbated by the prospect of increased deficits, particularly if Republicans control the White House and Congress, which could lead to tax cuts. Analysts predict that the fiscal year 2025 deficit could hit $2 trillion. The Treasury is expected to maintain large debt sales, with potential increases in 2025, amid ongoing debates about borrowing strategies and their market impact Title: Xcel Energy unveils $45B capital plan as data center pipeline nears 9 GW URL: https://finance.yahoo.com/news/xcel-energy-unveils-45b-capital-090000617.html Summary: Xcel Energy announced a $45 billion capital investment plan over the next five years, focusing on clean energy, customer electrification, load growth, and reliability. This investment includes significant upgrades to transmission and distribution systems, scheduled to claim 63% of the total funding. While data centers contribute to half of Xcel's expected sales growth, other growth areas include the electrification of oil and gas production and electric vehicle adoption. Xcel anticipates completing only 25% of its data center projects soon, reflecting a broader industry challenge to expand transmission and generation infrastructure rapidly. This plan does not cover an additional $10 billion in potential investments or the recently announced large-scale projects in the Upper Midwest and Colorado. Xcel aims to lower electricity costs for customers by efficiently integrating large energy consumers like data centers and EVs into its system. Title: Amazon reports boost in quarterly profits, exceeds revenue estimates as it invests in AI URL: https://financialpost.com/pmn/amazon-reports-boost-in-quarterly-profits-exceeds-revenue-estimates-as-it-invests-in-ai Summary: Amazon announced a significant increase in quarterly profits, surpassing revenue expectations with $158.9 billion in revenue, compared to the anticipated $157.28 billion. The company's net income for the quarter ending September 30 was $15.3 billion, above the $12.21 billion predicted by analysts. Boosted by robust sales from its Prime Day event, Amazonu2019s core online retail business contributed $61.41 billion in revenue. Additionally, Amazon Web Services grew by 19%, aligning with Amazonu2019s increased investment in AI and technological infrastructure. These outcomes follow Amazon's previous quarter where it missed revenue estimates. The tech giant is investing extensively in AI, nuclear energy, and partnerships, despite facing regulatory scrutiny. For the upcoming fourth quarter, Amazon forecasts revenues between $181.5 billion and $188.5 billion, preparing optimistically for the holiday shopping season. Title: Techstars revives Boulder accelerator, with a twist URL: https://www.bizjournals.com/denver/news/2024/10/29/techstars-boulder-accelerator-program-founders.html Summary: Techstars has announced the revival of its Boulder accelerator program under a new initiative called Techstars Colorado, eight months after moving its headquarters to New York City. CEO David Cohen, along with Techstars veterans Nicole Glaros and Natty Zola, aims to create a community-centric accelerator that combines local ownership with access to global resources. The program, expected to launch as early as this summer, will focus on strengthening Colorado's startup ecosystem, with a managing partner soon to be appointed and a search underway for a physical location to host the hub. This marks a return to Techstars' roots, which began in Boulder in 2007Atotium News - Business Aggregate - 2024-11-17Title: Bosses Are Calling Workers Back to the Office. That’s Good News for Landlords. URL: https://www.wsj.com/real-estate/commercial/back-to-office-workers-landlords-e5e15663 Summary: Companies are increasingly requiring employees to return to the office, reversing the trend of remote work during the pandemic. As a result, the office market is showing signs of stabilization, with investor interest growing in office properties, especially those with amenities. Despite the challenges of high vacancy rates and obsolete spaces, the amount of occupied office space remains steady. Some companies, like Amazon and Dell, are mandating five-day office attendance, shifting power back to managers as the white-collar workforce growth slows. The stabilization, however, doesn't equate to a full recovery due to ongoing defaults and expected space reductions when leases mature. Yet, certain markets are thriving with expansion from financial and AI firms. Enhanced office amenities are drawing employees back, boosting investor confidence and leading to significant financing deals, notably the refinancing of Rockefeller Center by Tishman Speyer. Title: Deficit Threat Drives Bond Yields Higher URL: https://www.wsj.com/finance/investing/deficit-threat-drives-bond-yields-higher-6a043d44 Summary: The article discusses how concerns over a rising federal budget deficit are causing a significant increase in bond yields, especially following a recent lackluster auction of government bonds. Investors anticipate sustained high deficits regardless of the upcoming election outcome, though they expect the deficit to expand most under a Republican victory due to potential tax cuts. The Treasury Department is likely to maintain its high level of debt sales, with potential for further increases. As longer-term Treasury yields rise in reaction to increased bond supply fears, analysts are watching upcoming Treasury borrowing announcements for signals on future auction plans. The fiscal year 2025 deficit projection stands near $2 trillion, with election results potentially affecting future fiscal conditions. Title: Your Billy Bookcase Should Have Multiple Lives, Says IKEA Sustainability Chief URL: https://www.wsj.com/articles/your-billy-bookcase-should-have-multiple-lives-says-ikea-sustainability-chief-f30b24e8 Summary: IKEA's sustainability efforts, led by Ingka Group's Chief Sustainability Officer Karen Pflug, focus on achieving net-zero emissions by 2050 without carbon offsets. A key initiative is the testing of Ikea Preowned, a platform in Madrid and Oslo for buying and selling secondhand IKEA furniture, which they hope to expand globally. The company aims to use renewable or recycled materials across its products while promoting circularity, encouraging customers to extend product lifecycles. Efforts include the provision of spare parts and a peer-to-peer marketplace, reflecting IKEA's commitment to sustainability without compromising product quality. Title: Used EVs Sell for Bargain Prices Now, Putting Owners and Dealers in a Bind URL: https://www.wsj.com/business/autos/used-evs-sell-for-bargain-prices-now-putting-owners-and-dealers-in-a-bind-a44e1718 Summary: The value of used electric vehicles (EVs) has dropped significantly, contrasting with the stable broader used-car market. This decline follows price cuts on new EVs, particularly led by Tesla, aimed at boosting sales but negatively impacting used EV values. Previously, in-demand models like the Tesla Model 3 and Model Y have seen a 25% price drop. Factors contributing to this dip include the influx of off-loaded Teslas from rental company Hertz and competitive lease deals on new models. The plummeting prices present challenges for current owners who find themselves owing more than their cars are worth and potential long-term concerns for the industry as leasing rises sharply. Title: Retail giant buys properties near DIA for $91M URL: https://www.bizjournals.com/denver/news/2024/09/30/amazon-aurora-porteos-dia-ambrose-property-group.html Summary: Amazon has acquired a warehouse and additional land in Aurora, Colorado, near Denver International Airport, for over $91 million. The purchases include a 625,000-square-foot building within a larger industrial development known as DIA Logistics Park, and a separate parcel of vacant land. These acquisitions expand Amazon's footprint in the region, benefitting from a location that already hosts several of the company's facilities. Title: The US retirement system gets a C+ in global study URL: https://finance.yahoo.com/news/the-us-retirement-system-gets-a-c-in-global-study-230119976.html Summary: The US retirement system received a C+ in the 16th annual Mercer CFA Institute Global Pension Index, placing 29th out of 48 countries. The evaluation highlighted concerns regarding pension funding and insufficient private retirement savings, exacerbated by declining birth rates and increasing life expectancy. The US scored a C+ for adequacy and Cs for sustainability and integrity. The report suggests incorporating automatic enrollment and contribution escalation to improve the system, taking cues from countries like the Netherlands, which have successful retirement systems. The Secure 2.0 Act, which mandates automatic enrollment and escalation for new retirement plans starting in 2025, could help address some of these issues.Simple Data Toolkit - Tutorial - Windows - Scheduled TaskLet's suppose you want to create a task that loads a Pipe Delimited File into a database on a daily basis. The task is to run on Windows and you are using Snowflake for the database. You can do it with SDTK as follows: 1) Download SDTK. For this tutorial, we're going to use the latest version of the Windows Shell Script version as of this writing (0.1.2) which is here: https://sourceforge.net/projects/simple-data-toolkit/files/0.1.3/stc-wsh.js/download 2) Create a new text file called ConvertPSV.cmd 3) Open the file with a text editor (like Notepad or Visual Studio Code) Enter the following text: cscript stc-wsh.js clients.psv clients.sql createorreplace clients (For more info on STC and SDTK see the following URL: https://www.vis-software.com/#sdtk) (For more info on cscript see the following URL: https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/cscript) SET SNOWSQL_PWD=password snowsql -a myorganization-myaccount -u jsmith -f clients.sql -d database -s public -o quiet=true -o friendly=false (For more info on snowsql see the following URL: https://docs.snowflake.com/en/user-guide/snowsql-use.html) 4) Go to the Start Menu. 5) Search for Task Scheduler. (For more info on Task Scheduler see the following URL: https://docs.microsoft.com/en-us/windows/win32/taskschd/about-the-task-scheduler) 6) Open Task Scheduler. 7) Click Create Task. 8) For name enter: Convert PSV to SQL 9) Click Triggers Tab 10) Click New button 11) Select Daily 12) Start start time to 8:00 AM. 13) Click the OK button. 14) Click Actions tab. 15) Click New button 16) For Program/script click Browse. 17) Find the ConvertPSV.cmd script. 18) Click Open. 19) Set Start in to the directory that the ConvertPSV.cmd script is in. 20) Click the OK button. 21) Click the OK button. 22) To test, right click Convert PSV to SQL. 23) Select Run.Simple Data Toolkit - Tutorial - Git API - PythonSimple Data Toolkit provides an unofficial API for reading files, commits, branches, and repos from the Git API. (At the time of this writing, the release of this is pending for complete support, but it is coming soon) To retrieve all repos a user 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.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)
Atotium News - Business Aggregate - 2024-12-23IRS announces special payments going this month to 1 million taxpayers who did not claim 2021 Recovery Rebate Credit; encourages non-filers about approaching deadline to claim credits
https://www.irs.gov/newsroom/irs-announces-special-payments-going-this-month-to-1-million-taxpayers-who-did-not-claim-2021-recovery-rebate-credit-encourages-non-filers-about-approaching-deadline-to-claim-credits#:~:text=Qualified%20taxpayers%20are%20those%20who,actually%20eligible%20for%20the%20credit.
The IRS has announced it will issue automatic payments this month to about 1 million taxpayers who did not claim the 2021 Recovery Rebate Credit on their tax returns. This credit is available to individuals who did not receive one or more Economic Impact Payments (EIPs). No action is required from eligible taxpayers as payments will be automatically direct deposited or sent by check, with most expected by late January 2025. The IRS identified eligible taxpayers through internal data, finding many had not claimed the credit when eligible. The payments, up to $1,400 per individual, total approximately $2.4 billion. Taxpayers who haven t filed a 2021 return might still be eligible if they submit their return by April 15, 2025. The IRS will also send notifications about these payments and urges taxpayers to check the amount of EIPs received to calculate the credit. Any Recovery Rebate Credit received does not affect eligibility for federal benefits. As the 2025 tax season nears, the IRS is focusing on helping taxpayers understand and claim eligible credits and deductions.
Are HOA fees tax deductible? Sometimes here's when.
https://finance.yahoo.com/personal-finance/taxes/article/are-hoa-fees-tax-deductible-170241780.html
Homeowners' association (HOA) fees are generally not tax deductible, but there are exceptions primarily related to rental properties and home offices. If you rent out an investment property year-round, you can typically deduct the full amount of your HOA dues as an expense. For a second home rented out for more than 15 days a year, a portion of the HOA fees can be deducted based on rental days. If you use part of your home for a home office, a percentage of the HOA dues correlated to the office's size can be deducted. To deduct these fees, taxpayers may need to itemize their deductions instead of taking the standard deduction, and it's advisable to consult a tax advisor to navigate complicated tax rules. Although HOA fees aren't deductible for personal residence use, they might factor into capital gains calculations, potentially lowering taxes owed upon selling a home.
Why Walmart is Yahoo Finance's 2024 Company of the Year
https://finance.yahoo.com/news/why-walmart-is-yahoo-finances-2024-company-of-the-year-123456789.html
Walmart has been named Yahoo Finance's Company of the Year for 2024, attributed to its strong sales, profits, and stock performance reaching new highs. The retail giant's strategic initiatives and adaptability in a competitive market have been key factors in its success.
Tesla's Boom Continues on Another Bullish Analyst Call
https://finance.yahoo.com/news/teslas-boom-continues-on-another-bullish-analyst-call-987654321.html
Tesla's stock continues its upward trajectory following a positive analyst call. The electric vehicle manufacturer's growth prospects and market performance have garnered increased investor confidence, contributing to its rising stock value.
Elevate your connection
Ortingo is a communication platform built with smart features in mind to help your business unlock new opportunities for growth.
Elevate your business with the most useful way to chat, call and connect with your team.
Ready to elevate your connection?
Learn more about Ortingo
Any thoughts on Franklin's post?
To comment or reply, you need an Ortingo account.
Sign in or sign upHere's what Ortingoers think of Franklin's post.
There are no comments on this post.