Hi , thanks for the reply...i tried what you suggested but even that is not working out...is there any other solution for this ? please suggest as i am complately stuck up with this from last three days....plz suggest
On Thu, Nov 3, 2011 at 12:08 PM, Johann Spies <[email protected]>wrote: > 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) > >
