tko2003 Posted October 1, 2008 Share Posted October 1, 2008 Hello Group, at first i want to thank for this incredible product, never had such good one. Now to my problem, i need to export some user accounts from a mysqlserver in a flat textfile. Following two tables have the data: wa_user: userid, username, firstname, lastname wa_userrighttokenmap : UserID, RightKey What my problem is, i need to export the data in following way. Extract the data from the tables and write it into a file, example: firstname lastname username rightkey (if content of rightkey is admin, it should write Admin user and if content of rightkey is user it should write user) Can someone help with this problem`? many thanks in advance Link to comment Share on other sites More sharing options...
PsaltyDS Posted October 1, 2008 Share Posted October 1, 2008 Hello Group,at first i want to thank for this incredible product, never had such good one.Now to my problem, i need to export some user accounts from a mysqlserver in a flat textfile.Following two tables have the data:wa_user: userid, username, firstname, lastnamewa_userrighttokenmap : UserID, RightKeyWhat my problem is, i need to export the data in following way.Extract the data from the tables and write it into a file, example:firstname lastname username rightkey (if content of rightkey is admin, it should write Admin user and if content of rightkey is user it should write user)Can someone help with this problem`?many thanks in advanceHow far have you gotten? What have you tried? Have you got enough code already to connect to the server and access the tables at all? Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
tko2003 Posted October 1, 2008 Author Share Posted October 1, 2008 How far have you gotten? What have you tried? Have you got enough code already to connect to the server and access the tables at all? Hello Psalty,yes, but the rest is really a mess....Or i am just to dumb... Link to comment Share on other sites More sharing options...
PsaltyDS Posted October 1, 2008 Share Posted October 1, 2008 Hello Psalty,yes, but the rest is really a mess....Or i am just to dumb...So, what part are you stuck on at the moment? The first post listed an entire project, but some steps have already been achieved. What step are you on now? Are you still trying to get data from MySQL with AutoIt, or is that all done and you need to work on the file writing? Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now