• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

BOE XI FTP's in binary instead of ASCII

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Carlotta McCormick
Basic Member
Posts: 7
Basic Member
3/24/2006 4:28 PM
Has anyone ever tried to run a Crystal Report on Lawson's Oracle tables through Business Objects Enterprise XI, and then tried to use BOE XI to auto-FTP the file back to Lawson? I'm trying to use this process to create an interface file, but the file gets transferred back to Lawson in binary (EBCDIC) format and it needs to be ASCII. I can't find anything on BO's website, and I've had a ticket open with them for over a month, with no luck on their end. They reference Data Integrator to fix the problem, but we didn't purchase DI and so therefore can't use that to fix the issue. Thoughts? Thanks!
Jesse
Basic Member
Posts: 10
Basic Member
8/30/2006 4:02 PM
I haven't tried your approach, but another option that will work is to create a script on the LBI machine that uses the console FTP PUT command to transfer the file in ascii back to your Lawson server. You could have the script run periodically to check for the file, and FTP it if it is present.