On Monday, October 24, 2011 6:20:32 AM UTC-4, Saurabh S wrote: > > Hi , > I have deployed single app to two different instances , i want to > have > some of the data to be common in both the system so i exported the > data in csv from one app and added some data manually into the same > csv then tried to add this csv to another app via import...but this > is > not working....but when i tried to import it without any > modifications , it works fine.... >
Hard to say. Maybe you've done something to corrupt the file. Make sure you have a newline after the last line of data in the CSV file. > please suggest on this . > also please answer the questions below : > 1. if the DB structure is different than the coloumns in csv , will > the import work ? > for example my x table in DB has 10 columns and i am importing a > csv into it with 8 columns...will i be able to do this > successfully ?... if yes then what about values in those two fields ? > Try it (in a safe environment) and see what happens. It might work OK if the 8 columns are the first 8 fields defined in the model. I guess the two missing fields would end up empty (though probably won't work if either has a notnull constraint).
