Hi!!, we have the smart service that maps an excel to database only if the column names match with the fields of the database in oracle (same size). Now ,we have a problem , the names of the excel columns are in uppercase( but the fields in database are in lowercase), how i could work to map the fields between the columns of the exceel and database (fields with different size)?
Discussion posts and replies are publicly visible
Hi Rebecar369, i guess its nothing to do with lowercase and uppercase if name is same for both excel and database column name. what exact error you are getting?
In my case are differente, the fields of the excel are LARGE and in bbdd are SMALL, so the smart service doesnt work well, it doesnt save the information.
For me its working irrespective of lowercase and smallcase. are you sure there is no other issue like extra space in column name in excel etc?
Ye, for us as well. UPPER or lower case doenst matter
rebecar369 Can you share with us what error message you're actually receiving?
Aside from what others have already mentioned, the other thing to note is that the number of columns in your csv file must exactly match the number of columns in the database table. Otherwise, an error will be thrown.