My advice is to start by exporting a small sample representative of the data you wish to import. This gives you a template XLS file into which you can cut and paste your required import data. Unfortunately, this is not as simple as it sounds. You need to ensure the Excel data is in the same format as that exported. Also, when exporting/importing relationships and resources etc, the export produces multiple tabs (sheets) in the one export XLS file. Thus, all tabs must be compiled correctly. E.g. there is one row of data for each relationship for a single task.
Member for
18 years 1 monthRE: to import excell files(.xls) to P3e
Hi shearad.
Could you elaborate your problem sothat we can help you better?
Thanks
Member for
17 years 10 monthsRE: to import excell files(.xls) to P3e
Ms. Shaerah,
Also could be due to requirement in P5 (the correct terminology apparently) of having superuser access to import. Cheers.....
Member for
19 years 6 monthsRE: to import excell files(.xls) to P3e
Hi,
My advice is to start by exporting a small sample representative of the data you wish to import. This gives you a template XLS file into which you can cut and paste your required import data. Unfortunately, this is not as simple as it sounds. You need to ensure the Excel data is in the same format as that exported. Also, when exporting/importing relationships and resources etc, the export produces multiple tabs (sheets) in the one export XLS file. Thus, all tabs must be compiled correctly. E.g. there is one row of data for each relationship for a single task.
Again, export to XLS and see what I mean.