Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 5 years ago. Improve this question Any idea why below code is not working ? Trying to export username then the groups on to a csv. I just need … Read more
I have a .sql.tar.gz file tht ws generated by mysql export is there any command in linux to convert this sql.tar.gz file to csv? Thanks Answer You can try to export MySQL data as CSV and no need to look for a tool for conversion. Even if you don’t have the original MySQL database table, … Read more
I’ve used mysqlimport for MyISAM tables a lot in the past, without any problems. But now i want to import data into a InnoDB table and are facing the following problem: mysqlimport reports the following error and won’t import anything: mysqlimport: Error: 1062, Duplicate entry ‘1’ for key ‘PRIMARY’, when using table: … … and … Read more
Is there a tool like the Microsoft SQL Server’s DTS (Data Transformation Services) Wizard that simplifies the process of ad-hoc importing of flat files (CSV, TSV, or XLS) to Oracle database? Preferably free ones or the ones that are licensed together with the database. Thanks Answer Oracle Warehouse Builder is the standard Oracle ETL tool … Read more
I posted this question already but it was too vague and so was closed so I hope this is a bit better. We have a php based application which reads a csv report that is then added to a database and/or displayed in a graphic way for customers and ourselves. This works well but the … Read more
I try to work out why NXLog can’t read the complete .csf file witch has the same name but gets edited every 12 hours by windows for a export. conf file of NXLog: #define ROOT C:\Program Files\nxlog define ROOT C:\Program Files (x86)\nxlog Moduledir %ROOT%\modules CacheDir %ROOT%\data Pidfile %ROOT%\data\nxlog.pid SpoolDir %ROOT%\data LogFile %ROOT%\data\nxlog.log <Extension _syslog> Module … Read more
I need to export the object location of servers from a list. I have tried using the following script, but it only checks the mentioned OU, how can I search the entire domain and export the canonical name of the object to a CSV. Get-ADObject -Filter ‘Name -like “*”‘ -Searchbase ‘OU=ManagedGroups,DC=Fabrikam,DC=com’ | Export-CSV ExportOU.csv Answer … Read more
I have few connectionstrings which are xml files. I need to generate a CSV report using all these connectionstrings with the following output: Below is my PS script which works fine for 1 file and gives me the desired output. I have been playing around to make it work for all the files function extractValues … Read more
I have thousands of web pages(need login with username and passwords) like https://XXX.incometax.XXX/Preview/ViewDetail?TIN_INFO_NO=11935# where only last four digits(11935 for this example) changes for each url. Each url retrives tax information for a taxpayers in different types of tables. Tables are served based on the information entered in the system for each taxpayer e.g. Some taxpayer’s … Read more
I am attempting to create a powershell script to maintain users. Current environment. Office365 with ADFS, AD and on premise exchange server 2010. All integrated together. For the current problem, I am trying to import a list of users from a csv, and apply them to a specific distribution group, in either exchange or Active … Read more
