We need to export to a comma delimited format. We need double quotes around each field and a comma at the end. We have tried exporting to a *.csv format. No export or save as function seems to accomplish this. This issue keeps coming up and we had always thought comma delimted was a pretty common format. The last time I talked to BO about it, they were aware that it was a limitation but I didn’t get any indication of when this may be addressed.
The current workaround we have is moving each query to freehand sql and concatenating each field with quotes and a comma. Needless to say, this is extremely cumbersome.
Has anyone else had this problem?? Any other ideas on workarounds would be greatly appreciated!!
I have had no trouble with exporting, changing the delimiter, etc. But another option (although a lengthy one depending on your data) is to export it out to the csv format, use something like MS Access to import and Access can export to whatever you want it to. If you set up the Access dB correctly it would be a matter of double-clicking an icon and it would convert it for you!
Tim Heuer
PacifiCare Health Systems
(714) 825-5702 - office
(800) 946-4645 pin 1404017 - pager heuer_tk@exchange.phs.com
In a message dated 98-07-17 15:36:25 EDT, you write:
We need to export to a comma delimited format. We need double quotes
around each field and a comma at the end. We have tried exporting to a *.csv format.
Maria:
As you have found, the csv is simply separated by commas. There are no quotes.
May I ask a question? What is your eventual use for the data? Is it possible to configure it to read a different input file format?
If that is not the case, the it would potentially be easier to allow BusObj to export one of the basic text formats and then write a program (could even be done with BusObj scripting, but I would use VB or anything else for this task first) that would convert from csv to the file format that you need. This may be quicker than trying to make BusObj do something that it doesn’t want to do. For example, if you have Fox Pro you can export in BusObj as a dBase file, and then FoxPro can automatically generate the quote - comma delimited file that you need. It is an extra step, but has to be easier than all that Free Hand SQL!
Regards,
Dave Rathbun
Integra Solutions www.islink.com See you in Orlando in '98!
In a message dated 98-07-17 15:49:39 EDT, you write:
I have had no trouble with exporting, changing the delimiter, etc. But
another option (although a lengthy one depending on your data) is to export it out to the csv format, use something like MS Access to import and Access can export to whatever you want it to.
You can change the delimiters easily enough… if you only want one delimiter. The file format that Maria was asking about has two delimiters, quotes and commas. Character fields are in quotes, with all fields delimited by commas. In other words, the line:
Bahamas Beach FY95 Q1 15000
…would end up exported like:
“Bahamas Beach”,“FY95”,“Q1”,15000
… although if I understood correctly, the expectation is for quotes around the last item as well. A standard BusinessObjects export process could create a quote delimiter or a comma delimiter but not both at the same time. This used to be a fairly common file format. I have not needed it in quite some time, but it has come up twice in the last week for me now!
Regards,
Dave Rathbun
Integra Solutions www.islink.com See you in Orlando in '98
