Tags » Csv

Reading a UTF8 CSV file with Python

import csv

def unicode_csv_reader(utf8_data, dialect=csv.excel, **kwargs):
    csv_reader = csv.reader(utf8_data, dialect=dialect, **kwargs)
    for row in csv_reader:
        yield 

filename = 'da.csv'
reader = unicode_csv_reader(open(filename))
for field1, field2, field3 in reader:
  print field1, field2, field3
… 15 more words
Python

Get data from mysql to csv file using php

How to create csv file of all customer records from ‘users’ table

<a class="button flt" href="allcustomer.php?import_user=true">Export prospects in csv</a>

<?php
if(isset($_GET['import_user']) && $_GET['import_user']=='true') {
       $file = 'customer.csv'; 

$userlev = "SELECT * FROM `users`"; 

$query = mysql_query($userlev) or die(mysql_error());
       
$fields = "First Name,Last Name,Email Address,Address \n";
while($row = mysql_fetch_array($query)) {
   $customer_username1 = $Login_Process->check_parentid($row);
   $fields .= $row[1].' , '.$row[2].' , '.$row[3].' ,  '.$customer_username1." \n";
   }
   
file_put_contents($file, $fields);
header("Location: http://example.com/admin/customer.csv");
?>
Core PHP

Get installed SCSM Version for multiple computers by using PowerShell

I recently worked in a project where people are working with several Service Manager environments. First there is like a development environment where everyone does first steps and sees how it goes. 393 more words

Service Manager

Making a CSV file- using Notepad

What is a CSV file and what is its purpose?
CSV stands for Comma-Separated-Values. It is used to store tabular data in plain text. As the name suggests each value is separated by a comma. 113 more words

Software

CSV 2 GeoJSON

Recently I had another challenge, which I believe has the characteristics to be a common problem. I have a table with attributes, in CSV format, one of which is geospatial. 558 more words

Data Mining

Fetch flat files from FTP into Salesforce

I have been working on this and found a way to fetch flat files from FTP into Salesforce. I have taken it for csv files. Below are the points to follow – 86 more words

Salesforce

Export mysql databases with mysqldump to .sql .csv

## mysqldump is the command to obtain all data and schema from mysql databases, mainly to migrate databases between servers.

mysqldump -u {user} -h {host} {database}  > ~/dump.sql…

79 more words
Linux