Re: [libreoffice-users] Need Calc help
Thank you Jorge, My first quick glance suggests that these programmes may not work well with xls/ods files - I will look more closely at them Regards, Preston On 8/5/2011 10:33 PM, jorge wrote: Hi There are two programs that you can use for check the diferences between both files: 1) Meld 2) Kdiff3 Both programs are in the Ubuntu repository. Regards, Jorge Rodríguez __ El vie, 05-08-2011 a las 19:50 -0300, Preston Smith escribió: Hi, Hopefully someone can help me out. I maintain in Calc the regional section of a National membership file of Alumni. There are about 650 members in my regional Calc file. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Need Calc help
Hi, Hopefully someone can help me out. I maintain in Calc the regional section of a National membership file of Alumni. There are about 650 members in my regional Calc file. Each record is keyed to an unique College number and consists of about 26 fields of data including First/Last names, address, telephone number, etc. On a monthly basis, the national office sends me a 'pull' in Excel format from their national database. Since changes, additions, and deletions are not annotated by National, I have to manually compare each record in the latest listing with the appropriate record in my files. As you can imagine, doing this manually takes a long time when there are about 650 records involved. Assuming that the Column headers are the same in both files (not necessarily in the same order), is there a way that I can compare the two files to create a listing by College Number of fields that do not agree, and records that have been deleted or added? I am computer savvy but failed programming miserably so I need the input of the many smart people on this list. I do follow instructions well so could be led by the nose to create what is required. Thank you for your patience and help Preston -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Need Calc help
Hi There are two programs that you can use for check the diferences between both files: 1) Meld 2) Kdiff3 Both programs are in the Ubuntu repository. Regards, Jorge Rodríguez __ El vie, 05-08-2011 a las 19:50 -0300, Preston Smith escribió: Hi, Hopefully someone can help me out. I maintain in Calc the regional section of a National membership file of Alumni. There are about 650 members in my regional Calc file. Each record is keyed to an unique College number and consists of about 26 fields of data including First/Last names, address, telephone number, etc. On a monthly basis, the national office sends me a 'pull' in Excel format from their national database. Since changes, additions, and deletions are not annotated by National, I have to manually compare each record in the latest listing with the appropriate record in my files. As you can imagine, doing this manually takes a long time when there are about 650 records involved. Assuming that the Column headers are the same in both files (not necessarily in the same order), is there a way that I can compare the two files to create a listing by College Number of fields that do not agree, and records that have been deleted or added? I am computer savvy but failed programming miserably so I need the input of the many smart people on this list. I do follow instructions well so could be led by the nose to create what is required. Thank you for your patience and help Preston -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted