hi guys, I am new to base and made a new table by importing a csv file. then afterward I tried to import another csv file by opening it in calc and copying the data row. when I paste it in base and get the pasting wizard popup I continue to “assign columns” and I notice that base is matching the first value with the ID column. I of course want to to skip the ID column since it is autonumbering, I want base to match the data starting at the second column. Is there a way to do this?
Hello,
It appears you are simply trying to add more data to an existing table. Just copy the column(s) with the wanted data (not the ID column) and paste that. Then insure the added data lines up with the existing column for the table.
here is a picture to clarify some more Imgur: The magic of the Internet
See how when I select food name on the source table it selects food ID on the right. that’s because the destination table has an extra ID column. Now here is the thing, 1. I cannot move the ID down for some reason, the only way I can do it is by moving all the values below above ID one by one, I have a lot of them. Doing this for every import would be highly inefficient. Any ideas?
update: I managed to move the ID column to the back by copying and pasting my DB and then moving it in the paste wizard. But now i get the error “Wrong data type: java.lang.NumberFormatException: Too many nonzero exponent digits.”. It is probably because the ID is not generating the autovalues when the data is added…
Have tried numerous ways to reproduce you error but can’t. Here is a simpler method. Go back to the original ‘copy/paste’ with the ID column. When you get to the Assign columns window, remove the check mark from the Source ‘ID’ field, then create. Insure your table definition is set for this field to be an autovalue field.