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 ...
11th September 2008, 01:21 PM #1
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:
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)
11th September 2008, 06:42 PM #2
I found using OpenOffice Calc usually works better for manipulating stuff for Eclipse.
12th September 2008, 10:00 AM #3
I thought of trying that but fixed it with excel in the end.
By dgsmith in forum Network and Classroom Management
Last Post: 19th August 2011, 02:11 PM
By RoyG in forum MIS Systems
Last Post: 12th November 2009, 02:32 PM
By nomad in forum MIS Systems
Last Post: 8th October 2008, 03:06 PM
By DG01 in forum MIS Systems
Last Post: 14th March 2008, 01:36 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread