Home › Forums › General Discussion › Exporting data
- This topic has 8 replies, 6 voices, and was last updated 12 years, 10 months ago by Zander.
-
AuthorPosts
-
July 2, 2007 at 7:12 pm #161
Can an exported lexicon be opened with Excel? And vice versa, can data entered in Excel be imported into Personal Lexicon?
July 2, 2007 at 8:55 pm #187ZanderKeymasterHi. As of now, the answer is no. Exported files can only be read by PL and PL can only import files generated by someone using PL. There are plans to be able to import and export plain text files in a future release. This would mean that Excel could import and export such files, but as of now I can’t give you a release date. I will say that the more people who request this feature, the sooner it will get done.
regards,
Alexander
December 15, 2010 at 8:17 am #199well as what meJABE said, i would like to suggest you could export it to excel. majority uses microsoft software, so i hope you could be able to do this. it would be a lot easier for us, and great respond to lexicon.
March 1, 2011 at 7:26 am #200bjstevens wrote:well as what meJABE said, i would like to suggest you could export it to excel. majority uses microsoft software, so i hope you could be able to do this. it would be a lot easier for us, and great respond to lexicon.totally agree with you bjstevens! I have a VA and I send her a PL file and she can’t open it. It takes time to teach her how to use and install the software. So I think it would be a lot better if we have it excel. Just a suggestion though
April 7, 2011 at 5:56 am #209Hey , there are actually lexicon packages open to work with Excel files that will run on any platform and that undertake and don’t either Windows or even Excel to be used.
_______________________________________________
June 20, 2011 at 3:58 am #211ZanderKeymasterJust wanted to let you all know that version 1.3 will be able to import/export CSV files. This week I will update the beta version with one that has this new functionality. Hopefully, some of you will be able to try it out. Cheers.
June 25, 2011 at 6:22 pm #212ZanderKeymasterThe beta version now contains new features to import/export lexical items in CSV format.
To export a CSV file simply proceed through the normal steps to export selected lexical items. When you arrive at the file dialog, choose the CSV file format instead of the PLX file format. Done.
To import a CSV file into your lexicon then you’ll need to have a CSV text file with columns in the following order:
item text *
lexical type (name or abbr) *
definition *
pronunciation
themes
roots
synonyms
antonyms
phonetically similar
related
comments
personal examples
alt def
gender
gender changeable (Y or N)
classNote that only the first 3 columns are required. Also note that some of the additional columns support multiple entries within them. For example, you may want to add multiple synonyms to the synonyms column. If you need to separate multiple entries within a single column then you need to use a | character to do this. For two synonyms it the column data would look something like “synonym1|synonym2”.
If you’re interested in making your own CSV file with just the 3 require columns then the process is easy. However, if you want to include the additional columns then perhaps it would be a good idea to examine an export file. This will give you a concrete example to emulate. Of course, feel free to ask me any questions. I will be updating the documentation when release 1.3 is officially out.
regards,
Zander
July 6, 2011 at 4:44 am #213pburkeParticipantHi Alexander. I tried exporting a CSV file containing some lexical items but it won’t do it. I hit export button and nothing happens. But if I try exporting some different items it works. What’s going on? Have you seen this?
Pete
July 7, 2011 at 5:58 am #214ZanderKeymasterHey Pete. Yes, I do believe I’ve seen the bug that you describe. It’s fixed, but I haven’t updated the beta release. If it’s important that you have the fix quickly then I could update it. Otherwise, the actual release should be out towards the end of next week. Let me know if you need it asap.
Regards,
Alexander
-
AuthorPosts
- The topic ‘Exporting data’ is closed to new replies.