Home Home
  login

Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Unable to Import Excel with cells that have line breaks in the text e.g. Comments

Excel

I have to import a large number of items from a legacy system into Gemini. Problem is with large text fields that are attempted to be imported into Rich Text textbox fields. Import keeps thinking that the line break is a new row to import and then rejects it. It is critical I can import the line breaks otherwise these text boxes become unreadable blob of text.

Can Line Breaks be replaced with some special character that will not be recognized by the imported as a new row but will be recognized as a line break in the Rich Text Box fields?

Currently on Gemini 5.1.5

Also reive the below error

Import Wizard

There seems to be a problem accessing the 'app_data/imports' folder. Please ensure you have given 'everyone' modify access to this folder.

Map incoming column values to Gemini field values

User48651
· 1
User48651
Replies (4)
helpful
0
not helpful

Can you please post the file? Is it xls or csv?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Please see email just sent to support with Subject "URGENT: Gemini 5.1.5 : Cnnot import into Rich Text box fields with line breaks?"

Actualy it does not work for Excel nor CVS. The email shows a clear example of how a CVS file is not loading and where. Basically breaks down on the first new line CHAR(10) i.e. Excel Alt+Enter in a TextField.


User48651
· 1
User48651
helpful
0
not helpful

Can you send the XLS file itself? It seems to me like it is a CSV format not XLS!


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

just sent it. Also more information on the email as well.


User48651
· 1
User48651