Creating a file using SFTP

Hi again,

I’m trying to create a file in the following format:

@FIRM_BEGIN(3)

@IMPORT_METHOD(3)
@WaBnd (Descr, ValDt)

“Exported from ABC software” “20240123”

@WaVo (VoNo, Votp, Txt, VoDt, InvoNo, ValDt, DbAcNo, DbTxCd, CrAcNo, CrTxCd, Am, DueDt, CID, R1, R3)

“271660” “12” “Utg. kr.nota” “20231218” “271660” “20231218” “0” “0” “150629” “0” “1625,00” “20240101” “1111222222222222111” “1” “76”
“271660” “12” “Utg. kr.nota” “20231218” “271660” “20231218” “3097” “3” “0” “0” “1625,00” “20240101” “1111222222222222111” “1” “76”

I’m familiar with the “SFTP Upload” module to create the end product, but am struggling with how to construct the file itself, based on the formatting above.

Can someone give me some pointers?

I’ve created the following scenario in order to identify the data I needed to collect.

I’m not sure what would be helpful from me other than that at this point, so please ask me for additional information.

:slight_smile:

Perhaps a Tools > Compose a String module would help?

Screenshot_2024-01-23_230153

You can just paste the format in the module, and replace the dynamic text with your variables.

2 Likes

Thanks, samliew, I have it working now :slight_smile:

2 Likes