Introducing Firefly Semantics CSV

Image for post
Image for post

Firefly Semantics CSV or FS CSV is a tool for:

  • Checking CSV Files for Parser Errors

Demo

Login in and try it out.

Detecting Parser Errors

This file has fields without corresponding headers.

LOCATION, SKU  
Chicago, FS1
Boston, FS2, 42, 42

When loaded it will generate the error seen in the screenshot:

Image for post
Image for post
Parser Errors

Defined Key Values Check

In this file a valid SKU value is missing from the row containing Philadelphia as the city.

LOCATION,    SKU
Chicago, FS1
Boston, FS2
Philadelphia,

We want to detect this so we load the file, check off SKU as a column that has key values. Then click PROCESS . This is the result:

Image for post
Image for post
Undefined Key Values

Duplicate Key Value Check

This file as row duplicates.

LOCATION, SKU
Chicago, FS1
Boston, FS2
Chicago, FS1
Boston, FS2

We load it and check off LOCATION and SKU as key values. Hit PROCESS and this is the result:

Image for post
Image for post

The result shows which rows are duplicates according to the key values selected.

Data Assembly

We have the following files:

CSV1.csv

LOCATION, SKU, FORECAST
Chicago, FS1, 2
Boston, FS2, 3

CSV2.csv

LOCATION, SKU, STOCK
Chicago, FS1, 10
Boston, FS2, 10

We want to combine them so we end up with this:

LOCATION, SKU, FORECAST, STOCK
Chicago, FS1, 2, 10
Boston, FS2, 3, 10

So we load both files and select LOCATION and SKU as keys and we also select the headers we want in the result.

Image for post
Image for post

If you made it this far thanks for reading up and staying with us! We hope you will try our app and we hope you love using it as much as we liked creating it.

Brought to You By Firefly Semantics

Written by

Founder of Firefly Semantics Corporation

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store