Import COS .csv from MIVB 8.0 to a MIVB 7.2 system 2

[tech1302]

Hi

I need to import MIVB 8.0 COS .csv to MIVB 7.2 system.
When i try to do this i get errors as the columns of MIVB 8.0 is different to the 7.2 system COS form.
Is there a way around this please.

Thanks

 

[kwbMitel]

You need to figure out which columns are extra and delete them from the import

 

[jpruder]

I might also use the header info from the 7.2 when doing this just in case that says something that the import uses

 

[tech1302]

thanks guys

has anyone done this ?
how would you do this please.. I`ve tried comparing the columns of the csvs but it`s nightmare.

 

[kwbMitel]

Has anyone done this - Yes
How would you do this - Carefully

The column headers have numbers as well as names. You will find that all the new columns in rel 8 have higher numbers.

Find the highest number on 7.2 and delete every column with a higher number from release 8

There is no easy way.

 

[John Keri]

For best practice of comparing COS (or anything similar) that is in rows is to copy and transpose past them into a column format.
In this case, do it for rows of the ID number and the name for easier reading and into a new sheet.
Paste one set of COS options to column A and B, while the other to C and D, for example.
Use a simple comparison method as follows. Assuming your data starts in A1.
Type into cell E1: =if(a1=c1,"-","No")
Copy this to cells E1 to F1 and then down to the last row with data.
This compares the ID number and the description separately and shows a dash if the records match and 'No' if they don't.
All you have to do now is to scroll through the list and remove all the columns from the actual data of 8 that does not appear in 7.2.

Then comes the hard part, fixing the mess that Excel creates when saving 'csv' data.

 

[tech1302]

Cheers guys