Majofo

Some bitches waiting on me.. They keep emailing.. are you done?

Instead I'm bullshittin in here.. because their bitchasses fucked it up. How am I supposed to be fixin your shit on your timeline.. fuck you.

Majofo

justnspace

iTrader: (1)

I made it to line 500.

Hopefully it autocorrects itself further down the rows.....


4000 Rows.

Franchise1124

Only 4,000 rows?? You'd hate my job.

polobunny

90 angle ain't too bad. We need to butch the HVAC controls to fit the N7 properly. @_@

Good thinking and that's what I came to regarding the backup camera. Need to make it materialize though, easier said than done.

Also good idea on the backlight using the cam, but just as the backlight for instrumentation in the car switches as you use the low/high beams VS DRL (or off for you guys?) I'd like my N7 to switch the same way. I'll probably go the same way as the reverse cam automation and control it via an automation app such as Tasker. Once again, easier said than done. Also the front camera and light sensor are usually pretty imprecise so a glare could make it peak and get super bright.

All these smilies are there just for you!

I'm scared this could happen.

We still love you.

Supposed to be revising hundreds of joomla multi site installs for different components then calling up some users because they're using too much space on the mail server. CBA.

justnspace

iTrader: (1)

I'm glad there's some one out there that loves spreadsheets.

Majofo

Yumcha

Hory shet...4000 rows of information?!??


Dude, you need to get with IBM WebSphere or DataStage and see if you can do some data standardization.

justnspace

iTrader: (1)

2 columns.

but still sucks that most every row is messed up.

polobunny

We got like 2700 rows of real estate brokers with first name, last name, photo specs, site specs, office #, cell #, website url, email in an excel spreadsheet that the girls at the service department consult & copy/paste with every new photoshoot order.

I weep a bit when I think this could all be automatically loaded from a DB, but it's not, cause programmers are doing something else of "higher importance".

Majofo

Yumcha

Dafuq. Well, data cleansing/standardization is almost always an unfortunate afterthought by most organizations...

If you can get buy-in from the executives on the benefits of getting the data cleansed via an automated process, do it.

justnspace

iTrader: (1)

Franchise1124

@ 2 columns.

Sheets with 140k rows AND 60ish columns are the norm for me.

Majofo you still want a job??

Jamie's 08 TL

https://www.youtube.com/watch?v=1OAKdIrXWYA

Yumcha

If it's just 2 columns, you can easily run an ETL tool.


Anyhow, sucks to be you.

Maybe it's your birfday gift!

justnspace

iTrader: (1)

FIYW; its not an Excel spreadsheet.

its a spreadsheet inside the workflow program.
the program reads the spreadsheet(geometry) to out put squiggly lines.

so if spreadsheet is wrong; end product is wrong
and it came from client like this.

polobunny

Yup. Now it's dirty as heck and impossible to parse cleanly because 1 instruction can be written in 10 different ways.
All the brokers are already in a DB with phone # and personal information, unique IDs from the real estate board and whatever. Problem is they might not be written properly in that spreadsheet so you can't easily export the data without manual verification, and we're understaffed for the work we have.
The photo specs/notes as well as website notes is what's really important to the department, so technically this should have been included from the start. After-thought that grew big enough that now it's bullshit to manage. So many things like that here, sometimes I just want to facepalm or quit.

polobunny

Get a squiggly line correction program my nigga.

justnspace

iTrader: (1)

LOL that's what Im used for.

Yumcha

That's fine. Export the data into a .csv file. Cleanse/standardize it...import it back in.

Yumcha

Like, fixing the data directly within the source system is kinda an exercise in going postal IMO.

Guns are legal over there, no?

Yumcha

Pewpew.

polobunny

Always knew you were not completely straight. :theghey:

Yumcha

justnspace

iTrader: (1)

thats like 2 extra steps than just correcting in-program.


instead of figuring it out with you, I could be done already.

polobunny

One of my friends started working at a bank and he had to open each account 1 by 1 and change the commas to periods in the address fields because the data couldn't be exported properly by the 20 billions yrs old export program to be imported in the new structure. And they couldn't just migrate all the data using the DB because each account was encrypted with separate hashes and he had to type his password with every account he was opening or so he was told. Long short story, 2 generations of programming clashing, and they decided to pay college students to do the data input/change.

After the first week he sounded like he wanted to die and he acted like a girl in her bad week. I asked him on the phone if he wanted to join me and a few other friends at the bar and he told me he'd rather watch movies and eat the ice cream he bought. :gheylaugh:

Yumcha

Okay, my last post on this Birthday Boi:

You just said you have 4000 lines of data (by 2 columns) of data to review. Unless I'm from another orbit, this sort of data correction should be done AT A MINIMUM in Microsoft Excel which allows for filtering, sorting, and find-replace.

Unless your source application has that sort of functionality, or you've built in some business intelligence into fixing the data (which, you have not told us), the TWO steps it takes to export the bad data into Excel will be a small sacrifice to pay for the number of steps you save because Excel offers the functionality (filtering, sorting, etc.) I just described.

If you are doing it line by line DIRECTLY in the system...line by line? They could not pay you enough to do that.

Yumcha

polobunny

Seems like it's common business to ask people to manage shit load of data rather than have systems properly working. Programmers be assholes, or they'd rather chitchat on azine than work...

TacoBello

Spreadsheets over 15x4 should not be allowed to exist.

Now excuse me while I return back to being a lowly civil enjinear.

TacoBello

Fixed

Yumcha

Well, I'm even lowlier than you. I'm a worker who has no chance of ever climbing the career ladder because well, I'm yerrow.

TacoBello

Oh you are so humble and modest... And own half of the Engrish speaking world.

Majofo

Yumcha

Well, percentage-wise, we own almost all the dry-cleaning joints on the planet. But, as for the rest...dunno.

The also make up a nice percentage of the global population and so, that'd eat into the 50% you are estimating IMO.

rockstar143

iTrader: (6)

I totally just glazed over the last page and a half...

that is not the norm for me.



boats, hos or car talk anyone?

Jamie's 08 TL

There you are! Yes please!

Jamie's 08 TL

I will say Maj's "Fake Phantom" video was good stuff!!

Yumcha

You didn't miss anything or any salad being hucked around. You're good.