topic Re: Export / Import Interactive Schedules in Collaboration with other software

Export / Import Interactive Schedules

Anonymous — Wed, 19 Nov 2008 16:02:32 GMT

Hi...

Is there a way where I can export the schedule we have generated...
then open it in another program (i.e. excel)
edit the data
then reimport it back to repopulate the schedule fields?

I see the Schedule exports into xml
I can open xml in excel but it doesnt retain its layout
ideally i would like to open xml in another program
edit fields and then reimport the xml back to archicad

Re: Export / Import Interactive Schedules

Karl Ottenstein — Wed, 19 Nov 2008 17:53:56 GMT

You have several options.

With the schedule displayed, you can use File >Save As and saved to Tabbed Text, which will open properly in Excel.

From Publisher, you can publish the schedule as a List. Same thing.

Karl

Re: Export / Import Interactive Schedules

Steve Jepson — Fri, 05 Dec 2008 06:53:01 GMT

C:\Program Files (x86)\Graphisoft\ArchiCAD 12 final\Help\Files\wwhelp\wwhimpl\js\html\wwhelp.htm

Saving from a Schedule Window (Interactive Schedule)
Schedules can be saved in the following formats: Tabbed text, DWF, and PDF. From a PC, with MS Office, you can also save in .doc and .xls formats.

I don't think I have ever gotten this to work.

I can save Lists, but not interactive schedules.
I can Publish it to XL.

I have and interactive schedule open. I click File>Save As, and nothing happens.

I had trouble with this before and the trouble seemed to be that the name of my schedule was 8" Concrete Walls. It was the " that I thought was the problem.

Now I have changed the name and I still can't get it to work.

Re: Export / Import Interactive Schedules

Barry Kelly — Fri, 05 Dec 2008 07:12:09 GMT

I just saved one in .XLS format from V12 with no problems at all.
Barry.

Re: Export / Import Interactive Schedules

Laszlo Nagy — Fri, 05 Dec 2008 12:59:32 GMT

Interesting, I tried and it does not save as XLS for me either, with AC12 on Vista 32-bit. I have MS Office 2003 on my system. What do you guys have?
I even managed to crash the program while trying.

Re: Export / Import Interactive Schedules

Steve Jepson — Fri, 05 Dec 2008 15:52:22 GMT

I am using Microsoft Office Small Business 2007
Windows XP Pro x64 Edition 2003 SP 2

Re: Export / Import Interactive Schedules

Laszlo Nagy — Fri, 05 Dec 2008 16:00:57 GMT

So our systems and Office versions are different and still we both have problems. That may be a bug.

Re: Export / Import Interactive Schedules

Anonymous — Sat, 06 Dec 2008 17:44:23 GMT

and to Import a schedule from excel???
I couldn't find any options about that

Re: Export / Import Interactive Schedules

Karl Ottenstein — Sat, 06 Dec 2008 18:31:10 GMT

fabricfo wrote:
and to Import a schedule from excel???
I couldn't find any options about that

Not possible. Why would you want to do it? Might be able to give you another method to accomplish your goal.

Karl

Re: Export / Import Interactive Schedules

Karl Ottenstein — Sat, 06 Dec 2008 18:32:53 GMT

Help wrote:
Saving from a Schedule Window (Interactive Schedule)
Schedules can be saved in the following formats: Tabbed text, DWF, and PDF. From a PC, with MS Office, you can also save in .doc and .xls formats.

Works fine for me on Mac. Save As dialog format choices attached. Did not try on XP to see if the Office formats are available. (Tabbed text is adequate.)

Cheers,
Karl

Re: Export / Import Interactive Schedules

Anonymous — Sat, 06 Dec 2008 19:23:51 GMT

I was trying to import a schedule of the areas of the rooms...
I will learn to use the Archicad Schedules instead...
Thanks

Re: Export / Import Interactive Schedules

Laura Yanoviak — Thu, 11 Dec 2008 18:20:51 GMT

Steve wrote:
C:\Program Files (x86)\Graphisoft\ArchiCAD 12 final\Help\Files\wwhelp\wwhimpl\js\html\wwhelp.htm

Saving from a Schedule Window (Interactive Schedule)
Schedules can be saved in the following formats: Tabbed text, DWF, and PDF. From a PC, with MS Office, you can also save in .doc and .xls formats.

I don't think I have ever gotten this to work.

I can save Lists, but not interactive schedules.
I can Publish it to XL.

I have and interactive schedule open. I click File>Save As, and nothing happens.

I had trouble with this before and the trouble seemed to be that the name of my schedule was 8" Concrete Walls. It was the " that I thought was the problem.

Now I have changed the name and I still can't get it to work.

I've had it work in the past, no problem -- now in AC12, nothing happens when I click File > Save As. In AC11, it crashes if the IS contains a list of more than 200 or so elements. I'm in BIG TROUBLE, because we're putting together a rather large FF&E package -- all of my previous tests worked when listing fewer than 200 elements, now that the project has begun and we have about 1000 elements per Story, I can't get it to work in AC11 (crashes) nor AC12 (nothing happens)...

Re: Export / Import Interactive Schedules

Laura Yanoviak — Thu, 11 Dec 2008 18:50:15 GMT

Karl wrote:
From Publisher, you can publish the schedule as a List. Same thing.

Karl

THANK YOU KARL!!!
I am able to Save As an XLS file from the Publisher (and I can create more than one spreadsheet at a time)...I would have never thought of it myself (and AC Help is terrible on the subject).

Re: Export / Import Interactive Schedules

Barry Kelly — Fri, 12 Dec 2008 01:12:21 GMT

These are the options I have when I "Save As" from the interactive schedule window.

Running Windows XP Pro & MS Office Excel 2003.

Barry.

Re: Export / Import Interactive Schedules

Erika Epstein — Mon, 15 Dec 2008 03:13:34 GMT

Karl wrote:
fabricfo wrote:
and to Import a schedule from excel???
I couldn't find any options about that
Not possible. Why would you want to do it? Might be able to give you another method to accomplish your goal.

Karl

Karl, since you ask...
I've often wished we could import/export xml files. This comes up often when working with a team. Some team members are doing tasks that involve schedules such as furniture and other specs. They shouldn't have to learn archicad to do this, nor do we want them tying up a license. We would like to be able to export a file such as a furniture or equipment schedule and have them as part of their work edit it as they add cost, spec the items etc. Then we would like to import their changes/updates back into the main archicad [BIM] file.
We can export a schedule as an xml file as you note, but we can't import back the xml file into archicad.
Care to whip up an add-on?