Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to export the data of the tables with the export all source file flow #437

Open
sotalvaro opened this issue Sep 18, 2023 · 6 comments
Open

Comments

@sotalvaro
Copy link

I need export the data of the tables with all the files when I export all the source files

@joyfullservice
Copy link
Owner

@sotalvaro - This question comes up occasionally, so I have added some details to the FAQs page. You can also read a more detailed discussion in #250. Hope that helps!

@sotalvaro
Copy link
Author

@sotalvaro - This question comes up occasionally, so I have added some details to the FAQs page. You can also read a more detailed discussion in #250. Hope that helps!

Thanks adam, Can you explain a little bit more whats is the difference between xml option or tab delimited?

@joyfullservice
Copy link
Owner

If your goal is to easily read simple text data in version control, tab delimited might be a good choice. (For example, a table with simple key-value pairs of configuration settings.)

If you want to load the data back into the system during a build, XML is a much more robust choice. With the improved indenting and layout enhancements added this year, readability has been greatly improved in the XML files.

I find that XML is usually the better choice for almost all of my personal use cases, but feel free to try out both and see what works better for what you are trying to accomplish. (Select Tab Delimited, run an export, then change to XML and run an export to see the difference.)

If you haven't already seen it, you will probably also benefit from the page in the Wiki that describes the add-in options. (Note that some of the newest V4 options are not yet documented here, but it should help in understanding some of what is available.)

@sotalvaro
Copy link
Author

This is because the both methods produces me an error in the process of build the application

@sotalvaro
Copy link
Author

sotalvaro commented Sep 20, 2023

If your goal is to easily read simple text data in version control, tab delimited might be a good choice. (For example, a table with simple key-value pairs of configuration settings.)

If you want to load the data back into the system during a build, XML is a much more robust choice. With the improved indenting and layout enhancements added this year, readability has been greatly improved in the XML files.

I find that XML is usually the better choice for almost all of my personal use cases, but feel free to try out both and see what works better for what you are trying to accomplish. (Select Tab Delimited, run an export, then change to XML and run an export to see the difference.)

If you haven't already seen it, you will probably also benefit from the page in the Wiki that describes the add-in options. (Note that some of the newest V4 options are not yet documented here, but it should help in understanding some of what is available.)

Hi Adam, I have a question for the JSON of the tables I have 9 linked tables that have multiples primary keys how can I export the tables in the folder of structure "tbldefs" with this primary keys, because I check the file and export with any primary key
image
@hecon5 or you man, may you have an idea for that? This will be a incredible help for me, thanks a lot.

@hecon5
Copy link
Contributor

hecon5 commented Nov 13, 2023

When you say multiple PKs, do you mean Foreign Keys? The data export won't care about the state of primary/foreign/data state. Also, table data is exported into the folder tables and not tbldefs. Tbldefs is the folder for the table definitions. See wiki Export/Import Page for more details.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants