Export of records to a Text file

customaware

Can anyone suggest a way to export records to a text file that actually includes static text on each line.

I already realise that LIST_TABLE_START and LIST_TABLE_END are not useable in a text file export.

I need to export the following data but cannot see any way to do it.

mystatictext,0,A<<LOOP_ITERATION>>,<<RecordValue1>>
mystatictext,0,B<<LOOP_ITERATION>>,<<RecordValue2>>
mystatictext,0,C<<LOOP_ITERATION>>,<<RecordValue3>>

The ultimate output should look like this.....

mystatictext,0,A1,RecordOne Data a
mystatictext,0,B1,RecordOne Data b
mystatictext,0,C1,RecordOne Data c
mystatictext,0,A2,RecordOne Data a
mystatictext,0,B2,RecordOne Data b
mystatictext,0,C2,RecordOne Data c
mystatictext,0,A3,RecordOne Data a
mystatictext,0,B3,RecordOne Data b
mystatictext,0,C3,RecordOne Data c

I don't think this can be done as html as I must end up with a text file.

RentProperty

Hi, I developed a plug-in which allows you to append any text string to a file you specify. We have used it in similar cases.
I Will PM the details. 🙂

rbross

I have a similar situation.
I have an export routine that exports data using an Export Template from a BO based on a FIND. At then end of the csv file that is created I need to APPEND one more Line. The value comes from SystemSetting.TotalCreditDue
I would like to be able to export this line as' Total Credit Due '+','+SystemSetting.TotalCreditDue
This way the text and the amount are in separate cells.

Can this be done. What I have tried so far does not work and I would rather not add the Total Credit Due to the BO that is being exported.

Any Idea's

Roger

tford

I can't think of a way to append, Roger, but I did something similar one time when building a file to export to Fusion Charts. I created a temp BO & iterated through the various parts that needed to be added to the file, then exported it.

customaware

Ask Hein above.

He sent me a plugin but I lost it when my computer and backup drives got stolen.

Would love to get a copy again. 😐

tford

Is Hein willing to make the plug-in available here on the forums?

kklosson

Not elegant but you could create a non-persistent BO and a process to populate it as needed, then export.

rbross

I think I figured it out.
Currently I have:
EXPORT AVX_Sales_Ledger TO 'PathName\FileName.csv' USING 'Export AVX_Sales Ledger'
DISPLAY DOCUMENT 'Report Name'

I found in the help you can Export using a 'Existing Query' and then use the APPEND function to append to an existing file.
I added this next line in the process.
EXPORT 'AVX Sales Ledger Credit' TO 'PathName\FileNmae.csv' APPEND
Moved the DISPLAY DOCUMENTS below this line

Just ran this and it over wrote my file?
Maybe I need to move this rule to a separate process? The Rules are on their own lines

Roger

rbross

Has anyone used the APPEND Function before?
This is what the Help Says.
"5. The APPEND clause allows you to append to an existing file rather than create a new one. For example:
EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv' APPEND "

The Help when referring to exporting using a Query has two different examples not sure which one is right. neither of them seem to work?

First reference Found
"4.The USING expression allows you to use an existing query to retrieve the data to be exported. For example:
EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv' USING Account Query"

Second Reference Found
"EXPORT action
The EXPORT action exports existing instances of the specified business object or results of running a query into a comma delimited text file (CSV file). For example:
EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv'
EXPORT ‘My Query’ TO 'c:/mydocuments/psa.csv' "

I split up the steps into different processes but that didn't work either. Looks like The DISPLAY DOC has to be in the same process as the FIND.

Roger

fjcortes

Hello, has anyone used the EXPORT action to export information to a text file ?, it seems that those instructions that appear in the help do not work.

customaware

Werner Hanekom - username Rentproperty sells two small small plugins that ease the reading and writing to text files.

ACDC

Why don't you just create a report in the report writer with the document type set as a Text Document and then use EXPORT TO FILE xxx.csv - I don't see the need for a plug-in.

Jaymer

ACDC wrote
Why don't you just create a report in the report writer with the document type set as a Text Document and then use EXPORT TO FILE xxx.csv - I don't see the need for a plug-in.

I dont see these options in 8.1

ACDC

Jaymer wrote
ACDC wrote
Why don't you just create a report in the report writer with the document type set as a Text Document and then use EXPORT TO FILE xxx.csv - I don't see the need for a plug-in.

I don't see these options in 8.1

When creating a new Document, under Document Type, there must be an option to select TEXT as opposed to REPORT or EXCEL or HTML etc etc

I don't have access right now to Version 8.1 , but it should be there

tford

This V6 sample BSV shows a simple way to accomplish this:

https://www.awareim.com/forum/d/10610

Jaymer

I ended up writing data I needed to 1 attr. in a BO.
Then using the EXPORT Action to write that field to a text file.
Then execute these commands on it to strip the extra "s and the heading line.

tail -n +2 Nav0.bat | sed s:^\x22:: | sed s:\x22$:: | sed s:\x22\x22:\x22:g > ..\incoming\Nav0.bat