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

dcwul62 · « **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 · « **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.

mouser · « **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 · « **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 · « **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

mouser · « **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 · « **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

=

=

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 · « **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 · « **Reply #8 on:** November 20, 2013, 04:29 AM »

Eh ... sorry .. but where?

=

Export to txt-Import into Excel-some minor flaws
=

mouser · « **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 · « **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 · « **Reply #11 on:** November 20, 2013, 06:47 AM »

Works here. Not for you?

dcwul62 · « **Reply #12 on:** November 20, 2013, 07:14 AM »

I am afraid not..
looks a bit like this ..

=

Export to txt-Import into Excel-some minor flaws
=

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

=

mouser · « **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 · « **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.

-=

Export to txt-Import into Excel-some minor flaws
==

mouser · « **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 · « **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 · « **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)