Problem
User exported data, then imported it
back. Various problems- data has shifted, items don't match up any more, missing text.
Diagnosis
Troubleshooting questions:
- Did the user open the export file with
Word or Excel?
- Did they import into a file that already has data in it?
- Are there problems when importing
a layout, or seeing posting
problems in
a file recently exported?
- None of the above?
Solution
Answers to the above:
- Word and Excel will sometimes shift data, even if you just open and
close without a save. This seems to happen most often in huge data files. Opening in Excel and then saving
will also drop text in long text fields (more than 255 characters). If user wants to
look at data, look at a COPY of the file.
- If there are already items there, there may be
2 items with the same id number. In that case incoming items get
new numbers, and won't line up anymore with other places they may be used.
- See those linked answers.
- Best bet is to send us the export file, so
we can try it here.
NOTE-- Starting with version
2.3 of Goldenseal business
management software we have "frozen" the file format,
so users will not need to export/import data
when going to a new version.
Comments
Entered 8/9/01 by Dennis. Updated 11/4/2010.
|
