×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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



RE: Import COS .csv from MIVB 8.0 to a MIVB 7.2 system

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

RE: Import COS .csv from MIVB 8.0 to a MIVB 7.2 system

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

RE: Import COS .csv from MIVB 8.0 to a MIVB 7.2 system

(OP)
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.

RE: Import COS .csv from MIVB 8.0 to a MIVB 7.2 system

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.

RE: Import COS .csv from MIVB 8.0 to a MIVB 7.2 system

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.

RE: Import COS .csv from MIVB 8.0 to a MIVB 7.2 system

(OP)
Cheers guys

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close