On 2 November 2011 13:36, Saurabh S <[email protected]> wrote: > Questions: > 1. What is the correct way to create the CSV file so that the file can > be imported using appadmin feature. > 2. How to debug the error in case data is not reflected after > importing the .csv file? > 3. Is there any particular steps that needs to be followed while > importing the file. Please share the documentation/reference in case > it is available. > > What I normall do is to create an empty table, use the admin function to export it to a csv-file, open the file in a spreadsheet and populate the columns - but I leave the data in the 'id' column empty.
If I am struggling to get this working in using the admin interface I try it on the commandline where it is a bit easier to debug. There were cases that I could not import csv files (created by web2py) on another computer. As a last resort I just did a dump of the table using Postgresql and imported the dump using 'psql -f <filename> dbname' Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)
