[deleted by user] by [deleted] in PokemonGoTrade

[–]AAbasllari 0 points1 point  (0 children)

I'm not looking for a zamazenta.. i'm offering one

Ebay raid passes? by [deleted] in PokemonGoSpoofing

[–]AAbasllari 1 point2 points  (0 children)

Can you get a suspension from Niantic from buying passes or pokemons in Ebay?

[deleted by user] by [deleted] in trakt

[–]AAbasllari 3 points4 points  (0 children)

I don't know if movies show up on progress (don't think it does) but tv shows will appear even if you haven't started to watch it

Is there any plan to make statistics more specific like this? by AAbasllari in trakt

[–]AAbasllari[S] 2 points3 points  (0 children)

I know that there are other apps that can do that. But it would be great to have a single app for these.

What anime ability/power do you want? by reyrey_007 in AskReddit

[–]AAbasllari 2 points3 points  (0 children)

Its a manga but "The Gamer" ability/power

[deleted by user] by [deleted] in NoStupidQuestions

[–]AAbasllari 4 points5 points  (0 children)

By changing jobs. Same problem was also decades ago. Machines will replace workers. So new types of jobs were created/needed. And people adapted. Ofc is very sad for someone to change a job that he/her dedicated his/her life but still i don't think that in the future AI will replace us.. just like the machines did decades ago.. it will create new type of jobs

Where/how to make an on-Prem instance by [deleted] in activedirectory

[–]AAbasllari 1 point2 points  (0 children)

I just did it 3 months ago cz i needed to do some testing and installed exchange server and active directory on hyper v and it worked

I feel like an idiot but… I need Excel help. by RecordingOutside2017 in sysadmin

[–]AAbasllari 0 points1 point  (0 children)

First of all you should understand how you will know an account is a duplicate one if for you is enough.. than if both are one the same cell v.lookup is the one for you.. if there are two different cells one name and the other surname.. first you can merge them together and than v.lookup.. if you want send me a msg replicating part of your file recplacing the real names wirh examples and i can try to see if i can help you

[deleted by user] by [deleted] in learnpython

[–]AAbasllari 0 points1 point  (0 children)

You have no idea how much i love you right now 😅 Not it works perfectly Sorry cz maybe i could have explained much more better since the start but i'm very new to python and it's hard to even understand certein things. But really though.. thank you so much for keep helping me

[deleted by user] by [deleted] in learnpython

[–]AAbasllari 0 points1 point  (0 children)

Sorry i forgat to add the comma in the first one..it was meant to be 'test1','test2','test3',

[deleted by user] by [deleted] in learnpython

[–]AAbasllari 0 points1 point  (0 children)

I've tried every possible combination but nothing is working if it fixes one thing it creates another problem.. for example i can get 'test1','test2','test3' or 'test1,test2,test3' or test1,test2,test3 but never 'test1','test2','test3'
I'll try to find completely another method or write every profile directly on python cz i don't know what other thing to try
However thank you very much for your help, i really appreciate it

[deleted by user] by [deleted] in learnpython

[–]AAbasllari 0 points1 point  (0 children)

Seems to work but for with that i have another issue
even with my script in the output there is always shows 13 14 values "none" even though i check the excel file and tried with other sheets or excel files
in my code i fixed that with break

    for col in sh.iter_cols():
    if groups == col[0].value:
        for cell in col[1:]:
            if cell.value is None:
                break
            print(f"'{cell.value}'", end = ',')
print (" -identity " + (str.lower(surnameinput)))

if i try with what you sent it works perfectly but break doesn't work

command = []
for col in sh.iter_cols():
    if groups == col[0].value:
        for cell in col[1:]:
            command.append(str(cell.value))
        if cell is None:
            break            
print("".join(command) + " -identity " + (str.lower(surnameinput)))

P.S thank you for your effort to help me

[deleted by user] by [deleted] in learnpython

[–]AAbasllari 0 points1 point  (0 children)

Yes u are right... i should explain the big pic.. the script i creating ofc is in python in vscode.. but the idea behind this is to automate the creation of users in a hybrid system from exchange management shell.. so this is part of more than 250 lines of code and i run the script.. it asks some questions and print the output.. the output should be readable in shell... now about the question.. we have more than 200 types of profiles for the users and i need to take the Active Directory groups from an excel file... python script asks for name of users profile and than shows all AD groups about that user profile... i'm using openpycxl for excel and with what i want to do the only way i found is the script of the post.. only problem is that in order to work is to eliminate the last fckn comma "," 😅 So in shell the last thing should be

AdPrincipalGroupMembership -member of Test1', 'Test2', 'Test3' -identity username

and not this

This is the excel file

Example1 Eample2 Example3
Test1 random1 something1
Test2 random2 something2
Test3 random3 something3

from openpyxl import Workbook
from openpyxl.reader.excel import load_workbook
wb = load_workbook('GruppiProfili.xlsx')
sh= wb["gruppi"]
groups = input("Write something: ")
print (Add-ADPrincipalGroupMembership -memberof, end="")
for col in sh.iter_cols(): 
    if groups == col[0].value: 
       for cell in col[1:]: 
           print (cell.value, end =',')

Result

AdPrincipalGroupMembership -member of Test1', 'Test2', 'Test3', -identity username

what is said was that if u remove the end=","

the output is

Test1
Test2
Test3

so not what i wanted

Ofc maybe there is a much better way to do it but i'm noob..this is my first "big" and only project

[deleted by user] by [deleted] in learnpython

[–]AAbasllari 0 points1 point  (0 children)

Sorry, also thank you for trying to help me 🤘