325
Folks I have got as far as generating the Transaction import control file, however I need to understand more clearly how to create the DTAfile. I have some experience here in that when I needed a DAT file in the past I simply did it in Excel and saved it as CSV , however I need to match this DTA file with te CTL and I cannot seem to do so.
any advice would be welcome
Regards
Bradley Georges
*This post is locked for comments
Thanks Man it worked like a dream, Our company is usind SQL Server 2008 as well as windows server 2008, but our FRx does not work with 2008 - do you know if Frx is doinf anything about this?
If you are having trouble reading the Intelligent control file, try the simple control file. It is a list of fieldnames in the proper order. The intelligent file gives you more information, such as Possible Values and which fields are required.
Also, *in general*, the order of the fields and lines is the same as the screen. So it may help you to take a screen shot showing all the fields, and keep that in front of you while you set up your spreadsheet.
Laura
HI Bradley,
I suggest you to open your control file in notepad and create your DTA file by looking at the each importfields() statement for the first time. So that you can match them easily. Once you create the DTA file for the first time, you can save it as a template(CSV) file. You can use this for future DTA file creation.
-Nagesh
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (