-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Creation of ACH/NACHA file
- Thread starter rajpawar
- Start date
I have data in the database that I need to export to a csv file. When I run the export from the list I have the following 2 situations to meet.
Lets say my data has 2 columns (a)is a numeric 10 digit field. It is not necessary that the data is 10 digits, the data could be any width upto 10 digits. Lets say my data is "123" (b) is numeric 10 digit field, data could be less that 10 digits. lets say my data is "456"
(1) I need to be able to export column (a) data and maintain the field width of 10, on export my data should have leading "blank" spaces. So the export in the above example "-------123" (without the quotes ofcourse) "- " represents blank space
(2) I need to be able to export column (b) data and maintain the field width of 10 however on export the data should have leading "0" (zeroes). So the export in the above example "0000000456" (without the quotes ofcourse)
The exported should not have any delimiter, but should maintain the character lengths. so the output of the list would look like, without the quotes, the "|" is just showing the two columns and should not be in the actual output
"-------123|0000000456"
How can I accomplish this?
Lets say my data has 2 columns (a)is a numeric 10 digit field. It is not necessary that the data is 10 digits, the data could be any width upto 10 digits. Lets say my data is "123" (b) is numeric 10 digit field, data could be less that 10 digits. lets say my data is "456"
(1) I need to be able to export column (a) data and maintain the field width of 10, on export my data should have leading "blank" spaces. So the export in the above example "-------123" (without the quotes ofcourse) "- " represents blank space
(2) I need to be able to export column (b) data and maintain the field width of 10 however on export the data should have leading "0" (zeroes). So the export in the above example "0000000456" (without the quotes ofcourse)
The exported should not have any delimiter, but should maintain the character lengths. so the output of the list would look like, without the quotes, the "|" is just showing the two columns and should not be in the actual output
"-------123|0000000456"
How can I accomplish this?
You can try with "Format string" in field element's "Formatting" settings + CSV export settings "Delimiter"
or
an additional calc element appending the values with the formatting you need and export only this calc element
or
modifying/formatting you export data with a listcsv plugin.
or
an additional calc element appending the values with the formatting you need and export only this calc element
or
modifying/formatting you export data with a listcsv plugin.