u/_marlowe_

Partner drops a CSV on SFTP every night, ~40k rows of order line items, we upsert into a custom object on an external ID through Bulk API.

Most nights a few dozen rows fail. Usually a lookup that doesn't resolve, sometimes an external ID with trailing whitespace nobody trimmed upstream. Bulk API hands back the error file, and right now that file lands in a folder on the same box the script runs on, where it is read by nobody.

So the org ends up incomplete and there's no sign of it from the inside. A report comes back short and there's nothing in Salesforce explaining why.

Trying to work out where failed rows should actually live. Write them to a custom object so ops can fix and requeue from the UI, push a rejects file back to the partner's SFTP and make it their problem, or fail the whole load once the error rate crosses some threshold.

Anyone built the requeue-from-UI version? Wondering whether it's worth it or whether it becomes a second product nobody maintains.

hey dunno if I’m in the right place but feeling a bit confused about my future and need some advice. I grew up around a lot of creative ppl and have always been good at telling stories and even did some sales at a past internship - really liked all that and wanna turn it into a marketing career. Don Draper Jr, ya know :)

I think the dream end goal is working at a really creative agency or brand, coming up with cool campaigns - like Dollar Shave Club, Liquid Death, I think it’s really cool how they built a huge business around kinda normal stuff (shavers and water haha). One of my friends went to a portfolio school and ended up getting work that. I think I'd be really good at this but I know it’s a long road, so all I want is a clear path to my first real job. So far just been doing internships and no college yet, kinda think its a scam tbh… but maybe that’s bc of the price

not to whine about AI… BUT it seems SO hard to get someone to get an entry level role right now. I want to prove myself, have tried sending pitches and my portfolios cold, even did some creative stuff like ordering one hiring manager a cake - but still no offers. most job listings I’m not even getting an email back, period!

Are you seeing this too? Entry level is kinda wiped out in your industry or just me? How do I climb this ladder?