Export *some* entries to Excel and re-import into the correct entries

[xeint]

Hello,

I'm new to dbForge and need little help.
I have a database which contains data in 4 languages:
index, organize, text

Code: Select all

1, 10, text_EN_1
2, 20, text_ES_1
3, 30, text_PT_1
4, 40, text_IT_1
5, 50, text_EN_2
6, 60, text_ES_2
7, 70, text_PT_2
8, 80, text_IT_2

and so on.

Now, I would like to export all Spanish data for correction and re-import these once the task has been completed. But I need to make sure, that what was index 4 before the export, becomes index 4 after the import again.
The import assistant offers an ´update´ option for import, but does not explain how the software matches data to the existing entries !?

I can imagine that there's more then one way to solve that.
I really appreciate any suggestion on this task.

Thanks !

[Viktor]

You can correct data directly in table, and it is not necessary to export data and import it afterwards.
Execute “retrieve data” on the table from the popup menu in Database Explorer. After this you will be able to edit data as you do this in Excel.

[xeint]

Thanks for your answer Victor.

But we do not want to grant translators access to the full table. We want them to translate their language and once they completed the job, it should be transfered back into the database.

[alexa]

Once the data in the 4th column (optionally, 3rd column) of the previously exported file has been replaced with the translated text, please perform the following:

1. Invoke the Data Import wizard.
2. On the 'Source file' page of the 'Data Import' wizard, select the import format and the modified file.
3. On the 'Mapping' page, select only the columns that were not changed. In your case, that should be the first 3 columns. (If the text in the 3rd column was also modified, please select only the first 2 columns).
4. On the 'Modes' page, please select the 'Update' option.
5. Complete the wizard and perform import.

Please let us know if you succeed on this.

[xeint]

Thank you Alexa !

I'm a bit confused, because you want me to mark those which did no change - I tried the opposite, because it sounds more logic to me. But anyway, we both know who has more experience

Following your explanation: So, I just need to make sure that the export includes the unique index and then mark the index only during import ?

[alexa]

Following your explanation: So, I just need to make sure that the export includes the unique index and then mark the index only during import ?

Yes, in case you export all 4 columns, you have to then (in the Data Import wizard) select the columns that are included into the unique index.

I guess, it will be enough to select just the first column during import.