hi boss, 7 days lah… http://7dayslah.com/index.html build simple application in 7 days... Mon, 10 May 2021 10:52:20 +0000 en-US hourly 1 SitePad Retrieve Dynamic Web Data http://7dayslah.com/blog/retrieve-dynamic-web-data.html http://7dayslah.com/blog/retrieve-dynamic-web-data/#respond Mon, 10 May 2021 09:31:34 +0000 http://7dayslah.com/blog/retrieve-dynamic-web-data.html

Retrieve bank exchange rate in certain time daily, choose the currency needed and capture the latest rate, send the rate via email. Whole process using Microsoft Azure – Function App with python.

DBS Exchange Rate
Email Notification
]]> http://7dayslah.com/blog/retrieve-dynamic-web-data/feed/ 0 Crawl Data From Website http://7dayslah.com/blog/crawl-data-from-website.html http://7dayslah.com/blog/crawl-data-from-website/#respond Fri, 26 Mar 2021 02:48:37 +0000 http://7dayslah.com/blog/crawl-data-from-website.html

Crawl 4D and Toto history result from website using Python, Microsoft Azure, PHP and MySQL. Hosting on Microsoft Azure Serverless – Function Apps, estimate $5 per month.

Python to crawl information from website, Microsoft Azure to host Python script as serverless platform, setup LogicApps as scheduler, and setup PHP portal to display result.

 

Results Portal
Python
Azure
FunctionApps
]]> http://7dayslah.com/blog/crawl-data-from-website/feed/ 0 Simple API with Azure Logic App http://7dayslah.com/blog/simple-api-with-azure-logic-app.html http://7dayslah.com/blog/simple-api-with-azure-logic-app/#respond Wed, 17 Jun 2020 06:24:09 +0000 http://7dayslah.com/blog/simple-api-with-azure-logic-app.html

Develop an easy API solution to retrieve or write data in on-prem Microsoft SQL Server. The data can be from EDI or from HTTP, both able to configure in Microsoft Azure Logic App. Using HTTP POST to write data, and using HTTP GET to retrieve data from SQL Server. Those using EDI, can be “massaged” to the format needed and pump in to SQL Server.

Whole project needs 1 week. Easy to manage, low cost and error free…

Azure Logic App
]]> http://7dayslah.com/blog/simple-api-with-azure-logic-app/feed/ 0 Retrieve Orders from Multiple eCommerce Platform http://7dayslah.com/blog/order-from-multiple-ecom.html http://7dayslah.com/blog/order-from-multiple-ecom/#respond Tue, 26 May 2020 05:14:24 +0000 http://7dayslah.com/blog/order-from-multiple-ecom.html

Retrieve Orders from Multiple eCommerce Platform

I have developed a platform to retrieve orders from several eCommerce platform, such as Shopee, Presto Mall, Lazada, Shopify, etc. System will be able to retrieve the orders from each platform and consolidate all in a single file.

Depend how many platform you have, $250 per platform. There is a monthly running cost on cloud act as always-on server to retrieve data from all platforms. The cost is depend the usage, estimate $25 USD per month.

 

]]> http://7dayslah.com/blog/order-from-multiple-ecom/feed/ 0 PDF to Excel File http://7dayslah.com/blog/pdf-to-excel-file.html http://7dayslah.com/blog/pdf-to-excel-file/#respond Sat, 23 May 2020 03:16:03 +0000 http://7dayslah.com/blog/pdf-to-excel-file.html

Upload PDF to FTP Server and Convert to Excel.

I have setup a FTP server for a customer to capture the DO in PDF format from customer, and convert the PDF to excel, then consolidate to a single excel sheet.

Whole Development only about 3 days, cost is S$ 300.

 

Deliver Order in PDF Format
Convert PDF to Excel File
Consolidate all excel to a single excel sheet
]]> http://7dayslah.com/blog/pdf-to-excel-file/feed/ 0 Default Blog Post http://7dayslah.com/blog/default-post.html http://7dayslah.com/blog/default-post/#respond Sat, 31 Aug 2019 09:03:30 +0000 http://7dayslah.com/blog/2019/08/31/default-post/

31st AUG 2019 is the first day…

]]> http://7dayslah.com/blog/default-post/feed/ 0