Previous 1 2 Next 29 Replies Latest reply: Dec 24, 2012 12:34 PM by Csound1 Go to original post
  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)

    I agree with you. My suggestion was very complicated: you know.

    Unfortunately I ignored the existence of CSV to VCARD converters...

    Should be a lot simpler.

    Going to support your suggestion with payeeagain.

  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)

    Forget my suggestion.

    It works but it requires a lot of time and a carefully match between data of CSV and Contacts.

     

    Try the way of Csound1 and find a CSV VCARD converter.

    Test it on a sample file.

  • paieyeagain Level 1 Level 1 (0 points)

    Csound, thank you, I have opened the MS Word table in the NeoOffice spreadsheet-module  -- ought I to save it as an .xml file ?  If I try to export it without first saving it, I am offered the same choices as are available in the word-processor.

  • Csound1 Level 8 Level 8 (42,320 points)

    paieyeagain wrote:

     

    Csound, thank you, I have opened the MS Word table in the NeoOffice spreadsheet-module  -- ought I to save it as an .xml file ?  If I try to export it without first saving it, I am offered the same choices as are available in the word-processor.

     

    Save As: comma seperated values (.csv)

  • paieyeagain Level 1 Level 1 (0 points)

    I am not offered that choice.

  • Csound1 Level 8 Level 8 (42,320 points)

    Then download Open Office and use it.

     

    Is this a .doc from MS Word? if it is then save as a .txt file (to strip formatting characters)

  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)

    A CSF is nothing different than a TXT file.

    Each line contains a Record (that is a "Card") where each of its fields are separated by a comma. Each line ends with a Reutourn and new line ASCI commands. (You may probably see the new line command as in word)

    How do you have your records in your file ?

    If you save them as TXT are they in lines with commas ?

    If it is in this way just change the file name from .TXT to .CSV and it is done.

  • Csound1 Level 8 Level 8 (42,320 points)

    WALTER-MILANO-ITALY wrote:

     

     

    If it is in this way just change the file name from .TXT to .CSV and it is done.

    .TXT and .CSV should have different delimiters, but that can be adjusted for in the converter, good idea.

  • paieyeagain Level 1 Level 1 (0 points)

    What is the difference in the delimiters, please ?  I may need to renew my efforts tomorrow, but meanwhile thank you, and I shall be putting your suggestions into effect as best I may.

  • Csound1 Level 8 Level 8 (42,320 points)

    .txt may use spaces or periods, .csv uses comma's. However this is the ideal and deviation is common in the real world.

     

    But ...

     

    You said "I have opened the MS Word table in the NeoOffice spreadsheet-module"

     

    Did you copy the table out of a Word doc and then try to use it, or is this the complete doc file.

  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)

    As explained by Csound1. Delimiters is what separate the fields in the line. CSV=Comma Separated Values

    You have to check what do you have in your TXT. May be commas spaces semicolon event tabs....

    You can try to convert the file as it is after renaming into CSV and see what the converter does. Sometimes it will probably work with a delimiter different from comma.... need to test.

    If necessary you can search and replace the delimiter.

    The big problem may arise if you have same punctuation in your data, you imagine what happen if you have commas in your adress.  You nead to make tests and after you have reached the decision which will be the delimiter that works with your converter before rearranging the file you will need to check for the presence of that delimiter and remove it.

    I hope I am clear.

    You see ... we go back to something similar to the complexity of my early suggestion.

    Actually it is not complex, but you have to start with fresh mind and no noise around your table.

  • paieyeagain Level 1 Level 1 (0 points)

    Here is what I have done, after a suitable interval to get some sleep, do some Christmas errands, &c.:

     

    1.   Launch NeoOffice.

    2.   Open MS Word table.

    3.   Save it as a .txt-file.

    4.   Click Table, Select, Table and press Ctrl-C to copy the .txt-file.

    5.   In NeoOffice, click File, New, Spreadsheet.

    6.   With the insertion-point in the top left-hand cell, press Ctrl-V.

    7.   Save the result as a CSV-file.

    8.   Launch Avery DesignPro.

    9.   Enter the product-number in the empty field,

    10. Click in the image of the sheet of labels, then click Text at the top.

    11. Make sure that 'All same' is marked 'OFF.'

    12. Click Mail Merge, and follow the simple steps shown.

    13. Result: perfection.

     

    My thanks to you both, you could not have been more helpful.  Best wishes for Christmas and 2013.

  • Csound1 Level 8 Level 8 (42,320 points)

    Merry Christmas

  • WALTER-MILANO-ITALY Level 4 Level 4 (2,175 points)

    Thanks ans Merry Chrismas to you both.

    It was a pleasure for me. First time I experience such a 3 side discussion

  • Csound1 Level 8 Level 8 (42,320 points)

    E un felice Natale a voi Walter

Previous 1 2 Next