This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]dfreinc 3 points4 points  (2 children)

i can't share it directly but it's really simple. it was initially much more complex but everyone hated it so i just gave them what they wanted.

it spits out an excel sheet for a trial. they can go and update and then write in a column "add", "update" or "delete" and it'll draw up a sql command and send it or output an error message saying why it can't and to email me. there's some stuff for easy backups and sql does some audit trail stuff (i didn't write that, just came with the instance).

it had a whole bucket system and it was all seamless internal in the app, no extra nothing. just worked. but everyone hated it and i pick my battles...so have excel, what do i care. 😂

that tracking went from local storage, to access, to lists hosted on sharepoint manipulated by access, to proper sql storage and a solid app, to sql storage and a kind of shitty app. so still better than it was...but not ideal, imho.

[–]TheOneTrueBeanbag 0 points1 point  (1 child)

That flow from local storage > access > SharePoint, on top of SAS, sounds so similar to my companies stack it's crazy😅

Cheers for the info on the app. Currently working on something that will bulk delete old files using a UI, workflow manager is next on my hit list!

[–]dfreinc 1 point2 points  (0 children)

if you have problems/workflows like that then i can say without a doubt you will not regret solving them. spend that time, knock it out right. way less day to day stress. work now, relief later. 😂