3

For phase one of this integration project, the requirment is to export data to a fixed-width fields type flat file and place it in a specific folder on the network, where the legacy system with pick it up.

I was thinking of using and automated Dataloader job via a batch file, but I don't see how it can produce the file we need. Perhaps more research is needed :)

If this is not possible, would the next best approach be to create our own program in C# or other and use the SF API to do what we want?

Any other options?

Thank you.

Improve this question

1 Answer 1

Reset to default
2

As far as I know, the Apex Dataloader only exports to CSV, so you would need to turn to a third-party.

Off of the top of my head, I know the Jitterbit Dataloader provides the functionality to export to both fixed width and character delimited file formats. You can grab it off of the AppExchange, or find more information here:

http://www.jitterbit.com/solutions/salesforce-integration/salesforce-data-loader/

Improve this answer
3
  • Thank you Mark. I will take a look at that option and see if it meets my requirements.
    – Quade
    Commented Feb 15, 2014 at 21:57
  • 1
    For others benefit, I checked out Jitterbit andd it looks like a great product. I installed and tried it and it's very easy to use and quite flexible. Unfortunately, the cost is quite prohibitive. Their subscription starts at $1000/month for connections of up to 2 applications!
    – Quade
    Commented Feb 18, 2014 at 16:43
  • 1
    The Jitterbit Data Loader has a free version that should cover the requirements you outlined.
    – Thomas Taylor
    Commented Apr 15, 2014 at 22:07

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .