I have data in MS Excel that I want to convert over to Concordance, what is the procedure to get the data into Concordance?
Typically, each "row" in the Excel file is a different document. Also, each "column" of data in Excel is representative of a different field of data in a Concordance document. Choosing the correct delimiters is important in loading the data into the proper fields in Concordance. Excel offers two of the more common delimited formats, Tab and Comma delimited. These are also presets available in the Concordance Import/Export Wizards.
We have a reoccurring problem with font/format and exporting from Concordance. Many times when we export from Concordance, font coding instructions (example: {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;}) are exported too.
The font coding that you are seeing is the Rich Text Font ("RTF") embedded coding that Concordance stores from the data inputted. You can easily disable the RTF coding by de-selecting the "Export Rich Text" option in the Export Wizard/Export Dialog Box. The option appears in the "Field" select Window of the Export Wizard. For your reference, you can disable RTF for any field in "Edit| Validation". Check the "Data Validation" criteria and look for "Disable Rich Text".
How can I send another user my data from Concordance? Do they have to have Concordance to view the data? Conversely, how do I view data in Concordance that was sent to me by another user?
Data can easily be imported and exported in Concordance using the Import and Export Wizards available under "Documents | Import/Export | Delimited Text". Data from a Concordance database can be exported into ASCII Delimited files (using an array of delimiters including Comma or Tab delimiters), which can then be opened in virtually any other program. ASCII is a basic format that is accessible by all standard applications. Similarly, once data is saved as an ASCII text file, it can be imported easily into a Concordance database structure.