InfoQube IM - Community

Submitted by jan_rifkinson on 2009/04/06 10:39

I've read (& I think) followed instructions correctly @ http://www.sqlnotes.net/drupal5/index.php?q=node/88 however when I import, IQ states it has read x number of items but they never appear in the grid. I'm missing something but I can't figure out what. This should be a simple import, tel book from another program TIA

Jan Rifkinson

Ridgefield CT USA

Comments

Hi Jan: I have communicated these problems to Pierre. Only a few fields successfully imported a couple of betas ago. In this beta, I see none of the fields being imported. So I am confirming your observation. Pierre, I really need this to work. Please! Jon

Thanks, Jon. If this is as we both suspect, then I agree w your sense of urgency. Importing csv is a pretty basic function to be mis-firing.
OTOH, both of us may be doing something wrong. Let's hope Pierre will jump in here w a definitive answer one way or the other.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Hi to both of you,

I'm now well setup in my new home and ready to move on with IQ dev.

This issue will be the first I'll tackle. CSV import is certainly a must... but this format is also difficult to handle as it is ill-defined. Can you try to use tab-delimited instead while I look into this further.

Also, if possible, send files (.csv and .snmap if available) to betasupport@sqlnotes... so I can test with specific files. It works with some, so I'll be able to include these into my test library.

As important as this might be, you advertised work on the calendar as the next big update. Have you been able to do any of that that you would be willing to release. It would definitely be helpful in my world. Thanks.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

I've added a link to the latest build in the download page. Copy the included files into the application folder. The CSV import bug is now fixed.

FYI, it was not a bug in CSV import, but one in handling IQ Fields with special characters, such as "(" and ")"

Thanks, Pierre. Is the latest build still identified as release 10?

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Yes it is.

gulp...

Everything lines up, i.e. data + mapping but I must be doing something wrong because the data does not show up in the grid. I close / re-open grid & /or program w same result. However, data is present in the db.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

In the field mapping, do you assign the field(s) to ensure the items show up in your grid(s) ? (as described in step 2 of Delimited Text files (Excel, Access, Outlook, etc.))

Yes I believe so, Pierre. I don't expect all fhe fields to show up until I add the proper columns that reflect the import -> field mapping but I do expect the item to appear in the grid. This is what bothers me. As I've mentioned, the data appears in the db but not in the grid. I'll try it again. Maybe it's something with the way I'm creating my grid for the import ??

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

[quote=jan_rifkinson]

Maybe it's something with the way I'm creating my grid for the import ??

[/quote]

Your grid for the import ? Import and grids are not related. Notice that Import is under the File menu, not the Grid menu.

Import puts items in your database. Grids display some of these items

What I could add, is an extra step, in the import process, where you would select the grid(s) where the imported items should show up.

I'll have to re-read the instructions in the on-line manual as I'm now totally confused. I did find my floating items, selected them as a group & assigned them to the field which is the source of the grid I was using for import.

Yes, I think offering the user a place to put their imports would be very useful.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Pierre, I think I can identify the problem here.

The imported item does not "attach" itself to the field that is auto-created when the grid is created.

Subsequently, adding the auto-created field to the grid source does nothing, i.e. brings nothing into the grid.

Could that be it?

I now have an imported 954 items floating around in my db

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Correct. Please read my post (same time as yours).

To resolve this, you can:

Use the journal grid to view newly inserted items or,
Double-click a field (in the properties pane), that you know is filled for all imported items. This will show all imported items in a grid

then select all items and either:

In the properties pane, check the field for your grid
Do Ctrl-E to delete them. Re-import and this time, add a line in the import field mapping to ensure the imported items show up in your grid

Pls see the error I reported on import.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

This is fixed for me (finally). Thank you. Jon