Clearly the export functionality does not work as it it did before. Has anyone found a way to export tabular text as it was in prior releases.
Exports are delimeted by tabs instead of spaces which when uploaded to the iseries is replaced with a space. So a column which contains either 1 character or 3 character is not exported as a tabular. The single char is not padded with spaces.
Subject: Can you please be more specific
about how you believe export functionality has changed? I just tried an export from this view, and there were no tabs in it.
You talk about tabs being changed to spaces on uploading to iSeries, but this is something that happens after import and doesn’t sound like it has anything to do with Notes.
Subject: Export from Lotus
The spacing between fields is different. The offset from the first column is different. The justification of the fields with varying length data is different.
If I use the arrow keys to traverse the record I have spaces between fields in the lotus 8.0.1 version. While 8.5 version jumps to the beginning of the next field (I’m calling these tabs)
Lotus 8.0.1 has leading spaces, next field is centered.
xyz TDA D
fgh I D
Lotus 8.5
xyz TDA D
fgh I D
When uploaded to system i
8.0.1 version looks like this
xyz TDA D
fgh I D
8.5 version looks like this
xyz TDA D
fgh I D
Hopefully that is a little clearer.
thanks
Subject: Export
My previous post didn’t maintain my spacing.
8.0.1
xyz.TDA.D
def…I…D
after upload to system i
xyz…TDA.D
def…I…D
8.5
xyz…TDA.D
def…I…D
after upload to system i
xyz…TDA.D
def…I.D
Subject: Don’t use tabular text export when you need predictable results.
It looks like your problem is that your 8.5 client adds an extra space in the first column as compared to your 8.0.1 client.
However, I don’t think this is a version difference. If the column widths of the view are customized by the user, this affects how many spaces are used in the tabular output. So it will be different for individual users, even if they use the same versions of Notes. It would be better to use CSV format, or better yet, program your own export using LotusScript, so that the results are in a consistent layout.