Hi Guys,
Im running Asprunnerpro 6.0 (Build 766)
I not a programmer so please excuse me for these novice questions.
- In the database table, you can set the max character or max length of a certain field.
Now my question is, how to set the minimum character or minimum length of a certain field?
So that when I upload from an excel file, if the field is lessthan the maximum characters (if for example there was typographical error in the excel file) then
it will not upload that specific information but rather will show that or prompt me that this information was not uploaded due to this reason. But the rest in the
excel file with correct max length will all be uploaded successfully.
2. Looking at the screen shot provided. In the BOE date and Submission date field I set the type to TEXT because in the information in my excel
file that I will be importing to the datebase are in different date formats. Some are in words, some are in dd/mm/yy format and others are in mm/dd/yy format.
When I do the importing, the program is automatically converting it to a different format which is not good because there are some dates which are being converted to a different
date. Now how can I upload these information or dates in the datebase as it is in the excel file regardless of what date format in the excel file we're using?
Thanks in advance.
Please be specific as possible. As I mentioned, I'm not a programmer so if you don't mind, please speak english <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=20450&image=2&table=forumtopics' class='bbc_emoticon' alt=':)' />
