Comments (3)
The problem is in the Excel Spreadsheet, rather than the code parsing the column.
Referred to @rwendler
from aspace-import-excel.
I can easily change all the indicator_[n] columns from format "General", where Excel tries to recognize dates and convert them, to format "Text", where it leaves what you type alone. I suspect it would desirable (or at least not harmful) for most if not all columns that do not have controlled lists of values to be formatted as Text. Bobbi, does that seem right to you? If there is any question, I'd prefer that the ASWG specify column formatting and I can make it so. Meanwhile, here's a revised spreadsheet with Text formatting applied to columns for indicator_1, indicator_2, and indicator_3, which are columns Z, AC, and AE in this file.
aspace_import_excel_template-rev_2017-07-13.xlsx
from aspace-import-excel.
The reporting user is satisfied with the change; the template file has been updated
from aspace-import-excel.
Related Issues (20)
- Problem with ASpace Service starting after Plugin install HOT 12
- Processing stopped at row 6 [Error(s) parsing Excel File No processible data rows found!] HOT 11
- The file you have chosen is not an Excel Spreadsheet HOT 3
- Uploading Multiple Digital Objects to Archival Objects as import HOT 2
- Enhancements when importing archival objects with containers? HOT 3
- Ref ID not found error HOT 3
- please help with install issue HOT 20
- install issues, Bundler could not find compatible versions for gem "bundler" HOT 51
- Updating existing archival objects? HOT 3
- Search/match for agents is too loose HOT 1
- Importing Language to Archival Object Basic Info Rather than Language Notes HOT 2
- Could not find gem 'rubyXL (= 3.3.29) java' with aspace-import-excel v2.1.17 on AS 2.6.0 HOT 5
- Duplicate Entries after Import and long import time HOT 3
- Series of error upon import HOT 7
- xlink namespace in extref causes scopecontent note import to fail HOT 5
- Compatibility with AS v2.7.0? HOT 9
- Ref ID not importing into resource record HOT 2
- Language of materials note not importing into resource record HOT 6
- Won't Close If You Miss The File First Try
- Could not find gem 'rubyXL (= 3.3.29) java' with aspace-import-excel v3.0.4 on AS 2.8.1 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 aspace-import-excel.