Comments (4)
Hi @KyleHaynes
I'll have a look at the data when I can and see what the problem might be with the schema or the application
But just to make sure I've understood the issue:
I would have thought it might be possible from importing package properties, but the only option is from a URL,
. Yes unfortunately there are 'Import' options that we used up our current scope on and didn't have time to add others (Table, and Package by file. With more funding to the project, I'm hoping to be able to add these features in to complete this.doing so just indicates it's not a valid schema.
So if you're importing Column properties, I'll have a look at the schema and see where the issue might be. The lower level errors that come back from the libraries we use can be difficult to interpret depending on what the error is, but in a future release maybe we can look at adding this as an option to display these errors in event that someone does want to try to dig further.
If there isn't a problem with the application itself, there might be some other ways to try to use the data (But again please let me know if I haven't quite understood the use case here):
- If you already have the original data and the original schema (ie: including the Column properties):
- Open a new tab with the newest data,
- Copy and paste this data, (e.g., 'Select All' and 'Copy') from the new, second table over the existing one in the first tab.
- If the table had a header row 'locked' ('Tools'-> 'Header Row') in either of the tables, and they are different, you will need to unlock the table header to include it in any 'Copy' or 'Paste'
That way it should keep the existing column properties and you can then apply to the new data.
- If you have the unzipped new data available in a folder and you have the original table and schema already in Data Curator, you could:
- clear the existing data from the table (say 'Select All' and 'Delete') - again ensure that the header row is unlocked to include it in the 'Delete'
drag and drop
the file from your unzipped folder into the blank tab
This should also keep the original schema as it is just the data that you have switched.
- It's not clear to me yet (once I have a look at the example you've supplied I might know more) whether the schema is a valid frictionless schema and is not being imported just because there is an issue with the data not matching the schema. If that is the reason, then another way to allow the import might be:
- Start the Data Curator without any existing data or schemas
- Check the number of columns that are in the schema that you have and add these so the Data Curator has the correct number of rows
- Now import the Schema
- Open the csv file (or drag/drop file in)
Let me know if any of these cases help or if there is more detail for me to consider here.
Although it doesn't cover the case you have, the 'Help' menu, does also offer some basics about use of Data Curator that might be useful.
The use case(s) you've raised here though are a new one for me. If the schema that you have is a valid frictionless schema (ie: regardless of what the data may be), it would be useful for Data Curator to still import it, no matter what state the data is in. Once I've tested your example Kyle I'll add more to this
from data-curator.
Hi @KyleHaynes
I've had at go at importing for column properties and it seems like it succeeded. Not sure if you've seen the frictionless documentation (from the help message you mentioned in Data Curator), but basically I removed the outer json for package and table, so it just showed everything under, but not including the keyname: schema
.
Data Curator will flag that it needs a certain number of columns if it doesn't match, but that's usually an indicator that it recognises the schema and it's just a matter of adding the number of blank columns required.
I've added your example schema to our Data Curator's test fixtures, here - a copy of how the json looks as just a schema
(as opposed to the original datapackage.json you supplied).
Hope it helps.
from data-curator.
@mattRedBox - thanks a lot for the detailed reply - this has worked perfectly.
Cheers
Kyle
from data-curator.
No problem @KyleHaynes. Glad it worked.
from data-curator.
Related Issues (20)
- Opening Excel wordsheet, if cancelled leaves menu item disable
- Use latest version of tableschema.js HOT 1
- Open data package .zip from local drive opens additional tab HOT 1
- Overwriting data and resetting data
- Import Data Package Properties from file
- Import Table Properties from file
- Export Table Properties
- Hashing of properties or resources HOT 1
- Help -> Data Curator Help dead link HOT 1
- Can no longer export HOT 2
- Where does data package export file go? HOT 1
- Custom Properties Type checkboxes displaying over option text HOT 1
- Open Office Calc xls format, removes blank fields shifts left HOT 1
- Default Contributor Title in Preferences is misleading HOT 2
- Link to help broken HOT 2
- link to data packages on main page incorrect HOT 1
- MacOS binaries can't run HOT 3
- Consider re-visiting display of frictionless errors on Import
- Unable to install Data Curator on my Windows HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from data-curator.