Skip to main content
Nintex Community Menu Bar

How to create table in SQL db using text file upload

  • August 2, 2018
  • 1 reply
  • 71 views

Forum|alt.badge.img+6

I have text file with data like column name and values.

16247i289658BC3046EE53.jpg

I am going to upload the text file in the K2 Five smartform.

Afterthat text file upload i have create that Files columns and values as a table in SQL server.

Kindly help how to achieve above requirement.

 

1 reply

Forum|alt.badge.img+4
  • August 2, 2018

I assume you are using the fileupload control on the smart form and that you have a smart object that was generated from the table where you want to store this information?

 

 

We will store the attached file in SQL as a base64 string, our file attachment control does this conversion when create/update/read methods are executed so you shouldnt have to worry about doing this manually in smart forms.

 

When you create the table where you want to store the attachmetns I would recommend using the type ntext/memo so that we have a field big enogh to store the poteintially long base 64 string representation of the file attachment.