Import CSV file > Firing positions confused with the origin man

[Pyro_84860000]

Likes:

|

Share this thread

When I export a show (Export > Export script as Finale Generic csv…), I have in my csv file the names of my positions (column Position Name) and the coordinates of my positions (column Coordinates). Why when I import this file (Import > Import into a new show… > Do-it-yourself CSC file…), my positions are not at their place and are confused with the origin man?

[Will]

Likes:

|

Share this thread

Hello, you found a bug.  We recently added more information to the coordinates field of the Finale Generic CSV export file format (adding the angle of the position and the angle of the effect in 3D), but we forgot to make import handle the extra information if you try to import Finale Generic CSV.  So at this moment, if you export a Finale Generic CSV and reimport it, all the positions appear at coordinates 0, 0, 0, the location of Origin Man.

 

(For specifications of the coordinates information in Finale Generic CSV, see “Coordinates” in Table 3 of https://finale3d.com/documentation/finale-generic-csv-file-format/).

 

An immediate workaround if you are in a pinch is to edit the “Coordinates” column of the Finale Generic CSV spreadsheet.  Each cell in this column contains nine floating point numbers.  Delete the last six, and then the file will import with correct position coordinates.

 

I have fixed the problem already, and a new beta release will be coming out this week with the fix.

 

The fix, however, just imports the position coordinates; it doesn’t import the position angles or 3D effect angles.  We have never round-tripped that information through Finale Generic CSV before.  We could do that, but it would be a bit more work.  If the ability to export and reimport position angles and 3D effect angles is important to you, could you describe the use case so we can understand the context?

 

 

 

[Pyro_84860000]

Likes:

|

Share this thread

Hello,

 

Thank you for your answer.

 

In our workflow, we program our shows in others softwares. In these softwares, we have of course the angle of the positions and the angles of the effects in 3D. Then, we  import a csv file into Finale 3D to get the simulation. So yes the ability to import positions angles and 3D effect angles is very important for us! 🙂

[Will]

Likes:

|

Share this thread

Hello,

 

Some good news.

 

We have implemented support for importing position angles and effect angles along with position coordinates, all in the “Coordinates” column of an imported CSV file.  Documentation is here:

 

Importing shows basic instructions

 

The imported data is in the same format as the exported data in the Finale Generic CSV format, described in the Coordinates row of Table 3 of:

 

Finale Generic CSV (full show export format)

 

Since effect angles in the script window are in a PAN, TILT, SPIN representation, which is different from the imported and exported HEADING, PITCH, ROLL representation, we just added documentation on pan, tilt, spin here:

 

Effects coordinate system: pan, tilt, spin

 

For reference, the description of heading, pitch, roll is here:

 

Positions coordinate system: heading, pitch, roll

 

The new import feature will be available in a beta this week, by the end of the month (June).  It is actually in the current beta from two days ago, but the current beta has an unrelated angles but so I would suggest waiting for the update this week.

 

Will

 

 

 

[Pyro_84860000]

Likes:

|

Share this thread

Hi Will,

 

Thank you for these good news! We will test the beta version as soon as it is released.

[Author]

Posts