In the tutorial, I mentioned a free excel plug-in called ASAP tools that has a feature to help with this. Those leading apostrophes need to be there for the import to work. If the answer to the above is “no”, then I would probably ask if every cell that has data in it in the excel import file has a leading aspostrophe? EG: ‘A1020 or ‘4 or ‘Paul McCartney. So, my first question is – Are you trying to populate data into a field that is non-updatable? That’s because Primavera calculates those fields and populates them. “Start Date” and “Finish Date” or two likely candidates that can’t be updated. Those fields with an asterisk can’t be populated with Excel data. If you look at exported data in Excel, you’ll notice that in Row 2 (the 2nd header row), some fields have an asterisk (*) in the column name. One thing to note is that not all fields can be updated from Excel.
0 Comments
Leave a Reply. |