I'm having problems importing data.  The import file was exported from a Zoho Creator App and now I'm trying to import it into a copy of the same Application. 

I'm going to use the copy of the App for development.  I'm trying to populate the forms in the copied application with the same data in the original application to get a realistic development environment.

The import works fine on most of the forms/tables, however I'm getting strange non-descriptive errors on a few of the forms.  It seems the errors may have to do with one of the following...

1.  The exported data contains commas and/or some special characters. 

      Are there restrictions on characters and what are the appropriate escape characters to allow them to be used?

2.  The form has several lookup fields pointing to another Form.  I imported the relevant records into the other Form first, so the foreign data is in place.

     Are there restrictions on importing to a lookup field and what is the correct procedure to import a value into a field that is defined as a lookup field?

I've tried exporting both XLS and CSV and then importing them, but can't get it to work.

Your help is greatly appreciated.