topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday March 29, 2024, 10:29 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Export to txt-Import into Excel-some minor flaws  (Read 9508 times)

dcwul62

  • Supporting Member
  • Joined in 2013
  • **
  • default avatar
  • Posts: 336
    • View Profile
    • Donate to Member
Export to txt-Import into Excel-some minor flaws
« on: October 03, 2013, 09:04 AM »

Noticed that when importing the ExportedClips.txt file into Excel, in column 'A' some date-time settings show up and sometimes something else.

Looks like this

=
CHS-Export to Excel-031013.png
=

Now what is listed there, like 2013-08-29 03:29:32.598  it does not exist in the CHS database.
Same for the other examples.

They are not in  2274 or 2273 (or 3156/3155, 3221/3220)

It is not a big thing, I can delete it manually.

There may be roughly 7-8 such entries in the entire list.

=

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #1 on: November 19, 2013, 09:54 PM »
I need some more information.

I've just done some checking into this, and it appears, to the best i can tell, that CHS *IS* properly writing the csv file, and your import process is not parsing it correctly.

It seems to me, from the screenshots, that the import process you are using is not properly dealing with embedded linebreaks.

But here is how a CSV with embedded linebreaks should be handled, and it seems consistence with CHS:
http://www.creativys...ticles/CSV/CSV01.htm

I can't believe the excel isn't capable of proper csv importing -- but maybe there are multiple options for importing CSV files are you are just choosing an unusual option?

OR, I could be misreading how embedded newlines are supposed to be represented in a CSV file.
« Last Edit: November 19, 2013, 10:19 PM by mouser »

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #2 on: November 20, 2013, 12:41 AM »
Nevermind, i'm writing a whole new export function and i can test on excel and see it's choking on some formats.
I'm fixing.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #3 on: November 20, 2013, 01:28 AM »
Ok please try the new beta with completely rewritten CSV export.
Also, see the Backup/Maintenance tab in options for some new csv export options.

https://www.donation...dex.php?topic=1514.0

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #4 on: November 20, 2013, 01:31 AM »
Apparently, if the filename has a txt extension, you get a different import wizard which looks like it can do csv but not really.  So half the fix was renaming the file to .csv extension.

One thing I've noted is that I was able to export a clip with = near the beginning of the cliptext, and it freaked out excel and caused that one row to import wrong.  This seems to be excel making an ass of itself and there's little i can do to fix it.

If you figure out a way for me to tell excel to not be so stupid, please let me know.

Good work bill gates and the Excel team -- never content to do things the standard way :down:

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #5 on: November 20, 2013, 01:44 AM »
By the way, one of the new options for exporting is that you can specify a smaller number of fields to export -- should make it a bit easier to export just what you need.

If someone can suggest some common sets of fields that one might want to export, i can put some sample lists available as a dropdown to make it easy to switch between common choices.

dcwul62

  • Supporting Member
  • Joined in 2013
  • **
  • default avatar
  • Posts: 336
    • View Profile
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #6 on: November 20, 2013, 04:07 AM »
Hi Mouser
How?
How to set the number of fields?
Database maintenance exports all
File -> Export Listed Clips

=
SnagIt-20112013 110526.png
=

However, the exported text -file shows all fields.
Index,UserKeywords,ClipType,ParentId,ParentGroup,OtherGroups,Application,FullApplicationPath,
WindowTitle,Title,Description,ImageIndex,ExcerptText,ClipText,CreationDateTime,ModificationDateTime,
etc.etc.

Or am I mixing things up now?
Very well possible...  :)

=


mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #7 on: November 20, 2013, 04:20 AM »
Go to the Backup/Maintenance tab.
There you can specify a list of which fields to export.

dcwul62

  • Supporting Member
  • Joined in 2013
  • **
  • default avatar
  • Posts: 336
    • View Profile
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #8 on: November 20, 2013, 04:29 AM »


Eh ... sorry .. but where?

=
SnagIt-20112013 112846.pngExport to txt-Import into Excel-some minor flaws
=

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #9 on: November 20, 2013, 05:02 AM »
You don't have the latest version.  This sometimes happens when I upload a new version too soon -- the downloads are still serving the previous version.

The installer should say 2.22.02.  If it still says 2.22.01 then its not the new version.

dcwul62

  • Supporting Member
  • Joined in 2013
  • **
  • default avatar
  • Posts: 336
    • View Profile
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #10 on: November 20, 2013, 06:37 AM »
Right, I was on 2.22.01   :)
tried out exporting with this
ExcerptText,ClipText,CreationDateTime

I don't know ... did you try it out yourself?

=

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #11 on: November 20, 2013, 06:47 AM »
Works here.  Not for you?

dcwul62

  • Supporting Member
  • Joined in 2013
  • **
  • default avatar
  • Posts: 336
    • View Profile
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #12 on: November 20, 2013, 07:14 AM »
I am afraid not..
looks a bit like this ..


=
SnagIt-20112013 140716.pngExport to txt-Import into Excel-some minor flaws
=

did you try to export selected clips? (not the entire database)

=

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #13 on: November 20, 2013, 07:23 AM »
It always exports the clips in the current view (selected group/filter), not just selected clips.  We can talk about that later.

You're loading this csv into excel without changing the file extension, right?  And you're only showing one clip -- can you tell me if your saying that ALL exported clips are coming in wrong, or is it just one or two?

If you look at the csv file in a text editor, can you see what's wrong?

dcwul62

  • Supporting Member
  • Joined in 2013
  • **
  • default avatar
  • Posts: 336
    • View Profile
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #14 on: November 20, 2013, 09:04 AM »
Looks pretty much the same.
I can select -say- 4 clips, then file export selected clips, the entire database is exported.
In the excelsheet you can see it goes up to close 90.000  rows.

-=
SnagIt-20112013 155946.pngExport to txt-Import into Excel-some minor flaws
==


mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #15 on: November 20, 2013, 11:18 AM »
I will add a feature to export only selected clips.  But let's focus on the basic export functionality first.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #16 on: November 21, 2013, 03:38 AM »
Anyone else care to report on the new export function?
If your csv is importing with some clips not being parsed, can you see if you can identify why?

dcwul62

  • Supporting Member
  • Joined in 2013
  • **
  • default avatar
  • Posts: 336
    • View Profile
    • Donate to Member
Re: Export to txt-Import into Excel-some minor flaws
« Reply #17 on: November 23, 2013, 01:04 AM »


Just gave it a try again.
Copied a few things from the donationcoder site.
Exported it to .csv (90.000+ lines of text)

http://imagizer.imageshack.us/v2/150x100q90/c/202/b6a4.png
Export to txt-Import into Excel-some minor flaws

http://imagizer.imageshack.us/v2/150x100q90/c/853/hy71.png
Export to txt-Import into Excel-some minor flaws

http://imagizer.imageshack.us/v2/150x100q90/c/96/fcui.png
Export to txt-Import into Excel-some minor flaws

http://imagizer.imageshack.us/v2/150x100q90/c/716/wy5j.png
Export to txt-Import into Excel-some minor flaws

http://imagizer.imageshack.us/v2/150x100q90/c/34/zkuc.png
Export to txt-Import into Excel-some minor flaws

http://imagizer.imageshack.us/v2/150x100q90/c/5/q41a.png
Export to txt-Import into Excel-some minor flaws


Export Settings
http://imagizer.imageshack.us/v2/150x100q90/c/203/mo4m.png
Export to txt-Import into Excel-some minor flaws


Exported
http://imagizer.imageshack.us/v2/150x100q90/c/404/oj1r.png
Export to txt-Import into Excel-some minor flaws


In a text-editor
http://imagizer.imageshack.us/v2/150x100q90/c/30/hifj.png
Export to txt-Import into Excel-some minor flaws


=