+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Eclipse2 and Phoenix E1 in Technical; Heres a good one for you all. I just had to create a report to export the year 7 details ...
  1. #1

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,325
    Thank Post
    622
    Thanked 1,577 Times in 1,414 Posts
    Rep Power
    413

    Eclipse2 and Phoenix E1

    Heres a good one for you all.

    I just had to create a report to export the year 7 details from e1 to import into eclipse2.

    Trouble is that e1 uses an xls file as it's output and eclipse2 needs a csv with quotes around the fields so it needs to look like this:

    "surname","forename".....

    Microlibrarian have no fix for it and apparently they've been waiting for pearson to get back to them for weeks.

    I found a solution in the end.

    Opening the xls in excel I used a formula to create the text I needed in the first free column and then copied this resulting correctly formatted text into a blank notepad document.

    At first this didn't work but then I found that eclipse2 didn't like the upn field which even though it's supposed to be a required field the import worked fine when I deleted it.

    The forumla used was:

    =CHAR(34)&A1&CHAR(34)&","&CHAR(34)&B1&CHAR(34)&"," &CHAR(34)&C1&CHAR(34)&","&CHAR(34)&D1&CHAR(34)&"," &CHAR(34)&E1&CHAR(34)&","&CHAR(34)&F1&CHAR(34)&"," &CHAR(34)&G1&CHAR(34)

    Ben

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    I found using OpenOffice Calc usually works better for manipulating stuff for Eclipse.

  3. #3

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,325
    Thank Post
    622
    Thanked 1,577 Times in 1,414 Posts
    Rep Power
    413
    I thought of trying that but fixed it with excel in the end.

    Ben

SHARE:
+ Post New Thread

Similar Threads

  1. Eclipse2 network connection error (very frustrating)!
    By dgsmith in forum Network and Classroom Management
    Replies: 6
    Last Post: 19th August 2011, 01:11 PM
  2. Pearson Phoenix E1
    By RoyG in forum MIS Systems
    Replies: 18
    Last Post: 12th November 2009, 01:32 PM
  3. Pearson Phoenix Gold - end of support
    By nomad in forum MIS Systems
    Replies: 1
    Last Post: 8th October 2008, 02:06 PM
  4. Phoenix to Facility Admin
    By DG01 in forum MIS Systems
    Replies: 1
    Last Post: 14th March 2008, 12:36 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •