Format of text file for dataports of two tables

vyanku · 2006-12-07

Hi
If we create one dataport having two different data Items.
for ex. table1main and table2sub.
Both tables have different fild list for import.
Ex. table1main have No.,date. and table2sub have name,amount,time.
Then how is the format of data in the text file from which we import data?

Savatage · 2006-12-07

an easy way to to enter some data in the main & sub
then used your dataport to export the data.
then look at the file it created and you'll see how it needs to be setup.

vyanku · 2006-12-07

there is value in data saperator field <<NewLine><NewLine>>

And when I export data It shows me first table line then one line break then other table data.

Is it means I have to follow this format to import data in the table?
But it shows me every field in " ","",format
Is this method i have to use to import data. if yes It is very difficuelt method is there any other method?

Savatage · 2006-12-07

for example if you were doing a header & a line

first part of your data file would be all the headers & then all the lines.

See here how we handle it
http://www.mibuso.com/forum/viewtopic.php?t=12718

Howdy, Stranger!

Quick Links

Categories

Format of text file for dataports of two tables

Comments