I have a couple of forms that use repeating groups or tables to capture data, and I am having trouble when exporting this data to MS SQL database tables. When the data is exported, it is getting trimmed to the length of the first line of line, for instance there is a field where the values can range from 5 to 13 characters in length, but if the first line has only 5 characters, all subsequent lines are trimmed to 5 characters even if they have more. Additionally, this particular field is optional, and if the first line has no value in this field, all subsequent lines are trimmed down to a single character. Is there something I need to change to get Flexicapture to export all data, as right now this is resulting in data loss.
Issue With Exporting Text Fields In Repeating Groups/Tables to Database (Flexicapture 11)
Was this article helpful?
0 out of 0 found this helpful
Comments
1 comment
Hello,
Please check that you are using the recommended providers and drivers for export to the DB (see the list in the following FC11 Administrator's Help article Program settings > Document Definitions > Data export settings > Export to database )
If the recommended settings are chosen but you get this issue, please address this question to your regional support together with the information about the program build and used DB/provider/driver version
Please sign in to leave a comment.