Notifications
Clear all
How To
6
Posts
3
Users
0
Reactions
4
Views
Topic starter
Hi,
I need to generate a text file. I'm populating it with data from Airtable. This is a specific file type, its purpose is to trigger bank transfers from a bank.
What I've done is create it from Google Docs or Google Sheets, and then export it as a text file. The issue is that the export process corrupts the text file, and the bank rejects it.
I'm looking for a module that can generate a raw text file.
Do you know which is the best option?
Thank you
Posted : 18/01/2023 4:34 am
Hi. Utilize the “Set variable” module to construct your structure and data file. In the subsequent step, use the data from this module to facilitate the upload to your bank.
If you require further assistance, please feel free to get in touch.
Cheers
//HFBR
Posted : 18/01/2023 9:26 am
Topic starter
Thank you, I'll give that a try. The structure should be quite straightforward since it only involves rows without any separators.
Posted : 18/01/2023 8:11 pm
Hello, can you share an image of the created scenario, in addition to indicating the structure of the file and where it will be located.
Posted : 18/01/2023 10:43 pm
Topic starter
It works! Many thanks.
I have one request: How can I “download” the file to my Airtable?
Here are the details of the entire scenario.
My data originates from Airtable.
I have a first table containing a list of invoices.
A second table is called “ebics”: it has one line for a daily document and is linked to the invoices. This document can trigger bank transfers.
This is my document:
=> The first line is always the same
=> Lines 2 to 9 are invoices (there can be more than 8 lines).
=> The last 3 lines depend on lines 2 to 9.
Here is my scenario:
1 - Trigger via webhook
2- I create an ebics line. This record contains the content of the first line (default content in Airtable).
3- I search for invoices that are not linked to an ebics record.
4- I link them with the ebics record created.
5- I use the text aggregator to gather all bundles from step 3 and get lines 2 to 9.
6- I pause callin.io for 15 seconds using the sleep module. During this time, Airtable can calculate the values of the last 3 lines.
7- I refresh the data of the ebics record created in step 2 (to retrieve the data computed during step 6).
8- I set a variable with the first line, the result of step 5 (aggregator), and the last three lines.
9- I encode it to UTF-8 (perhaps it's just an option…).
10 - I send it to my client's bank.
I am missing the step where I can attach a document to Airtable. The Airtable update module requires a URL. I only have the text data. It can be obtained from the Gmail module.
=> Do you know a module that can generate a file?
Thank you!
Posted : 19/01/2023 12:03 am
Topic starter
I discovered the solution using Google Drive.
Thank you, everyone!
Posted : 19/01/2023 3:21 am