![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
so there's this other big project, right? and i was in no way
involved in setting it up, or choosing the software, or anything.
but now _i_ have to deal with the data.
the database is set up to collect information from an ongoing series of surveys. ok, all fine there. except there is absolutely no point in collecting data if you can't analyze the data. which is my job. which means they have to download data from their system, and give it to me to read into my system.
which should be dead simple for any competant database manager. you come up with a format for the data, a consistent format so you don't have to do it all from scratch every frickin' time, you hit the button, you generate a file. if you are a reasonably decent human being, you get a few stats, like how many records are in the data, so the person you send it to has some reasonable idea of what they should be getting.
does this group do this? no.
they apparently never thought about getting the data out of this system when they chose it, so they can't export things in any reasonably importable form. they can write an ascii file, or an excel file. the database consists of approximately 300 variables, some with lengths of 100 characters...not really workable in excel. so they do it in ascii. and every single time, the guy does it (apparently) from scratch. so every time, the order of variables is different. this time, he sent me over 2 dozen variables that appear nowhere in the survey instrument. i don't know whether he's managing to channel future surveys, has somehow connected to someone else's data, or if he's just making stuff up. i've asked him repeatedly to send me things in the same format, which should be the easiest thing for him to do anywhy. but every time he does something different, and when i ask (politely, even!) if i can't have it in the same format as last time....he tells me he's too busy.
it would save everyone a great deal of time if he could manage to learn how to do it _right_ .... but i guess he's too busy for that, too.
the database is set up to collect information from an ongoing series of surveys. ok, all fine there. except there is absolutely no point in collecting data if you can't analyze the data. which is my job. which means they have to download data from their system, and give it to me to read into my system.
which should be dead simple for any competant database manager. you come up with a format for the data, a consistent format so you don't have to do it all from scratch every frickin' time, you hit the button, you generate a file. if you are a reasonably decent human being, you get a few stats, like how many records are in the data, so the person you send it to has some reasonable idea of what they should be getting.
does this group do this? no.
they apparently never thought about getting the data out of this system when they chose it, so they can't export things in any reasonably importable form. they can write an ascii file, or an excel file. the database consists of approximately 300 variables, some with lengths of 100 characters...not really workable in excel. so they do it in ascii. and every single time, the guy does it (apparently) from scratch. so every time, the order of variables is different. this time, he sent me over 2 dozen variables that appear nowhere in the survey instrument. i don't know whether he's managing to channel future surveys, has somehow connected to someone else's data, or if he's just making stuff up. i've asked him repeatedly to send me things in the same format, which should be the easiest thing for him to do anywhy. but every time he does something different, and when i ask (politely, even!) if i can't have it in the same format as last time....he tells me he's too busy.
it would save everyone a great deal of time if he could manage to learn how to do it _right_ .... but i guess he's too busy for that, too.
