www.exmerg.comhttps://exmerg.com
EXMERG - Excellent Sheet Merging ToolTue, 13 Nov 2018 09:14:23 +0000en-UShourly1https://wordpress.org/?v=4.8.9Technologies, Frameworks and Librarieshttps://exmerg.com/technologies-frameworks-libraries/
https://exmerg.com/technologies-frameworks-libraries/#respondWed, 11 Mar 2015 22:32:13 +0000http://18.220.176.218/?p=476Building SaaS has never been easier than these days, at least from the technology point of view. It should be simple – just pick your favorite tools and libraries and start building something, right? Well, maybe not so straight forward. But no worries, you will hardly end up with perfect set of tools and libraries anyway. Because it probably doesn’t exist.

Let me highlight some of the tools and libraries which are part of our ‘almost perfect’ technology set at Exmerg.

Browser-side

Though often criticized as monolithic framework, for a lot of use cases there simply isn’t better choice then ExtJS. If you intend to provide desktop like user experience, visualize big datasets or organize UI into specific layouts, I suggest you take a look at ExtJS. Read how you can automatize your workflow with Sencha CMD, the CLI for manipulating and building ExtJS applications.

“User interface is like a joke. If you need to explain it, it’s not that good.”

Yes, no one likes to read through documentation to understand how a tool or service works. Ideally, the UI should be self-guiding with no need of additional information on how to use it. Back to reality… In case you want to provide user with helpful instructions about how to perform certain actions, intro.js could be what you are looking for. It provides a way to embed interactive help into your UI, highlight DOM elements and explain more complex features of your app step-by-step.

Server-side

Although widely considered to be an enterprise oriented technology (Java Enterprise Edition), using Java and it’s enterprise edition can help you with the heavy-lifting part of your SaaS – be it a transactional business logic or rigorous service oriented architecture. Java EE 7 is much more developer friendly as it’s predecessors (especially the famously infamous 1.4 and older versions), while at the same time provides sound base for your business logic implementation. Anyway, it’s not one size fits all, and Java EE may be overkill for many SaaS which are happy to use Django or Rails.

Again a technology heavily used in enterprise, Wildfly is the result of many years of JBoss Application Server development and open source community contributions. The main reasons to use Wilfdfly are speed, robustness, easy configuration management, and importantly for SaaS, literally 1-click deployment to the cloud with Openshift Online. This article is too short to provide even short Wildfly insight, but if you are looking for reliable Java EE server, Wildfly should be on your checklist.

Great example of long term open source community effort, Apache POI is the bridge between Java and MS Office worlds. Apache POI is the key technology behind Exmerg since it enables processing of XLS and XLSX documents. If you plan to deal with MS Office documents in your SaaS, Apache POI can make your life much easier!

Storage

Reliable relational database which can power anything from WordPress website to Youtube. When it comes to databases, the offer has become quite exotic in the last few years. The rule of thumb still is that if using non-relational DB does not provide you with obvious benefits compared to relational DB, it may be a good idea to start with SQL and see along the way if you need different type of database (document, json, graph, …).

If you need reliable, scalable and simple to use file storage in cloud, join the S3 club (it is already full of SaaS companies). Either using it as your primary storage or as a backup solution, you’ll feel quite a relief for handing the storage scaling problem over to Amazon.

Do you have experience with some of the mentioned technologies? Leave us a comment!

We have decided to load collected data into EXMERG and now we would like to share them with you!

Notes

Key to results data

ATP = Tournament number (men)
WTA = Tournament number (women)
Location = Venue of tournament
Tournament = Name of tounament (including sponsor if relevant)
Data = Date of match (note: prior to 2003 the date shown for all matches played in a single tournament is the start date)
Series = Name of ATP tennis series (Grand Slam, Masters, International or International Gold)
Tier = Tier (tournament ranking) of WTA tennis series.
Court = Type of court (outdoors or indoors)
Surface = Type of surface (clay, hard, carpet or grass)
Round = Round of match
Best of = Maximum number of sets playable in match
Winner = Match winner
Loser = Match loser
WRank = ATP Entry ranking of the match winner as of the start of the tournament
LRank = ATP Entry ranking of the match loser as of the start of the tournament
WPts = ATP Entry points of the match winner as of the start of the tournament
LPts = ATP Entry points of the match loser as of the start of the tournament
W1 = Number of games won in 1st set by match winner
L1 = Number of games won in 1st set by match loser
W2 = Number of games won in 2nd set by match winner
L2 = Number of games won in 2nd set by match loser
W3 = Number of games won in 3rd set by match winner
L3 = Number of games won in 3rd set by match loser
W4 = Number of games won in 4th set by match winner
L4 = Number of games won in 4th set by match loser
W5 = Number of games won in 5th set by match winner
L5 = Number of games won in 5th set by match loser
Wsets = Number of sets won by match winner
Lsets = Number of sets won by match loser
Comment = Comment on the match (Completed, won through retirement of loser, or via Walkover)

– you can turn paging feature on/off based on what suits the purpose better

Performance improvement

– we also included couple of perfomance fixes which you can experience with bigger datasets

We are certain that the new features will boost your productivity.

Happy data exploring from the EXMERG team!

]]>https://exmerg.com/exmerg-2-0-announcement/feed/0EXMERG: New version releasedhttps://exmerg.com/new-version/
https://exmerg.com/new-version/#respondTue, 06 May 2014 12:20:58 +0000http://18.220.176.218/?p=147What’s new in the latest version of EXMERG?

Following are the most important improvements:

New storage system

Support for CSV files

Improved security

Performance improvement

New storage system

We rely on Amazon S3 as main document storage system for our users. This helps us improve security and availability of EXMERG service as well as enabling us to scale the application independently of the storage system.

Support for CSV files

We are glad to add support for CSV files which are being produced by many business applications.

Improved security

From now on the domain app.exmerg.com uses 128-bit encryption, which limits the probability of transferred files being read by 3rd party down to 0.

Problem #2: Compare Data from Two Sheets and Extra the matching data with all the columns

1. Drag&Drop your Excel files into browser2. Choose from menu Merging tables -> Add Drag & Drop merging table3. Drag&Drop “ID” column from Sheet2 into the rules area (left side of the rule)4. Next Drag&Drop “ID” column from Sheet1 into the right side of the rule5. Export matched rows into XLSX/XLS

Columns from both sheets will be included in the export.

Problem #3: Find like numbers over two spreadsheets and highlight

1. Drag&Drop your Excel files into browser2. Choose from menu Merging tables -> Add Drag & Drop merging table3. Drag&Drop “column E” from Spreadsheet 1 into the rules area (left side of the rule)4. Next Drag&Drop “Column A” from Spreadsheet 2 into the right side of the rule5. Export matched rows into XLSX/XLS

Resulting spreadsheet will have 6+9 columns, and will contain row for each match between Column E of Spreadsheet 1 and Column A Spreadsheet 2.