Debian :: Import List From Excel File To Create Many Users
Sep 22, 2015
I'm working in a school and we have a Apple server, we have many problem with it. So, I would install a linux server instead.
Anyway, there is just one big problem (or I miss a simple tip to do it )
We have 1300 students. If I must create them one by one, that will take a lot of time. Actually with the apple server, we can go on a web interface & import an excel list with theses columns :
Due to this tool, I can upload an excel files with my 1300 students & a couple hours after, they have an account with a personal space & a shared space with their class.
My question is : This tool exist on Debian/Linux world ?
Have managed to create a simple script to poll the various printers we have at our company for a page count via SNMP. At the moment the script echos the printer name to a text file and then the snmp output is appended to the next line. In my rush I thought by using sed to add a comma to the end of each line would mean it would import in to excel nicely. So rather than having:
When I right click on a free area of the desktop or within an open folder, I read "Create Document" -> "no templates installed" and "Empty File". How to install the templates in there so I could open a file of my choice?
I have installed and configured a new ClearOS enterprise 5 and it is up and running. I need a way to import my old redhat mail users to ClearOS. Please any one help with idea to accomplish this task.
I want to use samba in ubuntu.For samba users i make a user in my linux box like
# useradd smith # useradd jone
These users can also login into my ubuntu system if they want. For samba I want to know that, is there any way to create separate valid list of samba users so that they may access files from windows xp.
I need to create a script that returns a list of the users who have never changed their password from /etc/shadow. As I know on linux there is a command "chage" used for find last password change.
Just installed Debian on a laptop. I'm not a Linux noob, been running Ubuntu / Kubuntu / Fedora elsewhere for a while. But first time with Debian (Gnome). [Broadly pretty happy so far. It may supplant Kubuntu on my desktop as the latter seems a bit of a resource hog.]I want the login screen to offer a list of users.I've tried System > Administration > Login Window > Localand chosen Themed with face browser from the dropdown marked Style:I'm using Bijou (though I've also tried some of the others) as my theme, in case that makes any difference.I haven't got any pictures set up for users. It's not particularly that that I want, just a list of users to choose from rather than having to type in your username each time. It's a family setup, no big security worries, so easing typing would be nice.
I'm using jessie and since I upgraded from wheezy, gdm3 no longer shows a list of users in the logon screen. (I can still log on by selecting "other users").
I had previously had the same symptoms on wheezy, but had fixed it by changing "UID_MIN" to 500 in /etc/login.defs
in order to visualize the mentor-student relations inside my fraternity, I'd like to create a genealogy graph from a Excel spreadsheet. This works way better than expected, but there is one final issue. To demonstrate, this is a smaller version of the graph:
[URL]
It is ordered by year , while members are placed in the appropriate timeslot and are connected to show said relations. Unfortunately, as you can see, during a few years when the choosing of mentors was partly suspended due to historical reasons (WWII etc.), the members stack up to the right of the graph, widening it a lot. Is there a way to specify that they are supposed to be distributed among the members that are part of the structure in order to achieve minimum width?
I have a file with 5000 lines. it is a list of books authors, series and titles. all lines start with the author names, than there is a dash (-) than the series name, a dash again and the title of the book.
The problem I encounter is that sometime there is a series, sometime not, and as I try to enter this list in a database, I wanted to create a cvs file to import into mysql.
ex:
The best would be to be able to add in the second line, a "space dash space" just after the author name, but how to make sure it does not do it to the first line as well.
If I could separate all line with 2 dash, (grep ?) then I would be able to do a simple replace, and change the single dash into two.
I am trying to write a script to pick the directory name from a list of file. Here is a detailed picture.Have a file name LIST which contains the follwing for example/apps/oracle/product/test1/apps/oracle/product/test2/apps/oracle/product/test3I need a script that reads these line from LIST and creates foldersin /apps/oracle/product/test1/backup/date/test1 after reading the first line /backup/date/test2 after readin the second line/backup/date/test3 and so on.
How would I list 4 users ID numbered 10, 11, 12 and 13 from my users list and output them to a file busers where their names are numbered by ascending order? How would I accomplish that on a one line command?
I've downloaded configuration files for my VPN, Kovurt, and they don't have a .ovpn file extension. Further, when I tried to enter the information manually (using this guide), I saw that the files only include the <ca> tags, and no <cert>, <key> or <tls-auth> tags.
Here is the content of one of the config files, simply named 'Tokyo' with no extension. (adding .ovpn didn't work either):
Code: Select allclient dev tun proto udp remote 50.31.255.86 443 resolv-retry infinite nobind
[Code] ....
I have an open ticket with Kovurt asking for the other info, but I know already that they don't have much in the way of documentation or support for Linux.
Now I have my ldap server doing authentication and providing autofs maps perfectly the next question ... is there a utility anywhere that will allow me to stuff 1200 users into the ldap server from a csv file
Imported users and groups (UIDs 500 and above) from Redhad to Ubuntu 9.10 by appending users to the passwd, shadow and group files. Users and groups appear to work, but they do not show in the Users/Groups GUI. Is that because they do not start at a UID 1000 and up? What are my options to make them visable?
I would like to find a tools to change csv file to excel , I tried google , there are some tools can do it , but the file have some specical character and Chinese character , can advise what tools is good for it ?
another that , I have one specical requirement , I would like the tools can change the date format of a specific column ( eg. from mm-dd-yy to dd/mm/yy ) , is there any tools can do that ?
I am having trouble getting some code to work. It takes an input file (csv) and converts it to an XLS. The problem is that I can't seem to get a header to be printed first...
Code: use Spreadsheet::WriteExcel; my $input = $ARGV[0];
I just switched from a basic digital camera to a more advanced one that stores both Jpeg and Raw (.Nef - it's a Nikon) files for me.When importing files in Digikam, I rename the files so that they start with Date and Time. Example: 20110121-223748.JPG for a photo taken on Jan 21st 2011 at 22:37:48.I was a bit surprised when importing both the JPEG and the Raw version of the same photo, that the filename is different by a few seconds (no constant offset, sometimes they are the same):
20110121-223748.JPG 20110121-223750.NEF
I did some "research" by looking at the exif data of both files (using "exiftool 20110121-223748.JPG" from the command line). Here is what I got back
(amongst other data):20110121-223748.JPG File Modification Date/Time : 2011:01:21 22:37:48+01:00 Modify Date : 2011:01:21 22:37:48 Date/Time Original : 2011:01:21 22:37:48
[code]....
So it seems that Digikam is using the "File Modification Date/Time" (different in the Jpeg's and Raw's of my camera) rather than the "Create Date" (the same for both Jpeg and Raw). (The few seconds difference in "File Modification Date/Time" between the two versions of the same photo is probably due to the time that my camera needs to write away the data on the SD memory card. I guess.) Is there a way to have Digikam use the Create Date? (Or the Date/Time Original?)
I am looking for ideas for getting windows users into an ldap server. I am currently running a Linux server for my department and need to create an LDAP server which mirrors the username/password information for all of us as they are stored in the windows server here. I have the openldap server up and running on Ubuntu 8.04 and it works great; I now need to find some way to import user info into this from windows. I've seen discussions of using ldifde.exe to export the AD users into an ldif file. Is this the simplest way to go about it?
Our Linux server is currently providing us with much needed services using apache, and apache is authenticating using LDAP to our windows server (Using our windows username / password is required functionality). This windows server has some problem which causes it to delay for inordinate amounts of time between authentication requests and responses. The situation is such that this problem will not be addressed by IT staff. However, I have control over the Linux server so I am looking to just mirror the windows server on an LDAP server of my own. I could get away with updating the passwords in the Linux server.
I am working on telnet session and excuting commands. I am able to redirect or store expect output to log file but now i want to store in excel file like ispreadsheet showing details of commands and its responses
Is it possible to import an xorg.conf file from Debian to Fedora and have it work? The reason for this is that I have an older monitor that only offers 800x600 as the maximum resolution.
