Creating a schedule from CSV

[knwlss]

Trying to create a schedule from CSV. It used to work perfectly fine before (version 4.7.4), but now all I manage to get is an empty schedule. The information from the cells is not imported.

1. Created a schedule in Excel and exported it to CSV.
   
2. Created text project parameters with the same titles.
   
3. Used pyRevit tool to create the schedule in the same category and... nothing. The schedule is created, but parameters from the category are not included in the schedule automatically.
   
   

I can't wrap my head around this issue - is it a bug or I'm doing something wrong?

[eirannejad]

Would you mind sharing the schedule so I can test? I might have broken something.

[knwlss]

Sure. Here you go - CSV and RVT files:
https://drive.google.com/file/d/1lRjnHX03zTlPZj8IOD_T8qQDk_qwbvHM/view?usp=sharing
https://drive.google.com/open?id=1E1fSQcIftBnlIunQ8kpAnE1qMkoUhy1u

[eirannejad]

Great! Let me test

[eirannejad]

Okay. CSV stands for Comma-Separated-Value meaning that the field values for each record is separated usually by a comma. Your CSV file looks like this:

The values are separated by ; so the script basically reads all of the Data1;Data2;Data3;Data4 string as the first field name as it was expecting , as delimiter by design.

I'd like to keep the CSV formatting in pyRevit consistent and always use comma. So It's be great if you can export your CSVs the same way from Revit. Make sure to select comma as delimiter:

[knwlss]

Amazing! The solution is very simple indeed. Thank you, Ehsan, and many thanks for the great product and its continuous improvement. You are awesome.