How to import CSV to databasejoin list?

[bluetoothbj]

Dear Sir,
How to import CSV to a databasejoin list?
Thanks.

 

[lousyfool]

If importing to create a new list: see Wiki and the note there

Note: CSV import is not going to work if your list has joined data. CSV files by their nature represent a information about a single row of data, it doesn't contain relationship information and thus we would find it very hard to guess the implied relationships in the CSV data when it comes to re-importing it back into a relational database.

If importing data into an existing list: do a CSV export to see what you're getting, means what you'll need for an import.

 

[bluetoothbj]

1." CSV import is not going to work if your list has joined data",does it mean we couldn't import CSV data to a list which has joined data?
2."If importing data into an existing list: do a CSV export to see what you're getting, means what you'll need for an import".Does this procedure only used for a single list which without joined data?

 

[lousyfool]

1. You quoted a sentence, then basically repeated it and asked if that's what it means. What answer do you expect now?

2. Whatever list you have, make a test CSV export (create a few test records first if the list is empty). What you get should be your "template" for a CSV to be imported. Do some testing with raw values versus others.

 

[bluetoothbj]

OK,Thanks lousyfool.