S
-
Please check your spam/junk folder after registration, for your email. Thank you
S
Sammy
Oh Miss Looby , I'm such a technophobe !! Truly awful
However Stew is the ultimate geek when it comes to excel
It's Bain of my life , it a punishment every time I open one up
In my previous work it was my bread and butter (performance management) but I suspect these days I've forgotten more than I can remember
S
Sammy
Doubt it very much !!! It all comes flooding a back even if you try to forget it
You n Stew will have a lot in common work wise
Meeeee I'll stick to pen n paper
I think you and Lew have much in common with computer and software frustrations...... poor Lew at times it's a bit like watching Basil Fawlty do IT....
S
Sammy
I think you and Lew have much in common with computer and software frustrations...... poor Lew at times it's a bit like watching Basil Fawlty do IT....
Lol yep I get mysel into pickles , m computer literate ... just hate it , but love graphics etc
But I've been known to to threaten to send laptop fir flying lessons .. I would hater it with a tree branch just like faulty .. I stick with Lew lol
S
Sammy
Stew, can you do database exporting and importing into a set of new fields and custom metadata?
Not strictly excel, but I have a massive db that needs playing with (oh do behave) to import into a custom site with custom fields.
Just curious...
Standardised tables but run through encryption and PHP/MYSQl. Quite technical if I'm honest....
MOTM
Indeed it is.....
I was toying with playing with it in Excel, but this is a huge scale job with a lot of metadata and custom fields.. Far from easy and add on top then that it's encrypted (which I can crack and already have).
okay, thanks anyway I understand that this is a very specific task in honesty.. Just thought I would ask.
It has to be imported into a massive scaled DB with extended custom metadata fields.
So let's say for example I have the table... salt and vinegar okay?
This table needs to be extracted, imported into a NEW table, named best flavour salt and vinegar.
There's about 30+ different tables and over 40k pieces of information in metadata alone.
Fantastic work! Bravo..
M
MickeyBlueBalls
Should be able to use vlookup for that...providing the source data's compatible with Excel.
M
MickeyBlueBalls
Should be able to use vlookup for that...providing the source data's compatible with Excel.
Nah you're not being told @MickeyBlueBalls genuinely now my friend. But @Stew is right. As much as a good suggestion Vlookup is, it won't really help in so much as exporting tables then reassigning the data within those tables, into a new system.
I'll be honest, this is a monster job and I either need to write/find some sort of import script to do it, or graft and manually extract each set of metadata and then import it into each table one by one.
Not an easy job..
Anyway I genuinely don't think it was meant to be offensive..
M
meet_the_fockers
Ffs whats wrong with your intel pentium processing doodah mehNah you're not being told @MickeyBlueBalls genuinely now my friend. But @Stew is right. As much as a good suggestion Vlookup is, it won't really help in so much as exporting tables then reassigning the data within those tables, into a new system.
I'll be honest, this is a monster job and I either need to write/find some sort of import script to do it, or graft and manually extract each set of metadata and then import it into each table one by one.
Not an easy job..
Anyway I genuinely don't think it was meant to be offensive..
M
meet_the_fockers
..I could help......Ffs whats wrong with your intel pentium processing doodah meh
So when I've been struggling with pivot tables and v lookups you could have helped?. That's mean! lol x
S
Sammy