Rocket Software Homepage
Forum Home Forum Home > AccuTerm Knowledge Base (read only) > File Transfer
  New Posts New Posts RSS Feed - Excell file transfer inserting col1
  FAQ FAQ  Forum Search   Register Register  Login Login

The AccuTerm forum has moved. Go to community.rocketsoftware.com to register for the new Rocket forum.

Forum LockedExcell file transfer inserting col1

 Post Reply Post Reply
Author
Message
bytebybyte View Drop Down
Newbie
Newbie


Joined: August 10 2016
Location: Australia
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote bytebybyte Quote  Post ReplyReply Direct Link To This Post Topic: Excell file transfer inserting col1
    Posted: August 10 2016 at 6:31pm
We are transferring data from a D3 multivalue database.   The data is transferred to an Excel spreadsheet  and the values in row 1 are being replaced with col1,  col2 col3  for excell cells a1 , a2, a3.
Version of AccuTerm 7.0d sp2 (7.0.1412).  

Alex
Alex
Back to Top
PSchellenbach View Drop Down
Admin Group
Admin Group

Moderator

Joined: December 15 2003
Location: United States
Status: Offline
Points: 2150
Post Options Post Options   Thanks (0) Thanks(0)   Quote PSchellenbach Quote  Post ReplyReply Direct Link To This Post Posted: August 11 2016 at 9:00am
Hi Alex -

There is an option in FTD (or FTEXPORT) to enable or disable the first row of the worksheet as a heading row. If you disable this you should see the first row of data on the first row of the worksheet. Otherwise the first data row would be on the second row of the worksheet.

Thanks,

Pete

Back to Top
bytebybyte View Drop Down
Newbie
Newbie


Joined: August 10 2016
Location: Australia
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote bytebybyte Quote  Post ReplyReply Direct Link To This Post Posted: August 11 2016 at 5:33pm
Pete,

Thanks.

The problem we have is some PC are having row data replaced by "Col1'.    Process has been running for years & recently we have some PC's having the problem.

The D3 data to be transferred to excel:

0001                   21487
0002                   For NEW MOTOR VEHICLE
0003                   NEW
0004                   N
0005                   GOVERNMENT
0006                   BRISBANE ISUZU
0007                   26 KERRY ROAD
0008                   ARCHERFIELD  4108

The Excel s/sheet finishes with:
Col1 Col2
For NEW MOTOR VEHICLE
NEW
N
GOVERNMENT
BRISBANE ISUZU
26 KERRY ROAD
ARCHERFIELD  4108


One PC window7 is Ok,  a 2nd PC using WIndows 10 has the 'Col1' being inserted.

Alex

Alex
Back to Top
PSchellenbach View Drop Down
Admin Group
Admin Group

Moderator

Joined: December 15 2003
Location: United States
Status: Offline
Points: 2150
Post Options Post Options   Thanks (0) Thanks(0)   Quote PSchellenbach Quote  Post ReplyReply Direct Link To This Post Posted: August 11 2016 at 5:38pm
Hi Alex -

First thing - update your version of AccuTerm to 7.1c-sp2 (the current release). You will probably see an error when you do the transfer. Normally, AccuTerm uses Automation with Excel to convert the text data from D3 into an Excel worksheet. But if Excel is not installed, there is a fallback converter that attempts to do the conversion. Its quite old and unreliable. The current version of AccuTerm will return an error from Excel if Excel is installed instead of using the fallback. Once you see the error, it will probably help sort out the solution.

Thanks,

Pete

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.