mysqlimport and “duplicate entry” error

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

Does Oracle DB has a tool like DTS Wizard in SQL Server?

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

deal with email attachments

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

NXLog unable to read complete .csv file

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\ SpoolDir %ROOT%\data LogFile %ROOT%\data\nxlog.log <Extension _syslog> Module … Read more

Export object location from CSV

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

Extract data from multiple XMLs and generate CSV report – Powershell

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

How to capture tables with different structure from web

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

How can I reset password and email it using a CSV?

In a nutshell, I have a CSV file with First name, Last name, and personal Email. I would like to use this file to rest the users passwords and then send them an email with their login information. I had to populate a bunch of users before “going live”. I pulled all users that have … Read more