Sign in to follow this  
Followers 0
tko2003

mysql script export with file creation

4 posts in this topic

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

Share this post


Link to post
Share on other sites



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

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?

:)


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

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0