Vic Moz Garcia <[email protected]> wrote: > On 03/27/14 09:52, Rob wrote: >> Vic Moz Garcia <[email protected]> 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 [email protected] https://lists.mozilla.org/listinfo/support-seamonkey
