Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
 Back  |  Find  |  Login  |  Help 
icon5.gif   Import a CSV, posted by Ben on Mon Apr 2 15:46:59 2012 
    icon2.gif   Re: Import a CSV, posted by Stefan Ritt on Mon Apr 2 15:48:25 2012 
       icon2.gif   Re: Import a CSV, posted by Ben on Mon Apr 2 16:07:48 2012 _Universal_SIM_tracker-test.csv
          icon2.gif   Re: Import a CSV, posted by Stefan Ritt on Mon Apr 2 17:06:33 2012 
             icon2.gif   Re: Import a CSV, posted by Ben on Mon Apr 2 17:24:17 2012 
Message ID: 67228     Entry time: Mon Apr 2 16:07:48 2012     In reply to: 67226     Reply to this: 67229
Icon: Reply  Author: Ben  Author Email: brecio@aeronix.com 
Category: Question  OS: Windows  ELOG Version: V2.9.1-243 
Subject: Re: Import a CSV 

Stefan Ritt wrote:

Ben wrote:

 I am trying to import a CSV file in to a logbook. The Attributes seem to import fine but it kicks out the first 2 columns of data and shifts the data over to the left by 2 columns. Has anyone tried to do this?

The CSV file must be wrongly formatted. But I don't see it I can't tell you what's wrong. 

 Here is an example of the CSV I am trying to import.

Attachment 1: _Universal_SIM_tracker-test.csv  405 Bytes  Uploaded Mon Apr 2 17:28:03 2012  | Hide | Hide all 
SIM #,Mobile #,Type,Activated,Supported in S/W,Location,Login,Administration ,Access Point Name (APN),Username/password
8901258000000000,882800000589,Jasper,Y,Y,Lab,http://att.com/,cesmart/test,M2M,[blank]/[blank]
8901158000000000,882800000576,Jasper,Y,Y,,http://att.com/,cesmart/test,M2M,[blank]/[blank]
8901158000000000,882350000577,Jasper,Y,Y,Randy,http://att.com/,cesmart/test,M2M,[blank]/[blank]
ELOG V3.1.5-fe60aaf