INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Exported database is not readable  (Read 3448 times)

tunetyme

  • Galactic Citizen
  • ****
  • Posts: 410
  • Have tunes will travel
Exported database is not readable
« on: July 28, 2007, 12:37:25 pm »
I have exported my database of 13,000+ records.  I can't open the file because of an error. It says there is an invalid character in line 77278 column 21.  How can I find it and correct the error?

Thanks!
Tunetyme   
Logged

tunetyme

  • Galactic Citizen
  • ****
  • Posts: 410
  • Have tunes will travel
Re: Exported database is not readable
« Reply #1 on: August 02, 2007, 01:30:50 pm »
Should I report this as a bug?  Is there other formats that this could be exported to?

Tunetyme
Logged

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re: Exported database is not readable
« Reply #2 on: August 02, 2007, 05:15:47 pm »
Quote from: tunetyme on July 28, 2007, 12:37:25 pm
I have exported my database of 13,000+ records.  I can't open the file because of an error. It says there is an invalid character in line 77278 column 21. How can I find it and correct the error?

Did you use the File > Library > Export to XML... feature for exporting?

What is "It" ?

What are you trying to do with the database?
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

tunetyme

  • Galactic Citizen
  • ****
  • Posts: 410
  • Have tunes will travel
Re: Exported database is not readable
« Reply #3 on: August 02, 2007, 08:33:55 pm »
"It" is the xml file that was created.  As to why, I try not to mess with a primary database.  If I want to experiment with new fields or develop a simple inventory it is easy for me to do without risking my primary database.
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42524
  • Shoes gone again!
Re: Exported database is not readable
« Reply #4 on: August 03, 2007, 08:43:53 am »
It could be a problem with whatever is reading the XML.

What character on line 77278 looks like a problem?
Logged
Matt Ashland, JRiver Media Center

tunetyme

  • Galactic Citizen
  • ****
  • Posts: 410
  • Have tunes will travel
Re: Exported database is not readable
« Reply #5 on: August 06, 2007, 09:42:03 pm »
If you can suggest a way for me to look at that line I  will be glad to do so.  Every program I have tpo open the file won't because of the error.  I think that the the should be renamed as catch 22...
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72637
  • Where did I put my teeth?
Re: Exported database is not readable
« Reply #6 on: August 06, 2007, 09:48:57 pm »
Try another editor, like notepad.
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42524
  • Shoes gone again!
Re: Exported database is not readable
« Reply #7 on: August 07, 2007, 08:54:05 am »
If you can reliably create a file that even notepad won't open, email a copy to matt at jriver dot com.

Thanks.
Logged
Matt Ashland, JRiver Media Center

tunetyme

  • Galactic Citizen
  • ****
  • Posts: 410
  • Have tunes will travel
Re: Exported database is not readable
« Reply #8 on: August 07, 2007, 05:48:26 pm »
Will do.
Logged

Skeezix

  • Galactic Citizen
  • ****
  • Posts: 295
Re: Exported database is not readable
« Reply #9 on: August 07, 2007, 11:16:22 pm »
Quote from: tunetyme on August 06, 2007, 09:42:03 pm
If you can suggest a way for me to look at that line I  will be glad to do so.  Every program I have tpo open the file won't because of the error.  I think that the the should be renamed as catch 22...

Next time you have that problem, use Hexedit, free download from the internet. Notepad doesn't handle very large files.
Logged
* HP Pavilion Desktop 510-p114
* Windows 10 Home 22H2 19045.5247
* Firefox 133; Thunderbird 128.5 esr

tunetyme

  • Galactic Citizen
  • ****
  • Posts: 410
  • Have tunes will travel
Re: Exported database is not readable
« Reply #10 on: August 11, 2007, 06:30:23 pm »
The file is larger than 20 MB and I am limited to 20 MB attachments on yahoo.  I still have the problem and I can open it with notepad.  I have look at the location specified and I do not see anything out of the ordinary.  Can I export to a comma separated file?

Tunetyme
Logged

Skeezix

  • Galactic Citizen
  • ****
  • Posts: 295
Re: Exported database is not readable
« Reply #11 on: August 11, 2007, 06:38:27 pm »
Can you zip the XML file? Probably can shrink it down that way to under 2 MB.
Logged
* HP Pavilion Desktop 510-p114
* Windows 10 Home 22H2 19045.5247
* Firefox 133; Thunderbird 128.5 esr

tunetyme

  • Galactic Citizen
  • ****
  • Posts: 410
  • Have tunes will travel
Re: Exported database is not readable
« Reply #12 on: October 01, 2007, 02:18:29 pm »
I need to resurrect this post.  I still am not able to import this file into excel or word.  I have been able to open it with notepad and go the line that it claims is where the problem is and I can not see any special  characters, only numbers in the field. (date info)  Is it feasible to export into a delimited flat file?

Matt I sent you a copy of this some time ago and I haven't heard from you.  Did you receive it?
Logged
Pages: [1]   Go Up
« previous next »