View Stats:
articy:draft > General Discussions > Topic Details
greystonefish Mar 5, 2013 @ 6:31am
ETA on excel import?
I am currently importing about 400 entries from a spreadsheet I have in google docs. Is there an eta of when we can expect the import feature? As I could focus on another aspect instead of importing all of those entries manually.
Last edited by greystonefish; Mar 5, 2013 @ 6:32am
< >
Showing 1-9 of 9 comments
athelasloraiel Mar 5, 2013 @ 10:54am 
North Mar 5, 2013 @ 11:18am 
How would Articy know whether to put what info? How would such an import work?
athelasloraiel Mar 5, 2013 @ 11:39am 
easy. One would designate where to go with what collumn.
Similar to importing CSV into Office docs - you decide what goes where.
greystonefish Mar 5, 2013 @ 11:41am 
I would assume it would reat the first line of the excel sheet as the technical name of the data, then grab all the lines in that collomn and brand them with that technical name. Then make a template containing all those fields and an entity for each line in the spreadsheet.
North Mar 5, 2013 @ 1:53pm 
Right, and that's a great theoretical way to sum it up, but now actually consider it from the perspective of the coder who has to MAKE THAT HAPPEN.

How would you designate what info goes where? You'd have to say, "This colomn is names of entities using THIS template, and this colomn is this NUMBER field of THIS Function of THIS template for Entities, and THIS colomn is locations of THIS variety using THIS template, and THIS colomn is flows that go through Journeys, but only the text of those Flows, not the names, no, that's in THAT colomn."

It's a pretty cool idea, but in the end, the amount you'd have to specify in the Import phase makes it more worth it to just copy the data over. Or export your Excel as XML, and use the Import XML function that's coming soon.
greystonefish Mar 5, 2013 @ 3:24pm 
I was actually thinking about that. What makes the most sense would be to open the spreadsheet in articy and let the user define the columns, rows and cells. So no auto discovery. I am sure there would be a way to do this with the api if I where to purchase the multi-user license.
North Mar 5, 2013 @ 3:33pm 
Hmm. That sound significantly more plausible, I must admit.
How about you create the templates in articy:draft first, and then export an empty Spreadsheet to Excel. In Excel, you can copy-paste data into the right columns and rows. Re-importing will then be relatively easy, since articy:draft knows the table layout perfectly well.

If you're happy with that, I'll enter it as a "first iteration" feature request into our system.

Some backstory: The main issue why we're neglecting the "import" aspect has to do with "branching", not in terms of branching dialogues, but branching the state of your project into two different versions. The moment you export to a Spreadsheet, you have two "fronts" at which you can progress your project: Within articy:draft, and in the Spreadsheet. So you'll end up having different versions of data for the same objects. This will result in the necessity to "merge" both versions. It's easy when one of the two hasn't changed in the meantime, but we cannot ensure that. Merging means either brute-force copying the Spreadsheet values over the project values, for example, and thus killing all changes made to the project in the meantime. Or we would need a sophisticated "conflict handling".

So for an initial import of existing data into an empty project, as greystonefish described, we may get along with just creating new copies of objects with the new values, because you're actually not expecting any existing objects in articy:draft. All other scenarios have to be very well throught-out. But... we're working on it :).

As always, thanks for your input!
Last edited by Nevigo | Kai Rosenkranz; Mar 6, 2013 @ 1:15am
greystonefish Mar 6, 2013 @ 4:59am 

That would work perfectly. I like doing some work from my android tablet as well So I can import from the same spread sheet multiple times (after I import I wipe the spreadsheet clean, so my next import will only be new items).

Thanks for the response!
< >
Showing 1-9 of 9 comments
Per page: 15 30 50

articy:draft > General Discussions > Topic Details
Date Posted: Mar 5, 2013 @ 6:31am
Posts: 9