Importing Log Data
In the Open Standard
Sean KeeganMember for 25 years 3 months
- Created
- 3
- 2
0
I want to reorganize all the log entries in a schedule. The plan was to export via dbf to xls, manipulate the data and then reimport to P3. All goes well until I find that an empty imported log field won’t replace a log field that already contains text. Trouble is Global Calcs don’t seem to handle log-data, or else I would clear all the fields that way and then import.
Any Ideas?
Sean
Any Ideas?
Sean
3 replies
Oldest first- 0Sean Keegan ·Good suggestion, although I was hoping for something a bit more straightforward. Nonetheless, that may be the most practical way of doing it. I have experimented with importing various unprintable characters into the fields that I want emptied and that appears to work, at least when you look at the results. However, the characters are still in the fields (you can tell when you export again). If I can find the time, I will try using Batch, or maybe even ODBC.
Thanks,
Sean
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?