2. PHPRunner General questions
  3. [SOLVED]  Export vs. Import
This topic is locked
[SOLVED]

 Export vs. Import

 		4/27/2014 8:50:55 PM
PHPRunner General questions
S
 Stucco author

Hi,
When exporting a table, the foreign key columns represented by lookup tables are replaced with the display value. However, reverse does not occur on import. So if I export a file to CSV, I can not turn around and import it back into the system. I have to do manual work to replace all the foreign key fields with their id values, which may or may not be possible. Has anyone found a way around this, besides customizing the import process and an event?
Thanks!
F
 		F5447 5/7/2014



Hi,
When exporting a table, the foreign key columns represented by lookup tables are replaced with the display value. However, reverse does not occur on import. So if I export a file to CSV, I can not turn around and import it back into the system. I have to do manual work to replace all the foreign key fields with their id values, which may or may not be possible. Has anyone found a way around this, besides customizing the import process and an event?
Thanks!



There should be no solution for this ... normally, what I did is I copied the existing view and create another view with lookup tables, but without the display value. This means that in this view, you will see the primary ID of the lookup table, and it ease the export and import.
Sergey Kornilov admin 5/9/2014

Agreed, CSV export should export Link field as opposed to Display field. We'll fix this shortly.