« previous next »
Pages: [1]   Go Down

Author Topic: Export Item Data Fields  (Read 1196 times)

0 Members and 1 Guest are viewing this topic.

Offline ctrullTopic starter

  • Active Member
  • **
  • Posts: 7
  • Country: 00
  • Gender: Male
Export Item Data Fields
« on: Sep 12, 2023, 22:13:46 PM »
When I export F Time and E Time, the cells come through as time and not a number.  Is there a way to get the times to come through the txt or csv file as a number and not a time?
Logged

Offline Jona

  • Senior Member
  • ****
  • Posts: 256
  • Country: us
  • Gender: Male
Re: Export Item Data Fields
« Reply #1 on: Sep 13, 2023, 19:29:43 PM »
You could set the decimal places to 0.
Logged

Offline cadbyken

  • Premier Member
  • *****
  • Posts: 5345
  • Country: us
  • Gender: Male
Re: Export Item Data Fields
« Reply #2 on: Sep 13, 2023, 19:35:10 PM »
You can use a file as a template with the correct formating and import your file.  It is called Power Query.  I haven't used it yet but it is referred to here http://www.xtracad.com/forum/index.php/topic,17097.msg112019.html#msg112019
Logged
Ken Taylor - Atlantic Constructors, Inc
BIM Technology & Database Manager
Revit - not ready for Primetime given all of the add-ons, work arounds, and general issues with Fabrication in Revit.  Tired of them taking our money for little results.

Offline cnash

  • Premier Member
  • *****
  • Posts: 1422
  • Country: us
  • Gender: Male
    • William R. Nash Companies
Re: Export Item Data Fields
« Reply #3 on: Sep 13, 2023, 20:45:57 PM »
What kind of number are you trying to push out? Hours? Minutes? Jona has the right idea here.
Logged
Christopher Nash
Operations Software & Process Manager
William R. Nash, LLC.

Offline tvtinbender

  • Full Member
  • ***
  • Posts: 79
  • Country: us
  • Gender: Male
Re: Export Item Data Fields
« Reply #4 on: Sep 13, 2023, 22:28:33 PM »
In my exports, I want hours. So what I do is add Item Installation Time and then a calculated field right below that. On the Item Installation Time, I set it to minutes with 0 decimal places and in the Column tab, I uncheck "Output" so this data does not show in the data export. Then in my calculated field, I check "Output" and set the calculation to (Item Installation Time / 60). This will give decimal hours for my exports.
Logged
Troy VanSanten
Hermanson Company
Pages: [1]   Go Up
« previous next »