Scott,

Importing those Excel 2007 files completely destroyed the OWL file. I
had to add </rdf:RDF> to the end of the file to get it to open without
errors, but the import process overwrote all my top two tiers of
classes so all I was left with was about 10% of my bottom tier of
subclasses and any instances. I tried rolling back to a local history,
but that file was corrupt too. the lesson here is to save my own local
versons several times a day so I can roll back. I did this on a
previous project when my file went to OWL Full when I wanted OWL Lite
so I guess I relearned a valuable lesson. Lucky for me there was no
deliverable for this file, it was just a "for fun" project.

On Jun 4, 12:07 am, Scott Henninger <[email protected]>
wrote:
> Bradley;  Composer supports Excel 2003 (.xls) files.  Excel 2007
> (.xlsx) is currently not supported.  Could this be the issue?
>
> To open an Excel 2003 file as a model, place it in the workspace and
> open directly (Open With... TopBraid Excel Files).  This will create
> default RDF/OWL definitions for the spreadsheet contents.
>
> The unnamed0 is not a problem, but ending a prefix definition with ":"
> instead of "#" or "/" could be.  If opened as a TopBraid Excel File,
> there should not be problems with URI or prefix definitions.
>
> -- Scott
>
> On Jun 3, 8:43 pm, Bradley Shoebottom <[email protected]> wrote:
>
>
>
> > I have an Owl file that when I was trying to import a list of Excel
> > instances, my system went "funny". My graphics card driver crashed and
> > required a reboot. When I opened my file again I got this error: !
> > MESSAGEhttp://www.owl-ontologies.com/unnamed0(line1098column
> > 21317): XML document structures must start and end within the same
> > entity.
> > Looking at a text verison of my file, here are the first few lines:
> > <?xml version="1.0"?>
> > <rdf:RDF
> >     xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#";
> >     xmlns:j.0="http://www.owl-ontologies.com/
> > unnamed0#npCN0249Ba8X1Arial1Arial1Arial1Arial0_00_Red00.00_0.000.00_Red0.00­72_0__0_-
> > ___._0__0_-___:"
> >     xmlns:owl="http://www.w3.org/2002/07/owl#";
> >     xmlns="http://www.owl-ontologies.com/unnamed0#";
> >     xmlns:xsd="http://www.w3.org/2001/XMLSchema#";
> >     xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#";
> >   xml:base="http://www.owl-ontologies.com/unnamed0"; >
>
> > It does not seem to like unamed0 for a URI.
> > This line seemed to be inserted when I imported the Excel file.
> > xmlns:j.0="http://www.owl-ontologies.com/
> > unnamed0#npCN0249Ba8X1Arial1Arial1Arial1Arial0_00_Red00.00_0.000.00_Red0.00­72_0__0_-
> > ___._0__0_-___:"
> > Lines like it appear in 2 other spots with the list of instances
> > crammed into the context of a Class that the file was not supposed to
> > be loading into eg TotalJobCode was supposed to load into that class
> > and not LASTREFTIME class
> >  <rdf:Description
> > rdf:about="#eV__LASTREFTIME__DOqS186S189S193S194S196S199S206S208S209S210S21­1S212S215S221S222S223S224S225S226S227S228S229S230S231S233S234S235S236S237S2­40S242S243S245S246S247S252S261S265S267S268S272S276S277S282S283S284S287S288S­289S290S291S292S293S294S296S297S301S303S304S305S306S307S308S310S311S312S313­S314S315S316S317S318S319S320S321S322S323S324S325S326S327S329S330S331S332T00­2T003T004T005T009T010T011T012T013T014T015T016T017T018T019T020T021T022T023T0­24T031T032T033T034T035T037T038T039T040T043T051T052T053T058T061T062T063T064T­067T069T070T074T076T077T078T079T080T084T086T087T089T090T091T092T094T096T108­T109T111T112T114T117T118T119T120T121T125T126T128T129T131T133T134T135T136T13­7T138T139T140T142T143T144T145T147T149T151T152T154T156T159T160T162T163T164T1­66T167T168T169T171T174T179T183T185T195T197T199T200T201T202T203T204T207T213T­215T216T217T218T219T220T221T222T224T225T226T228T229T230T231T232T233T234T235­T236T237T238T239T241T242T243T244T245T246T248T249T250T251T252T253T254J____To­talJobCodeT211C003C008C012C014C018C032C033C034C037C041C043C050C055C056C066C­069C074C080C090C095C102C103C108C111C125C138C139C145C150C153C155C156C157C159­C160C161C163C166C170C172C179C180C181C182C187C192C193C194C197C198C205C206C20­8C209C212C215C216C217C228C229C238C239C240C241C242C243C244C245C248C249C250C2­52C253C254C257C259C260C261C263C266C269C271C272C273C275C276C277C278C279C280C­281C282C283C284C348C354C356C358C360C364C366C367C374C376C378C388C392C399C411­C412C413C414C415C416C421C422C423C424C425C428C432C433C434C435C436C437C439C44­0C441C442C444C445C449C450C456C457C458C459C460C466C470C471C473C474C475C477C4­78C479C480C481C482C483C484C485C486C488C489C493C494C496C500C501C502C503C504C­505C506C507C508C509C510C511C512C513C514C515C516C517C518C519C520C521C522C523­C524C525C526C527C528C529C530C531C532C533C534C535C536C537C538C539C540C542C54­3C544C545C546C547C548C549C550C551C552C553C554C555C556C557C558C559C560C561C5­62G001G002G003G004G007G008G022G029G030G031G032G034G035G036G037G038G040G041G­043G044G045G046G047G048G050G052G054G056G057G061G065G070G072G074G075G076G079­G080G083G086G091G095G096G097G098G099G104G106G108G111G118G119G120G121G122G12­3G124G126G128G129G130G132G133G134G135G138G140G141G142G143G150G151G152G153G1­54G156G157G159G160G161G162G163G167G169G173G175G176G182G183G185G186G187G188G­193G194G195G198G199G203G204G206G207G208G211G212G213G217G221G230G232G234G235­G236G237G238G240G241G242G243G244G245G246G247G248G249G250G251G252G255G256G25­7G258G259G260G261G262G263G264G265G266G267G268G269G270G271G272G273G274G275G2­76G277G278G279G280G281G282G283G284G285G286G287G288N001N004N005N007N008N009N­010N011N012N013N018N019N021N022N023N024N025N030N031N034N035N036N038N039N040­N044N046N049N050N053N059N063N065N066N067N070N071N072N073N077N080N081N082N08­3N084N085N086N087N088N093N094N095N096N097N098N099N101N102N105N106N107N109N1­10N111N112N113N116N118N122N124N126N127N129N131N132N133N134N135N138N139N140N­141N149N151N152N153N154N155N156N157N158N159N160N161N162N163N164N165N166N167­N168N169N170N172N173N176N177N178N179N181N182N183N184N186N187N188N189N190N19­1N192N193N194N195N196N197N199N200N202N203N204N205N206N207N209N210N215N216N2­17N218N219N223N224N225N226N227N228N229N230N231N232N233N234N235N236N237N238N­239N240N241N242N243N244N245N246N247N248N249N250N251N252N253N254N255N256N257­N258N259N260N261N262N263N264N265N266N267N268N269N270N271N272N273N274N275N27­6N277N278N279N280N281N282N283N284N285N286N287N288N289N290P001P002P003P004P0­06P007P008P009P010P012P013P014P015P016P017P018P019PEN0PO11S003S006S007S009S­011S022S023S024S025S026S027S028S029S030S031S032S033S036S037S041S049S050S051­S052S057S060S062S063S065S068S072S075S076S077S078S079S081S086S087S088S090S09­2S094S098S100S101S104S106S107S110S112S114S115S117S119S120S121S122S127S129S1­30S134S135S136S137S139S142S146S148S149S150S160S161S163S167S168S170S174S179S­184">
>
> > Finally, my file ends off with with another huge line like the one
> > above and not the "normal" file closing structure.
>
> > Any help to fix my URI issue would be nice as this ontology has about
> > 20 hours of work into it at this point.
>
> > I can email this owl file if necessary- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"TopBraid Composer Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/topbraid-composer-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to