Skip to main content
M
muskans400426
January 20, 2025
Question

how to create a new file of .dat type to fetch and store database tables in a process model.

  • January 20, 2025
  • 7 replies
  • 0 views

I need to create new .dat file by fetching the data stored in database by running a process model. I looked into the smart services but couldn't find anything helpful. How can we create a .dat file with all the details?

    7 replies

    keshavd5650
    keshavd5650
    January 20, 2025

    I just need a couple of details.

    1. Are you looking to create a binary .dat file or a text-based one?
    2. What structure do you want the data to have in the .dat file?

    M
    muskans400426Author
    January 20, 2025

    1. I need to save text-based data, which is basically the data fetched from the database table.

    2. The structure should be the data rows where the data is separated by | and rows are separated by || or a new line.

    keshavd5650
    keshavd5650
    January 20, 2025

    1. Start by fetching the required data using a record or data store entity. Then, structure the data as needed. For example:

    2. Utilize the "Text Doc from Template" smart service. Pass a template document containing a single key, such as "###DATA###." To create a .dat file, follow these steps:

    1. On your system, create a new text file.
    2. Insert ###DATA### into the file.
    3. Save the file and then change its extension to .dat.

    Terms & ConditionsAccessibility statement