Can we export CSV file from Dataport?

kenl

Hello,

Can we export CSV file from Dataport?
When I run a dataport and export, click file name "...", the dialog file type is pre-set as "Text Files (*.txt)". Can we set it into other format (like CSV) ?

Btw, for dataport, which file format does it support (for import and export)?

Best regards,
Ken

pri_1_ranjan

ya u can export files in .csv format.
to get a better output u have toset some of the property of the dataport such filedelimeter to be set to comma type etc etc

dataport supprorts only flat file format ie .csv , .txt

kriki

You can also use fixed width.

Best format is tab-seperated (Property FieldSeparator = <TAB> (including < and > and TAB in uppercase). (the , or ; can be used in the texts to import or export and in this case the dataport goes nuts)

some other discussion on dataports:

http://www.mibuso.com/forum/viewtopic.php?p=21901#21901

kine

You mean to change the default file filter? No, you cannot change it. There is only one way - change the Request form, add new Text box, add OnAssistEdit code with use of Common Dialog Management to select the file (you can enter the file filter there which you need)....

kenl

Yeah, I follow Kine's suggestion and I am able to set the file type filter now.

Thank you all of you