Is there someone who could help me write a code to export data from SMART to SharePoint in a specific order of columns?
We have to edit our data after importing in SMART Desktop. A lot of team members need to work on their data, which means we have to get the data out of SMART Desktop, since not everyone can edit in SMART. At the moment we export an “all data” query, manually re-arrange the columns and then upload to a SharePoint spreadsheet that everyone in the team can access. Then lateron, the data assistant checks in the spreadsheet which edits have been made, and enters them in SMART.
It would be very helpful if we can make this process more efficient. I was thinking about a code that would automatically re-arrange the columns for us and make a certain export every week. That would help us to keep the spreadsheet updated, so teams can easily edit their data.
This is a great question. Do you have a bit more detailed information or a sample of what you require? Is it that the CSV file needs the columns directly seperated?
I think there would be a way to potentially create the code on the Sharepoint side (so add query results to a folder and then the code rearranges the columns as defined?)
Just want to ask for more clarity to see how we could be of assistance in creating a solution
Hi Denton,
SMART export the data to CSV on alfabetic order. This is not easy for our team to read, since the columns come in a different order on their data collection tablets.
We do intensive monitoring of carnivores, so at the moment I manually move the columns “observer”, “carnivore group” and “carnivore ID” to the front so people can better understand which observation they are looking at.
It would be great if we could automatically re-arrange some of these columns, or even automate the whole process of uploading the most recent data from SMART to SharePoint.
At them moment, our data assistants across 3 sites export data every week and upload it manually to SharePoint.
I could email you the template of our SMART CSV output and SharePoint template if that helps.
Hi,
How do I change the column order in a report template?
It is also over 3000 datapoints, so I would think it will probably not be able to run in a report.
You can create new report, then add your query data set to the report.
Add your data set to report layout, then you can move or restructure you table column by using (right click on the column you want to move) Cut, then Insert copied column.
Afther that, you can export your report as html, it can open with excel, remove the first row then save as CSV.
@LiliSadikin thanks it worked!
I was trying to change the columns in the XML source code. That would be much easier. But somehow when I change the code and save it, it doesn’t change anything in the table or report output.
Have you worked with the XML source code before?
Any clue how to make the edits in the code,instead of moving the columns around manually?
