How can I import TSV or excel files directly into my pack file packfile? Yellow bug.

[gdwitt]

I am frustrated to no end with adding tsv files back into PackFileManager.
I have succeed in the past but it's always a different method.
What id do is export the file from a directory to a tsv then open in excel to edit.
If I import directly to the file (say technologies) it just adds the new data above the old date so there are 2 different data sets in 1 file.
If I add the tsv directly to a directory and then delete the older file, it used to work.
But not anymore.
The directory and file are colored yellow after saving.
They are still yellow if the PFM is reopened.
When I start the game, the game crashes and "Rome has stopped working."
It's not my file because if I export the technologies from data_rome2.pack, I get the same error.

I am using PFM3.1.8 with Schema 42.

I request either a link to the answer to this or an explanation how everyone here is "importing" tsv files into PFM and getting them to work.
Also, what does the yellow mean?
Thank you,
GWITT

[daniu]

If I import directly to the file (say technologies) it just adds the new data above the old date so there are 2 different data sets in 1 file.

Then you can just select all rows and delete them before importing.

When I start the game, the game crashes and "Rome has stopped working."
It's not my file because if I export the technologies from data_rome2.pack, I get the same error.

Not sure what you mean by that.
Sounds like you include the original tech table in your pack and it crashes the game?
that sounds to me like another of your tables causes it.

[quote]Also, what does the yellow mean?/QUOTE]
It means that there is a schema with a newer version available for that table.
Chances are your file edited tech table in the last patch; it got updated in the latest one with changed columns.

[gdwitt]

I found that if I save the file and the yellow goes away with black letters only, then the added files stick.
If not, they disappear and I have to redo it.
It works randomly it seems.
Process it to right click the directroy "add db file from tsv" then delete the conflicting TSV.

I have been using the latest schema 42 that you link to. Where can I find newer versions of the schema.

Thank you for your work and continued answers.