Re: Column headers in CSV export
Philip Taylor wrote: > > > Dave Royal wrote: > >> You can change TB's language with a language pack: >> http://kb.mozillazine.org/Change_Default_Mozilla_Language >> >> I downloaded the French language pack and looked for those column names. >> I found them in >> chrome/fr/locale/fr/messenger/addressbook/abCardOverlay.dtd >> eg >> >> >> So maybe you could take one of the English variant language packs, change >> those labels, and install it - automatically. > > Clever. I like it ! > Philip Taylor The headers above the CSV export are not exactly the same as the field labels like the one you refer to here. However, they are translated in local language, so it should be possible to use this approach. Thanks! (to Dave). I'll see if this can be used. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Column headers in CSV export
Dave Royal wrote: You can change TB's language with a language pack: http://kb.mozillazine.org/Change_Default_Mozilla_Language I downloaded the French language pack and looked for those column names. I found them in chrome/fr/locale/fr/messenger/addressbook/abCardOverlay.dtd eg So maybe you could take one of the English variant language packs, change those labels, and install it - automatically. Clever. I like it ! Philip Taylor ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Column headers in CSV export
On Thu, 27 Mar 2014 14:16:22 -0500, Rob wrote: > > However, Outlook then comes up with a dialog to map the column names. > When the column names are what Outlook expects, it imports the file > immediately. > Here's an idea; I don't know whether it will work. You can change TB's language with a language pack: http://kb.mozillazine.org/Change_Default_Mozilla_Language I downloaded the French language pack and looked for those column names. I found them in chrome/fr/locale/fr/messenger/addressbook/abCardOverlay.dtd eg So maybe you could take one of the English variant language packs, change those labels, and install it - automatically. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Column headers in CSV export
On 3/27/2014 3:17 PM, Rob wrote: Keith Nuttle wrote: On 3/27/2014 9:52 AM, Rob wrote: Vic Moz Garcia wrote: On 03/27/14 09:12, Rob wrote: Is it possible to change the column headers above a CSV addressbook export to user-defined values, e.g. via a pref? We need to export many addressbooks for import in Outlook, and it would be much more convenient when the exported CSV files have the headers that Outlook recognizes automatically. (so the users to not need to tell Outlook what column to map to what) Probably easier to do it with an Excel macro. Easier to have everyone open the CSV file in Excel first before importing it in Outlook? We already have a simple script that performs the header change, but we are looking for a reduction in the number of steps to be performed by the users. (some 350 users need to perform those steps and most of them are very computer-illiterate) While I have not done it it is my understanding that you can set up a shared address book in Thunderbird. You may wish to google "thunderbird shared address book" A year or so ago I thought it would be nice to have one address book for my wife and I, but for two people it was too involved and I dropped the project.. I don's see how this is related. Exporting the address book is a way to migrate addressbook data to another program. It is related in that it is a possible different way to accomplish the same thing ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Column headers in CSV export
Keith Nuttle wrote: > On 3/27/2014 9:52 AM, Rob wrote: >> Vic Moz Garcia wrote: >>> On 03/27/14 09:12, Rob wrote: Is it possible to change the column headers above a CSV addressbook export to user-defined values, e.g. via a pref? We need to export many addressbooks for import in Outlook, and it would be much more convenient when the exported CSV files have the headers that Outlook recognizes automatically. (so the users to not need to tell Outlook what column to map to what) >>> >>> Probably easier to do it with an Excel macro. >> >> Easier to have everyone open the CSV file in Excel first before >> importing it in Outlook? >> >> We already have a simple script that performs the header change, >> but we are looking for a reduction in the number of steps to be >> performed by the users. >> >> (some 350 users need to perform those steps and most of them are >> very computer-illiterate) >> > > While I have not done it it is my understanding that you can set up a > shared address book in Thunderbird. You may wish to google > "thunderbird shared address book" > > A year or so ago I thought it would be nice to have one address book for > my wife and I, but for two people it was too involved and I dropped the > project.. I don's see how this is related. Exporting the address book is a way to migrate addressbook data to another program. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Column headers in CSV export
Vic Moz Garcia wrote: > On 03/27/14 09:52, Rob wrote: >> Vic Moz Garcia wrote: >>> On 03/27/14 09:12, Rob wrote: Is it possible to change the column headers above a CSV addressbook export to user-defined values, e.g. via a pref? We need to export many addressbooks for import in Outlook, and it would be much more convenient when the exported CSV files have the headers that Outlook recognizes automatically. (so the users to not need to tell Outlook what column to map to what) >>> >>> Probably easier to do it with an Excel macro. >> >> Easier to have everyone open the CSV file in Excel first before >> importing it in Outlook? >> >> We already have a simple script that performs the header change, >> but we are looking for a reduction in the number of steps to be >> performed by the users. >> >> (some 350 users need to perform those steps and most of them are >> very computer-illiterate) > > Yup, most users can open a file on Excel, and click 'convert' then save. > If you ask then to modify a file, run a script, or something else, > they'll find a way to mess-up everything. OF COURSE we have a single icon-to-be-clicked to start the conversion. Much easier than to open the file in Excel. However, it requires that the user first exports the addressbook to a file with an exactly specified name, then click the icon for the conversion, and then import the resulting outputfile. It would potentially be simpler to let the user export the file to a name of his/her own choosing and then import the file in Outlook. However, Outlook then comes up with a dialog to map the column names. When the column names are what Outlook expects, it imports the file immediately. I would expect that so many people already encountered this issue that the column names would be configurable via a (possibly hidden) pref. BTW, Google (GMAIL) has the same issue. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Column headers in CSV export
On 3/27/2014 9:52 AM, Rob wrote: Vic Moz Garcia wrote: On 03/27/14 09:12, Rob wrote: Is it possible to change the column headers above a CSV addressbook export to user-defined values, e.g. via a pref? We need to export many addressbooks for import in Outlook, and it would be much more convenient when the exported CSV files have the headers that Outlook recognizes automatically. (so the users to not need to tell Outlook what column to map to what) Probably easier to do it with an Excel macro. Easier to have everyone open the CSV file in Excel first before importing it in Outlook? We already have a simple script that performs the header change, but we are looking for a reduction in the number of steps to be performed by the users. (some 350 users need to perform those steps and most of them are very computer-illiterate) While I have not done it it is my understanding that you can set up a shared address book in Thunderbird. You may wish to google "thunderbird shared address book" A year or so ago I thought it would be nice to have one address book for my wife and I, but for two people it was too involved and I dropped the project.. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Column headers in CSV export
On 03/27/14 09:52, Rob wrote: Vic Moz Garcia wrote: On 03/27/14 09:12, Rob wrote: Is it possible to change the column headers above a CSV addressbook export to user-defined values, e.g. via a pref? We need to export many addressbooks for import in Outlook, and it would be much more convenient when the exported CSV files have the headers that Outlook recognizes automatically. (so the users to not need to tell Outlook what column to map to what) Probably easier to do it with an Excel macro. Easier to have everyone open the CSV file in Excel first before importing it in Outlook? We already have a simple script that performs the header change, but we are looking for a reduction in the number of steps to be performed by the users. (some 350 users need to perform those steps and most of them are very computer-illiterate) Yup, most users can open a file on Excel, and click 'convert' then save. If you ask then to modify a file, run a script, or something else, they'll find a way to mess-up everything. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Column headers in CSV export
Vic Moz Garcia wrote: > On 03/27/14 09:12, Rob wrote: >> Is it possible to change the column headers above a CSV addressbook >> export to user-defined values, e.g. via a pref? >> >> We need to export many addressbooks for import in Outlook, and it would >> be much more convenient when the exported CSV files have the headers >> that Outlook recognizes automatically. >> (so the users to not need to tell Outlook what column to map to what) > > Probably easier to do it with an Excel macro. Easier to have everyone open the CSV file in Excel first before importing it in Outlook? We already have a simple script that performs the header change, but we are looking for a reduction in the number of steps to be performed by the users. (some 350 users need to perform those steps and most of them are very computer-illiterate) ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey
Re: Column headers in CSV export
On 03/27/14 09:12, Rob wrote: Is it possible to change the column headers above a CSV addressbook export to user-defined values, e.g. via a pref? We need to export many addressbooks for import in Outlook, and it would be much more convenient when the exported CSV files have the headers that Outlook recognizes automatically. (so the users to not need to tell Outlook what column to map to what) Probably easier to do it with an Excel macro. ___ support-seamonkey mailing list support-seamonkey@lists.mozilla.org https://lists.mozilla.org/listinfo/support-seamonkey