Create FMT file with specific parameters

• SQL Espo

  SSCrazy

  Points: 2678

  More actions

  July 13, 2023 at 7:46 pm

  #4234440

  I am trying to create a new FMT file for a table I had to update. The base file is quoted and comma separated. The "current" file looks like this

  ---

  13.0

  8

  1 SQLCHAR 0 0 "\"" 0 first_quote SQL_Latin1_General_CP1_CI_AS

  2 SQLCHAR 0 25 "\",\"" 1 attraction_prefix SQL_Latin1_General_CP1_CI_AS

  3 SQLCHAR 0 255 "\",\"" 2 reseller_id SQL_Latin1_General_CP1_CI_AS

  4 SQLCHAR 0 255 "\",\"" 3 merchant_id SQL_Latin1_General_CP1_CI_AS

  5 SQLCHAR 0 255 "\",\"" 4 package_id SQL_Latin1_General_CP1_CI_AS

  6 SQLCHAR 0 255 "\",\"" 5 package_active_flag SQL_Latin1_General_CP1_CI_AS

  7 SQLCHAR 0 255 "\",\"" 6 customer_type_id SQL_Latin1_General_CP1_CI_AS

  8 SQLCHAR 0 255 "\"\n" 7 customer_type_active_flag SQL_Latin1_General_CP1_CI_AS

  ---

  I can't seem to find how to replicate this. Can someone please point me in the right direction?

   

  Thanks!

  Michael

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734489

  More actions

  July 13, 2023 at 8:49 pm

  #4234496

  What do you mean replicate this? This is just a text file you can edit.