jampoole

If I can make one person smile today that's an A+ in my book:) Appreciate your testing and feedback!

Hi HN, This is an ongoing pet project of mine. Been working on data manipulation stuff for more than a decade and originally built this entirely written in bash for the terminal exclusively.

Early product vision was for handling merging and organizing csv files quickly and easily.

As time has gone on, I've pivoted and expanded to a full-fledged CSV importer which (bonus) includes multiple file merging support and a pretty cool UI for mapping.

Looking for as much feedback as I can to enhance it even more.

Fair point. At this moment, it's mainly for software companies needing a plug-n-play CSV importer.

The free (sandbox) option is for trying it out. You can do everything, but it's limited to 100 records output per file.

I'm very open to suggestions on pricing. Was attempting to make it easy, but maybe not the best look:)

That tool looks pretty cool.

Funny thing is several years ago I made a very similar tool to what you pointed out above written entirely in bash/awk and is also blazing fast.

That's where I got the idea for this online tool. I wanted to create the same exact concept of working with files locally without having to open up a terminal/console.

The code is not open source. However, If you inspect the network traffic from Chrome developer tools you can verify there are 0 post events occurring.

True, you can do this with many languages like python (quite easily with pandas as you pointed out) or with awk, perl, even cat (minus ordering) etc. For more power users Excel Power Query is your friend, but as you know these require script setup and memory considerations.

This tool is geared for ease of use anyone can do without the fuss of custom scripts and/or setups and for the most part almost zero memory concerns as the output is being written on the fly.

This is expected as merging currently requires a header row for each file so that it can automatically line up the data accurately.

For example if you had two csv files...

[File1.csv]

    Id,ProductId
    1,200
    2,300

[File2.csv]

    ProductId,Name,Id
    400,NameFor400,3
    500,NameFor500,4

Final output would be...

[Output.csv]

    Id,ProductId,Name
    1,200,""
    2,300,""
    3,400,NameFor400
    4,500,NameFor500

With that said, thanks for commenting! I will add an option for "No Header" files, or maybe even auto detect for these situations and do a straight merge:)

I run about 5 different sites which all have Google Analytics. Having an app that displays these realtime stats right in my taskbar has been an absolute must have time saver, especially when all I want is an at a glance look for how things are looking so far on all my sites. It literally takes like 5 seconds to open my laptop, login, look and I'm done. easy-peasy

Hello HN, I made this site because the other sites out there really don't feel anonymous so I wanted a place that had very little restriction.

Here's how it's different than other sites out there:

-It's totally open and anonymous (e.g. no registration and no login). By removing logging in, people (including myself) are much more apt to actually providing salary information.

-Each entry is timestamped and displayed for indication of staleness when the time comes. You'll be able to better make judgements of what the current salaries are based on that, including cost of living increases per date, etc.

-The same person can continue to add salary info anytime (for raises, job movement, etc.) because it's always being tracked so this shouldn't destroy the integrity.

-The audience has a voice in each salary submission by having the opportunity to flag and comment for each.

-Lastly, this site is totally crowdsourced, however as mentioned above there's zero login. Also a lot of the other sites are only basing salaries on stats or taking from visa databases which is not what this site is about it's all about real entries.

Thanks for viewing!

I feel the exact same way about those two salaries listed. Thanks for noting that.

When the site gains more traction and authority I'm shooting for more honest than bad. Hopefully, it will be obvious looking at the averages.

Then when I add flagging (probably this weekend) I'm hoping that will really help solidify my opinions for removal (then I'll gain thresholds for grounds on removals). The flagging will either be tally based or vote based. Also I'm considering adding commenting on the flag or just in general commenting on any salary provided. Might even show std, med, etc.

Thanks for your input!

The site is localized en-US so the way it's displayed is accurate to that localization (in showing other currencies, other than USD, to be in ISO).

The better option here would be defaulting the site to the locale of the users browser and/or just localizing the whole site translations and all.

I'd like to get more feedback on this before rolling anything out unnecessarily.

Ah, that was you:) I just noticed those negative values were being allowed. Thanks for doing that I'll fix that up. I need more validation for sure.

With the $ display I thought since the default on posting is US$ that it would be more obvious to mean USD by default in the display. I can easily change that to be US$ instead or something more uniform. I was also planning on making a converter per currency display to show real market value conversions to any currency.

What currency format would you think people would prefer? I could straight up do symbols and all?

Yep, exactly this! I already have flagging on my list of TODO's which is currently at the top of that list. Til then I'm the filter. I'm allowing it to be a little more free right now just to get my foot in the door with data. Thanks!

Thanks for your suggestion. I totally agree and I'm going to add that soon.

Ya, I definitely considered it, but then also had the thought not to discriminate on gender so wanted a level playing ground. I'm also not sure about adding too many fields and over do it.

If I get enough request for it I'll definitely add this as an optional field.

So far a couple entries are showing locations other than US, but with salary in US$.

Just wanted to note you can change the currency by clicking the currency icon (not sure if that's obvious to anyone)?

That field is case sensitive for now. I'd like to get more data first, but I can edit the entries easily if they are similar.

I'd like to provide a autocomplete dropdown for Employer and Title in the future, but I didn't want to have a limited set in the short term.

This is something I'd like to add

I really love open source too and may consider it for the future, who knows.

Thanks for your thoughts.

:) I like your style emehrkay thanks

Actually, there are apps out there that give you meals based on pantry items. My sister in-law used one a couple times.

This would be a great feature to add.

I think the styling definitely could use some improvement, for a broader audience, as well. It's really all my wife's artsy flare (she has an architecture degree) :) She drew it up and then I just replicated in code.

Multi-meals per day sounds like the way to go for sure. I always had that in the back of my mind

Great idea for monetizing.

Thanks!

This is exactly how things went down, thanks.

Great tip thanks. It's added now.

Wow:) looks like my usage limits for calling recipes exceeded for the day! I have very limited calls, otherwise I'd have to pay out a lot per month to increase. Might have to if more people start using it.

Thanks all

I made this with Jing (http://www.techsmith.com/jing.html) super awesome tool.

My wife wanted something very simple; just needed to track dinner. I had the same thought, but she's the boss

It's literally for my wife. All her idea:) I promised I would build it to her spec.

It's what she asked for. She uses this to pick her main dinners for the week and it builds a grocery list for her (work in progress for organizing).

Ya it's a base project (I have a lot of ideas) unless traffic comes, but I feel like that'll be impossible. I have a full time job and kids so have zero time to work on side projects:( If more traffic I'll put more addons otherwise I guess it's dead in the water.

To your note I'll have to load more than 1 question + charts (maybe 5 in queue). BTW thanks for adding a question to the site:)